Silabus Training SQL Server DBA

Silabus/ Syllabuss Training SQL Server DBA

SQL Server DBA 2008 DBA Fundamental

Durasi

:

 7 jam x 4 Hari (28 Jam)

 

 

 

Deskripsi

:

SQL Server DBA 2008 merupakan salah satu produk database kelas server yang dikembangkan oleh Microsoft Co. , Release terbaru yang diluncurkan Microsoft memungkinkan untuk memenuhi kebutuhan database perusahaan besar dengan fitur fitur Business Intelegence dan integrasi yang lebih maksimal. Training ini ditujukkan bagi siapa saja yang ingin menguasai teknologi Microsoft SQL Server DBA 2008. Materi yang dibahas dalam training ini dapat memberikan pengetahuan dan keterampilan untuk merancang, mengoptimalkan, serta memelihara database.

Secara umum, topic yang dibahas dalam training :

    * Relational Database Systems

    * SQL Server DBA Management Studio (SSMS)

    * Transact SQL language

    * Data Definition Language

    * Relationships and Data Integrity

    * Queries and Views

    * Stored Procedures and User-Defined Functions

    * Microsoft Business Intelligence Development Studio (BIDS)

 

 

 

 

Tujuan Training

:

Peserta dapat memahami konsep dan langkah-langkah perancangan database menggunakan SQL Server DBA, mengenal

cara konfigurasi SQL Server DBA, teknik pemeliharaan database, penggunaan fitur dan tools SQL Server DBA 2008 serta

dapat menggunakan berbagai task untuk administrasi database SQL Server DBA 2008 baik secara sintak maupun menggunakan user interface.

 

 

 

 

Target Peserta

:

          Database Developer

          Aplication Programmer

          Umum , Mahasiswa

 

 

 

Prasyarat

:

          Familiar dengan sistem operasi Windows Client dan Server.

          Mengenal konsep database secara umum.

 

 

 

Materi Training

:

Hari  1

 

·         SQL Server DBA Management Studio (SSMS) Integrated Development Environment (IDE)

·         Database Design Fundamentals

·         Anatomy of an SSMS Project

·         Creating Schemas, Tables and Diagrams

·         Data Definition Language (DDL) Fundamentals

·         SQL Server DBA Objects and Simple Data Types

·         Defining Constraints and Relationships

 

 

Hari 2

·         Working with SQL Server DBA Diagrams

·         Fundamentals of Data Manipulation Language (DML)

·         Selecting, Inserting, Updating and Deleting Data from tables

·         Working with related tables

·         Creating Views and Stored Procedures

·         Creating User-Defined Functions

·         Exception-handling in Transact SQL

 

Hari 3

 

·         Working with Transactions

·         Advanced DML commands and concepts

·         Extending SQL Server DBA using the Common Language Runtime (CLR)

·         Working with Metadata

·         Securing the database

·         Introduction to using XML Data with SQL Server DBA

 

Hari 4

·         Introduction to the BIDS (Business Intelegence Development Studio)

·         Introduction to SQL Server DBA Integration Services (SSIS)

·         Layout controls and design elements

·         Creating Interactive Reports & Graph (SQL Server DBA Report Builder)

·         Review and Evaluation

 

 

 

Training Lanjutan yang Disarankan

:

Web and Application programming with MS. ASP.NET

 

 

 

HERY PURNAMA – 081.223344.506 Freelance trainer untuk traning SQL SERVER DBA . Aktif di beberapa training center di Jakarta ,Bandung ,Surabaya ataupun diundang sebagai Inhouse Trainer di beberapa perusahaan baik bidang industri, pertambangan, finansial, asuransi, perbankan di seluruh indonesia

Hery adalah Inhouse trainer SQL SERVER DBA  di bandung, Jakarta, bekasi, bogor, sukabumi, semarang, yogya, Surabaya, bali, Lombok, ntb, ambon, jayapura, makasar, menado, Banjarmasin, Pontianak, palangkaraya, Balikpapan, samarinda, batam, lampung, Palembang, Riau, Padang, Medan, Aceh, Malaysia, Singapore , sisindotek training center dan wilayah Indonesia , Undangan Inhouse training bisa menghubungi  Hery – 081.223344.506 atau inhousetrainer@yahoo.com

