Setup Menus in Admin Panel

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