Brochure
Join- Introduction
- What is a Data Engineer
- What is a Data Analyst
- What is SQL
Beginner
Online
₹ 3,499
Quick facts
| particular | details | |
|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 3,499
certificate availability
Yes
certificate providing authority
Udemy
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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 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
- 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
Similar Courses
Courses of your interest
How to Buy Cloud Strategies for Cloud Procurement
Amazon Web Services via Edx
Introduction to NoSQL Databases
IBM via Coursera
Big Data and Language 1
Korea Advanced Institute of Scie... via Coursera
Linux Getting Started
GreyCampus
Data Engineering and Machine Learning using Spark
IBM via Coursera
Understanding Your Google Cloud Costs
Google via Coursera
Developing a Google Site Reliability Engineering C...
Google via Coursera
Deploying SAP on Google Cloud
Google via Coursera
How Google does Machine Learning
Google via Coursera
Innovating with Data and Google Cloud
Google via Coursera
