Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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 (Free) 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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: SQL Server Administration Part 1|
What is a DomainPreview
Software to download and installPreview
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
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
Worked as a Production SQL Database Administrator for over 10 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Created five 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 enviroement. I want to pass that experience and information to my students.