dots bg

DS3A

Course Instructor: OdinSchool

FREE

To enroll in this course, please contact the Admin
Contact Admin
dots bg

Course Overview

Schedule of Classes

Start Date & End Date

Oct 24 2023 - Oct 24 2025

Course Curriculum

1 Subject

DS3A

38 Exercises • 216 Learning Materials

Live Session Recordings

DS3AA - All Live Session Recordings

External Link

DS3AB - All Live Session Recordings

External Link

DS3AD - All Live Session Recordings

External Link

SQL Mindmap

SQL Mindmap

External Link

Starter Checklist

LMS Walkthrough

First Step-Self Introduction Video

Student Intro Video

Exercise

Statement of purpose

Exercise

Survey on Behavioural Skills

SQL (Week 1) - 29th Oct, 2023

Agenda

Module Notes

PDF

Slide Deck

Class work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

MySQL Workbench Installation for Windows

MYSQL Workbench Installation For MAC

Importing SQL files in Workbench

Week 1 - E-Learning Content

Introduction to SQL

Introduction to SQL - Knowledge Check

Exercise

Create Database

Create Database - Knowledge Check

Exercise

Insert

Insert - Knowledge Check

Exercise

Alter

Alter - Knowledge Check

Exercise

Select

Select - Knowledge Check

Exercise
FREE

SQL (Week 2) - 4th & 5th Nov, 2023

Agenda

Slide Deck - Week 2 Day 1

PDF

Slide Deck - Week 2 - Day 2

PDF

Dataset for Class work Tasks

ZIP

Class work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

DS3AD - In-class Instructor files

ZIP

DS3AD - In-class Instructor files day 2

ZIP

DS3AB -In Class Instructor files - Day 2

ZIP

Week 2 - E - Learning Content

String Functions

String Functions - Knowledge Check

Exercise

Numeric and Temporal functions

Numeric and Temporal functions - Knowledge Check

Exercise

SQL functions- Order by, Limit

SQL functions- Order by, Limit - Knowledge Check

Exercise

Like (wildcards)

Like (wildcards) - Knowledge Check

Exercise

SQL Joins

SQL Joins - Knowledge Check

Exercise

Inner Join

Inner Join - Knowledge Check

Exercise

Full outer join

Full Outer Join - Knowledge Check

Exercise

Left Outer Join

Left Outer Join - Knowledge Check

Exercise

Right Outer Join

Right Outer Join - Knowledge Check

Exercise

Union

Union - Knowledge Check

Exercise

SQL (Week 3) - 11th & 12th Nov, 2023

Agenda

Slide Deck - Week - 3 - Day 1

PDF

Slide Deck - Week - 3 - Day 2

PDF

Dataset for Class work Tasks

ZIP

Class work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

Week 3 - E- Learning Content

Aggregate functions in SQL

Aggregate functions in SQL - Knowledge Check

Exercise

Group By

Group By - Knowledge Check

Exercise

Having

Having - Knowledge Check

Exercise

Case Statement

Case Statement - Knowledge Check

Exercise

SQL (Week 4) - 18th & 19th Nov, 2023

Agenda

Slide Deck - Day 1

PDF

Slide Deck - Day 2

PDF

Class work Task Solutions

ZIP

Dataset for Class work tasks

ZIP

Assignment Solution File

Practice Test

Exercise

DS3AA - In-class Instructor files day 2

ZIP

Week 4 - Doubts clarification - In-class files

ZIP

SQL (Week 5) - 25th & 26th Nov, 2023

Agenda

Slide Deck - Day 1

PDF

Slide Deck - Day 2

PDF

Dataset for Class work tasks

ZIP

Class work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

Practice - CT Solutions

ZIP

DS3AA - In-class Instructor files

ZIP

Week 5 - Doubts clarification - In-class files

ZIP

How to submit your projects? - Tutorial

SQL Mandatory Project Solution

SQL Mandatory Project Solution

ZIP

