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
Dasar-dasar
- Pemilihan semua kolom/bidang
- Pemilihan kolom/bidang tertentu
- Penggunaan kata yang berbeda/unik
- Pemilihan baris/catatan tertentu
- Pemilihan nilai dalam suatu rentang
- Pemilihan nilai yang cocok dengan pola topeng
- Pemilihan nilai dalam daftar
- Perawatan nilai nol
- Cara mengurutkan dan memesan data
- Pemilihan nilai yang dihitung dan diturunkan
- Cara mengontrol judul kolom dalam hasil kueri
- Cara mengirim hasil kueri ke file eksternal
Menggabungkan Tabel
- Prinsip penggabungan tabel:
- Penggunaan gabungan kartesian
- Penggunaan inner join
- Penggunaan non-equi join
- Penggunaan gabungan luar
Menggabungkan Kueri
- Operator serikat
- Operator perpotongan
- Kecuali operator
Fungsi Sederhana
- Fungsi konversi
- Fungsi tanggal
- Fungsi angka
- Fungsi teks
- Fungsi grup/ringkasan/agregat
Sub-Kueri
- Prinsip sub-query
- Cara memfilter baris dari kueri utama
- Penggunaan sub-query bersarang
- Penggunaan sub-query multi-kolom
- Penggunaan sub-query berkorelasi
- Penggunaan sub-query sebagai tampilan sebaris dan ekspresi tabel umum
- Penggunaan sub-query sebagai kolom dalam query utama
Pernyataan Kasus
- Prinsip pernyataan kasus
- Penggunaan pernyataan case untuk mendapatkan nilai kolom
- Penggunaan pernyataan kasus bersarang
- Penggunaan pernyataan kasus untuk menghasilkan tabel pivot
- Penggunaan pernyataan case dengan sub-query
Manipulasi Data
- Cara memasukkan nilai ke dalam tabel
- Cara menyalin nilai antar tabel
- Cara memperbarui nilai
- Cara menghapus rekaman
- Cara mengubah data melalui tampilan
- Penggunaan transaksi
- Cara mengunci baris dan tabel
Definisi Data
- Prinsip database relasional dan normalisasi data
- Penggunaan hubungan dan batasan kunci utama dan kunci asing
- Cara membuat tabel
- Cara mengubah tabel
- Cara membuat tampilan
- Penggunaan sinonim
- Cara menghapus tabel dan tampilan
14 Hours
Testimonials (6)
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Łukasz was very good. I liked how Łukasz talked about best practices. Pace was good. I liked the exercises. Having a wiki for future reference is good
Jake Real - Welsh Revenue Authority
Course - Transact SQL Basic
Lukasz was very patient and knowledgeable and made learning SQL very fun and informative. Easily one of the most rewarding training sessions of any subject I've had the pleasure of being part of!
Carwyn - Welsh Revenue Authority
Course - Transact SQL Basic
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Course - Transact SQL Basic
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Course - Transact SQL Basic
Interactive exercises
