Become an SQL Developer - Learn (SSRS, SSIS, SSAS,T-SQL,DW)
4.0 (42 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,236 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Become an SQL Developer - Learn (SSRS, SSIS, SSAS,T-SQL,DW) to your Wishlist.

Add to Wishlist

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))
4.0 (42 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,236 students enrolled
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $195 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 16 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Experience of working with relational databases
  • Querying with Transact-SQL.
  • An awareness of key business priorities such as revenue, profitability
Description

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

Who is the target audience?
  • Beginner SQL Developer
  • Beginner Database Administrator
  • Beginner Data Scientist
  • Beginner Data Warehouse administrators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
138 Lectures
15:52:22
+
Setting up Your Test Environment
7 Lectures 35:23



Install SQL Server Express 2014
06:47

Download Adventureworks 2014 Database
05:06

Attach Adventureworks 2014 to SQL Server
04:14

SSMS Quick Tour
08:21
+
T-SQL
43 Lectures 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:49

MIN()
06:50

SUM()
07:17

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
+
SQL Server Integration Services - SSIS
23 Lectures 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
+
SQL Server Reporting Services - SSRS
16 Lectures 01:34:25
What is SQL Server
04:26

What is SQL Server Reporting Services - SSRS
00:30

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:01

Create Report Definition File
08:31

Define Data Source
04:50

Define Dataset
05:42

Add a Table to Report
07:24

Format Report
06:57

Group Data
05:05

Add totals to Report
08:43

Publish Report
04:13
+
Data Warehouse and SQL Server Analysis Services -SSAS
49 Lectures 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:27

DW Vs EDW
01:54

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:28

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:27

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
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,578 Reviews
35,239 Students
86 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.