Course Curriculum
Introduction
Available in
days
days
after you enroll
Installing SQL Server like a professional
Available in
days
days
after you enroll
Creating Databases - What DBA's should know!
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
SQL Server DBA - Performance Tuning
Available in
days
days
after you enroll
Extra Topics
Available in
days
days
after you enroll
-
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.
Available in
days
days
after you enroll
Security For DBA's
Available in
days
days
after you enroll
SQL Server Training Path
Available in
days
days
after you enroll
Completion
Available in
days
days
after you enroll