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
Course content
- Preview07:12What is a Domain
- Preview08:03
- 08:11POST ADDENDUM
- 07:34APPS NEEDED
- 18:22CREATE VM
- 09:43INSTALL SQL SERVER 2017
- 08:13ADVENTUREWORKS 2017 DB
- 02:38COMPARISON OF SQL 2014 VS 2017
- 06:00Create Virtual Machine Domain Controller
- 15:06Promote Domain Controller to Active Directory
- 10:29Create Vm for SQL Server 2012 Install Part1
- 13:46Create Vm for SQL Server 2012 Install Part 2
- 11:13Install SQL On Separate Drive with Service Accounts Part 1
- 13:23Install SQL On Separate Drive with Service Accounts Part 2
- 09:20Installing Service Packs and Fixes (SP2)
- 10:28Touring SQL Server Management Studio (SSMS)
- 13:32Introduction to System Databases
- 08:21SQL Server Data and Log Files
- 07:35Detail Transaction log ATM Example
- 16:11Auto Growth and sizing of transaction log
- 12:15Types of Recovery Models
- 07:18Function fn_dblog to view inside a transaction log
- 11:22What is virtual log file (VLF)
- 14:06Create a SQL database
- 13:24The importance of Tempdb
- 08:28Attach and detach a database
- 13:45Introduction to Backups
- 10:59Full Database Backup
- 10:56Transactional Log Backups
- 08:16Differential Backups
- 05:19Introduction to Restore
- 11:39Restore database with GUI
- 09:11Restore database using differential
- 11:56Recovery mode with tail log backup
- 11:11Backup using Maintenance plan
- 10:33Backup database using Maintenance plan
- 05:45Maintenance Plan Tasks
- 15:43Don’t shrink a database
- 07:58The importance of using SQL Server Agent
- 05:20Create a simple backup job using SQL Server Agent
- 09:38The importance of DBCC CheckDB
- 05:59Using SQL Server Agent with multiple steps
- 10:58Setting up SQL Database Mail
- 05:16Setting up SQL Database Mail Part2
- 14:23Setting up alerts Severity Errors from 17 to 25
- 00:52Central Management with SQL Server Agent (CORRECTION)
- 12:21Central Management with SQL Server Agent
- 17:44Installing free VMware Pro Player for virtualization
- 13:44Introduction to SQL Server Security
- 11:43Demonstration of Users Logins Roles
- 06:27Managing security with T SQL
- 13:19Selecting Authentication or Mixed Mode security
- 12:46Accessing SQL Server using SQL Login
- 11:45Understanding SQL Server Roles
- 05:57Managing SQL Server Roles via TSQL
- 12:59SQL Server Roles Demonstration
- 14:38Managing SQL Server Permissions
- 13:22Best SQL Server Practice Security
- 00:53SQL ADMINISTRATION PART 2 TABLE OF CONTENT
Requirements
- While not 'mandatory', it is highly recommended that the student take my first course T-SQL - and have access to a desktop or laptop. All software, scripts, documentation will be provided
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.
Who this course is for:
- I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration
Instructor
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.