SQL: Data Reporting and Analysis
SQL: Data Reporting and Analysis
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 17m | 415 MB
Instructor: Emma Saunders
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 17m | 415 MB
Instructor: Emma Saunders
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
SQL: Data Reporting and Analysis
