This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Become an SQL Developer - Learn (SSRS , SSIS, SSAS, T-SQL, DW)
Setting Up Database Development Environment
What is SQL Server (4:26)
SQL Server Express Hardware Requirements (2:49)
Download SQL Server Express 2014 (4:07)
Install SQL Server Express 2014 (6:47)
Download and Install SQL Server 2017 Express (7:56)
Download adventureworks 2014 database (6:39)
Attach Adventureworks2014 database to SQL Server (5:45)
Database Concepts (3:50)
T-SQL Fundamentals
What is T-SQL (10:27)
What is a database (8:20)
What is SSMS (8:21)
What is SQL (2:29)
What is a Primary Key (4:50)
What is a Foreign Key (4:39)
What is a Schema (2:50)
Intellisense (7:52)
Normalization (14:13)
Query data with SELECT Statement (12:53)
Using Aliases in T-SQL Queries (7:12)
Case Expressions (12:15)
What are views (9:10)
Adding comments to T-SQL Queries (6:07)
Using Stored Procedures (11:59)
Using T-SQL Top Command (6:09)
T-SQL GO Command (5:07)
Using SQL DISTINCT To remove duplicates (6:42)
Introduction to Table Joins (0:27)
Why Table Joins are important (0:49)
INNER Join (10:36)
LEFT OUTER Join (12:26)
RIGHT OUTER Join (9:30)
Introduction to filtering records (2:16)
Filtering using equality filters (13:35)
Filtering with basic comparisons (11:22)
Filtering with logical comparisons (14:08)
Filtering with String comparisons (11:22)
Filtering with NULL Comparisons (4:35)
Introduction to sorting returned records (0:31)
ORDER BY Clause (3:02)
Sorting by ascending (4:34)
Sorting by descending (5:03)
Sorting by multiple columns (5:09)
Introduction to Aggregate Functions (2:12)
COUNT() (9:24)
AVG() (7:52)
MAX() (6:49)
MIN() (6:50)
SUM() (7:17)
Using Multiple Aggregate Functions (5:09)
Grouping Data (8:10)
Introduction to modifying data (1:40)
Adding new records to database (10:34)
Updating Records (9:18)
Deleting Records (7:53)
SQL Server Integration Services - SSIS
What is SSIS (3:24)
Visual Studio Requirements (3:08)
Download and Install Visual Studio (7:47)
Completing Visual Studio installation (5:09)
Working with solution explorer (11:44)
Download and install SQL SERVER DATA Tools -SSDT (6:03)
Create basic ETL : New SSIS Project (5:35)
Add a flat file connection manager (6:26)
Remapping column data types (11:12)
Add and configure OLE DB Connection Manager (3:39)
Add a data flow task to a package (5:02)
Add and configure Flat File Source (4:28)
Add and configure lookup transformation (11:29)
Add and configure lookup datekey transformation (9:28)
Add and configure OLE DB Destination (7:53)
Test SSIS Package (2:02)
Introduction to implementation lookup logic (3:29)
Create a new SSIS Package (4:05)
Write data to cache - Part 1 (8:10)
Write data to cache - Part 2 (7:09)
Perform lookups from cached data (9:22)
perform lookups from cached data part 2 (9:16)
Running your SSIS Package (3:36)
SQL Server Reporting Services - SSRS
What is SQL Server Reporting Services (0:30)
Creating basic report with SSRS (3:01)
How to enable built in administrator account in windows (4:09)
SQL Server Reporting Configuration Manager (10:46)
Configuration of SQL Server Reporting Services (10:46)
Granting Permission (6:20)
Create Report Server Project (3:01)
Create Report Definition File (8:31)
Define Data Source (4:49)
Define Dataset (5:42)
Add a table to report (7:24)
Format report (6:57)
Group data (5:05)
Add totals to report (8:43)
Publish Report (4:12)
Data Warehouse and SQL Server Analysis Services - DW | SSAS
New Lecture Install SQL Server Enterprise - Evaluation (11:54)
Install multiple instances of SQL Server (9:25)
Download and Attach AdventureworksDW2014 (5:33)
Enable SQL Server Agent (2:33)
Test adventureworksDW2014 (1:46)
Configure database settings for Data Warehousing (6:38)
What is data warehouse (3:06)
What is ETL (2:27)
DW Vs EDW (1:54)
Database vs Data Warehouse (3:14)
Hardware requirement for data warehouse (10:42)
FTDW Sizing Tool (3:56)
Designing a data warehouse - Logical design (4:14)
Physical design of a data warehouse Part 1 (9:55)
Physical design of a data warehouse Part 2 (11:42)
Designing dimension tables (10:14)
Introduction to ETS with SSIS (2:41)
Exploring source data - part 1 (8:41)
Exploring source data - part 2 (4:36)
Introduction to control flow - part 1 (9:55)
Introduction to control flow - part 2 (8:21)
Debugging SSIS Package - Part 1 (7:20)
Debugging SSIS Package - Part 2 (6:53)
Logging SSIS package events (10:18)
Handling errors in an SSIS package (8:00)
Introduction to incremental ETL Process (5:36)
Extracting modified data - part 1 (4:53)
Extracting modified data - part 2 (7:47)
Extracting modified data - part 3 (5:28)
Extracting modified data - part 4 (7:19)
Loading modified data - part 1 (7:31)
Loading modified data - part 2 (7:25)
Working with other slowly changing dimensions (7:38)
Deploying and configuring SSIS - Integration Services Catalog (8:19)
Deploy SSIS Solution (11:52)
Execute a package with SQL Server Agent (10:58)
Configuring Advanced SSIS Settings (5:19)
Enforce Data Quality: Install Data Quality Services (6:57)
Cleansing data (11:27)
Finding duplicate data - part 1 (11:11)
Finding duplicate data - part 2 (9:07)
Using data quality services in SSIS data flow (9:34)
Consuming data : Business intelligence (4:15)
SSRS and Data Warehouse - Part 1 (8:12)
SSRS and Data Warehouse - Part 2 (7:00)
Data analysis with SQL Server Analysis Server -SSAS - Part 1 (9:27)
Data analysis with SQL Server Analysis Server -SSAS - Part 2 (5:13)
Introduction to control flow - part 1
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock