Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Learning SQL Programming

via LinkedIn Learning

Go to class Write review

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

Taught by

Scott Simpson

Reviews

4.0 rating, based on 1 Class Central review

4.8 rating at LinkedIn Learning based on 3900 ratings

Start your review of Learning SQL Programming

Aditya Kokate

It was nice and good to learn this SQL course, it has taught all basics of sql from creating the table to modifying it and also to solve some common mistakes while solving or creaing the database.