Become an SQL Developer - Learn (SSRS , SSIS, SSAS, T-SQL, DW)
Practical Hands-on SQL Developer Skills
SQL developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers.
As an SQL developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important.
This course is Hands-on and by the end of the course you will have experience of working with relational database management systems like Microsoft SQL Server .
Some of what you will learn on the course includes following:
How to implement a data warehouse solution
Debug and Troubleshoot SSIS packages.
Cleansing data by using Data Quality Services.
Extend SSIS with custom scripts and components.
How to create ETL (Extract,Transform, Load) process
How to deploy SSIS Package
How to create SSIS package using SQL Server Integration Services
How to download and install SQL Server Data Tools
How to perform data analysis with SQL Server Analysis Server - SSAS
How to create reports using SQL Server Reporting Services
How to download and install SQL Server
Introduction to T-SQL basics
How to implement Table Joins
Using Aggregate functions
Your Instructor
Hello and welcome.
We have a passion for technology and passing on what we know to others. We have thought thousand of people online.
Course Curriculum
-
PreviewWhat is SQL Server (4:26)
-
PreviewSQL Server Express Hardware Requirements (2:49)
-
StartDownload SQL Server Express 2014 (4:07)
-
StartInstall SQL Server Express 2014 (6:47)
-
StartDownload and Install SQL Server 2017 Express (7:56)
-
StartDownload adventureworks 2014 database (6:39)
-
StartAttach Adventureworks2014 database to SQL Server (5:45)
-
StartDatabase Concepts (3:50)
-
PreviewWhat is T-SQL (10:27)
-
PreviewWhat is a database (8:20)
-
PreviewWhat is SSMS (8:21)
-
PreviewWhat is SQL (2:29)
-
StartWhat is a Primary Key (4:50)
-
StartWhat is a Foreign Key (4:39)
-
StartWhat is a Schema (2:50)
-
StartIntellisense (7:52)
-
StartNormalization (14:13)
-
StartQuery data with SELECT Statement (12:53)
-
StartUsing Aliases in T-SQL Queries (7:12)
-
StartCase Expressions (12:15)
-
StartWhat are views (9:10)
-
StartAdding comments to T-SQL Queries (6:07)
-
StartUsing Stored Procedures (11:59)
-
StartUsing T-SQL Top Command (6:09)
-
StartT-SQL GO Command (5:07)
-
StartUsing SQL DISTINCT To remove duplicates (6:42)
-
StartIntroduction to Table Joins (0:27)
-
StartWhy Table Joins are important (0:49)
-
StartINNER Join (10:36)
-
StartLEFT OUTER Join (12:26)
-
StartRIGHT OUTER Join (9:30)
-
StartIntroduction to filtering records (2:16)
-
StartFiltering using equality filters (13:35)
-
StartFiltering with basic comparisons (11:22)
-
StartFiltering with logical comparisons (14:08)
-
StartFiltering with String comparisons (11:22)
-
StartFiltering with NULL Comparisons (4:35)
-
StartIntroduction to sorting returned records (0:31)
-
StartORDER BY Clause (3:02)
-
StartSorting by ascending (4:34)
-
StartSorting by descending (5:03)
-
StartSorting by multiple columns (5:09)
-
StartIntroduction to Aggregate Functions (2:12)
-
StartCOUNT() (9:24)
-
StartAVG() (7:52)
-
StartMAX() (6:49)
-
StartMIN() (6:50)
-
StartSUM() (7:17)
-
StartUsing Multiple Aggregate Functions (5:09)
-
StartGrouping Data (8:10)
-
StartIntroduction to modifying data (1:40)
-
StartAdding new records to database (10:34)
-
StartUpdating Records (9:18)
-
StartDeleting Records (7:53)
-
PreviewWhat is SSIS (3:24)
-
StartVisual Studio Requirements (3:08)
-
StartDownload and Install Visual Studio (7:47)
-
StartCompleting Visual Studio installation (5:09)
-
StartWorking with solution explorer (11:44)
-
StartDownload and install SQL SERVER DATA Tools -SSDT (6:03)
-
StartCreate basic ETL : New SSIS Project (5:35)
-
StartAdd a flat file connection manager (6:26)
-
StartRemapping column data types (11:12)
-
StartAdd and configure OLE DB Connection Manager (3:39)
-
StartAdd a data flow task to a package (5:02)
-
StartAdd and configure Flat File Source (4:28)
-
StartAdd and configure lookup transformation (11:29)
-
StartAdd and configure lookup datekey transformation (9:28)
-
StartAdd and configure OLE DB Destination (7:53)
-
StartTest SSIS Package (2:02)
-
StartIntroduction to implementation lookup logic (3:29)
-
StartCreate a new SSIS Package (4:05)
-
StartWrite data to cache - Part 1 (8:10)
-
StartWrite data to cache - Part 2 (7:09)
-
StartPerform lookups from cached data (9:22)
-
Startperform lookups from cached data part 2 (9:16)
-
StartRunning your SSIS Package (3:36)