Setup Menus in Admin Panel

Home
Course
Course 3: SQL Server Administration Part 1

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