Data Training Institute
SQL for Data Analysis
Live & online$500
About This Course
Learn the fundamentals of SQL and how to apply it to data analysis. This course will guide you through querying databases, managing data, and performing complex analyses. Ideal for beginners and professionals seeking to enhance their data analysis skills with SQL
What You'll Learn
- Understand the basics of SQL and how to use it for effective data querying.
- Learn to manage and manipulate data within databases for accurate analysis.
- Develop skills to perform complex data analyses, enhancing your data-driven decision-making.
Course Content
16 sections · taught live, step by step
1
Section 1: What is SQL
2
Section 2: Installing SQL Server & SSMS
3
Section 3: Creating SQL Tables - SELECT Statements
4
Section 4: SQL WHERE Clause | AND, OR, LIKE Operator
5
Section 5: SQL GROUP BY Statement & ORDER BY Keyword | Aggregate Functions
6
Section 6: SQL Comments | Between Operator | NULL Values & More
7
Section 7: SQL Joins, Case Statements & Real World Mini Project
8
Section 8: The HAVING Clause
9
Section 9: Creating & Altering SQL Views + Subqueries
10
Section 10: The UNION Operator in SQL
11
Section 11: SQL Stored Procedures, Parameters & Use Cases
12
Section 12: Displaying Subtotals & Grand Totals with the SQL Server Rollup Clause
13
Section 13: Creating SQL Stored Procedures With Multiple Parameters
14
Section 14: SQL Server String Concatenation with NULL Values | '+', CONCAT(), CONCAT_WS()
15
Section 15: SQL Constraints
16
Section 16: SQL Date Functions | Extracting Date Parts & Date Differences
Not sure this course is the right fit?
Tell us your goals and we'll recommend the right learning path — or build a custom corporate training for your team.
Talk To Us