Post

SQL Foundations (Video Course)

SQL is a foundational skill for developers, analysts, and anyone who works with data. My recent course, SQL Foundations, is now available through InformIT!

Here’s the official description:

Whether you’re in business, tech, or any field that touches data, these foundational skills will make you more effective at your job.

SQL allows us to get data from databases, and to store and modify information in those databases. Most knowledge work involves using data, and in business and many other fields, this data is stored in databases. So, learning to access this data using SQL is a critical skill for modern workers.

This course takes you from database basics to practical, real-world usage. You’ll start by understanding how databases differ from spreadsheets and how tables, columns, rows, and relationships work together. Then, you’ll learn to retrieve and filter data with SELECT and WHERE, sort and limit results, and use aggregate functions to summarize information. You’ll explore joining multiple tables to answer complex questions, and learn to insert, update, and delete records as needed. The course includes hands-on challenges where you’ll design databases, create reports, and manipulate data just like you would do on the job. You’ll even explore how AI tools can assist with SQL, giving you a complete toolkit for working with databases in today’s world.

Check it out today!

This post is licensed under CC BY 4.0 by the author.