What You Will Learn

The Structured Query Langauge (SQL) is a must for anyone who wants to work in, or around, data; in this course, we will introduce you to SQL through theory and practice.

  • Learn about Relational Databases

  • Learn how to write SQL Statements

  • No Programming knowledge required

  • Permission to install software

Course curriculum

  • 1

    Introduction

    • About This Course

    • What IS in this Course

    • What IS NOT in this Course
  • 2

    Database Technologies

    • Introduction

    • Relational Databases

    • Relational Database Management Systems (RDBMS)

    • Not Only SQL (NoSQL) Databases

    • Summary
  • 3

    Installing a RDBMS

    • Introduction

    • MySQL

    • Oracle Database Express Edition (XE)

    • Microsoft SQL Server Developer Edition

    • Summary
  • 4

    The SELECT Statement

    • Introduction

    • SELECT FROM

    • SELECT FROM WHERE

    • SELECT FROM WHERE IN

    • SELECT FROM WHERE LIKE

    • SELECT FROM GROUP BY

    • SELECT FROM GROUP BY HAVING

    • SELECT FROM ORDER BY

    • SELECT FROM INNER JOIN

    • SELECT FROM LEFT OUTER JOIN

    • SELECT FROM RIGHT OUTER JOIN

    • SELECT FROM FULL OUTER JOIN

    • Summary
  • 5

    SQL Exercises

    • Introduction

    • SQL Exercise 1

    • SQL Exercise 2

    • SQL Exercise 3

    • SQL Exercise 4

    • SQL Exercise 5

    • Summary
  • 6

    Other Considerations

    • Introduction

    • The INSERT Statement

    • The UPDATE Statement

    • The DELETE Statement

    • Stored Procedures

    • Functions

    • Views

    • Thinking about Performance

    • Summary
  • 7

    Closing the Course

    • Course Review

    • Thank You