# SQL Level 1 Course

Canonical URL: <https://www.graduateschool.edu/courses/sql-level-1>

## Overview

This introductory SQL course covers the basics of database architecture and writing SQL queries to extract and analyze data. You'll learn to write SELECT statements, filter results with WHERE, AND/OR, IN, and NOT, and combine data using INNER JOINs.

By the end, you'll be able to write basic SQL queries for Microsoft SQL Server and use SQL Server Management Studio to execute them. The concepts apply to other SQL platforms with minor syntax changes.

## What you'll learn

- Understand core database concepts, including tables, rows, columns, and various types of SQL
- Connect to databases and navigate SQL Server Management Studio using tools such as Object Explorer and Query Editor
- Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
- Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
- Explore data types, comparison operators, and case sensitivity to refine queries with more control
- Learn how to join tables using INNER JOIN and understand relational database concepts with ER diagrams and table aliases

## Curriculum

### Foundations of SQL & Databases

#### SQL Fundamental Concepts

- What is SQL & why is it used?
- Flavors of SQL: SQL Server vs Postgres, etc.
- Database Tables, Rows, & Columns

#### Exploring Databases & Writing SQL Statements (with the free SQL Server Management Studio app)

- Connecting to a Database
- Object Explorer
- SQL Query Editor
- Using Code Hints
- Viewing the Results of your SQL query
- Setting Preferences (Options)

### Writing SQL Queries

#### Writing SELECT Statements

- Syntax of a SELECT statement
- Selecting all columns or specific columns from a table
- Limiting the number of results using TOP
- Ordering the results using ORDER BY
- Returning only DISTINCT records (eliminating duplicates)

#### Filtering Results

- Data Types (Strings vs Numbers)
- Comparison Operators: equal to, greater or less than, not equal to, etc.
- Filtering results using WHERE, AND, OR, IN, and NOT
- Pattern Matching: Wildcard Filters
- Case Sensitivity

### Using Joins to Combine Data from Multiple Tables

#### Understanding Table Relationships

- What are Primary vs Primary Keys
- Creating ER (Entity Relationship) Diagrams to visual what’s in a database
- Database Relations: One-to-One, One-to-Many, & Many-to-Many

#### Combining Tables with JOIN

- Inner Joins
- Column & Table Aliases

## Schedule
- Jun 10, 2026 10:00am–5:00pm — Live Online
- Jul 27, 2026 10:00am–5:00pm — Live Online
- Sep 22, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $350