mcAfee-secured website

Course name Databases Courses SQL Developer Skills from Scratch: SQL Developer Skills from Scratch

SQL Developer Skills from Scratch Video Course

SQL Developer Skills from Scratch Video Course is developed by Databases Courses Professionals to help you pass the SQL Developer Skills from Scratch exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass SQL Developer Skills from Scratch exam.

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