Topik training lain yang diberikan Hery : sencha-extjs, excel-vba-macro, itil-cobit-cisa-uml, codigniter-yii,oracle-dba, sqlserver-dba, asp-net, vb-net, google-map-api, google-sketchup-3d, excel-advance-accounting, project-management, ms-project-SQL SERVER DBA, SEO-Internet-Marketing, php-mysql-jquery, android-phonegap-jquery-mobile, ms-access-vba, visual-foxpro, Ubuntu-server, facebook-api-developer, python-programming, adobe-photoshop, corel-draw, adobe-indesign, adobe-flash, cms-wordpress, 3d-studio, autocad, mobile-apps-development, sms-gateway, spss-matlab, dan lainnya silahkan konsultasikan

Untuk informasi/konsultasi atau undangan sebagai inhouse trainer silahkan menghubungi :

HERY PURNAMA
OCA., CIW., ITILF.

Hometown  : Bandung – Indonesia
Call/SMS/WA : 081.223344.506
EM :
inhousetrainer@yahoo.com
BB : 7DC633AA
FB : inhousetrainer , TW : @inhousetrainer , INS : inhousetrainer

Blog : http://freelance-it-trainer.blogspot.com

 

[tags  trainer freelance SQL SERVER DBA , pengajar lepas SQL SERVER DBA , trainer bersertifikasi SQL SERVER DBA, cari trainer SQL SERVER DBA, butuh trainer SQL SERVER DBA, trainer SQL SERVER DBA di bandung , trainer SQL SERVER DBA di jakarta, trainer SQL SERVER DBA di bogor, trainer SQL SERVER DBA di bekasi, trainer SQL SERVER DBA di semarang, trainer SQL SERVER DBA di yogya, cari freelance trainer SQL SERVER DBA, butuh freelance trainer SQL SERVER DBA , trainer SQL SERVER DBA di Surabaya, lowongan trainer SQL SERVER DBA , kursus SQL SERVER DBA , trainer SQL SERVER DBA di bali, trainer SQL SERVER DBA di lombok, trainer SQL SERVER DBA di ambon, trainer SQL SERVER DBA di makasar, trainer SQL SERVER DBA di menado, trainer SQL SERVER DBA di Banjarmasin, trainer SQL SERVER DBA di samarinda , trainer SQL SERVER DBA di Pontianak, trainer SQL SERVER DBA dipalangkaraya, trainer SQL SERVER DBA di batam, trainer SQL SERVER DBA di Palembang, trainer SQL SERVER DBA di lampung, trainer SQL SERVER DBA di tangerang, trainer SQL SERVER DBA di padang, trainer SQL SERVER DBA di medan, trainer SQL SERVER DBA di aceh, trainer SQL SERVER DBA di Malaysia, trainer SQL SERVER DBA di Singapore, certified trainer SQL SERVER DBA , download SQL SERVER DBA , tutorial SQL SERVER DBA, ebook SQL SERVER DBA, tips trik SQL SERVER DBA, belajar SQL SERVER DBA, tempat training SQL SERVER DBA, inhouse training SQL SERVER DBA , sertifikasi SQL SERVER DBA, training SQL SERVER DBA di tambang , training SQL SERVER DBA di bank , training SQL SERVER DBA di universitas, training SQL SERVER DBA di hotel, training SQL SERVER DBA di perusahaan asuransi , sertifikasi SQL SERVER DBA, ujian SQL SERVER DBA, hery trainer SQL SERVER DBA , syllabuss SQL SERVER DBA , sisindotek training SQL Server DBA, hubungi trainer SQL SERVER DBA , profesi trainer SQL SERVER DBA  , profile trainer SQL SERVER DBA , solusi SQL SERVER DBA, konsultasi SQL SERVER DBA, download ebook  SQL SERVER DBA gratis, download  gratis software SQL SERVER DBA ]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Author: Inhouse Trainer freelance

Hery Purnama 081.223344.506 - Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle , MySQL DBA, MS. Access VBA, Primavera P6, MS Project ,Jquery, Yii, CodeIgniter. laravel, CATIA 3D, Unity 5 , PMBOK, PMO, TOGAF, PRINCE2 - Call : 081.223344.506 | PinBB : 7DC633AA| Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer

Leave a Reply

Your email address will not be published. Required fields are marked *