We are glad to see you in the frame of an all-embracing SQL course! This learning experience, "Comprehensive SQL Course:Hands-on Project & Coding Exercises,” course is aimed at start students, and no experience in SQL or programming is required. You will be learning SQL for beginners, where basic skills for data professionals such as data Engineers, data analysts, data scientists, web developers and application developers will be instilled. Since the coursework is hosted via the Udemy platform, the required database is integrated within the website, which means that structures cannot be explicitly installed or downloaded onto your device and accessed from any web browser.
Our course, "Comprehensive SQL Course:Hands-on Project & Coding Exercises," is filled with more than 120 coding exercises and a practical project: creating a database for the Indian Premier League (IPL). This way, you will be exposed to the SQL statements needed for the scorecard of the tournament website, making it more interesting and practical. When you are done, you’ll be a pro in SQL with the skills to handle real-world projects on data.
The curriculum covers a wide range of topics: fundamentals of SQL transactions, data selection/restriction, SQL functions, dates’ functions, if-then-else, average, sum, max and min, grouping, join, primary and foreign keys, databases’ structure, entity relationship diagrams, sub-query, CTEs, views, and window functions. This fast-paced course, Comprehensive SQL Course:Hands-on Project & Coding Exercises Specifically, trains you in hands-on projects and coding exercises to guarantee you learn all that you need in the fastest and most efficient way so that you can search for real-time SQL projects once you complete the course.
Comprehensive SQL Course:Hands-on Project & Coding Exercises Table of Contents:
- Course Introduction (04:32)
- Course Structure (03:24)
- Course Slides Download (00:04)
- Introduction to SQL (07:31)
- Udemy Coding Exercises Overview (08:50)
- Practice - Udemy Coding Exercises Overview (1 question)
- SQLite Documentation (Optional) (00:05)
- Section Overview (01:17)
- Creating Tables (06:31)
- Writing SQL Statement - Best Practices (06:38)
- Practice - Creating Tables (1 question)
- Inserting Single Record (06:02)
- Practice - Inserting Single Record (1 question)
- Inserting Multiple Records (03:22)
- Practice - Inserting Multiple Records (1 question)
- Selecting Data (05:45)
- Practice - Selecting Specific Columns (1 question)
- Practice - Selecting All Columns (1 question)
- Filtering Data (03:28)
- Practice - Filtering Data (1 question)
- Updating Data (05:27)
- Practice - Updating Data (1 question)
- Deleting Data (03:24)
- Practice - Deleting Data (1 question)
- Dropping Tables (01:47)
- Practice - Dropping Tables (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Introduction to SQL Statements (1 question)
- Challenge 2 - Introduction to SQL Statements (1 question)
- Querying Data - Overview (03:36)
- Select Clause Overview (09:07)
- Practice - Select Clause (1 question)
- Renaming Columns - Column Alias (05:29)
- Practice - Renaming Columns (1 question)
- Removing Duplicates - DISTINCT (06:59)
- Practice - Removing Duplicates - DISTINCT (1 question)
- FROM Clause Overview (02:20)
- Sorting Outputs by Single Column - ORDER BY (06:02)
- Practice - Sorting Outputs by Single Column (1 question)
- Sorting Outputs by Multiple Columns and Positions - ORDER BY (05:28)
- Practice - Sorting Outputs by Multiple Columns and Positions (1 question)
- Restricting Number of Records - LIMIT (04:19)
- Practice - Restricting Number of Records (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Querying Data (1 question)
- Challenge 2 - Querying Data (1 question)
- Introduction to Filtering Data (04:08)
- Filtering Using Mathematical Operators (05:47)
- Practice - Filtering Using Mathematical Operators (1 question)
- Filter Data Using BETWEEN Operator (03:42)
- Practice - Filter Data Using BETWEEN Operator (1 question)
- Filter Data Using LIKE Operator and Percentage Wildcard (05:57)
- Practice - Filter Data Using LIKE Operator and Percentage Wildcard (1 question)
- Filter Data Using LIKE Operator and Underscore Wildcard (03:20)
- Practice - Filter Data Using LIKE Operator and Underscore Wildcard (1 question)
- Filter Data Using LIKE Operator - Bringing It All Together (03:30)
- Practice - Filter Data Using LIKE Operator - Bringing It All Together (1 question)
- Filter Data Using IN Operator (02:40)
- Practice - Filter Data Using IN Operator (1 question)
- Filter Data Using Multiple Conditions - AND Operator (03:28)
- Practice - Filter Data Using Multiple Conditions - AND Operator (1 question)
- Filter Data Using Multiple Conditions - OR Operator (03:03)
- Practice - Filter Data Using Multiple Conditions - OR Operator (1 question)
- Filter Data Using Multiple Conditions - Bringing It All Together (07:39)
- Practice - Filter Data Using Multiple Conditions - Bringing It All Together (1 question)
- Filter Data Using Negative Conditions (07:02)
- Practice - Filter Data Using Negative Conditions (1 question)
- Filters in UPDATE and DELETE Statements (04:37)
- Practice - Filters in UPDATE and DELETE Statements (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Filtering Data (1 question)
- Challenge 2 - Filtering Data (1 question)
- SQL Functions - Overview (06:54)
- String Functions - UPPER, LOWER, CONCAT (10:30)
- Practice - String Functions UPPER, LOWER, CONCAT (1 question)
- String Functions - REPLACE, TRIM (09:10)
- Practice - String Functions - REPLACE, TRIM (1 question)
- String Functions - SUBSTR, INSTR, LENGTH (10:44)
- Practice - String Functions - SUBSTR, INSTR, LENGTH (1 question)
- Math Functions (08:31)
- Practice - Math Functions (1 question)
- Nested Function Calls (16:11)
- Practice - Nested Function Calls (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Simple SQL Functions (1 question)
- Challenge 2 - Simple SQL Functions (1 question)
- Conditional Functions - IIF (11:15)
- Practice - Conditional Functions - IIF (1 question)
- Simple CASE Expression (10:41)
- Practice - Simple CASE Expression (1 question)
- Searched CASE Expression (08:25)
- Practice - Searched CASE Expression (1 question)
- Introduction to NULLs (09:57)
- Practice - Introduction to NULLs (1 question)
- Conditional Functions - IFNULL (09:24)
- Practice - Conditional Functions - IFNULL (1 question)
- Conditional Functions - COALESCE (06:31)
- Practice - Conditional Functions - COALESCE (1 question)
- Conditional Functions - NULLIF (03:39)
- Practice - Conditional Functions - NULLIF (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Conditional Functions & Expressions (1 question)
- Challenge 2 - Conditional Functions & Expressions (1 question)
- Introduction to Date Functions (03:31)
- Transforming Date & Time (12:00)
- Practice - Transforming Date & Time (1 question)
- Formatting Date & Time (06:44)
- Practice - Formatting Date & Time (1 question)
- Bringing It All Together (07:22)
- Practice - Bringing It All Together (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Date Functions (1 question)
- Introduction to Aggregate Functions (13:38)
- Practice - Introduction to Aggregate Functions (1 question)
- Aggregate Functions and NULLs (05:05)
- Practice - Aggregate Functions and NULLs (1 question)
- Aggregate Functions - COUNT (07:53)
- Practice - Aggregate Functions - COUNT (1 question)
- Aggregate Functions - COUNT DISTINCT (03:47)
- Practice - Aggregate Functions - COUNT DISTINCT (1 question)
- Grouping Records (06:38)
- Grouped Aggregates (Single Column Groups) (07:33)
- Practice - Grouped Aggregates (Single Column Groups) (1 question)
- Grouped Aggregates (Multiple Column Groups) (05:41)
- Practice - Grouped Aggregates (Multiple Column Groups) (1 question)
- Having Clause (05:36)
- Practice - Having Clause (1 question)
- Order of Execution (11:41)
- Practice - Order of Execution (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Aggregate Functions (1 question)
- Challenge 2 - Aggregate Functions (1 question)
- Introduction to Joins (01:11)
- Introduction to Inner Join (15:41)
- Practice - Introduction to Inner Join (1 question)
- An Intuition to Inner Join (05:23)
- Cartesian Product from Joins (07:47)
- Practice - Cartesian Product from Join (1 question)
- Introduction to Outer Join (04:00)
- Left Outer Join (07:32)
- Practice - Left Outer Join (1 question)
- Right Outer Join (05:15)
- Practice - Right Outer Join (1 question)
- Full Outer Join (06:02)
- Practice - Full Outer Join (1 question)
- Inner Join with Filters (08:38)
- Practice - Inner Join with Filters (1 question)
- Outer Join with Filters (16:20)
- Practice - Left Outer Join with Filters (1 question)
- Practice - Right Outer Join with Filters (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - SQL Joins (1 question)
- Challenge 2 - SQL Joins (1 question)
- Challenge 3 - SQL Joins (1 question)
- Managing Tables - Section Overview (02:18)
- SQL Constraints Overview (05:59)
- SQL Constraints Demo (11:38)
- Practice - NOT NULL Constraints (1 question)
- Practice - CHECK Constraints (1 question)
- Practice - UNIQUE Constraints (1 question)
- Practice - DEFAULT Constraints (1 question)
- Primary Key, Foreign Key & Relationships Overview (05:28)
- Primary Key, Foreign Key & Relationships Demo (14:31)
- Practice - Primary Key (1 question)
- Practice - Foreign Key Relationships (1 question)
- Alter Table (11:20)
- Practice - Alter Table (1 question)
- Drop Table (02:06)
- Code Used During Demonstration (00:08)
- Challenge 1 (1 question)
- Project Requirements (08:45)
- Database Design (03:52)
- Data Modelling (21:42)
- Creating & Populating Tables (14:47)
- Practice - Create Table Venue (1 question)
- Practice - Create Table Team (1 question)
- Practice - Create Table Player (1 question)
- Practice - Create Table Match (1 question)
- Practice - Create Table Innings (1 question)
- Practice - Create Table Score By Ball (1 question)
- Practice - Create Table Result (1 question)
- Code Used During Demonstration (00:08)
- Section Overview (00:55)
- Match Summary (06:29)
- Practice - Match Summary (1 question)
- Innings Summary - Total Runs & Wickets (13:02)
- Practice - Innings Summary - Total Runs & Wickets (1 question)
- Innings Summary - Total Overs (10:24)
- Practice - Innings Summary - Total Overs (1 question)
- Batting Scorecard - Player Level (18:58)
- Practice - Batting Scorecard - Player Level (1 question)
- Batting Scorecard - Team Level (06:20)
- Practice - Batting Scorecard - Team Level (1 question)
- Bowling Scorecard - Player Level (15:42)
- Practice - Bowling Scorecard - Player Level (1 question)
- Code Used During Demonstration (00:08)
- Introduction to Subqueries (08:17)
- Practice - Introduction to Subqueries (1 question)
- Multiple Row / Column Subqueries (10:59)
- Practice - Multiple Row Subqueries (1 question)
- Practice - Multiple Column Subqueries (1 question)
- Introduction to Subquery in the FROM Clause (08:28)
- Practice - Introduction to Subquery in the FROM Clause (1 question)
- Real Use Case for Subquery in the FROM Clause (11:21)
- Practice - Real Use Case for Subquery in the FROM Clause (1 question)
- Correlated Subquery (14:10)
- Practice - Correlated Subquery (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Subqueries (1 question)
- Challenge 2 - Subqueries (1 question)
- Introduction to Common Table Expressions (CTEs) (10:39)
- Practice - Introduction to CTEs (1 question)
- Multiple CTEs in a Query (04:44)
- Practice - Multiple CTEs in a Query (1 question)
- Code De-Duplication Using CTEs (07:00)
- Practice - Code De-Duplication Using CTEs (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Common Table Expressions (CTEs) (1 question)
- Challenge 2 - Common Table Expressions (CTEs) (1 question)
- Introduction to Views (04:11)
- Views to Simplify Transformation Logic (09:01)
- Practice - Views to Simplify Transformation Logic (1 question)
- Views to Simplify Subqueries/CTEs (04:49)
- Practice - Views to Simplify Subqueries/CTEs (1 question)
- Views to Simplify Joins (05:31)
- Practice - Views to Simplify Joins (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Views (1 question)
- Introduction to Window Functions (05:35)
- OVER Clause (07:57)
- Practice - OVER Clause (1 question)
- PARTITION BY Clause (08:43)
- Practice - PARTITION BY Clause (1 question)
- ORDER BY Clause (04:43)
- Practice - ORDER BY Clause (1 question)
- PARTITION BY & ORDER BY Clauses Together (05:52)
- Practice - PARTITION BY & ORDER BY Clauses Together (1 question)
- Analytical Functions (12:30)
- Practice - Analytical Functions - LAG (1 question)
- Practice - Analytical Functions - LEAD (1 question)
- Ranking Functions - RANK & DENSE_RANK (07:34)
- Practice - Ranking Functions - RANK & DENSE_RANK (1 question)
- Ranking Functions - ROW_NUMBER (09:28)
- Practice - Ranking Functions - ROW_NUMBER (1 question)
- Ranking Functions - NTILE (04:11)
- Practice - Ranking Functions - NTILE (1 question)
- Introduction to Window Frames (05:38)
- Calculate Rolling Totals Using Window Frames (07:56)
- Practice - Calculating Rolling Totals (1 question)
- Code Used During Demonstration (00:08)
- Challenge 1 - Window Functions (1 question)
- Challenge 2 - Window Functions (1 question)
- Challenge 3 - Window Functions (1 question)
- Good Luck (00:47)
- Bonus Lecture (00:15)
Who is this course for?
- University students aspiring to be IT professionals
- Data Handlers such as Web Developers and App Developers are among the software engineers that deal with data.
- Students, freshers, professionals, and anybody who is involved or has an interest in Data Engineering, Data Analysis and Data Science, Business Intelligence and similar domains.
Click on the links below to Download Comprehensive SQL Course:Hands-on Project & Coding Exercises!
در حال پاسخ به :