SQL Developer Skills from Scratch

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

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

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

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