Brochure
Enquire- Introduction
- What is a Data Engineer
- What is a Data Analyst
- What is SQL
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 ...Read more
Beginner
Online
₹ 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
Who it is for
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
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
Popular Articles
prev
next
Latest Articles
prev
next
Similar Courses
My SQL Basics
Great Learning
Introduction to Structured Query Language
Davidson College, Davidson via Edx
Oracle SQL Exam Prep
LearnQuest via Coursera
prev
next
Courses of your Interest
C++ Foundation
PW Skills
Advanced CFD Meshing using ANSA
Skill Lync
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Fundamentals of Agile Project Management
UCI Irvine via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
prev
next
More Courses by Udemy
prev
next
