Course 4: SQL Server Administration Part II
9 STUDENTS ENROLLED
SQL Administration Part 2 will benefit the student by providing the necessary guidelines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics. The course will cover the following:
- What are indexes and the important role they play?
- Using SQL Profiler to find long running queries
- Executing SQL various tools to monitor SQL server performance
- How to manage large database and much more
Course Curriculum
1. SQL Admin Part 2 Scripts and Docs | |||
SQL Admin Part 2 Scripts and Docs | 00:00:00 | ||
2. Introduction to SQL Part 2 | |||
Introduction to SQL Part 2 | 00:00:00 | ||
3. Install SQL Server | |||
Install SQL Server | 00:00:00 | ||
4. Install SQL Suite | |||
Install SQL Suite | 00:00:00 | ||
5. Clustered Index | |||
Clustered Index | 00:00:00 | ||
6. Create Non Cluster Index | |||
Create Non Cluster Index | 00:00:00 | ||
7. Composite Index | |||
Composite Index | 00:00:00 | ||
8. Use or Not Use Indexes | |||
Use or Not Use Indexes | 00:00:00 | ||
9. Deciding Factors in Creating Indexes | |||
Deciding Factors in Creating Indexes | 00:00:00 | ||
10. Using SQL Profiler for Indexes | |||
Using SQL Profiler for Indexes | 00:00:00 | ||
11. Reorganize and Rebuild Indexes | |||
Reorganize and Rebuild Indexes | 00:00:00 | ||
12. Intro To SQL Profiler | |||
Intro To SQL Profiler | 00:00:00 | ||
13. SQL Profiler Longest Running Query | |||
SQL Profiler Longest Running Query | 00:00:00 | ||
14. Audit Logins | |||
Audit Logins | 00:00:00 | ||
15. SQL Profile with Index Tuning | |||
SQL Profile with Index Tuning | 00:00:00 | ||
16. SQL Profiler Best Practice | |||
SQL Profiler Best Practice | 00:00:00 | ||
17. SQL Server Side Trace | |||
SQL Server Side Trace | 00:00:00 | ||
18. Database Engine Tuning Advisor | |||
Database Engine Tuning Advisor | 00:00:00 | ||
19. Statistics | |||
Statistics | 00:00:00 | ||
20. Activity Monitor | |||
Activity Monitor | 00:00:00 | ||
21. SQL Performance Monitor | |||
SQL Performance Monitor | 00:00:00 | ||
22. SQL Performance Hardware Issues | |||
SQL Performance Hardware Issues | 00:00:00 | ||
23. SQL Performance Monitoring Hardware CPU | |||
SQL Performance Monitoring Hardware CPU | 00:00:00 | ||
24. SQL Performance Monitoring Hardware Memory | |||
SQL Performance Monitoring Hardware memory | 00:00:00 | ||
25. SQL Performance Monitoring Hardware Disks | |||
SQL Performance Monitoring Hardware Disks | 00:00:00 | ||
26. SQL Perfmon Schedule | |||
SQL Perfmon Schedule | 00:00:00 | ||
27. DMV | |||
DMV | 00:00:00 | ||
28. Block and Locks | |||
Block and Locks | 00:00:00 | ||
29. Blocking | |||
Blocking | 00:00:00 | ||
30. Deadlock | |||
Deadlock | 00:00:00 | ||
31. Extended Events | |||
Extended Events | 00:00:00 | ||
32. Extended Events Via TSQL | |||
Extended Events Via TSQL | 00:00:00 | ||
33. Database Snapshots | |||
Database Snapshots | 00:00:00 | ||
34. Import Export Data | |||
Import Export Data | 00:00:00 | ||
35. BCP | |||
BCP | 00:00:00 | ||
36. Partition | |||
Partition | 00:00:00 | ||
37. Partion Part 2 | |||
Partion Part 2 | 00:00:00 | ||
38. Partitions | |||
Partitions | 00:00:00 | ||
39. Contained Database 1 | |||
Contained Database 1 | 00:00:00 | ||
40. Contained Database 2 | |||
Contained Database 2 | 00:00:00 | ||
41. Policy Based Management | |||
Policy Based Management | 00:00:00 | ||
42. Linked Server | |||
Linked Server | 00:00:00 | ||
43. Server Logs | |||
Server Logs | 00:00:00 | ||
44. SQL Admin Part 3 | |||
SQL Admin Part 3 | 00:00:00 |