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

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 -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 functions

What's inside

Learning objectives

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

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

Syllabus

Getting Started

Introduction

Please Read

Database Concepts

SQL Server 2019 Setup

What is SQL Server

SQL Server 2019 Hardware | Software Installation Requirements

SQL Server Editions

Download SQL Server 2019 Developer Edition

SQL Server 2019 Developer Edition Installation

Installing SQL Server Management Studio

Connecting to SQL Server with SSMS

SSMS Quick Tour

SQL Server Configuration Manager

Installing adventureworks 2016 database

Installing adventureworksDW 2016 database

Attach Adventureworks 2014 to SQL Server

SQL Server Reporting Services Setup

Installing Reporting Services

Configure Report Server

Accessing Report Server Web Portal Locally

Accessing Report Server Web Portal Remotely

Configure SSMS for local SSRS administration

Adding users and groups to SSRS

Installing Report Builder

Setup for : Visual studio 2019 | SSIS | SSRS| SSAS BI Designer Templates

What is Visual Studio

Minimum Installation Requirements for visual studio 2019

Installing Visual Studio

Installing SQL Server Data Tools (SSDT)

Installing Designers for SSIS,SSAS,SSRS

T-SQL

What is T-SQL

What is a Database

Primary Key

Foreign Key

Intellisense

Normalization

Querying Data with SELECT Statement

Using Aliases in T- SQL Queries

Case Expressions

Creating Views

Adding comments to T- SQL Queries

Using Stored Procedures

Using T-SQL Top Command

T-SQL GO Command

Using SQL Distinct to remove duplicate records

Introduction to Table Joins

Why Table Joins are important

INNER Join

LEFT Outer Join

RIGHT OUTER Join

Introduction to filtering records

Filtering using equality filters

Filtering with basic comparisons

Filtering with logical comparisons

Filtering with String Comparisons

Filtering with NULL Comparisons

Introduction to sorting returned records

Order by clause

Sorting by ascending

Sorting by descending

Sorting by multiple columns

Introduction to Aggregate Functions

COUNT ()

AVG()

MAX ()

MIN()

SUM()

Using Multiple Aggregate functions

Grouping Data

Introduction to modifying data

Adding new records to database

Updating Records

Deleting Records

Learn how SSIS Works

Introduction to SSIS

Creating a new SSIS Project with Visual studio 2019

Create basic ETL: New SSIS project

Add a Flat File Connection Manager

Remapping Column Data Types

Add and Configure OLE DB Connection Manager

Add a Data Flow Task to a Package

Add and configure flat file source

Add and configure lookup transformation

Add and configure Lookup Datekey Transformation

Add and configure OLE DB Destination

Test SSIS Package

Introduction to implementing Lookup Logic

Create new SSIS Package

Write data to cache - part 1

Write data to cache - part 2

Perform Lookups from cached data -part 1

Perform Lookups from cached data -part 2

Running your SSIS Package

Create reports with SSRS

What is SQL Server Reporting Services - SSRS

Requirements for creating basic report with -SSRS

How to enable built-in administrator account in Windows

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches a variety of skills expected of SQL developers, such as database design, implementation, and maintenance

Provides learners with hands-on experience in relational database management systems like Microsoft SQL Server

Covers topics relevant to SQL developers, such as ETL processes, data cleansing, and data analysis

Taught by Bluelime Learning Solutions, which has expertise in SQL Server and related technologies

Requires learners to have a strong foundation in SQL and related concepts

Reviews summary

Useful for beginners only

According to students, this course is useful for beginners. However, some students felt like the information could have been better presented, especially for beginners.

Lots of useful information for beginners.

"There is a lot of very useful information here and as a beginner a learned a lot."

The presentation could be better for beginners.

"But I can't help but feel the way the information was presented could have been better, structure wise (e.g. clearly defining the goals of what we are doing before doing it)."

Career center

Learners who complete Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) will develop knowledge and skills that may be useful to these careers:

Database Analyst

A Database Analyst is responsible for studying, analyzing, and defining the data requirements for an organization. As a Database Analyst, you would design and develop databases that support the organization's operations. This course can help build a foundation for success as a Database Analyst, as it covers the basics of SQL and data warehousing. The course also includes hands-on experience with Microsoft SQL Server, which is a popular database management system used by many organizations.

See salaries and explore the career path for Database Analyst

Data Architect

A Data Architect is responsible for designing, developing, and maintaining the overall architecture of an organization's data systems. As a Data Architect, you would work with business stakeholders to understand their data needs and develop data solutions that meet those needs. This course can help you develop the skills and knowledge needed to be a successful Data Architect, as it covers the fundamentals of data warehousing, data modeling, and data integration.

