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