/CourseBundles(68166)/4679290-imgonline-com-ua-compressed-zfbBl9m3qwG9z1.jpg)
Course Overview
Schedule of Classes
Course Curriculum
19 Subjects
OLD_SKT_PG_Theory_Python
157 Learning Materials
Introduction to Programming Languages
Programming Language Paradigm
External Link
Imperative Programming Languages
External Link
Declarative Programming Languages
External Link
History of Programming Languages
External Link
Classification of Programming Languages
Machine Level Programming Language
External Link
Assembly Level Programming Language
External Link
High Level Programming Language
External Link
High Level Programming Languages
Introduction
External Link
FOTRAN
External Link
COBOL
External Link
ALGOL
External Link
BCPL & PASCAL
External Link
C Language
External Link
C++
External Link
JAVA
External Link
Python
External Link
Introduction to Python Programming
About Python Programming Language
External Link
History of Python
External Link
Characteristics of Python
External Link
Python Environment
Installation of Python
External Link
Compile and Running
External Link
Python Documentation
External Link
PIP
External Link
Editors & IDE's
Introduction to IDE
External Link
PyCharm
External Link
Anaconda
External Link
Spyder
External Link
Jupyter
External Link
Running Python Script
External Link
Getting Started with Python Programming
Creating your First Python Program
External Link
Reading & Printing to Screen
External Link
Interactive & Script Mode
External Link
Python File Extensions
External Link
Basic Concepts in Python
Shell as a Calculator
External Link
Comments in Python
External Link
Multiline Statements
External Link
Quotations in Python
External Link
Variables
Introduction to Variables
External Link
Naming Variables
External Link
Mnemonic Variable Names
External Link
Reserved Words
External Link
Data Types
Values & Types
External Link
Numerical Data Type
External Link
String Data Type
External Link
Working with Variables
Multiple Assignment
External Link
Swap Variables
External Link
Type Conversion
External Link
Mutable vs Immutable Objects
External Link
Number System Conversion
External Link
Operators
Arithmetic Operator
External Link
Assignment Operator
External Link
Comparison Operator
External Link
Logical Operator
External Link
Bitwise Operator
External Link
Membership Operator
External Link
Operator Precedence
External Link
Evaluating Expression
External Link
Decision Making
Introduction to Decision Making
External Link
if Statement
External Link
if...else Statement
External Link
elif Statement
External Link
Nested if...else Statement
External Link
Loops
Introduction to Loops
External Link
While Loop
External Link
For Loop
External Link
Nested Loops
External Link
Break Statement
External Link
Continue Statement
External Link
Pass Statement
External Link
Collections : List - 1
Introduction to Collections
External Link
Introduction to List
External Link
Accessing Items in a List
External Link
Loop through List
External Link
List Length & Add Items to List
External Link
Built-in List Methods
External Link
Basic List Operations
External Link
List Mutability
External Link
Collections : List - 2
Lambda Function
External Link
List with map() Function
External Link
List with filter() Function
External Link
List with reduce() Function
External Link
Difference between Strings & Lists
External Link
Collections : Tuples
Introduction to Tuple
External Link
Tuple Packing & Unpacking
External Link
Comparing Tuples & Iterating through Tuple
External Link
Deleting & Slicing of Tuples
External Link
Tuple Membership Test
External Link
Collections : Sets
Creating Set
External Link
Iteration Over Set
External Link
Python Set Methods
External Link
Set Operations
External Link
Set Built-in Functions
External Link
Frozen Set
External Link
Collections : Dictionary
Creating Dictionary
External Link
Python Hashing
External Link
Python Dictionary Methods
External Link
Copying & Updating Dictionary
External Link
Deleting & Sorting Keys in Dictionary
External Link
Summary of Dictionary Methods
External Link
String Handling - 1
Introduction to Strings
External Link
String Indices
External Link
Delete a String
External Link
String Multiplication & Concatenation
External Link
Iterating through a String
External Link
String Membership Test
External Link
String Built-in Functions
External Link
String Handling - 2
Reversing a String
External Link
Split String
External Link
Escape Sequence
External Link
String format() Method
External Link
String Methods
External Link
Functions
Introduction to Functions
External Link
Defining & Calling a Function
External Link
Working of Function
External Link
Doc Strings
External Link
Functions : Arguments & Return Statements
Default Arguments
External Link
Required Arguments
External Link
Keyword Arguments
External Link
Variable Length Arguments
External Link
Return Statement
External Link
Returning Multiple Values
External Link
Command Line Arguments
External Link
Functions : Scope of Variables
Global Variable
External Link
Local Variable & Its Comparison with Global
External Link
Functions : Recursion
Recursive Functions
External Link
Finding Sum of Natural Numbers using Recursion
External Link
Functions : Anonymous Functions
Lambda Function
External Link
Using Lambda with filter()
External Link
Using Lambda with map()
External Link
Using Lambda with reduce()
External Link
Functions : Parameter Passing Technique
Passing Immutable Objects
External Link
Passing Mutable Objects
External Link
Functions : First Class Functions
Assigning a Function to Variable
External Link
Passing a Function as Parameter
External Link
Returning Function to Function
External Link
Storing Function in Data Structures
External Link
NumPy Package
Introduction to NumPy
External Link
Installation of NumPy
External Link
Working with NumPy
External Link
Data Types in NumPy
External Link
NumPy Array Attributes
External Link
Engineering Mathematics : Basics of Matrices
Creating a Matrix
External Link
Identity Matrix
External Link
Transpose of a Matrix
External Link
Engineering Mathematics : Matrix Arithmetic Operations
Matrix Addition
External Link
Matrix Subtraction
External Link
Matrix Multiplication
External Link
Matrix Element Multiplication & Division
External Link
Engineering Mathematics : Operations on Matrices
Determinant of a Matrix
External Link
Inverse of a Matrix
External Link
Solving Linear Equations
External Link
Engineering Mathematics : Exercises on Matrices
Picking an Element from a Matrix
External Link
Interchange Diagonal Elements
External Link
Check a Matrix is Identity or Not
External Link
Matrix Arithmetic Operations
External Link
Inverse of 2X2 & 3X3 Matrix
External Link
Solving Linear Equations
External Link
OLD_SKT_Python Engg Applications
14 Learning Materials
Transpose of a Matrix without using NumPy
Introduction to Transpose of Matrix
External Link
Function to Input a Matrix : Code Explanation
External Link
Function to Input a Matrix : Code Implementation
External Link
Function to Transpose a Matrix : Code Explanation
External Link
Function to Transpose a Matrix : Code Implementation
External Link
Comparing with In-Built Function in NumPy
External Link
Determinant of Matrix without using NumPy
Manually Calculating Determinant of Matrix
External Link
Laplace Expansion to Calculate Determinant
External Link
Function to Find Determinant : Code Explanation
External Link
Function to Find Determinant : Code Implementation
External Link
Comparing with In-Built Function in NumPy
External Link
Cofactor & Minor Matrix without using NumPy
Introduction to Cofactors & Minor Matrix
External Link
Function for Cofactors & Minor Matrix : Code Explanation
External Link
Function for Cofactors & Minor Matrix : Code Implementation
External Link
SKT_DS_Theory_Anaconda Essentials
5 Learning Materials
Essential Programming Languages used for ML
Essential Programming Languages used for ML
External Link
Anaconda
Introduction to Anaconda
External Link
Installing Anaconda
External Link
Anaconda Environment
External Link
Jupyter Notebook
Jupyter Notebook
External Link
SKT_DS_Theory_Pandas
50 Learning Materials
Introduction to Pandas
Introduction to Pandas
External Link
Working with Pandas
Working with Pandas
External Link
Pandas Series-1
Introduction to Series
External Link
Creating Series from Lists
External Link
Creating Series from Dictionary
External Link
Creating Series from NumPy Array
External Link
Creating a Series from Scalar Value
External Link
Creating Series from NaN Values & Index Argument
External Link
Pandas Series-2
Working with Series Indexing
External Link
Accessing Data from Series
External Link
Accessing Data from Series using Slicing
External Link
Accessing Data from Series using loc & iloc
External Link
Series Attributes-1
External Link
Series Attributes-2
External Link
Pandas Series-3
Sorting and Converting Type of Elements in Series
External Link
Working with Null Values in Series
External Link
Summarising Series-1
External Link
Summarising Series-2
External Link
Working with Duplicate Values
External Link
Pandas Series - 4
Arithmetic Operations on Pandas Series
External Link
Comparison / Relational Operations with Pandas Series - 1
External Link
Comparison / Relational Operations with Pandas Series - 2
External Link
Comparison / Relational Operations with Pandas Series - 3
External Link
Logical Operators on Pandas Series
External Link
Manipulating Pandas Series
External Link
Pandas DataFrame - 1
Introduction to Pandas DataFrame
External Link
Creating Pandas DataFrame
External Link
DataFrame Attributes - 1
External Link
DataFrame Attributes - 2
External Link
Converting and Sorting Elements
External Link
Working with Null Values in DataFrame
External Link
Pandas DataFrame - 2
Summarising DataFrame - 1
External Link
Summarising DataFrame - 2
External Link
Working with Duplicates
External Link
Arithmetic Operations on Pandas Dataframe - 1
External Link
Arithmetic Operations on Pandas Dataframe - 2
External Link
Pandas DataFrame - 3
Comparison Operations on Pandas Dataframe - 1
External Link
Comparison Operations on Pandas Dataframe - 2
External Link
Comparison Operations on Pandas Dataframe - 3
External Link
Logical Operations on Pandas Dataframe - 1
External Link
Logical Operations on Pandas Dataframe - 2
External Link
Manipulating pandas Dataframe
External Link
Pandas DataFrame - 4
Accessing Single Column in a DataFrame
External Link
Accessing Multiple Columns
External Link
Accessing Rows in a DataFrame
External Link
Accessing Single Element in a DataFrame
External Link
Reading Data from variuos types of files
Reading & Saving CSV File
External Link
Reading & Saving Excel File
External Link
Reading & Saving JSON File
External Link
Reading Data from SQL Database
External Link
SKT_DS_Lab L1_Pandas
2 Learning Materials
Basic Level Programming on Pandas Series-1
Write a code to create a Series from a NumPy array of random numbers and Print the Series.
External Link
Create a Series with three NaN values, and specify index labels as 'A', 'B', and 'C'.
External Link
Basic Level Programming on Pandas Series-2
Basic Level Programming on Pandas Series-3
Basic Level Programming on Pandas Series - 4
Basic Level Programming on Pandas DataFrame - 1
SKT_DS_Lab L2_Pandas
2 Learning Materials
Intermediate Level Programming on Pandas Series-1
Create a Series and set custom index labels in Pandas
External Link
Create a Series with both positive and negative values and print its mean.
External Link
Intermediate Level Programming on Pandas Series-2
Intermediate Level Programming on Pandas Series-3
Intermediate Level Programming on Pandas Series - 4
Intermediate Level Programming on Pandas DataFrame - 1
SKT_DS_Lab L3_Pandas
2 Learning Materials
Advance Level Programming on Pandas Series-1
Construct a Pandas Series from dictionary {'USA': 331, 'India': 1380, 'China': 1441, 'Brazil': 213}
External Link
Python program using pandas library representing the marks of five students
External Link
Advance Level Programming on Pandas Series-2
Advance Level Programming on Pandas Series-3
Advance Level Programming on Pandas Series - 4
Advance Level Programming on Pandas DataFrame - 1
SKT_DS_Theory_Data Analasys & Vis
143 Learning Materials
About Course
Course Overview
External Link
Introduction to Data Analysis
What is Data Analysis?
External Link
Why is Data Analysis important?
External Link
Sources of Data
External Link
Sampling Techniques
External Link
Data Quality Issues
External Link
Data Management & Storage
External Link
Introduction to Data Visualization
Introduction to Data Visualization
External Link
Data Wrangling
Introduction to Data Wrangling
External Link
Subsetting a Dataset
Subsetting a Dataset
External Link
Selecting Columns
External Link
Selecting Rows
External Link
Selecting Rows & Columns
External Link
Slicing Columns
External Link
Slicing Rows
External Link
Slicing Rows & Columns
External Link
Indexing
External Link
Filtering
External Link
Combining and Merging Data Sets
Database-Style Merging Datasets
External Link
Merging on Index - Outer
External Link
Merging on Index - Left
External Link
Merging on Index - Right
External Link
Concatenating Along an Axis
External Link
Combining Data with Overlap
External Link
Reshaping
Reshaping
External Link
Data Transformation
Introduction for Data Transformation
External Link
Removing Duplicates & Replacing Values
External Link
Transforming Data Using a Function or Mapping
External Link
Renaming Axis Indexes
External Link
Data Discretization
External Link
String Manipulation
String Manipulation
External Link
Group By Operations
Introduction to Group By
External Link
Exploring get_group
External Link
Group by Syntax & Iterating Over Groups
External Link
Grouping with Dicts and Series
External Link
Grouping with Functions
External Link
Grouping By Index Levels
External Link
Data Aggregation
Introduction to Data Aggregation
External Link
Syntax of Data Aggregation
External Link
Column-wise and Multiple Function
External Link
Returning Aggregated Data in "Unindexed" Form
External Link
Group-wise Operations and Transformations
Apply: General split-apply-combine
External Link
Quantile & Bucket Analysis
External Link
Filling Missing Values with Group-specific Values
External Link
Random Sampling & Permutation
External Link
Random Sampling & Permutation using Group By
External Link
Group Weighted Average and Correlation
External Link
Pivot Tables and Cross-Tabulation
Pivot Table
External Link
Cross Tabulation
External Link
Data Preparation & Basic Models
Data Preparation
External Link
Advanced Data Transformation Techniques
Linear Transformation
External Link
Quadratic Transformation
External Link
Non-polynomial Transformation
External Link
Polynomial Transformation
External Link
Rank Transformation
External Link
Box-Cox Transformation
External Link
Histogram
External Link
Missing Values
Introduction to Data Cleaning
External Link
Introduction to Missing Values
External Link
Removing Missing Values
External Link
Mean Imputation
External Link
Median Imputation
External Link
Mode Imputation
External Link
Forward Fill Imputation
External Link
Backward Fill Imputation
External Link
Dealing with Noisy Data
Noisy Data
External Link
Types of Noise Data
External Link
Introduction to Noise Filtering
External Link
Noise Filtering at Data Level
External Link
Enhancing Data Analysis Strategies Against Noise
External Link
Introduction to Outliers
Introduction to Outliers
External Link
Detecting & Handling Outliers
Detecting outliers using Boxplot and IQR
External Link
Detecting outliers using the Z-scores
External Link
Detecting outliers using the percentile method
External Link
Detecting outliers using Standard Deviation method
External Link
Handling Categorical Data
Introduction to Categorical Data
External Link
Categorical Encoding
External Link
One Hot Encoding
External Link
Label Encoding
External Link
Ordinal Encoding
External Link
Helmert Encoding
External Link
Binary Encoding
External Link
Frequency Encoding
External Link
Mean Encoding
External Link
Weight of Evidence Encoding
External Link
Probability Ratio Encoding
External Link
Hashing Encoding
External Link
Backward Difference Encoding
External Link
Leave One Out Encoding
External Link
James Stein Encoding
External Link
M-estimator Encoding
External Link
Thermometer Encoder
External Link
Which Encoding is best?
External Link
Handling Numerical Data
Introduction to Numerical Data
External Link
Introduction to Feature Scaling
External Link
Min- Max Scaling
External Link
Standardization
External Link
Robust Scaling
External Link
Max Abs Scaler
External Link
Exploratory Data Analysis
Introduction to Exploratory Data Analysis
External Link
Intoduction to Univariate Analysis
External Link
Bar Plot for Univariate
External Link
Pie Chart for Univariate
External Link
Count Plot for Univariate
External Link
Histogram for Univariate
External Link
Box PLot for Univariate
External Link
Density Plot for Univariate
External Link
Line Plot for Univariate
External Link
Intoduction to Bivariate Analysis
External Link
Scatter Plot
External Link
Line Plot
External Link
Joint Plot
External Link
Heatmap
External Link
Stacked Bar Plot
External Link
Grouped Bar Plot
External Link
Clustered Heatmap
External Link
Chi-Square Test
External Link
Bar Plot
External Link
Box Plot
External Link
Violin Plot
External Link
Point Plot
External Link
Swarm Plot
External Link
Introduction to Multivariate Analysis
External Link
Heat Map for Multivariate
External Link
Pair plot
External Link
Feature Engineering
Introduction to Feature Engineering
External Link
Feature Selection Techniques & Criteria
External Link
Filter Feature Selection
External Link
Wrapper Feature Selection
External Link
Embedded Feature Selection
External Link
Implications of Feature Selection Methods
External Link
Representative Feature Selection Methods
External Link
Leading and Recent Feature Selection Techniques
External Link
Feature Extraction
External Link
Feature Construction
External Link
Experimental Comparative Analyses in Feature Selection
External Link
Handling Imbalance Data
Introduction to Handle Imbalance Data
External Link
Choose Proper Evaluation Metric
External Link
Resampling
External Link
SMOTE
External Link
Balanced Bagging Classifier
External Link
Threshold moving
External Link
Augmentation
External Link
SKT_DS_Lab L1_Data Analasys & Vis
4 Learning Materials
Basic Level Programming on Subsetting a Dataset
Generate the sample DataFrame and then choose any one of the Columns. Display its contents
External Link
Creating and displaying Data. choose any one of the Row. Display its contents
External Link
Basic Level Programming on Group By Operations
Group the DataFrame by a column and apply multiple aggregation functions
External Link
Group the numbers in the num column they are even or odd and calculate the sum of each group data
External Link
Basic Level Programming on Data Aggregation
Basic Level Programming on Group-wise Operations and Transformations
Basic Level Programming on Pivot Tables and Cross-Tabulation
SKT_DS_Lab L2_Data Analasys & Vis
2 Learning Materials
Intermediate Level Programming on Subsetting a Dataset
Construct a Sample DataFrame use the Slicing feature all columns whose names start with an ‘S’
External Link
Intermediate Level Programming on Group By Operations
Given a list of dictionaries representing customers average order total for each city
External Link
Intermediate Level Programming on Data Aggregation
Intermediate Level Programming on Group-wise Operations and Transformations
Intermediate Level Programming on Pivot Tables and Cross-Tabulation
SKT_DS_Lab L3_Data Analasys & Vis
3 Learning Materials
Advance Level Programming on Subsetting a Dataset
Write a Python Program to import any CSV file to Pandas DataFrame
External Link
Advance Level Programming on Group By Operations
Load, explore a dataset , perform groupby() operations using pandas library and visualise data
External Link
list of dictionaries representing employees group using Sorting higher salaries and longer.
External Link
Advance Level Programming on Data Aggregation
Advance Level Programming on Group-wise Operations and Transformations
Advance Level Programming on Pivot Tables and Cross-Tabulation
SKT_DS_Theory_Mataplotlib
34 Learning Materials
Introduction to Data Visualisation
Introduction to Data Visualisation
External Link
Matplotlib Architecture
Matplotlib Architecture
External Link
Working with Matplotlib
Working with Matplotlib
External Link
Decorators and Styles-1
Grids
External Link
Axes
External Link
Labels
External Link
Markers
External Link
Colors
External Link
Title
External Link
Decorators and Styles-2
Legends
External Link
Ticks
External Link
Font Styles
External Link
Limits
External Link
Decorators and Styles on the Bar Graph
External Link
Different Types of Plots-1
Single Line Plot
External Link
Multi-Line Plot
External Link
Scatter Plot
External Link
Stack Plot
External Link
Stream Plot
External Link
Different Types of Plots-2
Sub-Plot
External Link
Step Plot
External Link
Filled Plot
External Link
Hexagonal Bin Plot
External Link
Different Types of Plots-3
Box Plot
External Link
Violin Plot
External Link
Different Types of Graphs
Bar Graph
External Link
Multi Bar Graph
External Link
Stacked Bar Graph
External Link
Different Types of Charts
Different Types of Charts
External Link
Pie Chart
External Link
Bubble Chart
External Link
Polar Chart
External Link
Histograms and Contours
Histogram
External Link
Contour Plot
External Link
SKT_DS_Theory_Seaborn
34 Learning Materials
Getting Started
Introduction to Seaborn
External Link
Prerequisites & Dependencies
External Link
Installation of Seaborn
External Link
Basics of Seaborn Plotting
Introduction to Plots
External Link
Decorators and Styles - 1
External Link
Decorators and Styles - 2
External Link
Seaborn Figure Styles - 1
External Link
Seaborn Figure Styles - 2
External Link
Seaborn – Color Palettes
External Link
Seaborn Grids
External Link
Relational Plots
Line Plot()
External Link
Scatter Plot()
External Link
Rel Plot()
External Link
Distributions Plots
Histplot()
External Link
KDEplot()
External Link
ECDFplot()
External Link
Rugplot()
External Link
Displot()
External Link
Pairplot()
External Link
Categorical Scatter Plots
Stripplot()
External Link
Swarmplot()
External Link
Categorical Distribution Plots
Boxplot()
External Link
Violinplot()
External Link
Boxenplot()
External Link
Categorical Estimate Plots
Pointplot()
External Link
Barplot()
External Link
Countplot()
External Link
Catplot()
External Link
Statistical Estimations
Error bars
External Link
Estimating Regression Fits
External Link
Multi-Plot Grids
External Link
Advanced Seaborn
Plotting Univariate Distributions
External Link
Plotting Bivariate Distributions
External Link
Seaborn Python Case Study
Data Visualization Using Seaborn on Census Dataset
External Link
SKT_DS_Lab L1_Seaborn
3 Learning Materials
Basic Level Programming on Basics of Seaborn Plotting
Write a program to add titles and labels to a Seaborn plot?
External Link
Write a program to modify line styles and colors in Seaborn plot?
External Link
Write a program to customize legends and markers in Seaborn plots?
External Link
Basic Level Programming on Relational Plots
Basic Level Programming on Distributions Plots
Basic Level Programming on Categorical Scatter Plots
Basic Level Programming on Categorical Distribution Plots
SKT_DS_Lab L2_Seaborn
3 Learning Materials
Intermediate Level Programming on Basics of Seaborn Plotting
Write a program to use multiple line styles in one Seaborn plot?
External Link
Write a program to apply dark theme to a seaborn plot?
External Link
Intermediate Level Programming on Relational Plots
Write a program to create a grouped scatter plot using Seaborn
External Link
Intermediate Level Programming on Distributions Plots
Intermediate Level Programming on Categorical Scatter Plots
Intermediate Level Programming on Categorical Distribution Plots
SKT_DS_Lab L3_Seaborn
3 Learning Materials
Advance Level Programming on Basics of Seaborn Plotting
Write a program to customize and save figures in high resolution in Seaborn?
External Link
Write a program to customize a Seaborn plot with grids, axis labels and markers?
External Link
Advance Level Programming on Relational Plots
Write a program to create a heatmap overlay for a relational plot in Seaborn?
External Link
Advance Level Programming on Distributions Plots
Advance Level Programming on Categorical Scatter Plots
Advance Level Programming on Categorical Distribution Plots
SKT_DS_Theory_Plotly
14 Learning Materials
Introduction to plotly
Introduction to Plotly
External Link
History and Evolution of Plotly
External Link
Basic plot using plotly
Basic charts
External Link
Chart Customization & Interactivity
Styling plotly
External Link
Customize a plot using plotly
External Link
Basic 2D Charts
Line Charts
External Link
Scatter Plots
External Link
Basic Bar Charts
External Link
Grouped Bar Charts
External Link
Stacked Bar Charts
External Link
Pie chart
External Link
Area Charts
External Link
Box Plot
External Link
Notched Boxplot
External Link
SKT_DS_Theory_SQL for Data Science
52 Learning Materials
Introduction to Databases & RDBMS
Understanding Databases
External Link
Database Management System
External Link
Relational Database
External Link
Non- Relational Database
External Link
History
External Link
Installing SQL
Setting Up MySQL Environment
External Link
Database Processing Paradigms
OLAP vs. OLTP
External Link
Introduction to SQL
SQL Fundamentals and Introduction
External Link
SQL Syntax & Basic Queries
SQL Syntax & Basic Queries
External Link
SQL Data Types
Introduction to Data Types
External Link
Numeric Data Types
External Link
String Data Type
External Link
Date and Time Data Type
External Link
Binary Data Type
External Link
Miscellaneous Data Type
External Link
SQL Operators
Introduction to Operators
External Link
Arithmetic Operators
External Link
Comparison operators
External Link
Logical operators
External Link
Bitwise Operators
External Link
Compound Operators
External Link
String Operators
External Link
Set Operators
External Link
SQL Basics and Language Components
SQL Commands
External Link
Data Definition Language Commands
CREATE Database
External Link
USE Database
External Link
DROP Database
External Link
ALTER Database
External Link
CREATE Table
External Link
RENAME Table
External Link
DROP Table
External Link
TRUNCATE Table
External Link
Data Manipulation Language Commands
Retrieving data from a table
External Link
Inserting data into a table
External Link
Updating existing data into a table
External Link
Deleting all records from a table
External Link
Data Query Language Commands
Introduction to Clauses
External Link
FROM Clause
External Link
WHERE Clause
External Link
WITH Clause
External Link
ORDER BY Clause
External Link
LIMIT Clause
External Link
SQL Functions
Introduction to MYSQL Functions
External Link
Numeric Functions
External Link
String Functions
External Link
Date Time Functions
External Link
Conversion Functions
External Link
User Defined Functions
External Link
SQL GROUP BY , HAVING & Aggregate Functions
SQL Aggregation
External Link
SQL Grouping - GROUP BY
External Link
SQL Grouping - HAVING
External Link
SQL Indexes
Creating Indexes
External Link
SKT_DS_Theory_Power BI
32 Learning Materials
Introduction to Power BI
Introduction to Business Intelligence
External Link
Introduction to Power BI
External Link
History of Power BI
External Link
Comparison of Power BI Version
External Link
Introduction to Building Blocks
External Link
Working with Power BI
Working with Power BI
External Link
Power Pivot and Data Sources
Power Pivot and Data Sources
External Link
Power Query for Data Transformation
Introduction to Power Query
External Link
Transformations
External Link
Data Transformations and Calculations
External Link
DAX
DAX
External Link
Basics of Data Modeling
External Link
Creating Calculated Columns (Basics)
External Link
DAX Time Intelligence
External Link
DAX Table Functions
External Link
Working with Filter Context (FILTER and ALL)
External Link
Overriding Filter Context
External Link
Semi-Additive Measures
External Link
Nested Row Context
External Link
Error Handling
External Link
Building PivotTables on Power Pivot
Creating Tabels And Matrices
External Link
Building Pivot Tables on Top of Power Pivot Tables
External Link
Using Pivot Charts
External Link
Introduction Power View
Introduction to Power View
External Link
Authoring Power View reports
From table to chart
External Link
Working with bubble charts
External Link
Slicers, cards and multiples
External Link
Adding maps to Power View
External Link
Working with multi-view reports
External Link
Improving Power Pivot models for Power View reporting
External Link
Deploying Power View reports
Saving Power View reports in document libraries
External Link
Power Pivot Gallery functionality
External Link
Course Instructor
TBOCWWB
137 Courses • 108145 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy