Name: SQL Developer Skills from Scratch Training Course
Rating: 4.4 (809 reviews)

SQL Developer Skills from Scratch

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

What’s included

138 : Lectures
15h 50m 3s : Duration

$14.99/24.99

Setting up Your Test Environment

Lectures	Duration
1. Introduction- 3m 59s	3m 59s
2. SQL Server Express hardware requirements- 2m 49s	2m 49s
3. Download SQL Server Express 2014- 4m 8s	4m 8s
4. Install SQL Server Express 2014- 6m 47s	6m 47s
5. Download Adventureworks 2014 Database- 5m 6s	5m 6s
6. Attach Adventureworks 2014 to SQL Server- 4m 14s	4m 14s
7. SSMS Quick Tour- 6m 52s	6m 52s

T-SQL

Lectures	Duration
1. What is T-SQL- 10m 27s	10m 27s
2. What is a Database- 8m 20s	8m 20s
3. Primary Key- 4m 50s	4m 50s
4. Foreign Key- 4m 39s	4m 39s
5. Intellisense- 7m 52s	7m 52s
6. Normalization- 14m 13s	14m 13s
7. Querying Data with SELECT Statement- 12m 53s	12m 53s
8. Using Aliases in T- SQL Queries- 7m 12s	7m 12s
9. Case Expressions- 12m 15s	12m 15s
10. Creating Views- 9m 10s	9m 10s
11. Adding comments to T- SQL Queries- 6m 7s	6m 7s
12. Using Stored Procedures- 11m 59s	11m 59s
13. Using T-SQL Top Command- 6m 9s	6m 9s
14. T-SQL GO Command- 5m 7s	5m 7s
15. Using SQL Distinct to remove duplicate records- 6m 42s	6m 42s
16. Introduction to Table Joins- 27s	27s
17. Why Table Joins are important- 49s	49s
18. INNER Join- 10m 36s	10m 36s
19. LEFT Outer Join- 12m 26s	12m 26s
20. RIGHT OUTER Join- 9m 30s	9m 30s
21. Introduction to filtering records- 2m 16s	2m 16s
22. Filtering using equality filters- 13m 35s	13m 35s
23. Filtering with basic comparisons- 6m 7s	6m 7s
24. Filtering with logical comparisons- 14m 8s	14m 8s
25. Filtering with String Comparisons- 11m 22s	11m 22s
26. Filtering with NULL Comparisons- 4m 35s	4m 35s
27. Introduction to sorting returned records- 31s	31s
28. Order by clause- 3m 2s	3m 2s
29. Sorting by ascending- 4m 34s	4m 34s
30. Sorting by descending- 5m 3s	5m 3s
31. Sorting by multiple columns- 5m 9s	5m 9s
32. Introduction to Aggregate Functions- 2m 12s	2m 12s
33. COUNT ()- 9m 24s	9m 24s
34. AVG()- 7m 52s	7m 52s
35. MAX ()- 6m 24s	6m 24s
36. MIN()- 6m 37s	6m 37s
37. SUM()- 6m 57s	6m 57s
38. Using Multiple Aggregate functions- 5m 9s	5m 9s
39. Grouping Data- 8m 10s	8m 10s
40. Introduction to modifying data- 1m 40s	1m 40s
41. Adding new records to database- 10m 34s	10m 34s
42. Updating Records- 9m 18s	9m 18s
43. Deleting Records- 7m 53s	7m 53s

SQL Server Integration Services - SSIS

Lectures	Duration
1. Introduction to SSIS- 3m 24s	3m 24s
2. Visual Studio Requirements- 3m 8s	3m 8s
3. Download and Install Visual studio- 7m 47s	7m 47s
4. Completing visual studio installation- 5m 9s	5m 9s
5. Working with Solution Explorer and Projects Views- 11m 44s	11m 44s
6. Download and Install SQL Server Data Tools - SSDT- 6m 3s	6m 3s
7. Create basic ETL: New SSIS project- 5m 35s	5m 35s
8. Add a Flat File Connection Manager- 6m 26s	6m 26s
9. Remapping Column Data Types- 11m 12s	11m 12s
10. Add and Configure OLE DB Connection Manager- 3m 39s	3m 39s
11. Add a Data Flow Task to a Package- 5m 2s	5m 2s
12. Add and configure flat file source- 4m 28s	4m 28s
13. Add and configure lookup transformation- 11m 29s	11m 29s
14. Add and configure Lookup Datekey Transformation- 9m 28s	9m 28s
15. Add and configure OLE DB Destination- 7m 53s	7m 53s
16. Test SSIS Package- 2m 2s	2m 2s
17. Introduction to implementing Lookup Logic- 3m 29s	3m 29s
18. Create new SSIS Package- 4m 5s	4m 5s
19. Write data to cache - part 1- 8m 10s	8m 10s
20. Write data to cache - part 2- 7m 9s	7m 9s
21. Perform Lookups from cached data -part 1- 9m 22s	9m 22s
22. Perform Lookups from cached data -part 2- 9m 16s	9m 16s
23. Running your SSIS Package- 3m 36s	3m 36s

SQL Server Reporting Services - SSRS

Lectures	Duration
1. What is SQL Server- 4m 26s	4m 26s
2. What is SQL Server Reporting Services - SSRS- 31s	31s
3. Requirements for creating basic report with -SSRS- 3m 1s	3m 1s
4. How to enable built-in administrator account in Windows- 4m 10s	4m 10s
5. SQL Server Reporting Configuration Manager- 10m 46s	10m 46s
6. Configuration of SQL Server Reporting Services- 10m 46s	10m 46s
7. Granting Permission- 6m 20s	6m 20s
8. Create Report Server Project- 3m 2s	3m 2s
9. Create Report Definition File- 8m 31s	8m 31s
10. Define Data Source- 4m 50s	4m 50s
11. Define Dataset- 5m 42s	5m 42s
12. Add a Table to Report- 7m 25s	7m 25s
13. Format Report- 6m 57s	6m 57s
14. Group Data- 5m 5s	5m 5s
15. Add totals to Report- 8m 43s	8m 43s
16. Publish Report- 4m 13s	4m 13s

Data Warehouse and SQL Server Analysis Services -SSAS

Lectures	Duration
1. Install SQL Server Enterprise - Evaluation- 11m 54s	11m 54s
2. Installing multiple instances of SQL Server- 9m 25s	9m 25s
3. Download and install AdventureworksDW2014- 5m 33s	5m 33s
4. Enable SQL Server Agent- 2m 33s	2m 33s
5. Test AdventureworksDW2014 installation- 1m 46s	1m 46s
6. Configuring Database Settings for Data Warehousing- 6m 38s	6m 38s
7. What is Data Warehouse?- 3m 6s	3m 6s
8. What is ETL- 2m 28s	2m 28s
9. DW Vs EDW- 1m 55s	1m 55s
10. Database Vs Data Warehouse- 3m 15s	3m 15s
11. Hardware requirements for Data Warehouse- 10m 42s	10m 42s
12. FTDW Sizing Tool- 3m 56s	3m 56s
13. Designing a data warehouse: Logical design- 4m 14s	4m 14s
14. Physical design of a data warehouse -part 1- 9m 55s	9m 55s
15. Physical design of a data warehouse -part 2- 11m 42s	11m 42s
16. Designing Dimension Tables- 10m 14s	10m 14s
17. Introduction to ETL with SSIS- 2m 41s	2m 41s
18. Exploring source data - part 1- 8m 41s	8m 41s
19. Exploring source data - part 2- 4m 36s	4m 36s
20. Introduction to Control Flow - part 1- 9m 55s	9m 55s
21. Introduction to Control Flow - part 2- 8m 21s	8m 21s
22. Implementing Data Flow - part 1- 9m 44s	9m 44s
23. Implementing Data Flow - part 2- 9m 33s	9m 33s
24. Debugging an SSIS Package - part 1- 7m 20s	7m 20s
25. Debugging an SSIS Package - part 2- 6m 53s	6m 53s
26. Logging SSIS package events- 10m 18s	10m 18s
27. Handling errors in an SSIS Package- 8m	8m
28. Introduction to Incremental ETL Process- 5m 36s	5m 36s
29. Extracting Modified Data -part1- 4m 53s	4m 53s
30. Extracting Modified Data -part 2- 7m 47s	7m 47s
31. Extracting Modified Data -part 3- 5m 29s	5m 29s
32. Extracting Modified Data -part 4- 7m 19s	7m 19s
33. Loading modified data - part 1- 7m 31s	7m 31s
34. Loading modified data - part 2- 7m 25s	7m 25s
35. Working with other slowly changing dimensions- 7m 38s	7m 38s
36. Deploying and Configuring SSIS - Integration Services Catalog- 8m 19s	8m 19s
37. Deploy SSIS Solution- 11m 52s	11m 52s
38. Execute a package with SQL Server Agent- 10m 58s	10m 58s
39. Configuring Advanced SSIS Settings- 5m 19s	5m 19s
40. Enforce Data Quality: Install Data Quality Services- 6m 57s	6m 57s
41. Cleansing Data- 11m 28s	11m 28s
42. Finding duplicate data - part 1- 11m 11s	11m 11s
43. Finding duplicate data - part 2- 9m 7s	9m 7s
44. Using Data Quality Services in an SSIS Data Flow- 9m 34s	9m 34s
45. Consuming Data: Business Intelligence- 4m 16s	4m 16s
46. SSRS and Data Warehouse -part 1- 8m 12s	8m 12s
47. SSRS and Data Warehouse -part 2- 7m	7m
48. Data analysis with SQL Server Analysis Server - SSAS- 9m 27s	9m 27s
49. Data analysis with SQL Server Analysis Server - SSAS -part2- 5m 13s	5m 13s