Course Content
Introduction To Data Analysis
Managing and Analyzing Data
-
Structure data for optimum usage
12:01 -
Converting lists to tables
12:01
Sorting Data
-
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
-
Setting up single and multiple-level subtotals
04:55 -
Expanding and collapsing with grouping and outlining symbols
07:00
Filtering Data
-
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
-
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
-
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
-
Exercise Files
-
Understanding SQL
01:06 -
How to use the Exercise files
01:01 -
external-assets-links
SQL Installation
-
Installing on Windows
06:49
SQL Overview
-
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
-
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
-
Understanding JOIN
02:17 -
Accessing Related Tables
06:49 -
Relating Multiple Tables
05:24
Strings
-
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
-
Numeric Types
02:59 -
What Type is That Value
02:15 -
Integer Division
02:05 -
Rounding Numbers
02:17
Date & Time
-
Date and Times
02:06 -
Date and Time Related Functions
02:15
Aggregates
-
What are Aggregates
05:03 -
Using Aggregate Functions
01:30 -
Aggregating DISTINCT Values
01:41
Transactions
-
What are Transactions
02:01 -
Data Integrity
04:07 -
Performance
02:40
Triggers
-
Automating Data With Triggers
04:08 -
Preventing Updates
03:44 -
Example Timestamps
03:15
Views & Subselects
-
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
-
Embedding SQL
05:16 -
The SELECT Function
05:49 -
INSERT, UPDATE and DELETE Functions
03:41
Data Reporting and Analysis in SQL
-
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
-
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
-
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
-
Use variables
05:17 -
Use functions
08:03 -
Use procedures
06:00
Introduction to Python Programming
-
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
-
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
-
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
-
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
Student Ratings & Reviews
No Review Yet