Lowongan di Pertambangan

Bagi putra putri rekan-rekan yg ingin bekerja di BUMN Pertambangan MIND ID dan Anak Perusahaannya, antara lain PT Antam, PT Bukit Asam, PT Freeport, PT Inalum dan PT. Timah, silakan mendaftarkan diri Anda mulai tanggal 21 Juli 2021.

Untuk info detil, silakan klik link di bawah ini.

https://xplorer.mind.id/?lang=id

Detil persyaratan minimum dapat dibaca dari link berikut:

https://xplorer.mind.id/assets/XPLORER-Detailed-Minimum-Requirement-Bahasa_vF-1626409091.pdf

Detil FAQ dapat dibaca dari link berikut:

https://xplorer.mind.id/assets/MIND-ID-Program-XPLORER-FAQs_vF.pdf

Aplikasi akan dibuka secara resmi pada tanggal 21 Juli. Klik "Notify Me" dari URL di atas (atau klik link URL di bawah ini) dan ikuti akun media sosial resmi MIND ID untuk mendapatkan info terkini.

https://xplorer.mind.id/notify-me

Semoga bermanfaat

Training Schedule August-September 2007

Just receive an email from Iverson Technology. Maybe you need this: 

B elow is our training schedule that will run on August-September 2007.

 

23-27 July 2007

1. Citrix Presentation Server 4.5 Administration (CTX-1256AI)
2. Cisco Certified Network Associates (CCNA)
3. Implementing & Maintaining a Ms Win Server 2003 Active Directory (2279)
4. Implementing a MS SQL Server 2000 database (2779)
5. Programming with Microsoft ADO.NET (2389) –- 23-25 July
6. Core Web Application Technologies with MS VS 2005 (2543) -- 23-25 July
7. Core Data Access with Microsoft Visual Studio 2005 (2541) -- 26-28 July
8. Ms Excel 2003 Basic-Advance Level -- 25-27 July
9. Oracle 9i Intro to SQL
10. Ms Project Professional 2003 –- 23-24 July
11. Ms Excel using VBA –- 25-26 July

 

30 July-3 August 2007

1. Cisco Certified Network Associate (CCNA)
2. Maintaining a MS SQL Server 2000 Database (2780)
3. Managing & Maintaining a Ms Win Server 2003 Environment (2273)
4. Developing Ms ASP.NET Web applications using VS.NET (2310)
5. Managing Messaging Security using Ms Exchange Server 2007 (5049) -- 3 Aug
6. Implementing a Microsoft Windows 2000 Network Infrastructure
7. Introduction to Visual Basic.NET Programming with Microsoft.NET (2559)
8. MS Visual Basic Scripting Edition and MS Windows Script Host Essentials (2433) -- 30 Jul-1 Aug
9. Scripting Microsoft windows Management Instrumentation (2439) –- 2-3 Aug

 

6-10 August 2007

1. Administering a Microsoft SQL serve 2000 Database (2072)
2. IT Project Management
3. Windows System Programming
4. Oracle 9i Database Administration I
5. Implementing and Administering Security in a MS Windows Server 2003 Network (2823)
6. Administering Microsoft Windows SharePoint Services and SharePoint Portal Server 2003 (2554)
7. Configuring Windows Vista Application and Tools (5116) –- 6-7 Aug
8. Installing and Configuring the Windows Vista Operating System (5115) –- 8-10 Aug
9. Managing & Maintaining a Ms Win Server 2003 Environment (2273)

 

13-17 August 2007

1. Programming a Microsoft SQL Server 2000 Database (2073)
2. Developing Secure Web Applications (2300) -- 13-15 Aug
3. Developing XML Web Services using Microsoft ASP.NET (2524) –- 13-15 Aug
4. Designing High Availability Database Solutions using MS SQL server 2005 (2788) –- 13-15 Aug
5. Administering and Automating Microsoft SQL server Dbase and Server (2789) –- 16 Aug
6. Introduction to Installing & Managing a MS Exchange Server 2007 (5047) – 13-15 Aug
7. Managing Messaging Security using MS Exchange Server 2007 (5049) -– 16 Aug
8. Maintaining and Configuring Windows Vista Computers (5118) –- 13-15 Aug
9. Supporting Win Vista Comp with Desktop Images & Application Packages (5119)--16-17 Aug

 

20-24 August 2007

1. IT Infrastructure Library –- 20-22 Aug
2. Implementing a Microsoft Internet Security and Acceleration Server 2004 (2824)
3. Developing Microsoft.NET Application for Windows (VB.NET) (2565)
4. Oracle 10g Database Administration I
5. Implementing, Managing & Maintaining a MS Win Server 2003 Network Infrastructure (2277)
6. Core-Advanced Data Access with Microsoft Visual Studio 2005 (2541-2542)
7. Designing a Microsoft SQL Server 2005 Server Side Solutions (2781) –- 20-22 Aug
8. Designing a Microsoft SQL server 2005 database (2782) –- 23-24 Aug
9. Microsoft Project Professional 2003 –- 20-21 Aug
10. Microsoft Access 2003 Basic-Advance –- 22-24 Aug
11. Microsoft Excel 2003 Basic-Advance

 

 

TRAINING SCHEDULE AUGUST – SEPTEMBER 2006

 

