SQL Developer Skills from Scratch Video Course

Curriculum For This Course

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