Course Highlights
  • Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables
Curriculum

63 Topics
SQL SERVER 2019 PART 1
SQL SERVER 2019 PART 2
SQL SERVER 2019 PART 3
SQL SERVER 2019 PART 4
SQL SERVER 2019 PART 5
SQL SERVER 2019 PART 6
HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS
Introduction to Becoming a Production SQL Server Administrator
What is TSQL
POST ADDENDUM
APPLICATIONS NEEDED
CREATE A VIRTUAL MACHINE
INSTALL SQL SERVER 2017
ADD ADVENTUREWORKS2017 DATABASE
SQL SERVER 2014 AND 2017 COMPARISON
SQL Express 2012 Install
SQL AdventureWorks2012 Database
What is Database and a Table
Select
Where
Where With Like
Order By
Quiz 1
Insert Into
Update
Delete
IN Operator
Between
Quiz 2
Create Database
Create Table
Create Temp Table
Constraints Part 1
Constraints Part 2
Aliases
Quiz 3
Joins
Quiz 4
Union
Aggregates
Group By and Having
Alter
Null
ISNULL
Quiz 5
Select Into
Subquery
Data Type
Cast and Convert
String Function
Numeric and Date Function
Quiz 6
Views
Case
Indexes
Stored Procedure
Quiz 7
Triggers
Design Query Editor
Rank
Extra Quiz with answers
SQL Server Administration Part 1
BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA

  Write a Review

Learn T-SQL From Scratch For SQL Server Administrator

Go to Paid Course