Become a Production SQL Server Database Administrator
- 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
