SQL ETL Developer – T-SQL Stored Procedures ETL SSIS

Files Included :

1 Introduction.mp4 (6.09 MB)
MP4
2 What is SQL.mp4 (9.34 MB)
MP4
3 What is ETL.mp4 (19.54 MB)
MP4
4 What is T-SQL.mp4 (58.42 MB)
MP4
5 What is SSIS.mp4 (17.73 MB)
MP4
6 What is a Data Warehouse.mp4 (13.76 MB)
MP4
7 What is a Schema.mp4 (10.47 MB)
MP4
1 What is Visual Studio.mp4 (24.34 MB)
MP4
2 Minimum Installation Requirements for visual studio 2019.mp4 (37.64 MB)
MP4
3 Installing Visual Studio 2019.mp4 (46.1 MB)
MP4
4 Installing SQL Server Data Tools.mp4 (22.16 MB)
MP4
5 Installing Designers for SSIS,SSAS,SSRS.mp4 (38.76 MB)
MP4
1 What is SQL Server.mp4 (11.17 MB)
MP4
10 Installing adventureworks 2016DW database.mp4 (29.22 MB)
MP4
2 SQL Server 2019 Hardware Software Installation Requirements.mp4 (21.47 MB)
MP4
3 SQL Server Editions.mp4 (28.56 MB)
MP4
4 Download SQL Server Developer Edition.mp4 (23.23 MB)
MP4
5 Install SQL Server 2019 Developer Edition.mp4 (62.53 MB)
MP4
6 Installing SQL Server Management Studio.mp4 (36.87 MB)
MP4
7 Connecting to SQL Server with SSMS.mp4 (32.43 MB)
MP4
8 SQL Server Configuration Manager.mp4 (27.88 MB)
MP4
9 Installing adventureworks 2016.mp4 (32.6 MB)
MP4
1 AVG Aggregate Function.mp4 (61.09 MB)
MP4
10 NTILE Function.mp4 (20.25 MB)
MP4
11 ROW Number function.mp4 (20.65 MB)
MP4
12 DENSE RANK Function.mp4 (26.54 MB)
MP4
13 Analytic Function Syntax.mp4 (11.97 MB)
MP4
14 LEAD Analytic Function.mp4 (34.65 MB)
MP4
15 LAG Analytic Function.mp4 (33.95 MB)
MP4
16 LAST VALUE Analytic Function.mp4 (22.6 MB)
MP4
17 First Value Analytic Function.mp4 (19.42 MB)
MP4
18 CUME DIST Analytic Function.mp4 (21.07 MB)
MP4
19 PERCENTILE DISC Analytic Function.mp4 (22.26 MB)
MP4
2 MIN Aggregate Function.mp4 (45.98 MB)
MP4
3 MAX Aggregate Function.mp4 (42.25 MB)
MP4
4 SUM Aggregate Function.mp4 (47.72 MB)
MP4
5 COUNT Aggregate Function.mp4 (65.77 MB)
MP4
6 GROUPING Aggregate Functions.mp4 (71.58 MB)
MP4
7 VAR Aggregate Function.mp4 (12.76 MB)
MP4
8 VARP Aggregate Function.mp4 (10.99 MB)
MP4
9 RANK Function.mp4 (21.56 MB)
MP4
1 Extracting data using an INNER Join.mp4 (101.97 MB)
MP4
2 Extracting data using a LEFT Outer Join.mp4 (110.17 MB)
MP4
3 Extracting data using a RIGHT OUTER Join.mp4 (75.66 MB)
MP4
4 Extracting data using an FULL OUTER Join.mp4 (94.33 MB)
MP4
1 Introduction to stored procedures.mp4 (24.25 MB)
MP4
2 Creating stored procedures.mp4 (50.31 MB)
MP4
3 Modifying stored procedures.mp4 (18.1 MB)
MP4
4 Properties page of a stored procedure.mp4 (20.6 MB)
MP4
5 Viewing dependencies of a stored procedure.mp4 (11.28 MB)
MP4
6 Deleting a stored procedure.mp4 (8.01 MB)
MP4
7 Viewing definition of a stored procedure.mp4 (18.9 MB)
MP4
1 What is CRUD.mp4 (3.27 MB)
MP4
2 Naming Convention.mp4 (3.55 MB)
MP4
3 Basic Application Design Structure.mp4 (10.42 MB)
MP4
4 Stored Procedure For CREATE CRUD Operation.mp4 (64.32 MB)
MP4
5 Stored Procedure For READ CRUD Operation.mp4 (38 MB)
MP4
6 Stored Procedure For UPDATE CRUD Operation.mp4 (52.69 MB)
MP4
7 Stored Procedure For DELETE CRUD Operation.mp4 (38.15 MB)
MP4
1 How to create a new SSIS Project with vs2019.mp4 (7.15 MB)
MP4
10 Add and Configure OLE DB Destination.mp4 (46.1 MB)
MP4
11 Test and Run Package.mp4 (10.67 MB)
MP4
2 Create a new SSIS project.mp4 (33.58 MB)
MP4
3 Add a Flat File Connection Manager.mp4 (33.49 MB)
MP4
4 Remap Column Data Types.mp4 (86.38 MB)
MP4
5 Add and Configure OLE DB Connection Manager.mp4 (22.51 MB)
MP4
6 Add a Data Flow Task.mp4 (23.41 MB)
MP4
7 Add and configure Flat File Source.mp4 (25.18 MB)
MP4
8 Add and Configure Lookup Transformation.mp4 (71.2 MB)
MP4
9 Add and Configure Lookup For DateKey Transformation.mp4 (58.15 MB)
MP4