0 (0 Ratings)
Power Bi SQL
Course Curriculum
Introduction to Power BI
-
Business Intelligence
00:00 -
Self Service Business Intelligence
00:00 -
SSBI Tools
00:00 -
What is Power BI
00:00 -
Why Power BI?
00:00 -
Key Benefits of Power BI
00:00 -
Flow of Power BI
00:00 -
Components of Power BI
00:00 -
Architecture of Power BI
00:00 -
Building Blocks of Power BI
00:00
Power BI Desktop
-
Overview of Power BI Desktop
00:00 -
Data Sources in Power BI Desktop
00:00 -
Connecting to a data Sources
00:00 -
Query Editor in Power BI
00:00 -
Clean and Transform your data with Query Editor
00:00 -
Combining Data – Merging and Appending
00:00 -
Cleaning irregularly formatted data
00:00 -
Views in Power BI Desktop
00:00 -
Modelling Data
00:00 -
Manage Data Relationship
00:00 -
Cross Filter Direction
00:00 -
Create calculated tables and measures
00:00 -
Optimizing Data Models
00:00
Data Analysis Expressions (DAX)
-
Essential concepts in DAX
00:00 -
Why is DAX important?
00:00 -
DAX Syntax
00:00 -
Data Types in DAX
00:00 -
Calculation Types
00:00 -
DAX Functions
00:00 -
Measures in DAX
00:00 -
DAX Operators
00:00 -
DAX tables and filtering
00:00 -
DAX queries
00:00 -
DAX Parameter Naming
00:00
Data Visualization
-
Introduction to visuals in Power BI
00:00 -
Charts in Power BI
00:00 -
Matrixes and tables
00:00 -
Slicers
00:00 -
Map Visualizations
00:00 -
Gauges and Single Number Cards
00:00 -
Modifying colors in charts and visuals
00:00 -
Shapes, text boxes, and images
00:00 -
What Are Custom Visuals?
00:00 -
Page layout and formatting
00:00 -
KPI Visuals
00:00 -
Z-Order
00:00
Introduction to Power BI Q&A and Data Insights
-
Introduction to Power BI Service
00:00 -
Dashboard vs. Reports
00:00 -
Quick Insights in Power BI
00:00 -
Creating Dashboards
00:00 -
Configuring a Dashboard
00:00 -
Power BI Q&A
00:00 -
Ask questions of your data with natural language
00:00 -
Power BI embedded
00:00
Direct Connectivity
-
Introduction to using Excel data in Power BI
00:00 -
Exploring live connections to data with Power BI
00:00 -
Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
00:00 -
Introduction to Power BI Development API
00:00 -
Import Power View and Power Pivot to Power BI
00:00 -
Power BI Publisher for Excel
00:00 -
Content packs
00:00 -
Introducing Power BI Mobile
00:00
Power BI Report Servers
-
Report Server Basics
00:00 -
Web Portal
00:00 -
Paginated Reports
00:00 -
Row level Security
00:00 -
Data Gateways
00:00 -
Scheduled Refresh
00:00 -
Resources (Rest API/ SOAP API’s/ URL Access)
00:00
Advanced Analytics in Power BI using R & Python
-
R Integration in Power BI Desktop
00:00 -
R visuals in Power BI
00:00 -
R Powered Custom Visuals
00:00 -
Creating R visuals in Power BI
00:00 -
R Visuals in Power BI Service
00:00 -
R Scripts Security
00:00 -
Creating visual using Python
00:00
SQL Server Integration Services (SSIS)
-
What is SSIS?
00:00 -
Add SSIS to a SQL Server instance
00:00 -
Connect to the SSIS catalog database
00:00 -
Explore SSIS packages
00:00 -
SSIS Designer
00:00 -
Install SQL Server Data Tools (SSDT)
00:00 -
View SSIS solutions and projects
00:00 -
Define control flow tasks
00:00 -
Create a precedence constraint
00:00 -
Create a sequence container
00:00 -
Run a package
00:00 -
Control flow task
00:00 -
Understanding tasks in control flow
00:00 -
The Data Flow task
00:00 -
The File System tasks
00:00 -
Modify file attributes
00:00 -
The Execute Package task
00:00 -
The Send Mail task
00:00 -
SQL Server tasks
00:00 -
Maintenance tasks
00:00 -
Data Sources and connections
00:00 -
Project level connections
00:00 -
Convert package connections
00:00 -
The Excel connection manager
00:00 -
Connect to flat file data sources
00:00 -
Additional connection managers
00:00 -
The Data Flow Task and Transformations
00:00 -
Data flow components
00:00 -
Extracting data from a source
00:00 -
Understand transformations
00:00 -
Character Map row transformation
00:00 -
Conditional Split transformation
00:00 -
Rowset transformations
00:00 -
Loading data to a destination
00:00 -
Prevent duplicate records
00:00 -
Controlling Package Execution
00:00 -
Work with variables and scope
00:00 -
Add execution parameters
00:00 -
Change a variable’s value
00:00 -
Group tasks in looping containers
00:00 -
Event handlers
00:00 -
Error handling in data flows
00:00 -
Deployment and Run SSIS Projects
00:00 -
Deploy projects to SQL Server
00:00 -
Run packages with T-SQL
00:00 -
Schedule packages with SQL Server Agent
00:00
Introduction to DBMS
-
File Management System And Its Drawbacks
00:00 -
Database Management System (DBMS) and Data Models
00:00 -
Physical Data Model
00:00 -
Logical Data Models
00:00 -
Conceptual Data Models
00:00
Introduction to SQL Server
-
Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
00:00 -
Connecting to Sever
00:00 -
Server Type
00:00 -
Server Name
00:00 -
Authentication Modes
00:00 -
Login and Password
00:00 -
Sql Server Management Studio and Tools In Management Studio
00:00 -
Object Explorer
00:00 -
Object Explorer Details
00:00 -
Query Editor
00:00
Transact Structured Query Language (TSQL)
-
History and Features of TSQL
00:00 -
Types Of TSQL Commands
00:00 -
Data Definition Language (DDL)
00:00 -
Data Manipulation Language (DML)
00:00 -
Data Query Language (DQL)
00:00 -
Data Control Language (DCL)
00:00 -
Transaction Control Language (TCL)
00:00 -
Database
00:00 -
Data Types in TSQL
00:00 -
Table
00:00
Data Manipulation Language (DML)
-
Insert Identity
00:00 -
Creating A Table From Another Table
00:00 -
Inserting Rows From One Table To Another
00:00 -
Update
00:00 -
Computed Columns
00:00 -
Delete
00:00 -
Truncate
00:00 -
Differences Between Delete and Truncate
00:00 -
Data Query Language (DQL)
00:00 -
Select
00:00 -
Where clause
00:00 -
Order By Clause
00:00 -
Distinct keyword
00:00 -
Isnull() function
00:00 -
Column aliases
00:00 -
Predicates
00:00 -
Between … And
00:00 -
In
00:00 -
like
00:00 -
is null
00:00
Built In Functions
-
Scalar Functions
00:00 -
Convenient Aggregate Functions
00:00 -
Statistical Aggregate Functions
00:00 -
Group By and Having Clauses
00:00 -
Super Aggregates
00:00 -
Over(partition by …) Clause
00:00 -
Ranking Functions
00:00
Set Operators
-
Union
00:00 -
Intersect
00:00 -
Except
00:00
Joins
-
Inner Join
00:00 -
Left join
00:00 -
Right join
00:00 -
Self Join
00:00 -
Equi join
00:00 -
Outer Join
00:00 -
Full Outer Join
00:00 -
Cross Join
00:00
Sub Queries
-
Single Row Sub Queries
00:00 -
Multi Row Sub Queries
00:00 -
Exists and Non-Exists
00:00
Indexes
-
Clustered Index
00:00 -
Non Clustered Index
00:00 -
Create , Alter and Drop Indexes
00:00 -
Using Indexes
00:00
Security
-
Login Creation
00:00 -
SQL Server Authenticated Login
00:00 -
Windows Server Authenticated Login
00:00 -
User Creation
00:00 -
Granting Permissions
00:00 -
Revoking Permissions
00:00 -
Roles
00:00
Views
-
Purpose Of Views
00:00 -
Creating , Altering and Dropping Indexes
00:00 -
Simple and Complex Views
00:00 -
Encryption and Schema Binding Options in creating views
00:00
Transaction Management
-
Introduction
00:00 -
Begin Transaction
00:00 -
Commit Transaction
00:00 -
Rollback Transaction
00:00 -
Save Transaction
00:00 -
Role Of Log File In Transaction Management
00:00 -
Implicit Transactions
00:00
Cursors
-
Working With Cursors
00:00 -
Types Of Cursors
00:00 -
Forward_Only and Scroll Cursors
00:00 -
Static, Dynamic and Keyset Cursors
00:00 -
Local and Global Cursors
00:00
Stored Sub Programs
-
Advantages Of Stored Sub Programs compared to Independent SQL Statements
00:00 -
Stored Procedures
00:00 -
User Defined Functions
00:00 -
Types Of User Defined Functions
00:00 -
Table Valued Functions
00:00 -
Inline Table Valued Functions
00:00 -
Multi Statement Table Valued Functions
00:00 -
Permissions On User Defined Functions
00:00
Triggers
-
Purpose of Triggers
00:00 -
Differences Between Stored Procedures and User Defined Functions and Triggers
00:00 -
Creating, Altering and Dropping Triggers
00:00 -
Magic Tables
00:00 -
Instead Of Triggers
00:00
Exception Handling
-
Implementing Exception Handling
00:00 -
Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
00:00 -
Raising Exceptions Manual
00:00
CLR Integration
-
What is CLR Integration and The Steps For Implementing It
00:00 -
A Simple Example With CLR Integration
00:00
Working with XML Data Type
Backup and Restore of Database
Attach and Detach of Database
Normalization
Hands On Projects
FAQs & Interview Preparation
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
₹19,999.00
₹30,000.00
-
LevelIntermediate
-
Duration90 hours
-
Last UpdatedOctober 21, 2024
-
CertificateCertificate of completion
Hi, Welcome back!