About Lesson
-
Introduction to SQL: Learn the Lang. of Data
- SQL Basics for Data Analysis:
- Introduction to SQL
- Setting up the SQL environment
- Basic SQL Commands
- Creating and Deleting Databases and Tables
- Importing and Exporting Data from CSV Files
- Fundamentals of SQL Query:
- Anatomy of SQL Query
- SQL Data Types and Operators
- Filtering and Sorting Data in SQL
- Aggregate functions in SQL
- Dealing With Multiple Tables:
- Grouping Data – GROUP BY
- HAVING
- Subqueries
- Joining tables using INNER JOIN, LEFT JOIN, RIGHT JOIN & FULL OUTER JOIN
- Alias in SQL queries
- Working with Multiple Tables Using Subqueries
- Using Set Operators
- Aggregating Data from Multiple Tables using GROUP BY and HAVING.
- Advanced SQL Joins:
- Advanced Join Techniques
- Joining multiple tables
- Handling duplicate records and eliminating duplicates
- Using UNION and UNION ALL to combine data from multiple tables
- SQL Basics for Data Analysis:
-
SQL In-Built Functions
- Type Casting & Math Functions:
- Mathematical Functions
- Type Conversion Functions
- Using CASE Statements to Perform Conditional Operations
- DateTime & String Functions:
- Working with date/time data in SQL
- Date/time functions
- Formatting date/time data
- String manipulation functions (e.g. UPPER, LOWER, LEFT, RIGHT, etc.)
- Regular expressions in SQL for string operations
- Using CONCAT_WS to concatenate strings with a separator
- Window Functions:
- Syntax of Windows Function
- Ranking functions (e.g. ROW_NUMBER, RANK, DENSE_RANK, etc.)
- Aggregate functions using windows (e.g. SUM, AVG, MAX, MIN, etc.)
- Partitioning data for window functions
- Understanding the difference between row-based and aggregate-based window functions
- Type Casting & Math Functions:
-
SQL for Data Preparation
- Complex queries using CTE & Pivoting:
- Common Table Expressions(CTE)
- Recursive CTEs for Hierarchical Data
- Combining CTEs with Window Functions and Subqueries
- Understanding the Performance Implications of CTEs
- Database Management & Schema Design:
- Understanding The Relational Model and Database Schema Design
- Normalization and Denormalization of Database Tables
- Database Administration Tasks
- Implementing Indexes and Constraints for Data Integrity
- Designing Efficient Database Queries for Performance Optimization
- Complex queries using CTE & Pivoting:
