Intermediate SQL: Data Reporting and Analysis

سرفصل های دوره

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.

01 - Introduction

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

02 - Who this course is for

03 - What can you do with intermediate SQL

02 - 1. Prepare to Code in SQL

01 - Get familiar with phpMyAdmin

02 - Understand the demo database

03 - 2. Reporting Data with SQL

01 - The basic SELECT query

02 - Aggregated results with GROUP BY

03 - Wildcards and aliases

04 - Merging tables with JOIN

05 - Use string functions

06 - Use number functions with grouped data

07 - Use date functions

08 - Challenge Report average cost by staff

09 - Solution Report average cost by staff

04 - 3. Editing Data

01 - UPDATE fields in a table

02 - Common issues with the UPDATE command

03 - Automating your query creation

04 - Updating a field using JOIN

05 - Updating dynamically

06 - Challenge Update the film table using JOIN

07 - Solution Update the film table using JOIN

05 - 4. Inserting Data

01 - INSERT rows into a table

02 - Common issues with the INSERT command

03 - Using MERGE instead of UPDATEINSERT

04 - Duplicate table with SELECT

05 - Challenge Insert a row into the film table

06 - Solution Insert a row into the film table

06 - 5. Deleting Data

01 - DELETE rows from a table

02 - DROP an entire table

03 - ALTER TABLE for modifying fields

04 - Problems with foreign key constraints

05 - Challenge Delete from the country table

06 - Solution Delete from the country table

07 - Conclusion

01 - Next steps

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)