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

Learn SQL Developer Skills from Scratch(SSRS, SSIS, SSAS,T-SQL,Data Warehouse(DW))

Created by: Bluelime Learning Solutions

Produced in 2021

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 74 / 100

icon
Course 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 solutionDebug 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) processHow to deploy SSIS PackageHow to create SSIS package using SQL Server Integration ServicesHow to download and install SQL Server Data ToolsHow to perform data analysis with SQL Server Analysis Server - SSASHow to create reports using SQL Server Reporting ServicesHow to download and install SQL ServerIntroduction to T-SQL basicsHow to implement Table JoinsUsing Aggregate functionsWho this course is for:
Beginner SQL DeveloperBeginner Database AdministratorBeginner Data ScientistBeginner Data Warehouse administrators

icon
Instructor Details

Bluelime Learning Solutions

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.

icon
More courses by Bluelime Learning Solutions

17 Beginner C# Walkthrough Projects step by step

$11.99

Coding for beginners

$11.99

PostgreSQL Database Administration (DBA) for Beginners

$11.99

Python and Django Full-Stack Web Development for beginners

$11.99

Learn Java by building 17 projects step by step

$11.99

Full-Stack Web Development For Beginners

$11.99

icon
More sql courses

SQL Server - zapytania. Querying. Exam 70-761

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

$11.99

Introduction to Structured Query Language (SQL)

Free

Learn C# With Windows Forms and SQL Server

$11.99

Microsoft Access SQL: SQL for Non-Programmers

$11.99

The Ultimate Oracle SQL Course

$11.99

icon
Reviews

3.7

260 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Muhamad Haiqal on 12/20/2020

Should be more explaining about feature and capabilities and bring up some use case that more relevant

By Mohamed Soliman on 11/23/2020

Need to explain the overall ETL plan before going into the details

By Akshata Patil on 11/23/2020

Video was understandable

By Nkosinathi Mathibela on 11/15/2020

The course was a good match. I forgot some skills along the way and this is good to get me back on that horse.

By SuperBird on 11/6/2020

Great basic lesson,

By Jeanette Kloppenburg on 11/3/2020

The slow speech is very annoying.

By Jay Patel on 10/19/2020

This course doesn't provide knowledge for mac users. at least there should be a notice from udemy that this course only supports and has functions that can only be installed in Microsoft os. For mac users, this course won't teach you anything, unless all you want is a certificate of completion.

By Augustine Masikonde on 10/14/2020

Precise, easy to follow with good hands-on

By Bidhan Chakma on 10/14/2020

The course could have been better. Overall it is the beginning course and covers a lot of topics very basic level. I am sure that the building of SSIS and SSAS would be very complex in a real world where you would have a lot of complex data structure and dimension.

By Charlotte Mdluli on 10/6/2020

a good match

By Sukanya Subramanian on 10/4/2020

Instructions are very clear and easy to follow.

By Regie Quindipan on 10/2/2020

The content is great, it could be better with more explanations and examples on certain lectures. However the structure of this course is a bit messy. Plus there is not enough Q&A support given on this course.