Materi
Kursus:
Panduan Optimization Query pada SQL Server
Login
Curriculum
Panduan Optimization Query pada SQL Server
Belajar Query Optimization
0/31
1. Introduction
1:27
Pratinjau
2. The SQL Engine
1:17
Pratinjau
3. The Query Processing Process
1:31
Pratinjau
4. The Search Space
Sorry, this lesson is currently locked. You need to complete "3. The Query Processing Process" before accessing it.
1:45
5. Whats In the Cost
Sorry, this lesson is currently locked. You need to complete "4. The Search Space" before accessing it.
1:33
6. Plan Cache Reuse
Sorry, this lesson is currently locked. You need to complete "5. Whats In the Cost" before accessing it.
1:21
7. What Causes Recompilation
Sorry, this lesson is currently locked. You need to complete "6. Plan Cache Reuse" before accessing it.
0:52
8. Terminology
Sorry, this lesson is currently locked. You need to complete "7. What Causes Recompilation" before accessing it.
4:03
9. Anatomy of Execution Plan
Sorry, this lesson is currently locked. You need to complete "8. Terminology" before accessing it.
2:35
10. Execution Plan Output Options
Sorry, this lesson is currently locked. You need to complete "9. Anatomy of Execution Plan" before accessing it.
1:38
11. Scan VS Seek
Sorry, this lesson is currently locked. You need to complete "10. Execution Plan Output Options" before accessing it.
1:57
12. Scanning Demos
Sorry, this lesson is currently locked. You need to complete "11. Scan VS Seek" before accessing it.
2:10
13. Seeking Demos
Sorry, this lesson is currently locked. You need to complete "12. Scanning Demos" before accessing it.
3:07
14. The Bookmark Lookup
Sorry, this lesson is currently locked. You need to complete "13. Seeking Demos" before accessing it.
4:09
15. Aggregations
Sorry, this lesson is currently locked. You need to complete "14. The Bookmark Lookup" before accessing it.
2:03
16. Hash Match Operator
Sorry, this lesson is currently locked. You need to complete "15. Aggregations" before accessing it.
3:06
17. Joins The Nested Loop
Sorry, this lesson is currently locked. You need to complete "16. Hash Match Operator" before accessing it.
1:55
18. The Merge Join
Sorry, this lesson is currently locked. You need to complete "17. Joins The Nested Loop" before accessing it.
1:26
19. Joins The Hash Join
Sorry, this lesson is currently locked. You need to complete "18. The Merge Join" before accessing it.
1:18
20. Parallelism Introduction
Sorry, this lesson is currently locked. You need to complete "19. Joins The Hash Join" before accessing it.
1:14
21. DBCC SHOW STATISTICS
Sorry, this lesson is currently locked. You need to complete "20. Parallelism Introduction" before accessing it.
1:36
22. Anatomy of a Stats Header,Vector & Histogram
Sorry, this lesson is currently locked. You need to complete "21. DBCC SHOW STATISTICS" before accessing it.
4:25
23. Out of Date Statistics
Sorry, this lesson is currently locked. You need to complete "22. Anatomy of a Stats Header,Vector & Histogram" before accessing it.
1:28
24. Stale Statistics Demo
Sorry, this lesson is currently locked. You need to complete "23. Out of Date Statistics" before accessing it.
1:17
25. Maintaining Statistics
Sorry, this lesson is currently locked. You need to complete "24. Stale Statistics Demo" before accessing it.
1:26
26. Setting Up Statistics Maintenance Job
Sorry, this lesson is currently locked. You need to complete "25. Maintaining Statistics" before accessing it.
4:36
27. The Scan On Large Tables
Sorry, this lesson is currently locked. You need to complete "26. Setting Up Statistics Maintenance Job" before accessing it.
3:24
28. Using SET STATISTICS IO ON
Sorry, this lesson is currently locked. You need to complete "27. The Scan On Large Tables" before accessing it.
2:47
29. Non Clustered Indexes on Heaps
Sorry, this lesson is currently locked. You need to complete "28. Using SET STATISTICS IO ON" before accessing it.
2:45
30. The No Good Sort Operator
Sorry, this lesson is currently locked. You need to complete "29. Non Clustered Indexes on Heaps" before accessing it.
3:30
31.Unwinding The Spool
Sorry, this lesson is currently locked. You need to complete "30. The No Good Sort Operator" before accessing it.
2:01
Tugas Praktek
0/1
Tugas: Praktik Optimasi Query pada SQL Server
Sorry, this lesson is currently locked. You need to complete "Belajar Query Optimization" before accessing it.
Tugas
Video
1. Introduction
Masuk
Kata sandi harus memiliki minimal 8 karakter angka dan huruf, mengandung setidaknya 1 huruf kapital
No Telp
Bidang Keahlian
Bisnis
Marketing
Pemrograman
Pengembangan Website
Bahasa
Design
Sains
Fisika
Kimia
Matematika
Hapus File
Yakin ingin melanjutkan?
Batal
Hapus
I agree with storage and handling of my data by this website.
Privacy Policy
Ingat Saya
Masuk
Daftar
Restore password
Send reset link
Password reset link sent
to your email
Tutup
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
Belum Punya Akun?
Daftar
Masuk
Lupa Password?