Intermediate SQL: Data Reporting and Analysis

Focused View

Emma Saunders

2:11:11

115 View

01 - Introduction

01 - Learn hands-on to extract, manipulate, edit, and delete real data.mp4

00:39

02 - Who this course is for.mp4

00:44

03 - What can you do with intermediate SQL.mp4

01:36

02 - 1. Prepare to Code in SQL

01 - Get familiar with phpMyAdmin.mp4

03:01

02 - Understand the demo database.mp4

03:30

03 - 2. Reporting Data with SQL

01 - The basic SELECT query.mp4

01:57

02 - Aggregated results with GROUP BY.mp4

01:51

03 - Wildcards and aliases.mp4

06:00

04 - Merging tables with JOIN.mp4

03:56

05 - Use string functions.mp4

08:06

06 - Use number functions with grouped data.mp4

06:46

07 - Use date functions.mp4

06:07

08 - Challenge Report average cost by staff.mp4

00:53

09 - Solution Report average cost by staff.mp4

01:49

04 - 3. Editing Data

01 - UPDATE fields in a table.mp4

06:11

02 - Common issues with the UPDATE command.mp4

07:53

03 - Automating your query creation.mp4

03:52

04 - Updating a field using JOIN.mp4

01:47

05 - Updating dynamically.mp4

08:29

06 - Challenge Update the film table using JOIN.mp4

00:44

07 - Solution Update the film table using JOIN.mp4

02:52

05 - 4. Inserting Data

01 - INSERT rows into a table.mp4

06:28

02 - Common issues with the INSERT command.mp4

07:08

03 - Using MERGE instead of UPDATEINSERT.mp4

08:40

04 - Duplicate table with SELECT.mp4

05:28

05 - Challenge Insert a row into the film table.mp4

00:37

06 - Solution Insert a row into the film table.mp4

01:45

06 - 5. Deleting Data

01 - DELETE rows from a table.mp4

05:20

02 - DROP an entire table.mp4

02:45

03 - ALTER TABLE for modifying fields.mp4

03:23

04 - Problems with foreign key constraints.mp4

02:38

05 - Challenge Delete from the country table.mp4

00:55

06 - Solution Delete from the country table.mp4

07:02

07 - Conclusion

01 - Next steps.mp4

00:19

Description

If you’re already familiar with the fundamentals of SQL covered in our introductory course on SQL: Data Reporting and Analysis, you may be interested in taking your skills to the next level and learning a few more new tricks of the trade. Join data consultant Emma Saunders in this hands-on, practical follow-up, designed specifically to help you grow beyond the basics so you can start writing more complex queries to change data in the database instead of just reporting it.

Expand your SQL toolbox, including how to query data in real time for reporting, editing, inserting, and deleting. Learn new date, number, and string functions to manipulate data as you retrieve it. Along the way, test out your technical know-how with the coding challenges and quizzes at the end of each section.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

SQL

Microsoft 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.