What Does a SQL Server DBA Do?
  • Course Introduction. What are we going to learn?
  • What Does A Database Do? It's Different Than What It Is.
  • DBA Daily Look
  • Where Do I Install It SQL Server?
  • The Language of SQL Server
  • What Are The Different Jobs A DBA Can Have?
  • What Are The ACID Properties
  • Key Terms
  • Summary
  • Quiz
Installing SQL Server
  • SQL Server Instances Explained
  • The Various Versions of SQL Server
  • The Services SQL Server Uses
  • What is Collation
  • Stepping Through A Basic Installation
  • The SQL Server Configuration Manager
  • Key Terms
  • Summary
  • Quiz
Creating Our Database
  • Database Files
  • Why Do We Need A Log and Data File?
  • File Groups
  • Key Terms
  • Summary
  • Quiz
Manipulating Our Databases
  • Detach and Attach. The Fastest Way To Move a SQL Server Database.
  • The States of a Database
  • Modifying A SQL Server Database
  • Key Terms
  • Summary
  • Section 4 Quiz
The Table Object
  • Table Basics - Part 1
  • Table Basics - Part 2
  • Heap Versus Table With Clustered Index
  • Key Terms
  • Summary
  • Section 5 Quiz
Transact-SQL. The Language of SQL Server
  • DML and DDL
  • The Anatomy of a SELECT Statement
  • The Big 4
  • Key Terms
  • Summary
  • Section 6 Quiz
The Fundamentals of Stored Procedures
  • Defining and Creating Our First Stored Procedure
  • Passing Parameters Into Our Stored Procedures
  • What's A Plan?
  • Key Terms
  • Summary
  • Section 7 Quiz
Conclusion
  • Congratulations and Thank you!!!
  • Bonus Lecture: What Course Should You Take Next?