The Complete SQL Bootcamp for Aspiring Data Scientists

Files Included :

1 What all will be covered.mp4 (12.37 MB)
MP4
2 What is a database.mp4 (17.39 MB)
MP4
3 Understand SQL.mp4 (18.76 MB)
MP4
4 Installation of SQL Server.mp4 (23.51 MB)
MP4
5 Download and Restore Database.mp4 (23.01 MB)
MP4
1 Create a View.mp4 (66.04 MB)
MP4
2 Alter, Join and Drop the views.mp4 (65.21 MB)
MP4
1 Subqueries 1.mp4 (77.7 MB)
MP4
2 Subqueries 2.mp4 (58.24 MB)
MP4
3 Subqueries 3.mp4 (74.08 MB)
MP4
4 Subqueries 4.mp4 (53.2 MB)
MP4
5 Subqueries 5.mp4 (40.04 MB)
MP4
6 Common Table Expression 1.mp4 (59.74 MB)
MP4
7 Common Table Expression 2.mp4 (112.34 MB)
MP4
1 Create, Alter, Execute, Drop a Stored Procedure.mp4 (90.46 MB)
MP4
2 Stored Procedure with Input Parameters.mp4 (81.26 MB)
MP4
3 Stored Procedure with Output Parameters.mp4 (81.63 MB)
MP4
4 Calling One Stored Procedure from Another Stored Procedure.mp4 (134.59 MB)
MP4
1 DDL Create Database Graphically.mp4 (30.01 MB)
MP4
10 DDL Alter Table Command.mp4 (56.39 MB)
MP4
11 DDL Drop the Table.mp4 (13.2 MB)
MP4
12 DML Delete the Table.mp4 (14.79 MB)
MP4
13 DDL Truncate the Table.mp4 (19.06 MB)
MP4
14 What is Schema.mp4 (65.29 MB)
MP4
2 DDL Create Database using Query.mp4 (57.45 MB)
MP4
3 Add Comments.mp4 (24.07 MB)
MP4
4 DDL Alter Database Command.mp4 (13.88 MB)
MP4
5 DDL Delete a Database.mp4 (10.58 MB)
MP4
6 Data types.mp4 (18.71 MB)
MP4
7 DDL Create Table.mp4 (54.07 MB)
MP4
8 DML Insert data in table.mp4 (69.6 MB)
MP4
9 DDL Create table with Identity Column.mp4 (29.51 MB)
MP4
1 What is Data Integrity.mp4 (15.42 MB)
MP4
2 Not Null Constraint.mp4 (28.27 MB)
MP4
3 Primary Key Constraint.mp4 (68.79 MB)
MP4
4 Unique Constraint.mp4 (70.3 MB)
MP4
5 Foreign Key Constraint.mp4 (51.99 MB)
MP4
6 Check Constraint.mp4 (75.9 MB)
MP4
7 Default Constraint.mp4 (32.22 MB)
MP4
1 Import data from excel.mp4 (20.83 MB)
MP4
10 WHERE Clause with Update Command.mp4 (33.74 MB)
MP4
2 SELECT Statement.mp4 (44.03 MB)
MP4
3 SELECT with DISTINCT and TOP clause.mp4 (67.82 MB)
MP4
4 WHERE Clause with Comparison Operators.mp4 (56.41 MB)
MP4
5 WHERE Clause with Logical Operators.mp4 (94.77 MB)
MP4
6 WHERE Clause with Range Operators.mp4 (48.18 MB)
MP4
7 WHERE Clause with List Operators.mp4 (52.63 MB)
MP4
8 WHERE Clause with Wildcard Operators.mp4 (108.11 MB)
MP4
9 WHERE Clause with IS NULL IS NOT NULL Operators.mp4 (32.5 MB)
MP4
1 Sort the data.mp4 (60.3 MB)
MP4
2 Aggregate Functions 1.mp4 (50.44 MB)
MP4
3 Aggregate Functions 2.mp4 (46.15 MB)
MP4
4 Group By Clause.mp4 (37.85 MB)
MP4
5 Having Clause.mp4 (37.44 MB)
MP4
1 String Functions.mp4 (108.41 MB)
MP4
2 Date Functions.mp4 (121.52 MB)
MP4
3 Mathematical Functions.mp4 (31.74 MB)
MP4
4 Data Conversion Functions.mp4 (61.09 MB)
MP4
5 COALESCE and ISNULL.mp4 (31 MB)
MP4
6 String Aggregation function.mp4 (22.51 MB)
MP4
1 Inner Join.mp4 (88.03 MB)
MP4
2 Left Join.mp4 (33.65 MB)
MP4
3 Right Join.mp4 (33.27 MB)
MP4
4 Full Outer Join.mp4 (18.66 MB)
MP4
5 Self Join.mp4 (32.95 MB)
MP4
6 Cross Join.mp4 (14.63 MB)
MP4
1 Order of execution 1.mp4 (41.63 MB)
MP4
2 Order of execution 2.mp4 (73.61 MB)
MP4
1 Simple CASE Expression.mp4 (57.34 MB)
MP4
2 Searched CASE Expression.mp4 (49.53 MB)
MP4
3 Variable and Print Statement.mp4 (30.78 MB)
MP4
4 IF ELSE Statement.mp4 (24.73 MB)
MP4
5 Set Operators Union and Union All.mp4 (31.67 MB)
MP4
6 Set Operators Intersect and Except (Minus).mp4 (28.47 MB)
MP4