Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI

Data Extraction | Data Cleaning & Transformation | Data Visualization

3.75 (34 reviews)
Udemy
platform
English
language
Data & Analytics
category
Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI
2,331
students
7 hours
content
Feb 2022
last update
$59.99
regular price

What you will learn

Setup SQL Server

Filter Data

Sort Data

Implement ETL Process

Create and execute SSIS Package

Analyse and transform data with Power BI

Create visualization with Power BI

Description

SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences. Millions of data points are being generated every minute. And raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.

Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.

  • Azure SQL Database: Support modern cloud applications on an intelligent, managed database service, that includes serverless compute.

  • Azure SQL Managed Instance: Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud.

  • SQL Server on Azure VMs: Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access.

Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with. Your skills and experience transfer to the cloud, so you can do even more with what you already have.

Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.

In this beginners course you will learn how to  get started with this powerful toolset.  We will  cover topics like  connecting to and transforming web based data sources.  You will learn how to publish and share your reports and visuals on the Power BI service.

Content

Introduction

Introduction
What is a Data Engineer
What is a Data Analyst
What is SQL

Microsoft SQL Server Setup

What is SQL Server
SQL Server Editions
Hardware | Software Requirements
SQL Server Download
SQL Server Installation
Installing SSMS
SQL Server Configuration Manager
Connecting SSMS to SQL Server
Download Sample Database
Install adventureworks DW Database
Database Concepts

Filtering Data

Filter data with equality filters
Filter data with comparison filters
Filter data with logical filters
Filter data with String filters
Filter data with NULL filters

Sorting Data

Using ORDER BY
Sorting by ascending
Sorting by descending
Sorting by multiple columns

Setup and interact with Azure SQL Database

What is Azure
What is Azure SQL
Create Azure account
Accessing Azure services
Create a database in Azure Portal
Query SQL Database in azure portal
Connect Azure SQL Database to SSMS
Insert data into Azure SQL Database
Update data in Azure Database
Delete Data from Azure database

Visual Studio Setup

What is Visual studio
Visual Studio Installation Requirements
Installing Visual studio
Visual studio work load
Installing SQL Server Data Tools - SSDT
Installing SSDT Designer Templates

Implementing ETL with SSIS

What is ETL
ETL Process
Introduction to SSIS
Create a new SSIS Project (vs 2019)
Create a new SSIS Project (vs 2015)
Add a flat file connection manager
Remap Column Data Types
Add and configure OLE DB Connection Manager
Add a data flow task
Add and configure flat file source
Add and configure lookup transformation
Add and configure lookup for Date4Key Transformation
Add and configure OLE DB Destination
Test and run SSIS Package

Power BI Setup

What is Power BI
What is Power BI Desktop
Office 365 Setup
Installing Power BI Desktop
Power BI Desktop brief tour

Overview of Power BI

Power BI Overview: Part 1
Power BI Overview: Part 2
Power BI Overview: Part 3
Components of Power BI
Building blocks of Power BI
Power BI Desktop Interface
Power BI Service
Power BI Apps

Power BI: Data Extraction | Transformation | Visualization

Connect to web based data
Clean and transform data : Part 1
Clean and transform data : Part 2
Combining Data Sources
Creating Data Visuals : Part 1
Creating Data Visuals : Part 2
Publishing report to Power BI Service
Connecting Power to SQL Server

Coupons

DateDiscountStatus
10/28/2021100% OFF
expired
11/20/2021100% OFF
expired

Charts

Price

Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI - Price chart

Rating

Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI - Ratings chart

Enrollment distribution

Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI - Distribution chart
4369760
udemy ID
10/27/2021
course created date
10/28/2021
course indexed date
Sanaturk
course submited by