COURSE TITLE	Code	Schedule
IT Project Management	IT PM	6-10 August
IT Infrastructure Library (IT- Service Management)	IT-IL	20-22 Aug
Citrix Presentation Server 4.0: Administration	CTX-1256AI	13-16 Aug
Cisco Certified Network Associate (CCNA)	CCNA	30 Jul-3 Aug 3-7 September
Building Scalable Cisco Internetworks	BSCI	20-24 August
Implementing Secure Converged Wide Area Networks	ISCW	ON CALL
Cisco Internetwork Troubleshooting  Support	CIT	ON CALL
Implementing a Microsoft Windows 2000 Network Infrastructure	2153	30 July – 3 Aug
Managing and Maintaining Win Server 2003 Environment	2273	6-10 Aug 10-14 September
Implementing, Managing & Maintaining a MS Win Server 2003 Network Infrastructure: Network Services	2277	20-24 Aug 17-21 September
Planning, Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure	2279	27-31 Aug 24-28 September
Planning and Maintaining a Microsoft Windows Server 2003 Network Host	2278	27-31 Aug 17-21 September
Implementing & Administering Security in a MS Windows Server 2003 Network	2823	6-10 August 3-7 September
Implementing Microsoft Internet Security and Acceleration Server 2004	2824	20-24 August
Implementing & Managing Microsoft Exchange Server 2003	2400	27-31 Aug 17-21 September
Microsoft Certified Desktop Special Technician : 1.       Supporting Users Running the MS Windows XP Operating System 2.       Supporting Users Running Applications on MS Windows XP OS	MCDST 2261 2262	3-7 September
Administering a MS SQL Server 2000 Database	2072	6-10 August 10-14 Sept
Programming a Microsoft SQL Sever 2000 Database	2073	13-17 Aug 17-21 September
SQL Performance Tuning 2000 Database	Tuning 2000	ON CALL
Designing High Availability Database Solutions Using Microsoft SQL Server 2005	2788	13-15 August
Administering and Automating Microsoft SQL Server 2005 Database and Servers	2789	16 August
Implementing a MS SQL Sever 2005 Database	2779 B	23-27 July
Maintaining a MS SQL Server 2005 Database	2780 B	30 July-3 August
Mastering Object Oriented Analysis and Design with UML	UML	ON CALL
Developing Microsoft ASP.NET Web Applications using Visual Studio.NET	2310	30 July-3 Aug 3-7 September
Developing Microsoft.NET Applications for Windows Visual Basic.NET	2565	20-24 Aug
Developing XML Web svc using Microsoft ASP.NET	2524	13-15 Aug
Getting Started with Microsoft Visual Studio 2005 for Microsoft Visual Basic 6.0 Developer	2562	6-7 September
Core Data Access with Microsoft Visual Studio 2005	2541	20-22 Aug 24-26 September
Advanced Data Access with Microsoft Visual Studio 2005	2542	23-24 Aug 27-28 September
Core Web Application with Microsoft Visual studio 2005	2543	10-12 September
Advanced Web Application with Microsoft Visual Studio 2005	2544	13-14 September
Core Windows Form Technologies with Microsoft Visual Studio 2005	2546	27-29 Aug 17-19 September
Advance Windows Forms Technologies with Microsoft Visual Studio 2005	2547	30-31 August 20-21 September
Administering Microsoft Windows SharePoint Services and SharePoint Portal Server 2003	2554	6-10 August
Introduction to Installing and Managing Microsoft Exchange Server 2007	5047	13-15 August 5-7 Sept
Managing Messaging Secirity using Microsoft Exchange Server 2007	5049	16 Augst 10 Sept
Implementing Microsoft Office Share Point Server 2007	5061	1-3 August 3-5 Sept
Intalling and Configuring the Windows Vista Operating System	5115	13-15 August 5-7 Sept
Configuring Windows Vista Applications and Tools	5116	6-7 August 10 Sept
Maintaining and Configuring Windows Vista Computers	5118	10,13-14 Augst 12-14 Sept
Supporting Windows Vista Computers with Desktop Images and Application Packages	5119	16-17 Augst -
MS Project Professional 2003	PRO 2003	20-21 Aug
Microsoft Access 2003 Professional - Advance	ACS 251-252	22-24 Aug
Microsoft Excel 2003 Professional - Advance	Exc 251-252	13-15 Aug
Microsoft Excel using VBA	Exc VBA	25-26 July 30-31 August 24-25 September
Oracle 9i Database Administration Fundamentals I	9i DBA I	6-10 August
Oracle 10g Database Administration Fundamentals I	10g DBA I	20-24 August
Oracle 10g Intro to SQL	10g Intro	27-31 August
Oracle 9i Intro to SQL	9i Intro	23-27 July
PHP Fundamental		ON CALL
Java Programming Language		ON CALL

   

Please click to http://www.iverson.co.id to find our others training schedule and the syllabus.

For further information that you may need regarding the course (syllabus, promo, schedule) please do not hesitate to contact me.

 

Best Regards,

PT. Iverson Technology -- http//:www.iverson.co.id

Chase Plaza , 9th Floor

Jl. Jend. Sudirman Kav. 21 Jakarta 12920

Telp.+62 21 520 8210  l  Fax. +62 21 520 8209

SELECT "YYYYDD" datetime

Can you explain about this ?

1st sql script :

SELECT CONVERT(VARCHAR(6),GETDATE(), 112)

------
200705

(1 row(s) affected)


2nd sql script :

SELECT CONVERT(VARCHAR(4),YEAR(GETDATE()), 112) + CONVERT(VARCHAR(2),MONTH(GETDATE()), 112)

------
20075

(1 row(s) affected)


Why 2nd sql script doesn't show the same result with the 1st sql script ?

UNION and GROUPING

Still about using UNION, how sql server grouping this result?

SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '198001'

output
------
198001
200701

(2 row(s) affected)

How can SQL Server order this result

How can SQL Server order this result?

SELECT '200702'
UNION
SELECT '200701'
UNION
SELECT '200703'
UNION
SELECT '200705'
UNION
SELECT '198001'

output
------
198001
200701
200702
200703
200705

(5 row(s) affected)