Chapter 7

SQL Part 1: Introduction and Azure Data Studio

Learning Objectives

Upon completing all the content in this chapter, you should be able to do the following:

  1. Understand what a relational database is and how SQL is used to manage it.
  2. Write SQL queries to perform read operations.
  3. Understand different types of table relationships and what foreign/primary keys are.

Key Terminology

Here is a list of key terms for this chapter, based on what page the term first appears. Make note of these terms and their definitions.

What is SQL?

  1. Relational databases
  2. Structured Query Language
  3. SQL
  4. Relational Database Management System
  5. RDMS
  6. Transact-SQL
  7. T-SQL

SQL Queries

  1. query
  2. result set
  3. CRUD

Table Relationships

  1. primary key
  2. foreign key

Content Links