Home
About KFP
Courses
Explorer

Course Content

Introduction To Data Analysis (Copy 1)

0/4

Defining Data Analysis (Copy 1)

Modern Data Ecosystem (Copy 1)

Key Players in the Data Ecosystem (Copy 1)

Introduction to mastering excel for Data Analysis (Copy 1)

Managing and Analyzing Data (Copy 1)

0/2

Structure data for optimum usage (Copy 1)

Converting lists to tables (Copy 1)

Sorting Data (Copy 1)

0/7

Sorting concepts and sort menu options (Copy 1)

Sorting from menu icons (Copy 1)

Multiple-key sorting (Copy 1)

Sorting based on the order of data in custom lists (Copy 1)

Sorting by cell color, font color, or cell icon (Copy 1)

Sorting columns (sorting left-to-right) (Copy 1)

Sorting data in random order (Copy 1)

Creating Automatic Subtotals In Sorted Lists (Copy 1)

0/2

Setting up single and multiple-level subtotals (Copy 1)

Expanding and collapsing with grouping and outlining symbols (Copy 1)

Filtering Data (Copy 1)

0/6

Single and multiple-column filtering (Copy 1)

Using text filters (Copy 1)

Using date filters (Copy 1)

Using numeric filters (Copy 1)

Using the Top Ten (value or percent) option (Copy 1)

Creating custom filters (Copy 1)

Advanced Filtering (Copy 1)

0/3

Using Advanced Filter for complex OR criteria (Copy 1)

Using Advanced Filter for specialized filters (Copy 1)

Using Advanced Filter to create unique lists from repeating field data (Copy 1)

Eliminating Duplicate Data (Copy 1)

0/3

Using the Remove Duplicates command (Copy 1)

Using a specialized array formula to identify data that’s been duplicated (Copy 1)

Using an array formula to count the number of unique items in a list (Copy 1)

Master SQL for Data Analysis (Copy 1)

0/4

Exercise Files (Copy 1)

Understanding SQL (Copy 1)

How to use the Exercise files (Copy 1)

external-assets-links (Copy 1)

SQL Installation (Copy 1)

0/1

Installing on Windows (Copy 1)

SQL Overview (Copy 1)

0/6

About SQL (Copy 1)

Database Organisation (Copy 1)

The SELECT Statement (Copy 1)

Selecting Rows (Copy 1)

Counting Rows (Copy 1)

Deleting Data (Copy 1)

Fundamental Concepts (Copy 1)

0/9

Inserting Rows (Copy 1)

The NULL Value (Copy 1)

Constraining Columns (Copy 1)

Changing A Schema (Copy 1)

ID Columns (Copy 1)

Filtering Data (Copy 1)

Removing Duplicates (Copy 1)

Ordering Output (Copy 1)

Conditional Expressions (Copy 1)

Relationships (Copy 1)

0/3

Understanding JOIN (Copy 1)

Accessing Related Tables (Copy 1)

Relating Multiple Tables (Copy 1)

Strings (Copy 1)

0/5

About SQL Strings (Copy 1)

Finding The Length Of A String (Copy 1)

Selecting Part Of A String (Copy 1)

Removing Spaces (Copy 1)

Folding Case (Copy 1)

Numbers (Copy 1)

0/4

Numeric Types (Copy 1)

What Type is That Value (Copy 1)

Integer Division (Copy 1)

Rounding Numbers (Copy 1)

Date & Time (Copy 1)

0/2

Date and Times (Copy 1)

Date and Time Related Functions (Copy 1)

Aggregates (Copy 1)

0/3

What are Aggregates (Copy 1)

Using Aggregate Functions (Copy 1)

Aggregating DISTINCT Values (Copy 1)

Transactions (Copy 1)

0/3

What are Transactions (Copy 1)

Data Integrity (Copy 1)

Performance (Copy 1)

Triggers (Copy 1)

0/3

Automating Data With Triggers (Copy 1)

Preventing Updates (Copy 1)

Example Timestamps (Copy 1)

Views & Subselects (Copy 1)

0/4

Creating a Subselect (Copy 1)

Searching Within A Result Set (Copy 1)

Creating a View (Copy 1)

