SQL: Data Reporting and Analysis

Focused View

Emma Saunders

2:32:36

253 View

01 - Introduction

01 - Don't let your reporting system hold you back.mp4

00:39

02 - Who this course is for.mp4

00:20

03 - What is SQL.mp4

04:12

02 - 1. Prepare to Code in SQL

01 - Get familiar with phpMyAdmin.mp4

03:45

02 - Understand the demo database.mp4

01:34

03 - 2. Use SQL to Report Data

01 - Retrieve data with SELECT.mp4

05:31

02 - Filter results with the WHERE clause.mp4

05:04

03 - Use LIKE, IN, and wildcards with WHERE.mp4

05:39

04 - Sort SQL results with ORDER BY.mp4

01:42

05 - Use string functions on your data.mp4

06:41

06 - More advanced string functions.mp4

08:35

07 - Change report headings with an alias.mp4

02:28

08 - Use date functions with WHERE.mp4

08:50

09 - Challenge Query a table.mp4

01:07

10 - Solution Query a table.mp4

01:23

11 - Challenge Convert case.mp4

00:50

12 - Solution Convert case.mp4

02:30

04 - 3. Group Your SQL Results

01 - Use GROUP BY with count.mp4

05:47

02 - Filter grouped results with HAVING.mp4

04:31

03 - Deduplicate with SELECT DISTINCT.mp4

06:30

04 - Merge rows with GROUP BY.mp4

02:24

05 - Challenge Cost analysis.mp4

01:17

06 - Solution Cost analysis.mp4

01:32

05 - 4. Merge Data from Multiple Tables

01 - Make your queries faster.mp4

01:47

02 - Understand SQL indexes and keys.mp4

07:16

03 - EDIT Visualize your database.mp4

07:58

04 - Merge data across tables with JOIN.mp4

05:02

05 - Understand SQL JOINS.mp4

04:16

06 - Combine rows with SQL UNION.mp4

04:49

07 - Merge data across tables with IN.mp4

02:11

08 - Select from a selection with subqueries.mp4

02:56

09 - Challenge Join tables.mp4

01:04

10 - Solution Join tables.mp4

04:37

06 - 5. More Advanced SQL

01 - Save your queries using a VIEW.mp4

08:28

02 - Use variables.mp4

05:17

03 - Use functions.mp4

08:04

04 - Use procedures.mp4

04:58

07 - Continuing Your SQL Learning Journey

01 - Next steps and additional resources.mp4

01:02

Description

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 using a publicly accessible online database. 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

SQL

Emma Saunders

Instructor's Courses

Data visualisations, training & consultancy. D3.js, Power BI custom visuals, js-based web apps. Design and delivery. Online courses at LinkedIn Learning.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.