SQL Guided Project Solution

SQL Guided Project Solution

ZIP

SQL - Module End Test

SQL - Practice Test

External Link

SQL - Module End Test

External Link

SQL Module End Test Solution

Python (Week 1) - 2nd & 3rd Dec, 2023

Agenda

Module Notes

ZIP

Slide Deck - Week 1 - Day 1

PDF

Slide Deck - Week 1 - Day 2

PDF

Class Work - Task Solutions

ZIP

Assignment Solution File

ZIP

Practice Test

Exercise

DS3AD - Python Week 1 - In Class Instructor File

ZIP

DS3A - Doubts Clarification Session - In-class Instructor file

ZIP

How to read a file in Jupyter Notebook

How to read a file in Google Colab

Anaconda Installation

Python (Week 2) - 9th & 10th Dec, 2023

Agenda

Slide Deck - Week 2 - Day 1

PDF

Slide Deck - Week 2 - Day 2

PDF

Class Work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

In-class Instructor files - Week 2 - Day 1

ZIP

In-class Instructor files - Week 2 - Day 2

ZIP

Doubts Clarification In-class Instructor files

ZIP

Python (Week 3) - 16th & 17th Dec, 2023

Agenda

Slide Deck - Week 3 - Day 1

PDF

Slide Deck - Week 3 - Day 2

PDF

Class work Task Solutions

ZIP

Assignment Solution File

Practice Test

Exercise

In-class Instructor files - Week 3 - Day 1

ZIP

In-class Instructor files - Week 3 - Day 2

ZIP

Doubts Clarification Session - In-class Instructor files

ZIP

Python (Week 4) - 23rd & 24th Dec, 2023

Agenda

Slide Deck - Week 4 - Day 1

PDF

Slide Deck - Week 4 - Day 2

PDF

Class Work Task Solutions

ZIP

Assignment Solution File

ZIP

Practice Test

Exercise

In-class Instructor files - Week 4 - Day 1

ZIP

In-class Instructor files - Week 4 - Day 2

ZIP

In Class Instructor File

ZIP

Python (Week 5) - 30th & 31st Dec, 2023

Agenda

Slide Deck - Week 5 - Day 1

PDF

Slide Deck - Week 5 - Day 2

PDF

Class Work Task Solutions

ZIP

Assignment Solution File

ZIP

Practice Test

Exercise

In-class Instructor files - Week 5 - Day 1

ZIP

In-class Instructor files - Week 5 - Day 2

ZIP

In-class Instructor files - Week 5 - Day 1 & 2

ZIP

Doubts Clarification In-class Instructor files

ZIP

In Class Instructor File

ZIP

Python Mandatory Project Solution

Python Mandatory Project Solution

ZIP

Python - Module End Test

Python - Module End Test

External Link

Python - Module End Test - Solution File

Mini Capstone Project Presentation - 6th and 21st Jan, 2024

PyCharm Installation

Mini Capstone Project

Mini Capstone Project - Submission

Assignment

Mini Capstone Dataset

ZIP

Applied Statistics With EDA (Week 1) - 27th & 28th Jan,2024

Agenda

Module Notes

PDF

Slide deck - Week 1 Day 1

PDF

Slide deck - Week 1 Day 2

PDF

Class work Task solution

ZIP

Assignment Solution File

Practice Test

Exercise

In-class Instructor files - Day 1

DOC

In-class Instructor files - Day 2

DOC

Applied Statistics with EDA - Live Session - Recordings - Week 1 - Day 1

Applied Statistics with EDA - Live Session - Recordings - Week 1 - Day 2

Applied Statistics With EDA (Week 2) - 03rd & 04th Feb,2024

Agenda

Slide deck - Week 2 Day 1

PDF

Slide deck - Week 2 Day 2

PDF

Class work Task Solutions

ZIP

Assignment Solution File

ZIP

Practice Test

Exercise

Mandatory Project

In-class Instructor files - Day 1

