SQL: Data Reporting and Analysis

SQL: Data Reporting and Analysis
SQL: Data Reporting and Analysis
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 17m | 420 MB

Do you rely on IT to get the data you need? Are you often stuck waiting in line for data, and wish you could just retrieve it yourself? In this course, learn how to get the data you want by writing a bit of SQL code. You won’t just be able to pull data out of the database; you’ll be able to manipulate it: merging it, grouping it, and relabeling it to get just the report you want. Join Emma Saunders as she shows how to write simple SQL queries for data reporting and analysis. Learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, she introduces views, procedures, functions, and variables.

Topics include:

  • Retrieving data with SELECT statements
  • Filtering and sorting your results
  • Transforming results with built-in SQL functions
  • Grouping SQL results
  • Merging data from multiple tables
  • Using variables, functions, and procedures
Table of Contents

1 Don’t let your reporting system hold you back
2 Who this course is for
3 What is SQL
4 Get familiar with phpMyAdmin
5 Understand the demo database
6 Retrieve data with SELECT
7 Filter results with WHERE clause
8 Use LIKE, IN, and wildcards with WHERE
9 Sort SQL results with ORDER BY
10 Use string functions on your data
11 More advanced string functions
12 Change report headings with alias
13 Use date functions with WHERE
14 Use GROUP BY with count
15 Filter grouped results with HAVING
16 De-duplicate with SELECT DISTINCT
17 Merge rows with GROUP BY
18 Make your queries faster
19 Understand SQL indexes and keys
20 Visualize your database
21 Merge data across tables with JOIN
22 Understand SQL JOINS
23 Combine rows with SQL UNION
24 Merge data across tables with IN
25 Select from a selection with subqueries
26 Save your queries using a VIEW
27 Use variables
28 Use functions
29 Use procedures
30 Next steps