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

LinkedIn Learning

Intermediate SQL: Data Reporting and Analysis

via LinkedIn Learning

Write review
Train in Data Ad

Master Production-Ready Machine Learning, Step by Step

Learn More → Destination Certification Ad

CISSP MasterClass with a true CAT exam simulator

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Take your data skills to the next level with SQL by learning how to write code for more complex queries to report, edit, insert, and delete data from your database.

Syllabus

Introduction
  • Learn hands-on to extract, manipulate, edit, and delete real data
  • Who this course is for
  • What can you do with intermediate SQL?
1. Prepare to Code in SQL
  • Get familiar with phpMyAdmin
  • Understand the demo database
  • Using ChatGPT to check SQL code
2. Reporting Data with SQL
  • The basic SELECT query
  • Aggregated results with GROUP BY
  • Wildcards and aliases
  • Merging tables with JOIN
  • Use string functions
  • Use number functions with grouped data
  • Use date functions
  • Challenge: Report average cost by staff
  • Solution: Report average cost by staff
3. Editing Data
  • UPDATE fields in a table
  • Common issues with the UPDATE command
  • Automating your query creation
  • Updating a field using JOIN
  • Updating dynamically
  • Challenge: Update the film table using JOIN
  • Solution: Update the film table using JOIN
4. Inserting Data
  • INSERT rows into a table
  • Common issues with the INSERT command
  • Using MERGE instead of UPDATE/INSERT
  • Duplicate table with SELECT
  • Challenge: Insert a row into the film table
  • Solution: Insert a row into the film table
5. Deleting Data
  • DELETE rows from a table
  • DROP an entire table
  • ALTER TABLE for modifying fields
  • Problems with foreign key constraints
  • Challenge: Delete from the country table
  • Solution: Delete from the country table
Conclusion
  • Next steps

Taught by

Emma Saunders

Reviews

4.6 rating at LinkedIn Learning based on 437 ratings

Start your review of Intermediate SQL: Data Reporting and Analysis

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.