Certification training

SQL Developer Skills from Scratch

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

138Lectures
15h 50m 3sDuration
Vendor
SQL Developer Skills from Scratch course cover Best seller
certification training 138 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

5 sections, 138 lessons, and lecture-level duration details.

01 Introduction 3m 59s
02 SQL Server Express hardware requirements 2m 49s
03 Download SQL Server Express 2014 4m 8s
04 Install SQL Server Express 2014 6m 47s
05 Download Adventureworks 2014 Database 5m 6s
06 Attach Adventureworks 2014 to SQL Server 4m 14s
07 SSMS Quick Tour 6m 52s

01 What is T-SQL 10m 27s
02 What is a Database 8m 20s
03 Primary Key 4m 50s
04 Foreign Key 4m 39s
05 Intellisense 7m 52s
06 Normalization 14m 13s
07 Querying Data with SELECT Statement 12m 53s
08 Using Aliases in T- SQL Queries 7m 12s
09 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

01 Introduction to SSIS 3m 24s
02 Visual Studio Requirements 3m 8s
03 Download and Install Visual studio 7m 47s
04 Completing visual studio installation 5m 9s
05 Working with Solution Explorer and Projects Views 11m 44s
06 Download and Install SQL Server Data Tools - SSDT 6m 3s
07 Create basic ETL: New SSIS project 5m 35s
08 Add a Flat File Connection Manager 6m 26s
09 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

01 What is SQL Server 4m 26s
02 What is SQL Server Reporting Services - SSRS 31s
03 Requirements for creating basic report with -SSRS 3m 1s
04 How to enable built-in administrator account in Windows 4m 10s
05 SQL Server Reporting Configuration Manager 10m 46s
06 Configuration of SQL Server Reporting Services 10m 46s
07 Granting Permission 6m 20s
08 Create Report Server Project 3m 2s
09 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

01 Install SQL Server Enterprise - Evaluation 11m 54s
02 Installing multiple instances of SQL Server 9m 25s
03 Download and install AdventureworksDW2014 5m 33s
04 Enable SQL Server Agent 2m 33s
05 Test AdventureworksDW2014 installation 1m 46s
06 Configuring Database Settings for Data Warehousing 6m 38s
07 What is Data Warehouse? 3m 6s
08 What is ETL 2m 28s
09 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
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.