00-Beginning.md

Beginning

Basic SQL Statements

By the end of this section, you will be able to:

1. Describe the structure of a SQL query
2. Query a table to retrieve existing data
3. Filter data in a query using basic operators, including:
   • SELECT, FROM, WHERE, AND, BETWEEN, NOT BETWEEN, >, <, =, !=, and DISTINCT
4. Explain how to read an entity relationship diagram (ERD)

Prerequisites

• No SQL experience needed! Welcome!

Lesson

Objective 1: Describe the structure of a SQL query

SELECT * FROM employees;

Objective 2: Query a table to retrieve existing data

• SELECT Queries Introduction
  • make sure you press 'reset' when you want to clear the query

Objective 3: Filter data in a query using basic operators, including: SELECT, FROM, WHERE, AND, DISTINCT

• SELECT with Constraints
• Filtering Query Results

Objective 4: Explain how to read an entity relationship diagram (ERD)

• SQLPrep ERD

Assessment

• Daily Challenge 1
  • Note: Use this alternate Challenge Prompt: Show all the information for the offices table.
• Daily Challenge 4
• Daily Challenge 15