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)."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) with these activities:

Review T-SQL Basics

Show steps

Review the basics of T-SQL, including data types, operators, and control flow, to strengthen your foundation for working with SQL databases.

Browse courses on T-SQL

Show steps

Revisit SQL syntax and data types
Practice writing basic queries using SELECT, INSERT, UPDATE, and DELETE statements
Create and modify tables using CREATE TABLE and ALTER TABLE statements

Participate in Online Discussion Forums

Show steps

Engage in discussions with peers on course-related topics, ask questions, share knowledge, and enhance your understanding through collaboration.

Show steps

Join online discussion forums
Participate in discussions and post questions

Build an ETL Pipeline with SSIS

Show steps

Follow step-by-step tutorials to create a complete ETL pipeline using SSIS, gaining hands-on experience in data extraction, transformation, and loading.

Browse courses on ETL

Show steps

Design the ETL process flow
Configure data sources and destinations
Create transformations to clean and prepare data
Execute the ETL package

Five other activities

Expand to see all activities and additional details

Show all eight activities

Querying and Analyzing Data with SQL Server Analysis Services (SSAS)

Show steps

Practice writing MDX queries and creating calculated measures and KPIs to analyze data and gain insights using SQL Server Analysis Services.

Browse courses on SSAS

Show steps

Create a cube and dimensions
Write MDX queries to retrieve data
Create calculated measures and KPIs

Develop a Business Intelligence Report with SQL Server Reporting Services (SSRS)

Show steps

Create a comprehensive business intelligence report using SSRS, including charts, tables, and visualizations, to present data insights effectively to stakeholders.

Browse courses on SSRS

Show steps

Design the report layout and structure
Create datasets and data sources
Add charts and visualizations
Publish the report

Contribute to Open-Source SQL Projects

Show steps

Gain practical experience and contribute to the SQL community by participating in open-source projects, such as database management systems or data analysis tools.

Show steps

Identify suitable open-source projects
Explore the codebase and understand the project's goals
Contribute code, documentation, or other resources

Design a Data Warehouse Schema

Show steps

Design a data warehouse schema using star or snowflake models, ensuring optimal data storage and retrieval for business intelligence purposes.

Browse courses on Data Warehouse

Show steps

Identify business requirements and data sources
Choose the appropriate data model (star or snowflake)
Create dimension and fact tables
Define relationships between tables
Optimize the schema for performance

Participate in a Kaggle Competition

Show steps

Apply your SQL and data analysis skills in a competitive environment by participating in a Kaggle competition, showcasing your abilities and expanding your knowledge.

Show steps

Choose a relevant competition
Explore the dataset and understand the problem statement
Develop and implement your data analysis approach
Submit your results and evaluate your performance

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