Module 5 Part 1: Queries and Introduction to SQL

Learning Outcome

Demonstrate competencies in basic features of the Structured Query Language (SQL)

Class Agenda

Conceptual Framework

Hour of Code on Database by Khan Academy

Introduction to SQL by Khan Academy

SQL and Relational Database 101 by Big Data University


Querying Relational Databases (6.5 minutes)

Introduction to SQL (4.5 minutes)

Basic SELECT Statement (10 minutes)

MEC SELECT_FROM Video

MEC SELECT_FROM_WHERE Video

SQL for Web Nerds


The Magic of SQL

Tables

Select and Where

Insert and Commit

Joins

Practical Applications

Section A of "Getting Started" of the Atomic Learning Access Training Collection: Working with Access Objects - Queries

Section H "Working with Queries" of the Atomic Learning Access Training Collection (25 minutes) 

Instructions for Assignment Due Before Next Class Available in Moodle

Atomic Learning Assessment: Working with Queries