Kelas Professional Database

Ms.SQL Server 2000
Target kelas ini adalah Melatih serta membimbing siswa mulai dari pendesainan database, menjalankan query, implementasi database, pemeliharaan database, transfer data sampai dengan authorisasi user. (Database Administrator)
Durasi : 24 Jam
Biaya : Rp. 1,000,000,-
Silabus	Perancangan Database, Membangun Database, Query Database, Memodifikasi Data, Memelihara Database, Transfer Data serta Security.
Tools	MS. SQL Server 2000

SQL SERVER 2005 FUNDAMENTAL
Target kelas ini adalah Melatih serta membimbing untuk dapat membuat aplikasi menggunakan Ms. SQL Server 2005
Durasi : 30 Jam
Biaya : Rp. 1,500,000,-
Silabus	Overview SQL Server 2005,SQL Server 2005 Architecture, Entity Relationship Diagram Normalization, Creating and Managing Database, Data Types, Creating and Managing Tables, Data Integrity, Integrity Constraint, Primary Key, Check, Default,Identity, Foreign Key, Using Select Statement, Filtering Data, Formatting Result Sets, Using Aggregate Function, Listing TOP n values, Group by Clause, Using Compute by clauses Using Aliases for Table Names, Combining Data from Multiple Table, Combining Multiple Result Sets, Querying Multiple Tables, Introduction to Subqueries, Using a Subquery as a Derived Table, Using a Subquery as an Expression, Using Transaction, Inserting Data, Deleting data, Updating Data, Introduction View Object, Creating and Modifying Views, Accessing data through Views, Introduction Triggers Object, Creating and Modifying Triggers, Programming Triggers, Introduction Proc Object, Creating and Modifying Proc, Executing and Deleting Proc, Introduction Index Object, Creating and Modifying Index, Dropping Index, Overview to XML, Integrated XML and SQL 2005, Retrieving XML using For XML, Shredding XML using Open XML
Tools	Ms. SQL Server 2005

Oracle 10G DBA
Target kelas ini adalah Melatih dan membimbing siswa untuk dapat menguasai administrasi database serta mengatur security didalamnya.
Durasi : 36 Jam
Biaya : Rp. 3,600,000,-
Silabus	Oracle Concept, Installing Oracle Database, I-SQL Plus, Writing Basic SQL Select Statements, Restricting and Sorting Data,S ingle Row Function, Manipulating Data, Including Constraints Managing an Oracle Instance, Creating a Database, Declaring Variables, Writing Explicit Cursors, Writing Executable Statements, Handing Exceptions, Creating Procedures, Function, Package, Creating Database Triggers, Maintaining the Control File, Maintaining Redo Log Files, Managing Tablespaces and Datafiles, Managing Undo Data, Managing Tables
Tools	Oracle 10G

Oracle 10G DBA dan Developer
Target kelas ini adalah Melatih dan membimbing siswa untuk dapat menguasai administrasi database serta mengatur security didalamnya, serta membuat aplikasi menggunakan oracle 10G.
Durasi : 81 Jam
Biaya : Rp. 6,700,000,-
Silabus	Oracle Concept, Installing Oracle Database, I-SQL Plus, Writing Basic SQL Select Statements, Restricting and Sorting Data, Single Row Function, Manipulating Data, Including Constraints Managing an Oracle Instance, Creating a Database, Declaring Variables, Writing Explicit Cursors, Writing Executable Statements, Handing Exceptions, Creating Procedures, Function, Package, Creating Database Triggers, Maintaining the Control File, Maintaining Redo Log Files, Managing Tablespaces and Datafiles, Managing Undo Data, Managing Tables, Introduction to Oracle Forms Developer and Oracle Forms Services, Running a Forms Developer Application, Creating LOVs and Editors, Creating Additional Input Items, Creating Noninput Items, Working with Text Items, Producing Triggers, Adding Functionality to Items, Run Time Messages and Alerts, Query Triggers, Validation, Navigation, Transaction Processing, Introducing Multiple Form Applications, Creating a Menu Module, Building Multiple Form Applications, Overview of Report Developer, Data Model, Layout Model, System and User Parameter, Using Formula Columns, Using Summary Columns, Parameter Form, Report Trigger, Program Units in Reports Developer, Running Report under Web.
Tools	Oracle 10G

Note

• Biaya sudah termasuk Registrasi Rp. 100,000
• Biaya Modul
• Biaya Sertifikat
• Teh Manis & Snack
  
• Kelas Sabtu dan Minggu ada penambahan biaya Rp. 100,000,- 

Waktu Pilihan Belajar :

• Senin - Rabu - Jumat @ 3jam
• Selasa - Kamis - Sabtu @ 3jam
• Weekend (Sabtu & Minggu) @ 3jam/@ 6jam

Copyright ©2008 Cyber Campus, All rights reserved