Course 3: SQL Server Administration Part 1
17 STUDENTS ENROLLED
The following course will introduce to you the foundation of SQL Server Administration as it’s practiced in the production real world situations. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. The course will cover the following:
- What is SQL Server administration?
- How to install SQL Server in a virtual environment?
- The importance of backing up and restoring databases
- Reviewing SQL Server automation with SQL Agent
- Managing SQL Server Security and much more
Course Curriculum
1. SQL Admin Part 1 Scripts and Docs | |||
SQL Admin Part 1 Scripts and Docs | 00:00:00 | ||
2. What is a Domain | |||
What is a domain | 00:00:00 | ||
3. Software to Download and Install | |||
Software to Download and Install | 00:00:00 | ||
4. Create Virtual Machine Domain Controller | |||
Create Virtual Machine Domain Controller | 00:00:00 | ||
5. Domain Controller with Active Directory | |||
Domain Controller with Active Directory | 00:00:00 | ||
6. Create Vm for SQL Server 2012 Install Part 1 | |||
Create VM for SQL Server 2012 Install Part 1 | 00:00:00 | ||
7. Create VM for SQL Server 2012 Install Part 2 | |||
Create VM for SQL Server 2012 Install Part 2 | 00:00:00 | ||
8. Install SQL On Separate Drive with Service Accounts | |||
Install SQL On Separate Drive with Service Accounts | 00:00:00 | ||
9. Installing Service Packs and Fixes | |||
Installing Service Packs and Fixes | 00:00:00 | ||
10. Touring SSMS | |||
Touring SSMS | 00:00:00 | ||
11. System Databases | |||
System Databases | 00:00:00 | ||
12. SQL Data and Log Files | |||
SQL Data and Log Files | 00:00:00 | ||
13. AutoGrowth | |||
AutoGrowth | 00:00:00 | ||
14. Transaction Log ATM Example | |||
Transaction Log ATM Example | 00:00:00 | ||
15. Recovery Models | |||
Recovery Models | 00:00:00 | ||
16. Function fn_dblog to View Inside a t log | |||
Function fn_dblog to View Inside a t log | 00:00:00 | ||
17. VLF | |||
VLF | 00:00:00 | ||
18. Create a Database | |||
Create a Database | 00:00:00 | ||
19. Tempdb | |||
Tempdb | 00:00:00 | ||
20. Attach Dettach Database | |||
Attach Dettach Database | 00:00:00 | ||
21. Introduction to Backup | |||
Introduction to Backup | 00:00:00 | ||
22. Full Database Backup | |||
Full Database Backup | 00:00:00 | ||
23. Transactional Log Backups | |||
Transactional Log Backups | 00:00:00 | ||
24. Differential Backups | |||
Differential Backups | 00:00:00 | ||
25. Introduction to Restore | |||
Introduction to Restore | 00:00:00 | ||
26. Restore with GUI | |||
Restore with GUI | 00:00:00 | ||
27. Restore using Differential | |||
Restore using Differential | 00:00:00 | ||
28. Recovery State in Restores | |||
Recovery State in Restores | 00:00:00 | ||
29. Recovery with Tail log | |||
Recovery with Tail log | 00:00:00 | ||
30. Backup using Maintenance Plan | |||
Backup using Maintenance Plan | 00:00:00 | ||
31. Backup Admin database using Maintenance Plan | |||
Backup Admin database using Maintenance Plan | 00:00:00 | ||
32. Maintenance Plan Tasks | |||
Maintenance Plan Tasks | 00:00:00 | ||
33. Shrink a Database | |||
Shrink a Database | 00:00:00 | ||
34. Using SQL Agent | |||
Using SQL Agent | 00:00:00 | ||
35. Create a Simple Backup Job Using SQL Agent | |||
Create a Simple Backup Job Using sql Agent | 00:00:00 | ||
36. DBCC CheckDB | |||
DBCC CheckDB | 00:00:00 | ||
37. Using SQL Agent With Multiple Steps | |||
Using SQL Agent With Multiple Steps | 00:00:00 | ||
38. Setting up SQL Database Mail | |||
Setting up SQL Database Mail | 00:00:00 | ||
39. Setting up SQL Database Mail Part2 | |||
Setting up SQL Database Mail Part2 | 00:00:00 | ||
40. Alerts Severity Errors | |||
Alerts Severity Errors | 00:00:00 | ||
41. Central Management with SQL Agent (CORRECTION) | |||
Central Management with SQL Agent (CORRECTION) | 00:00:00 | ||
42. Central Management with SQL Agent | |||
Central Management with SQL Agent | 00:00:00 | ||
43. VMware Pro Player | |||
VMware Pro Player | 00:00:00 | ||
44. Introduction to Security | |||
Introduction to Security | 00:00:00 | ||
45. Demo of Users Login Roles | |||
Demo of Users Login Roles | 00:00:00 | ||
46. TSQL for Security | |||
TSQL for Security | 00:00:00 | ||
47. Authentication and Mixed Mode | |||
Authentication and Mixed Mode | 00:00:00 | ||
48. Using SQL Login | |||
Using SQL Login | 00:00:00 | ||
49. Understanding SQL Roles | |||
Understanding SQL Roles | 00:00:00 | ||
50. Managing Roles via TSQL | |||
Managing Roles via TSQL | 00:00:00 | ||
51. SQL Server Roles | |||
SQL Server Roles | 00:00:00 | ||
52. Managing Permission | |||
Managing Permission | 00:00:00 | ||
53. Best Practice Security | |||
Best Practice Security | 00:00:00 |