SQL Developer Skills from Scratch

SQL Developer Skills from Scratch

BEST SELLER 138 Lectures 15h 50m 3s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$13.99 $24.99

Curriculum For This Course

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

43 lectures 5h 14m 15s
  • 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

23 lectures 2h 29m 36s
  • 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

16 lectures 1h 34m 28s
  • 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

49 lectures 5h 57m 49s
  • 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

Free Test Engine Player

How to open .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

Our test engine player will always be free.

DumpsArena Test Engine

Windows
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support