See salaries and explore the career path for Data Architect

Data Engineer

A Data Engineer is responsible for designing, developing, and maintaining the infrastructure that supports an organization's data systems. As a Data Engineer, you would work with data architects and other IT professionals to ensure that data is available, reliable, and secure. This course can help you develop the skills and knowledge needed to be a successful Data Engineer, as it covers the fundamentals of data warehousing, data integration, and data security.

See salaries and explore the career path for Data Engineer

Database Administrator

A Database Administrator is responsible for managing and maintaining an organization's database systems. As a Database Administrator, you would be responsible for ensuring that databases are available, reliable, and secure. This course can help build a foundation for success as a Database Administrator, as it covers the basics of database administration, including database design, performance tuning, and security.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

A Business Intelligence Analyst is responsible for analyzing data to identify trends and patterns that can help businesses make better decisions. As a Business Intelligence Analyst, you would use data visualization and other tools to communicate your findings to business stakeholders. This course can help develop the skills and knowledge needed to be a successful Business Intelligence Analyst, as it covers the fundamentals of data analysis, data visualization, and business intelligence.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist is responsible for using data to solve business problems. As a Data Scientist, you would use machine learning and other data science techniques to build models that can predict future outcomes. This course may be useful for those interested in a career as a Data Scientist, as it provides a foundation in data analysis and data mining.

See salaries and explore the career path for Data Scientist

Web Developer

A Web Developer is responsible for designing, developing, and maintaining websites. As a Web Developer, you would work with other web developers to build websites that are informative, engaging, and easy to use. This course may be useful for those interested in a career as a Web Developer, as it provides a foundation in web development and database programming.

See salaries and explore the career path for Web Developer

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. As a Software Engineer, you would work with other software engineers to build software systems that meet the needs of users. This course may be useful for those interested in a career as a Software Engineer, as it provides a foundation in software development and database programming.

See salaries and explore the career path for Software Engineer

Systems Analyst

A Systems Analyst is responsible for studying and analyzing business systems to identify areas for improvement. As a Systems Analyst, you would work with business stakeholders to develop and implement solutions that improve the efficiency and effectiveness of business processes. This course may be useful for those interested in a career as a Systems Analyst, as it provides a foundation in business analysis and data modeling.

See salaries and explore the career path for Systems Analyst

Project Manager

A Project Manager is responsible for planning, executing, and closing projects. As a Project Manager, you would work with project stakeholders to ensure that projects are completed on time, within budget, and to the required quality standards. This course may be useful for those interested in a career as a Project Manager, as it provides a foundation in project management and business analysis.

See salaries and explore the career path for Project Manager

Business Analyst

A Business Analyst is responsible for studying and analyzing business processes to identify areas for improvement. As a Business Analyst, you would work with business stakeholders to develop and implement solutions that improve the efficiency and effectiveness of business processes. This course may be useful for those interested in a career as a Business Analyst, as it provides a foundation in business analysis and data modeling.

See salaries and explore the career path for Business Analyst

Quality Assurance Analyst

A Quality Assurance Analyst is responsible for testing and evaluating software applications to ensure that they meet quality standards. As a Quality Assurance Analyst, you would work with software engineers and other IT professionals to identify and fix software defects. This course may be useful for those interested in a career as a Quality Assurance Analyst, as it provides a foundation in software testing and quality assurance.

See salaries and explore the career path for Quality Assurance Analyst

Data Warehouse Manager

A Data Warehouse Manager is responsible for managing and maintaining an organization's data warehouse. As a Data Warehouse Manager, you would work with data engineers and other IT professionals to ensure that the data warehouse is available, reliable, and secure. This course may be useful for those interested in a career as a Data Warehouse Manager, as it provides a foundation in data warehousing and data management.

See salaries and explore the career path for Data Warehouse Manager

IT Consultant

An IT Consultant is responsible for providing advice and guidance to organizations on the use of information technology. As an IT Consultant, you would work with clients to identify their IT needs and develop and implement solutions that meet those needs. This course may be useful for those interested in a career as an IT Consultant, as it provides a foundation in information technology and business analysis.

See salaries and explore the career path for IT Consultant

Technical Writer

A Technical Writer is responsible for writing and editing technical documentation, such as user manuals, white papers, and training materials. As a Technical Writer, you would work with subject matter experts to gather information and develop clear and concise documentation that explains complex technical concepts. This course may be useful for those interested in a career as a Technical Writer, as it provides a foundation in technical writing and communication.

See salaries and explore the career path for Technical Writer