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

LinkedIn Learning

SQL: Data Reporting and Analysis

via LinkedIn Learning

Go to class Write review
Scrimba Ad

Our career paths help you become job ready faster

Learn More → Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.

Syllabus

Introduction
  • Don't let your reporting system hold you back
  • Who this course is for
  • What is SQL?
1. Prepare to Code in SQL
  • Get familiar with phpMyAdmin
  • Understand the demo database
2. Use SQL to Report Data
  • Retrieve data with SELECT
  • Filter results with the WHERE clause
  • Use LIKE, IN, and wildcards with WHERE
  • Sort SQL results with ORDER BY
  • Use string functions on your data
  • More advanced string functions
  • Change report headings with an alias
  • Use date functions with WHERE
  • Challenge: Query a table
  • Solution: Query a table
  • Challenge: Convert case
  • Solution: Convert case
3. Group Your SQL Results
  • Use GROUP BY with count
  • Filter grouped results with HAVING
  • Deduplicate with SELECT DISTINCT
  • Merge rows with GROUP BY
  • Challenge: Cost analysis
  • Solution: Cost analysis
4. Merge Data from Multiple Tables
  • Make your queries faster
  • Understand SQL indexes and keys
  • EDIT: Visualize your database
  • Merge data across tables with JOIN
  • Understand SQL JOINS
  • Combine rows with SQL UNION
  • Merge data across tables with IN
  • Select from a selection with subqueries
  • Challenge: Join tables
  • Solution: Join tables
5. More Advanced SQL
  • Save your queries using a VIEW
  • Use variables
  • Use functions
  • Use procedures
Continuing Your SQL Learning Journey
  • Next steps and additional resources

Taught by

Emma Saunders

Reviews

4.7 rating at LinkedIn Learning based on 2530 ratings

Start your review of SQL: Data Reporting and Analysis

Go to class

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.