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

LinkedIn Learning

Learning SQL Programming

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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

Start your review of Learning SQL Programming

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.