Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DigiHubs - Data Analysis Course
Course Introduction
Course Information
Course Resources
Data Analysis Intro Video (3:21)
Section 1: Introduction to SQL
Introduction to Data and its Attributes (8:27)
Data Sources and Types (9:35)
Data Tools and Data Management Systems (8:46)
Introduction to PostgreSql (4:52)
Activity
Section 2: SQL Statements
Writing SQL Statements (7:05)
Primary and Foreign Keys (6:41)
SQL Syntax Principles (2:16)
Section 3: Advanced SQL
Select, From and Where Commands (9:45)
Logical and Special Operators (7:39)
Temporary Tables (6:01)
Joins (10:27)
Unions, Group By and Order By Clauses (26:03)
SQL Wildcards (7:40)
Activity
Knowledge Check
Section 4: Introduction to Excel
Introduction to Microsoft Excel (8:10)
Data Preparation (36:56)
Section 5: Excel Syntax
Cell locking (11:15)
If Else Statement (9:00)
Vlookup, Index Match and Excel Syntax Priniciples (11:07)
Section 6: Elementary Data Visualisation
Conditional Arithmetic Procedures (11:24)
Elemetary Data Visualisation (9:05)
Final Steps
Assessment
Select, From and Where Commands
Complete and Continue