Exclusive SALE Offer Today

SQL Developer Skills from Scratch

Best Seller 138 Lectures 15h 50m 3s
Prepare for your Microsoft examination with our training course. The No_code course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft No_code test with flying colors.
$14.99$24.99
Curriculum For This Course
  • 1. What is T-SQL 10m 27s
  • 2. What is a Database 8m 20s
  • 3. Primary Key 4m 50s
  • 4. Foreign Key 4m 39s
  • 5. Intellisense 7m 52s
  • 6. Normalization 14m 13s
  • 7. Querying Data with SELECT Statement 12m 53s
  • 8. Using Aliases in T- SQL Queries 7m 12s
  • 9. Case Expressions 12m 15s
  • 10. Creating Views 9m 10s
  • 11. Adding comments to T- SQL Queries 6m 7s
  • 12. Using Stored Procedures 11m 59s
  • 13. Using T-SQL Top Command 6m 9s
  • 14. T-SQL GO Command 5m 7s
  • 15. Using SQL Distinct to remove duplicate records 6m 42s
  • 16. Introduction to Table Joins 27s
  • 17. Why Table Joins are important 49s
  • 18. INNER Join 10m 36s
  • 19. LEFT Outer Join 12m 26s
  • 20. RIGHT OUTER Join 9m 30s
  • 21. Introduction to filtering records 2m 16s
  • 22. Filtering using equality filters 13m 35s
  • 23. Filtering with basic comparisons 6m 7s
  • 24. Filtering with logical comparisons 14m 8s
  • 25. Filtering with String Comparisons 11m 22s
  • 26. Filtering with NULL Comparisons 4m 35s
  • 27. Introduction to sorting returned records 31s
  • 28. Order by clause 3m 2s
  • 29. Sorting by ascending 4m 34s
  • 30. Sorting by descending 5m 3s
  • 31. Sorting by multiple columns 5m 9s
  • 32. Introduction to Aggregate Functions 2m 12s
  • 33. COUNT () 9m 24s
  • 34. AVG() 7m 52s
  • 35. MAX () 6m 24s
  • 36. MIN() 6m 37s
  • 37. SUM() 6m 57s
  • 38. Using Multiple Aggregate functions 5m 9s
  • 39. Grouping Data 8m 10s
  • 40. Introduction to modifying data 1m 40s
  • 41. Adding new records to database 10m 34s
  • 42. Updating Records 9m 18s
  • 43. Deleting Records 7m 53s
  • 1. Introduction to SSIS 3m 24s
  • 2. Visual Studio Requirements 3m 8s
  • 3. Download and Install Visual studio 7m 47s
  • 4. Completing visual studio installation 5m 9s
  • 5. Working with Solution Explorer and Projects Views 11m 44s
  • 6. Download and Install SQL Server Data Tools - SSDT 6m 3s
  • 7. Create basic ETL: New SSIS project 5m 35s
  • 8. Add a Flat File Connection Manager 6m 26s
  • 9. Remapping Column Data Types 11m 12s
  • 10. Add and Configure OLE DB Connection Manager 3m 39s
  • 11. Add a Data Flow Task to a Package 5m 2s
  • 12. Add and configure flat file source 4m 28s
  • 13. Add and configure lookup transformation 11m 29s
  • 14. Add and configure Lookup Datekey Transformation 9m 28s
  • 15. Add and configure OLE DB Destination 7m 53s
  • 16. Test SSIS Package 2m 2s
  • 17. Introduction to implementing Lookup Logic 3m 29s
  • 18. Create new SSIS Package 4m 5s
  • 19. Write data to cache - part 1 8m 10s
  • 20. Write data to cache - part 2 7m 9s
  • 21. Perform Lookups from cached data -part 1 9m 22s
  • 22. Perform Lookups from cached data -part 2 9m 16s
  • 23. Running your SSIS Package 3m 36s
  • 1. What is SQL Server 4m 26s
  • 2. What is SQL Server Reporting Services - SSRS 31s
  • 3. Requirements for creating basic report with -SSRS 3m 1s
  • 4. How to enable built-in administrator account in Windows 4m 10s
  • 5. SQL Server Reporting Configuration Manager 10m 46s
  • 6. Configuration of SQL Server Reporting Services 10m 46s
  • 7. Granting Permission 6m 20s
  • 8. Create Report Server Project 3m 2s
  • 9. Create Report Definition File 8m 31s
  • 10. Define Data Source 4m 50s
  • 11. Define Dataset 5m 42s
  • 12. Add a Table to Report 7m 25s
  • 13. Format Report 6m 57s
  • 14. Group Data 5m 5s
  • 15. Add totals to Report 8m 43s
  • 16. Publish Report 4m 13s
  • 1. Install SQL Server Enterprise - Evaluation 11m 54s
  • 2. Installing multiple instances of SQL Server 9m 25s
  • 3. Download and install AdventureworksDW2014 5m 33s
  • 4. Enable SQL Server Agent 2m 33s
  • 5. Test AdventureworksDW2014 installation 1m 46s
  • 6. Configuring Database Settings for Data Warehousing 6m 38s
  • 7. What is Data Warehouse? 3m 6s
  • 8. What is ETL 2m 28s
  • 9. DW Vs EDW 1m 55s
  • 10. Database Vs Data Warehouse 3m 15s
  • 11. Hardware requirements for Data Warehouse 10m 42s
  • 12. FTDW Sizing Tool 3m 56s
  • 13. Designing a data warehouse: Logical design 4m 14s
  • 14. Physical design of a data warehouse -part 1 9m 55s
  • 15. Physical design of a data warehouse -part 2 11m 42s
  • 16. Designing Dimension Tables 10m 14s
  • 17. Introduction to ETL with SSIS 2m 41s
  • 18. Exploring source data - part 1 8m 41s
  • 19. Exploring source data - part 2 4m 36s
  • 20. Introduction to Control Flow - part 1 9m 55s
  • 21. Introduction to Control Flow - part 2 8m 21s
  • 22. Implementing Data Flow - part 1 9m 44s
  • 23. Implementing Data Flow - part 2 9m 33s
  • 24. Debugging an SSIS Package - part 1 7m 20s
  • 25. Debugging an SSIS Package - part 2 6m 53s
  • 26. Logging SSIS package events 10m 18s
  • 27. Handling errors in an SSIS Package 8m
  • 28. Introduction to Incremental ETL Process 5m 36s
  • 29. Extracting Modified Data -part1 4m 53s
  • 30. Extracting Modified Data -part 2 7m 47s
  • 31. Extracting Modified Data -part 3 5m 29s
  • 32. Extracting Modified Data -part 4 7m 19s
  • 33. Loading modified data - part 1 7m 31s
  • 34. Loading modified data - part 2 7m 25s
  • 35. Working with other slowly changing dimensions 7m 38s
  • 36. Deploying and Configuring SSIS - Integration Services Catalog 8m 19s
  • 37. Deploy SSIS Solution 11m 52s
  • 38. Execute a package with SQL Server Agent 10m 58s
  • 39. Configuring Advanced SSIS Settings 5m 19s
  • 40. Enforce Data Quality: Install Data Quality Services 6m 57s
  • 41. Cleansing Data 11m 28s
  • 42. Finding duplicate data - part 1 11m 11s
  • 43. Finding duplicate data - part 2 9m 7s
  • 44. Using Data Quality Services in an SSIS Data Flow 9m 34s
  • 45. Consuming Data: Business Intelligence 4m 16s
  • 46. SSRS and Data Warehouse -part 1 8m 12s
  • 47. SSRS and Data Warehouse -part 2 7m
  • 48. Data analysis with SQL Server Analysis Server - SSAS 9m 27s
  • 49. Data analysis with SQL Server Analysis Server - SSAS -part2 5m 13s

Hot Exams

How to Open Test Engine .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

DumpsArena Test Engine

Windows

Refund Policy
Refund Policy

DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.

How our refund policy works?

safe checkout

Your purchase with DumpsArena.com is safe and fast.

The DumpsArena.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.

Need Help Assistance?

Customer Support