Course Content
Introduction To Data Analysis
0/4
Defining Data Analysis
04:42
Modern Data Ecosystem
03:49
Key Players in the Data Ecosystem
04:37
Introduction to mastering excel for Data Analysis
00:38
Managing and Analyzing Data
0/2
Structure data for optimum usage
12:01
Converting lists to tables
12:01
Sorting Data
0/7
Sorting concepts and sort menu options
11:04
Sorting from menu icons
07:07
Multiple-key sorting
05:15
Sorting based on the order of data in custom lists
06:12
Sorting by cell color, font color, or cell icon
04:57
Sorting columns (sorting left-to-right)
02:24
Sorting data in random order
02:19
Creating Automatic Subtotals In Sorted Lists
0/2
Setting up single and multiple-level subtotals
04:55
Expanding and collapsing with grouping and outlining symbols
07:00
Filtering Data
0/6
Single and multiple-column filtering
05:19
Using text filters
03:07
Using date filters
04:00
Using numeric filters
03:20
Using the Top Ten (value or percent) option
04:17
Creating custom filters
03:36
Advanced Filtering
0/3
Using Advanced Filter for complex OR criteria
09:10
Using Advanced Filter for specialized filters
05:42
Using Advanced Filter to create unique lists from repeating field data
04:15
Eliminating Duplicate Data
0/3
Using the Remove Duplicates command
03:01
Using a specialized array formula to identify data that’s been duplicated
05:12
Using an array formula to count the number of unique items in a list
06:36
Master SQL for Data Analysis
0/4
Exercise Files
Understanding SQL
01:06
How to use the Exercise files
01:01
external-assets-links
SQL Installation
0/1
Installing on Windows
06:49
SQL Overview
0/6
About SQL
03:52
Database Organisation
02:49
The SELECT Statement
05:26
Selecting Rows
02:56
Counting Rows
02:02
Deleting Data
01:10
Fundamental Concepts
0/9
Inserting Rows
03:21
The NULL Value
06:29
Constraining Columns
04:38
Changing A Schema
02:30
ID Columns
03:17
Filtering Data
07:24
Removing Duplicates
03:07
Ordering Output
03:01
Conditional Expressions
02:29
Relationships
0/3
Understanding JOIN
02:17
Accessing Related Tables
06:49
Relating Multiple Tables
05:24
Strings
0/5
About SQL Strings
01:38
Finding The Length Of A String
01:59
Selecting Part Of A String
03:46
Removing Spaces
01:32
Folding Case
02:17
Numbers
0/4
Numeric Types
02:59
What Type is That Value
02:15
Integer Division
02:05
Rounding Numbers
02:17
Date & Time
0/2
Date and Times
02:06
Date and Time Related Functions
02:15
Aggregates
0/3
What are Aggregates
05:03
Using Aggregate Functions
01:30
Aggregating DISTINCT Values
01:41
Transactions
0/3
What are Transactions
02:01
Data Integrity
04:07
Performance
02:40
Triggers
0/3
Automating Data With Triggers
04:08
Preventing Updates
03:44
Example Timestamps
03:15
Views & Subselects
0/4
Creating a Subselect
03:19
Searching Within A Result Set
02:59
Creating a View
02:19
Creating a Joined View
02:56
CRUD Applications
0/3
Embedding SQL
05:16
The SELECT Function
05:49
INSERT, UPDATE and DELETE Functions
03:41
Data Reporting and Analysis in SQL
0/11
Introduction to Data Reporting and Analysis in SQL
00:37
Get familiar with phpMyAdmin
03:43
Understand the demo database
01:33
Retrieve data with SELECT
05:30
Filter results with WHERE clause
05:04
Use LIKE, IN, and wildcards with WHERE
05:39
Sort SQL results with ORDER BY
01:41
Use string functions on your data
06:41
More advanced string functions
08:34
Change report headings with alias
02:27
Use date functions with WHERE
08:49
Grouping Your SQL Results
0/4
Use GROUP BY with count
05:46
Filter grouped results with HAVING
04:31
De-duplicate with SELECT DISTINCT
06:30
Merge rows with GROUP BY
02:24
Merge Data From Multiple Tables
0/8
Make your queries faster
01:47
Understand SQL Indexes and keys
07:15
Visualise your database
07:59
Merge data across tables with JOINS
05:02
Understand SQL JOINS
04:16
Combine rows with SQL UNION
04:48
Merge data across tables with IN
02:10
Select from a selection with subqueries
02:55
More Advanced SQL
0/3
Use variables
05:17
Use functions
08:03
Use procedures
06:00
Introduction to Python Programming
0/7
Introduction to Python Programming
04:11
Raw Descriptions
05:00
Text
02:51
Exporting
03:24
Overview
04:48
Text 2
04:49
Saving & Exporting
03:00
Data Analysis With Python
0/9
Introduction to Data Analysis with Python
01:01
Working with Identifiers in Python
12:54
Write Comments in python
07:09
Working with strings in python
03:25
Variables in Python
09:04
Naming Python Variables
07:40
Defining output Function
02:30
Defining input Functions in Python
07:57
Importing Libraries in Python
04:53
Statistical Operations In Python
0/7
Addition of Data points Python
02:13
Comparing Strings and variables in Python
01:53
Performing Logic in Python
07:39
Performing Bitwise Manipulations of Data in Python
07:51
Assigning Variables in Python
03:34
Assigning Special Variables in Python
02:00
Assigning Members in Python
02:52
HANDS-ON DATA ANALYSIS PRACTICE WITH PYTHON
0/10
Introduction to HandsOn Data Analysis with Python
00:50
Uber Loading Dataset and Preparation
21:31
Uber Analysis Of Categories Of Trips
02:14
Uber Analysis Of Length Of Trips
01:33
Uber Analysis Of Hot Hour Of Trips
04:33
Uber Analysis Of Purpose Of Trips
04:56
Uber Analysis Of Day With Highest Number Of Trips
01:43
Uber Analysis Of Number Of Trips Per Day
01:54
Uber Analysis Of Number Of In The Month
01:36
Uber Analysis Of Starting Point Of Trips
03:34
Full Stack Data Analyst A-Z BootCamp
Previous
Next
0% Complete

FOLLOW US ON

@kfprojectsonline

hello@kfprojectsonline.com

WE WOULD LOVE TO HEAR FROM YOU

KF Projects Info-Tech -- Copyright © 2023 - All Rights Reserved

Select your currency
NGN Nigerian naira
USD United States (US) dollar

Hit enter to search or ESC to close