Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Perkenalan
Instalasi dan Konfigurasi Microsoft SQL Server
Gambaran Umum Microsoft SQL Fitur Server
Tinjauan Umum Konsep Transact-SQL
Menanyakan Database menggunakan SELECT
Memfilter Data dengan WHERE
Mengurutkan Data dengan ORDER BY
Menanyakan Beberapa Tabel dengan Gabungan
Pengelompokan Data dengan GROUP BY
Menggunakan Fungsi Agregat untuk Melakukan Perhitungan pada Data yang Dihasilkan
Memfilter Grup dengan HAVING
Membuat Baru Database
Memahami Model Database
Mengoptimalkan Database melalui Normalisasi
Meningkatkan Pertanyaan Anda dengan Prosedur
Menulis Fungsi dan Subrutin
Menggunakan Kondisi untuk Mengontrol Aliran
Menghubungkan ke Server Microsoft SQL melalui Excel
Penyelesaian Masalah
Ringkasan dan Kesimpulan
Requirements
- TIDAK diperlukan pengalaman sebelumnya SQL atau pengalaman database.
21 Hours
Testimonials (5)
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
Safdar Abbas - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
