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
Completion
Available in
days
days
after you enroll