SQL: Data Reporting and Analysis
4.0 /5- Offered byLinkedin Learning
SQL: Data Reporting and Analysis at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
SQL: Data Reporting and Analysis at Linkedin Learning Highlights
- Earn a sharable certificate
- 5 quizzes
- Access on tablet and phone
SQL: Data Reporting and Analysis at Linkedin Learning Course details
- In this course, learn how to get the data learner want by writing a bit of SQL code
- Learner won't just be able to pull data out of the database, learner will be able to manipulate it?merging it, grouping it, and relabeling it to get just the report learner want
SQL: Data Reporting and Analysis at Linkedin Learning Curriculum
Introduction
Don't let your reporting system hold you back
Who this course is for
What is SQL?
Prepare to Code in SQL
Get familiar with phpMyAdmin
Understand the demo database
Use SQL to Report Data
Retrieve data with SELECT
Filter results with the WHERE clause
Use LIKE, IN, and wildcards with WHERE
Sort SQL results with ORDER BY
Use string functions on your data
More advanced string functions
Change report headings with an alias
Use date functions with WHERE
Challenge: Query a table
Solution: Query a table
Challenge: Convert case
Solution: Convert case
Group Your SQL Results
Use GROUP BY with count
Filter grouped results with HAVING
Deduplicate with SELECT DISTINCT
Merge rows with GROUP BY
Challenge: Cost analysis
Solution: Cost analysis
Merge Data from Multiple Tables
Make your queries faster
Understand SQL indexes and keys
EDIT: Visualize your database
Merge data across tables with JOIN
Understand SQL JOINS
Combine rows with SQL UNION
Merge data across tables with IN
Select from a selection with subqueries
Challenge: Join tables
Solution: Join tables
More Advanced SQL
Save your queries using a VIEW
Use variables
Use functions
Use procedures
Continuing Your SQL Learning Journey
Next steps and additional resources
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?