- What is a Domain
- Software to download and install
- POST ADDENDUM
- APPS NEEDED
- CREATE VM
- INSTALL SQL SERVER 2017
- ADVENTUREWORKS 2017 DB
- COMPARISON OF SQL 2014 VS 2017
- Create Virtual Machine Domain Controller
- Promote Domain Controller to Active Directory
- Create Vm for SQL Server 2012 Install Part1
- Create Vm for SQL Server 2012 Install Part 2
- Install SQL On Separate Drive with Service Accounts Part 1
- Install SQL On Separate Drive with Service Accounts Part 2
- Installing Service Packs and Fixes (SP2)
- Touring SQL Server Management Studio (SSMS)
- Introduction to System Databases
- SQL Server Data and Log Files
- Detail Transaction log ATM Example
- Auto Growth and sizing of transaction log
- Types of Recovery Models
- Function fn_dblog to view inside a transaction log
- What is virtual log file (VLF)
- Create a SQL database
- The importance of Tempdb
- Attach and detach a database
- Introduction to Backups
- Full Database Backup
- Transactional Log Backups
- Differential Backups
- Introduction to Restore
- Restore database with GUI
- Restore database using differential
- Recovery mode with tail log backup
- Backup using Maintenance plan
- Backup database using Maintenance plan
- Maintenance Plan Tasks
- Don’t shrink a database
- The importance of using SQL Server Agent
- Create a simple backup job using SQL Server Agent
- The importance of DBCC CheckDB
- Using SQL Server Agent with multiple steps
- Setting up SQL Database Mail
- Setting up SQL Database Mail Part2
- Setting up alerts Severity Errors from 17 to 25
- Central Management with SQL Server Agent (CORRECTION)
- Central Management with SQL Server Agent
- Installing free VMware Pro Player for virtualization
- Introduction to SQL Server Security
- Demonstration of Users Logins Roles
- Managing security with T SQL
- Selecting Authentication or Mixed Mode security
- Accessing SQL Server using SQL Login
- Understanding SQL Server Roles
- Managing SQL Server Roles via TSQL
- SQL Server Roles Demonstration
- Managing SQL Server Permissions
- Best SQL Server Practice Security
- SQL ADMINISTRATION PART 2 TABLE OF CONTENT
What you'll learn
- Manage SQL Server Administration; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more
Description
The following course will introduce to you the foundation of SQL Server Administration Part 1 as it's practiced in the production real world situations. I have designed this course for the beginner but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. My first course T-SQL, while not mandatory, should be taken so you gain a better understanding of this course. All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and fullfill you future goals. These courses will give you that direction.
Students also bought
Información sobre el Instructor

- 4.43 Calificación
- 105265 Estudiantes
- 25 Cursos
Raphael Asghar
Production SQL Database Administrator
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.
Student feedback
Course Rating
Reviews
good and it is meeting expectation