Creating a Joined View (Copy 1)

CRUD Applications (Copy 1)

0/3

Embedding SQL (Copy 1)

The SELECT Function (Copy 1)

INSERT, UPDATE and DELETE Functions (Copy 1)

Data Reporting and Analysis in SQL (Copy 1)

0/11

Introduction to Data Reporting and Analysis in SQL (Copy 1)

Get familiar with phpMyAdmin (Copy 1)

Understand the demo database (Copy 1)

Retrieve data with SELECT (Copy 1)

Filter results with WHERE clause (Copy 1)

Use LIKE, IN, and wildcards with WHERE (Copy 1)

Sort SQL results with ORDER BY (Copy 1)

Use string functions on your data (Copy 1)

More advanced string functions (Copy 1)

Change report headings with alias (Copy 1)

Use date functions with WHERE (Copy 1)

Grouping Your SQL Results (Copy 1)

0/4

Use GROUP BY with count (Copy 1)

Filter grouped results with HAVING (Copy 1)

De-duplicate with SELECT DISTINCT (Copy 1)

Merge rows with GROUP BY (Copy 1)

Merge Data From Multiple Tables (Copy 1)

0/8

Make your queries faster (Copy 1)

Understand SQL Indexes and keys (Copy 1)

Visualise your database (Copy 1)

Merge data across tables with JOINS (Copy 1)

Understand SQL JOINS (Copy 1)

Combine rows with SQL UNION (Copy 1)

Merge data across tables with IN (Copy 1)

Select from a selection with subqueries (Copy 1)

More Advanced SQL (Copy 1)

0/3

Use variables (Copy 1)

Use functions (Copy 1)

Use procedures (Copy 1)

Introduction to Python Programming (Copy 1)

0/7

Introduction to Python Programming (Copy 1)

Raw Descriptions (Copy 1)

Exporting (Copy 1)

Overview (Copy 1)

Text 2 (Copy 1)

Saving & Exporting (Copy 1)

Data Analysis With Python (Copy 1)

0/9

Introduction to Data Analysis with Python (Copy 1)

Working with Identifiers in Python (Copy 1)

Write Comments in python (Copy 1)

Working with strings in python (Copy 1)

Variables in Python (Copy 1)

Naming Python Variables (Copy 1)

Defining output Function (Copy 1)

Defining input Functions in Python (Copy 1)

Importing Libraries in Python (Copy 1)

Statistical Operations In Python (Copy 1)

0/7

Addition of Data points Python (Copy 1)

Comparing Strings and variables in Python (Copy 1)

Performing Logic in Python (Copy 1)

Performing Bitwise Manipulations of Data in Python (Copy 1)

Assigning Variables in Python (Copy 1)

Assigning Special Variables in Python (Copy 1)

Assigning Members in Python (Copy 1)

HANDS-ON DATA ANALYSIS PRACTICE WITH PYTHON (Copy 1)

0/10

Introduction to HandsOn Data Analysis with Python (Copy 1)

Uber Loading Dataset and Preparation (Copy 1)

Uber Analysis Of Categories Of Trips (Copy 1)

Uber Analysis Of Length Of Trips (Copy 1)

Uber Analysis Of Hot Hour Of Trips (Copy 1)

Uber Analysis Of Purpose Of Trips (Copy 1)

Uber Analysis Of Day With Highest Number Of Trips (Copy 1)

Uber Analysis Of Number Of Trips Per Day (Copy 1)

Uber Analysis Of Number Of In The Month (Copy 1)

Uber Analysis Of Starting Point Of Trips (Copy 1)

Full Stack Data Analyst A-Z BootCamp (Copy 1)

Join the conversation

0% Complete

Newsletters (not login)

This subscription is for news email update, not to access the course. Please click here to create a login account

Name*

Email*

FOLLOW US

hello@kfprojectsonline.com

WE WOULD LOVE TO HEAR FROM YOU

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

Related

Select your currency

NGN Nigerian naira

USD United States (US) dollar

Search for:

Hit enter to search or ESC to close

Home
About KFP
Courses
Explorer

Insert/edit link

Enter the destination URL

URL

Link Text

Open link in a new tab

Or link to existing content

Search

No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.