Primary Pages

• Home
• First Steps
• Blog
• Book Code (Coming Soon)
• Books For Sale
• About

Steps 1-9

• Install SQL Server 2022 Developer Edition
• Install SSMS ver. 18 & Connect to SQL Server
• Installing SQL Server AdventureWorks2022 Sample Database
• Understanding RDBMS and Set Theory
• SQL Server Data Types
• A quick look at Schemas
• Create Table with SSMS GUI
• Create Table with T-SQL
• Creating Views with T-SQL

• SQL Server (T-SQL) Keywords by Category
• T-SQL Coding Standards and Best Practices
• What Does a DBA Do All Day?
• Copy Tables
• DELETE vs. TRUNCATE Which One Should You Use

SQL Practice & Interview Questions (book)

• Coming Soon