Introduction
Installing SQL Server like a professional
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
SQL Server DBA - Performance Tuning
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.
Security For DBA's
SQL Server Training Path
Completion
