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.
Overview
Syllabus
Introduction
- Don't let your reporting system hold you back
- Who this course is for
- What is SQL?
- Get familiar with phpMyAdmin
- Understand the demo database
- 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
- 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
- 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
- Save your queries using a VIEW
- Use variables
- Use functions
- Use procedures
- Next steps and additional resources
Taught by
Emma Saunders
