Free Data Science Foundations Bootcamp | Zindua School
FREE Data Science Foundations Course
Get started with the foundations of Data Science by learning SQL and Excel for Data Science.
Program Curriculum
4-6 Week Bootcamp in SQL and Spreadsheets(Excel)
-
-
2
-
Windows Installation
-
MAC OS installation
-
Introduction
-
Databases Introduction
-
Tables and Keys
-
SQL Basics
-
3
-
Creating Tables - SQL - Tutorial 6
-
Inserting Data - SQL - Tutorial 7
-
Constraints - SQL - Tutorial 8
-
Update Delete SQL Tutorial 9
-
Basic Queries SQL Tutorial 10
-
Quiz 1
-
Company Database Intro SQL Tutorial 11
-
Creating Company Database SQL Tutorial 12
-
More Basic Queries SQL Tutorial 13
-
Functions SQL Tutorial 14
-
WIldcards SQL Tutorial 15
-
Union SQL Tutorial 16
-
Joins SQL Tutorial 17
-
Quiz 2
-
Nested Queries SQL Tutorial 18
-
On Delete SQL Tutorial 19
-
SQL PROJECT 1
-
Triggers SQL Tutorial 20
-
ER Diagrams Intro SQL Tutorial 21
-
Designing an ER Diagram SQL Tutorial 22
-
Converting ER Diagrams to Schemas SQL Tutorial 23
-
Quiz 3
-
SQL PROJECT 2
-
4
-
Getting Started with MySQL
-
Creating our Database and Table
-
Quiz 4
-
Populating our Database and Table
-
Selecting and Getting Data
-
Query Conditions with WHERE and Wildcards
-
Updating Entries and Limiting Queries
-
Ordering our Queries and Results
-
Deleting Entries and Dropping Tables
-
Quiz 5
-
5
-
The Beginners Guide to Excel
-
Excel Intermediate tricks , navigation and tips
-
Freeze Panes
-
Find and Replace
-
Auto Fill Handle
-
Flash Fill
-
Excel Number Formats
-
6
-
Beginners Guide to Functions and formulas
-
SUM IFs
-
Statistical Functions in Excel
-
Excel Financial Functions
-
7
-
Conditional Formatting In-depth
-
Excel Relative and Absolute Cell Referencing
-
Excel Index and Match
-
Excel V Look Ups- Basics
-
Excel H- Look Ups
-
8
-
Excel - Dealing with Duplicates
-
Unique Data
-
Excel Conditional Formatting In-depth
-
Excel Common Errors
-
Excel Common Errors Part 2
-
Excel Filtering
-
Excel Advanced Filtering
-
9
-
Simple Charts
-
Intro to Dashboards
-
Excel Intermediate Dashboards
-
Excel Quick and Simple Charts Tutorial
-
10
-
Pivot Tables
-
Advanced Excel Recommnended Pivot Tables
-
11
-
What if Analysis
-
Goal Seek
-
12
-
Excel WhatIf Analysis with Scenario Manager and Goal Seek
-
MS Excel - Advanced Filters
-
Advanced Excel - Creating Pivot Tables in Excel
-
MS Excel - Filtering Data
-
Fixing Common Excel Errors - Part 2_ NULL, NUM & #####
-
Fixing Common Excel Errors - Part 1_ DIV_0, N_A, & NAME_
-
Beginner's Guide to Excel Dashboards
-
Intermediate Guide to Excel Dashboards
-
Advanced Excel - Using _Recommended Pivot Tables_
Join our Data Science Foundations Course.