Databases and SQL Server

Programs need somewhere to keep their data. You will learn what a relational database is, then meet SQL Server and the tool you will use to work with it, SQL Server Management Studio.

Updated

Introduction to Databases

  1. What is a Database? (Novice): A database is an organized place where an application stores its information so it can manage it and find it again quickly.
  2. Why Do We Need Data Storage? (Novice): Applications keep their data in a database to have it in one place, keep it accurate and secure, manage it quickly, and grow as the data grows.
  3. What is an RDBMS (Novice): A relational database management system (RDBMS) such as SQL Server stores data in tables of rows and columns, and links the tables with primary and foreign keys.

Using SQL Server

  1. SQL Server Management Studio (Novice): Create the course's sample databases in SSMS, find your way around Object Explorer, and run your first queries.