SQL: Data Reporting and Analysis

Description

In this course, you will :

• SELECT statements are used to retrieve data.
• Sorting and filtering your results
• Using built-in SQL functions to transform results.
• SQL result grouping
• Data from multiple tables is merged.
• Variables, functions, and procedures are used.

Syllabus :

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 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 alias
• Use date functions with WHERE

 

3. Group Your SQL Results

• Use GROUP BY with count
• Filter grouped results with HAVING
• De-duplicate with SELECT DISTINCT
• Merge rows with GROUP BY

 

4. Merge Data from Multiple Tables

• Make your queries faster
• Understand SQL indexes and keys
• 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

 

5. More Advanced SQL

• Save your queries using a VIEW
• Use variables
• Use functions
• Use procedures

Show more