Course Title: SQL for Data Analysis
Current Status:
Price:
Get Started:
You are not yet enrolled in this course.
Course Description:
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
- 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
Section 1: What is SQL
Section 2: Installing SQL Server & SSMS
Section 3: Creating SQL Tables – SELECT Statements
Section 4: SQL WHERE Clause | AND, OR, LIKE Operator
Section 5: SQL GROUP BY Statement & ORDER BY Keyword | Aggregate Functions
Section 6: SQL Comments | Between Operator | NULL Values & More
Section 7: SQL Joins, Case Statements & Real World Mini Project
Section 8: The HAVING Clause
Section 9: Creating & Altering SQL Views + Subqueries
Section 10: The UNION Operator in SQL
Section 11: SQL Stored Procedures, Parameters & Use Cases
Section 12: Displaying Subtotals & Grand Totals with the SQL Server Rollup Clause
Section 13: Creating SQL Stored Procedures With Multiple Parameters
Section 14: SQL Server String Concatenation with NULL Values | ‘+’, CONCAT(), CONCAT_WS()
Section 15: SQL Constraints
Section 16: SQL Date Functions | Extracting Date Parts & Date Differences
Enroll Now