LIN | SQL: Data Reporting And Analysis (2019 EN)

Company: Linkedin Learning
Author: Emma Saunders
Full Title: SQL: Data Reporting And Analysis
Year: 2019
Language: English
Genre: Educational: Big Data
Skill Level: Intermediate
Price: €24.99
-
Files: MP4 (+ Subtitles .SRT)
Time: 02:17:59
Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 300 kbps
Audio: AAC at 160 Kbps, 2 channels, 48.0 KHz



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:
01. Retrieving data with SELECT statements
02. Filtering and sorting your results
03. Transforming results with built-in SQL functions
04. Grouping SQL results
05. Merging data from multiple tables
06. Using variables, functions, and procedures

Our members see more. Join us!
-------------
Our members see more. Join us!