Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The SQL Server DBA Bootcamp: Beginner To Expert
Introduction
Introduction (1:18)
Installing SQL Server like a professional
Installing SQL Server Database Engine (9:02)
Assignment Time : Install a 'Named Instance' SQL Server
Install Management Studio (5:01)
Setup and creating test data (1:09)
Installation Quiz
Creating Databases - What DBA's should know!
MDF vs LDF Files
Creating a database using SQL Server Management Studio (SSMS) (2:33)
Creating databases using TSQL (2:30)
Creating, deleting and altering a table using TSQL (7:40)
Creating, altering and deleting a table using SQL Server Managent Studio (SSMS) (4:11)
Multiple File Groups - What they are (1:21)
Multiple File Groups - Practical (3:56)
T-SQL for Beginners
SELECT (4:04)
UNION (1:28)
DATE Functions (5:08)
CASE Statements (3:10)
JOINS : INNER, LEFT AND RIGHT JOINS - PART 1
JOINS : INNER, LEFT AND RIGHT JOINS - PART 2 (11:36)
Which JOIN is better? PART 1 (4:20)
Which JOIN is better? PART 2
COUNT Statement (3:23)
SUM Statement (2:39)
AVG (Average) Statement (3:29)
Filter GROUP BY Statement using HAVING Statements (4:27)
How to insert data into a table (2:57)
How to update data in a table (2:52)
How to delete information from a table (2:26)
IF / ELSE (4:53)
IF / ELSE Further Reading
Stored Procedures (3:35)
Views (2:29)
Backup And Restore
Backing up and restoring a database - Overview (2:27)
Backing up and restoring a database using SQL Server Management Studio (SSMS) (1:56)
Backing up and restoring a database using TSQL (1:29)
Further Reading - Backup and Restore
Assignment : Backing up and restoring
SQL Server DBA - Performance Tuning
Creating Indexes - Part 1 (2:28)
Creating Indexes - Part 2 (3:39)
When not to use an Index
Fragmentation - Rebuilding Indexes (4:13)
Extra Topics
SA vs Windows Account (3:55)
SQL Server Configuration Manager (3:23)
SQL Server Maximum Memory Setting (2:17)
Database Default Locations - Part 1 (1:08)
Database Default Locations - Part 2
What is the SQL Server Agent (10:25)
Detaching and Attaching Databases (2:26)
The System databases (1:47)
TempDB File growth and location settings (3:03)
'Killing' processes (1:59)
Importing data from a text file.
Importing data from a text file (5:40)
Security For DBA's
Logins and Roles - Part 1 (3:45)
Logins and Roles - Part 2
SQL Server Training Path
SQL Server Training Path
Completion
Certificate Of Completion
Teach online with
What is the SQL Server Agent
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock