Setup Menus in Admin Panel

Home
Course
Course 4: SQL Server Administration Part II

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