SQL Developer Skills from Scratch

What’s included

$14.99 / $24.99

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.

4.59

Pay once, own it forever

Video Courses

Setting up Your Test Environment

Lectures	Duration
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

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

Lectures	Duration
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. 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

Lectures	Duration
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. 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

Lectures	Duration
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. 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

Lectures	Duration
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

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

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

48. Data analysis with SQL Server Analysis Server - SSAS

9m 27s

49. Data analysis with SQL Server Analysis Server - SSAS -part2

5m 13s