Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning SQL Programming

Video Introducing this tutorial

Introduction

Welcome
Use the exercise files
Explore DB Browser
What is a database?
What is SQL?

1. Ask for Data from a Database

Ask for data with SELECT
Narrow down a query with WHERE
Add more criteria to a statement
Limit responses
Organize responses with ORDER BY
Find information about the data

2. Ask for Data from Two or More Tables

Ask for data across two or more tables
Understand JOIN types
Combine results

3. Data Types, Math, and Helpful Functions

Data types in SQL
Math in SQL
Compound Select
Transform data
Use aliases to shorten field names

4. Add or Modify Data

Add data to a table
Modify data in a table
Remove data from a table

Conclusion

Overcome common SQL mistakes
Next steps