Setup Menus in Admin Panel

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
top
© Copyright by Rafacademy@2016