ZIP

In-class Instructor files - Day 1

ZIP

In-Class Instructor File - Day 2

ZIP

In-class Instructor files - Day 2

ZIP

Doubts Clarification - In-class Instructor files

ZIP

Applied Statistics with EDA - Live Session - Recordings - Week 2 - Day 1

Applied Statistics with EDA - Live Session - Recordings - Week 2 - Day 2

Applied Statistics with EDA Mandatory Project Solution

Applied Statistics with EDA Mandatory Project Solution

ZIP

Machine Learning (Week 1) - 10th & 11th Feb,2024

Agenda

Module Notes

PDF

Slide deck - Week 1 Day 1

PDF

Slide deck - Week 1 Day 2

PDF

Class work Task Solutions

ZIP

Dataset for Assignment

DOC

Assignment Solution File

ZIP

Practice Test

Exercise

In-class Instructor files - Day 1

ZIP

In-class Instructor files - Day 1

ZIP

In-class Instructor files - Day 2

ZIP

In-class Instructor files - Day 2

ZIP

Doubts Clarification - In-class Instructor files

ZIP

Doubt Clarification Session Dataset

ZIP

Machine Learning (Week 2) - 17th & 18th Feb,2024

Agenda

Slide deck - Week 2 Day 1

PDF

Slide deck - Week 2 Day 2

PDF

Class Work Task Solutions

ZIP

Dataset for Assignment

DOC

Assignment Solution

ZIP

Practice Test

Exercise

Mandatory Project

Capstone Project 1

Capstone Project 2

In-class Instructor files - Day 1

ZIP

In-class Instructor files - Day 2

ZIP

In Class Instructor File

ZIP

Doubts Clarification - In-class Instructor files

ZIP

Doubts Clarification - In-class Instructor file link-1

External Link

Doubts Clarification - In-class Instructor file link-2

External Link

ML Mandatory Project Solution

ML Mandatory Project Solution

ZIP

ML - Module End Test

ML - Module End Test

External Link

Module End Test Solution

GenAI (Week 1) - 24th & 25th Feb,2024

Agenda

VS Code installation

In Class Instructor Files - Day 1 & 2

ZIP

In Class Instructor Files

ZIP

In Class Instructor Files - Day 2

ZIP

GenAI (Week 2) - 02nd & 03rd Mar,2024

Agenda

In Class Instructor Files - Day 1

ZIP

In Class Instructor Files - Day 1

ZIP

In Class Instructor Files - Day 2

ZIP

In Class Instructor Files - Day 2

ZIP

Docker's Files

ZIP

Capstone Projects

SQL - Capstone Project

Python - Capstone Project

ML - Capstone Project

ML Dataset

ZIP

SQL Dataset

ZIP

Power BI (Week 1) - 06th & 07th Apr, 2024

Agenda

Module Notes

PDF

Slide deck - Week 1 Day 1

PDF

Slide deck - Week 1 Day 2

PDF

Class work Task Solutions

ZIP

Assignment Solution

Practice Test

Exercise

In Class Instructor Files - Day 1

DOC

In Class Instructor Files - Day 2

DOC

In Class Instructor Files - Day 2

ZIP

Power BI (Week 2) - 13th & 14th Apr, 2024

Agenda

Slide deck - Week 2 Day 1

PDF

Slide deck - Week 2 Day 2

PDF

Class work Task Solutions

ZIP

Assignment Solution

ZIP

Practice Test

Exercise

In Class Instructor Files - Day 1

ZIP

In Class Instructor Files - Day 1

DOC

In Class Instructor File - Day 2

ZIP

Power BI Mandatory Project Solution

Power BI Mandatory Project Solution

ZIP

Capstone Project

Power BI - Capstone Project

Power BI Dataset

ZIP

Power BI - Module End Test

Module End Test

External Link

Power BI - Module End Test Solution

Course Instructor

tutor image

OdinSchool

177 Courses   •   11155 Students