Name: SQL Developer Skills from Scratch
Rating: 4.4 (782 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.

$14.99 / $24.99

Setting up Your Test Environment

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

T-SQL

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

SQL Server Integration Services - SSIS

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

SQL Server Reporting Services - SSRS

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

Data Warehouse and SQL Server Analysis Services -SSAS

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