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
How to update data in a table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock