3.92 out of 5
3.92
840 reviews on Udemy

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Learn SQL Developer Skills from Scratch(SSRS, SSIS, SSAS,T-SQL,Data Warehouse(DW))
Instructor:
Bluelime Learning Solutions
5,949 students enrolled
English [Auto-generated]
Deploy and Configure SSIS packages.
Describe data warehouse concepts and architecture considerations.
Implement an ETL solution that supports incremental data extraction and loading
Choose between star and snowflake design schemas
Design and implement a data warehouse.
Debug and Troubleshoot SSIS packages
Write and execute queries to answer business questions
Create reports with SSRS
Analyse data with SSAS
Use Business Intelligence to Consume Data

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

Setting up Your Test Environment

1
Introduction
2
SQL Server Express hardware requirements
3
Download SQL Server Express 2014
4
Install SQL Server Express 2014
5
Download Adventureworks 2014 Database
6
Attach Adventureworks 2014 to SQL Server
7
SSMS Quick Tour

T-SQL

1
What is T-SQL
2
What is a Database
3
Primary Key
4
Foreign Key
5
Intellisense
6
Normalization
7
Querying Data with SELECT Statement
8
Using Aliases in T- SQL Queries
9
Case Expressions
10
Creating Views
11
Adding comments to T- SQL Queries
12
Using Stored Procedures
13
Using T-SQL Top Command
14
T-SQL GO Command
15
Using SQL Distinct to remove duplicate records
16
Introduction to Table Joins
17
Why Table Joins are important
18
INNER Join
19
LEFT Outer Join
20
RIGHT OUTER Join
21
Introduction to filtering records
22
Filtering using equality filters
23
Filtering with basic comparisons
24
Filtering with logical comparisons
25
Filtering with String Comparisons
26
Filtering with NULL Comparisons
27
Introduction to sorting returned records
28
Order by clause
29
Sorting by ascending
30
Sorting by descending
31
Sorting by multiple columns
32
Introduction to Aggregate Functions
33
COUNT ()
34
AVG()
35
MAX ()
36
MIN()
37
SUM()
38
Using Multiple Aggregate functions
39
Grouping Data
40
Introduction to modifying data
41
Adding new records to database
42
Updating Records
43
Deleting Records

SQL Server Integration Services - SSIS

1
Introduction to SSIS
2
Visual Studio Requirements
3
Download and Install Visual studio
4
Completing visual studio installation
5
Working with Solution Explorer and Projects Views
6
Download and Install SQL Server Data Tools - SSDT
7
Create basic ETL: New SSIS project
8
Add a Flat File Connection Manager
9
Remapping Column Data Types
10
Add and Configure OLE DB Connection Manager
11
Add a Data Flow Task to a Package
12
Add and configure flat file source
13
Add and configure lookup transformation
14
Add and configure Lookup Datekey Transformation
15
Add and configure OLE DB Destination
16
Test SSIS Package
17
Introduction to implementing Lookup Logic
18
Create new SSIS Package
19
Write data to cache - part 1
20
Write data to cache - part 2
21
Perform Lookups from cached data -part 1
22
Perform Lookups from cached data -part 2
23
Running your SSIS Package

SQL Server Reporting Services - SSRS

1
What is SQL Server
2
What is SQL Server Reporting Services - SSRS
3
Requirements for creating basic report with -SSRS
4
How to enable built-in administrator account in Windows
5
SQL Server Reporting Configuration Manager
6
Granting Permission
7
Create Report Server Project
8
Create Report Definition File
9
Define Data Source
10
Define Dataset
11
Add a Table to Report
12
Format Report
13
Group Data
14
Add totals to Report
15
Publish Report

Data Warehouse and SQL Server Analysis Services -SSAS

1
Install SQL Server Enterprise - Evaluation
2
Installing multiple instances of SQL Server
3
Download and install AdventureworksDW2014
4
Enable SQL Server Agent
5
Test AdventureworksDW2014 installation
6
Configuring Database Settings for Data Warehousing
7
What is Data Warehouse?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
840 Ratings

Detailed Rating

Stars 5
307
Stars 4
276
Stars 3
155
Stars 2
52
Stars 1
51
f16a82d903db57596193f16776d5b5c0
30-Day Money-Back Guarantee

Includes

16 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion