@upGrad_edu
Topics with Time Stamps Chapter 1 00:01:10 - What is Relational Database? 00:01:40 - What Is A Non-Relational Database? 00:02:55 - What is ER Diagram? 00:03:29 - What is Primary Key? 00:04:34 - What is Foreign Key? 00:05:10 - SQL Commands 00:07:23 - How to Create a Database? 00:12:44 - Example on Database Chapter 2 - SQL Working with Datatypes 00:39:15 - What is Numeric Data Type? 00:41:05 - What is String Data Type? 00:42:30 - Data and Time Data Types 00:44:40 - Boolean Data Type 00:45:37 - Explicit Data Type Conversions 00:46:17 - CAST() 00:48:10 - CONVERT() 00:50:10 - Implicit Data Type Conversions 00:52:48 - Handling Null Values 00:57:20 - Why Handling Null is Important? Chapter 3 - How to Filter Data In SQL? 01:00:00 - Concat() 01:01:55 - Example on Concat() 01:11:00 - Substr() 01:12:17 - Example on Substr() 01:16:12 - INITCAP() 01:17:10 - What is Distinct? 01:18:29 - Example on Distinct 01:22:29 - Define Where Clause 01:23:50 - Example on Where Clause 01:30:13 - Order of Execution 01:35:10 - Example on Order of Execution Chapter 4 – Wildcards 01:46:44 - What is BETWEEN Operator? 01:47:55 - Example on BETWEEN Operator 02:02:22 - Define IN Operator 02:04:18 - Example on IN Operator 02:12:20 - What is LIKE Operator? 02:14:15 - What is WILDCARDS? Chapter 5 - Aggregate Function and Grouping 02:32:02 - What is Aggregate Function? 02:33:48 - Example on Aggregate Function 02:46:56 - Define Group by 02:49:45 - Example on Group by 03:05:30 - What is Having Clause? 03:07:30 - Example on Having Clause Chapter 6 - Joins in SQL 03:24:52 - What is Inner Joins? 03:26:36 - Example on Inner Joins 03:45:11 - What is Left Join? 03:46:50 - Example on Left Joins 03:57:56 - What is Right Join? 03:58:47 - Example on Right Join 04:03:07 - What is Full Join? 04:03:48 - Example on Full Join Chapter 7 - Subqueries in SQL 04:22:37 - What is Subquery? 04:26:00 - Example on Subquery Chapter 8 - SQL, DDL and DML 04:54:20 – What is DDL (Data Definition Language) 05:11:21 – What is DML (Data Manipulation Language) Chapter 9 - SQL CTE and Views 05:33:30 - What is CET? 05:36:34 - Example on CET 05:54:19 - What are Views? 05:58:15 - Example on View Statement 06:11:30 - Topics Covered
@swethat801
Can you please provide the data base
@upGrad_edu