Learning SQL Programming

Overview

Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.

Syllabus

Introduction

  • Learning SQL programming
  • Exercise files
  • Exploring DB Browser for SQLite
  • 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
  • Adding more criteria to a statement
  • Broadening and limiting responses
  • Organize responses with ORDER BY
  • Find information about the data
  • Challenge: Retrieve data from the database
  • Solution: Retrieve data from the database

2. Ask for Data from Two or More Tables

  • Ask for data across two or more tables
  • Understand JOIN types
  • Grouping results
  • Challenge: Practice with JOINs
  • Solution: Practice with JOINs

3. Data Types, Math, and Helpful Features

  • Data types in SQL
  • Math in SQL
  • Compound Select
  • Transforming data
  • Creating aliases with AS
  • Challenge: Calculate participant metrics
  • Solution: Calculate participant metrics

4. Add or Modify Data

  • Add data to a table
  • Modify data in a table
  • Removing data from a table
  • Challenge: Practice working with data
  • Solution: Practice working with data

Conclusion

  • Overcoming common SQL mistakes
  • Next steps

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Cart
  • Your cart is empty.