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

BY
Udemy

Learn about data engineering activities such as data cleaning, data extraction, data transformation, data analysis, and more.

Lavel

Beginner

Mode

Online

Fees

₹ 499 2499

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Data Analysts analyze numerical data and use it to assist businesses in making better decisions. Data Engineers are involved in data preparation. They design, build, test, and maintain the entire architecture. Bluelime Learning Solutions created the Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI online certification, which is offered by Udemy to participants who want to master the tools and techniques associated with data analysis and data engineering to become certified data engineers and data analysts.

Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI online training comprises 7 hours of prerecorded lectures accompanied by 3 articles and 10 downloadable resources which focus on teaching the functionalities of various powerful tools like SQL, Azure, Power BI, SSIS, ETL. With Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI online classes, participants will be taught about data analysis, data transformation, data extraction, data visualization, filtering data, sorting data, and much more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 7 hours of pre-recorded video content
  • 3 articles 
  • 10 downloadable resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 499  ₹2,499
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of data visualization Database management Sql knowledge Knowledge of etl mapping

After completing the Data Engineer/Data Analyst - SQL | Azure | ETL | SSIS | BI certification course, participants will obtain a thorough understanding of the principles associated with data analysis and data engineering to become professional data analysts and data engineers. In this data engineering course, participants will explore the fundamentals associated with Azure, Power BI, ETL, SQL, SSIS, Azure SQL, and Microsft SQL for data engineering and data analysis activities. In this data analysis certification, participants will also learn about various data operations like data sorting, data filtering, data visualization, data transformation, data analysis, and data extraction.

The syllabus

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

Articles

Similar Courses

My SQL Basics

Great Learning

Online
Beginner
Free

Introduction to Structured Query Language

Davidson College, Davidson via Edx

4 Weeks Online
Beginner
Free

Oracle SQL Exam Prep

LearnQuest via Coursera

3 Weeks Online
Beginner
Free
SQL for Beginners The Easiest Way to Learn SQL Ste...

SQL for Beginners The Easiest Way to Learn SQL Ste...

Udemy

Online
Beginner
₹649 ₹4,099
Ultimate MySQL Bootcamp Go from SQL Beginner to Ex...

Ultimate MySQL Bootcamp Go from SQL Beginner to Ex...

Udemy

Online
Beginner
₹649 ₹4,099
Complete SQL Bootcamp Go from Zero to Hero

Complete SQL Bootcamp Go from Zero to Hero

Udemy

Online
Beginner
₹549 ₹3,499
SQL Made Easy for Beginners

SQL Made Easy for Beginners

Udemy

Online
Beginner
₹ 2,299

Courses of your Interest

An Introduction To Coding Theory

An Introduction To Coding Theory

IIT Kanpur via Swayam

8 Weeks Online
Beginner
Free

C++ Foundation

PW Skills

5 Months Online
Beginner
Free

Advanced CFD Meshing using ANSA

Skill Lync

4 Weeks Online
Beginner
₹ 40,000

Salesforce Platform App Builder Certification Trai...

Simplilearn

12 Hours Online
Beginner

Data Science Foundations to Core Bootcamp

Springboard

7 Months Online
Beginner
$9,900 $13,900
Full Stack Developer Course With Placement

Full Stack Developer Course With Placement

AttainU

7 Months Online
Beginner
₹ 68,000
User Experience Design And Research

User Experience Design And Research

UM–Ann Arbor via Futurelearn

35 Weeks Online
Beginner
Fundamentals of Agile Project Management

Fundamentals of Agile Project Management

UCI Irvine via Futurelearn

21 Weeks Online
Beginner
Artificial intelligence Design and Engineering wit...

Artificial intelligence Design and Engineering wit...

CloudSwyft Global Systems, Inc via Futurelearn

17 Weeks Online
Beginner

More Courses by Udemy

Microsoft Excel 2013 Course Beginners Intermediate...

Udemy

Online
Beginner
₹399 ₹2,699

Python for Beginners to Advance

Udemy

Online
Beginner
₹ 2,499

Learn Python Turtle Using Block Coding

Udemy

Online
Beginner
₹399 ₹799

Master Python Basics For Developer

Udemy

Online
Beginner
₹475 ₹3,499

Programming in Python for Beginners

Udemy

Online
Beginner
₹ 799

Learn Python 3 Programming from Scratch

Udemy

Online
Beginner
₹475 ₹1,299

Automate Your Life With Python

Udemy

Online
Beginner
₹ 2,899

Learn Python Python for Beginners

Udemy

Online
Beginner
₹ 1,799

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books