MicroDegree

Welcome Message

Course Preview

What is Data Analytics

Applications Of Data Analytics

Steps in Data Science

Career Roles in Data Science Field

Tools For Data Science

Join Developer Community

MySQL - What is Database?

MySQL - Course Preview

MySQL - Welcome to this course

MySQL - Installation

MySQL - Alternative Mysql Installation

Xampp-2

MySQL - Creating a database

MySQL - Creating first table

MySQL - Insert Value to table

MySQL - Select statement

MySQL - Logical AND & OR

MySQL - BETWEEN and NOT Operator

MySQL - Primary Key, Default and Null

MySQL - Customers table

MySQL - Testing the customer table

MySQL - Answering questions

MySQL - Getting specific data

MySQL - Updating the customers table

MySQL - Deleting the customers table

MySQL - Aggregate Functions

MySQL - CONCAT()

MySQL - REPLACE()

MySQL - SUBSTRING()

MySQL - CHAR_LENGTH()

MySQL - UPPER()

MySQL - Look into Distinct

MySQL - ORDER BY

MySQL - LIMIT

MySQL - Pattern Matching

MySQL - COUNT()

How do you feel about the course till Now ?

MySQL - GROUP BY

MySQL - MIN MAX and SUBQUERIES

MySQL - GROUP BY with MAX and MIN

MySQL - SUM and AVG

MySQL - having

MySQL - foreign key

MySQL - largedataset

MySQL - Data types Integer and String

MySQL - DATE, DATETIME and JSON

MySQL - date time code

MySQL - let's Join

MySQL - Types of JOINS

MySQL - INNER JOIN

MySQL - Relationships in MYSQL

MySQL - join 3 tables

MySQL - LEFT JOIN

MySQL - Right Join

MySQL - OUTER JOINS & UNIONS

MySQL - Views

MySQL - Indexes

MySQL - Assignment Info

Join Developer Community

Student Feedback - Basics And Foundation

Certification Instructions

Referral Program

Python - Course Preview

Python - What is Python

Python - Who should Learn Python?

Python - Why Python

Python - How to learn Python

Python - Basics Of Programming

Python - Installation & Setup

Python - My First Python Program

Python - Instruction Execution in Python

Python - Variables

Python - Taking User Input

Python - Build Calculator Exercise

Python - Strings from Beginning

Python - String Manipulation

Python - Working With Numbers

Python - Intro to DataStructures

Python - Lists in Python

Python - List Methods

Python - Number List Manipulation

Python - Tuples

Python - If Else Statements

Python - Logical Operators

Python - Comparison Operators

Python - Build a Converter App

Python - Loops Intro

Python - While Loop

Python - Guessing Game Project

Python - For Loops In Python

Python - 2D Lists & Nested Loops

Python - Dictionaries

Python - Functions Intro

Python - Parameters in Functions

Python - Return Statements in Functions

Python - Word Counter Exercise

Python - Intermediate Project - Student Management System

Python - Handling Errors

Python - Generic Exceptions & Finally

Python - Modules

Python - Packages in Python

Python - File IO

Python - Object Oriented Programming (OOPs)

Python - Classes and Objects

Python - PyPI And Pip

Python - Coding Standards

Python - Price Tracker App - Intro

Python - Web Scraping Using Beautiful Soup

Python - Parsing Data

Python - Dynamic Multiple Inputs

Python - Price Check Logic

Python - Write Output File

Python - Project Wrap Up

Student Feedback - Python for Data Analytics

Certification Instructions

Referral Program

Why Pandas?

Reading Data and Iterate through each Row

Description of data and sorting

Working with Column

Saving Data

Filtering Data, Reset Index, Regex Filtering and Conditional Changes

Aggregate Statistics using Groupby

Working with huge data

Student Feedback - Intermediate Section

The Basics of Numpy

Accessing Specific Elements

Initializing Different Arrays

Basic Mathematics, Statistics and Linear Algebra

Reorganizing Arrays & copy variable

Load data, Advanced Indexing and Boolean Masking

Quiz

Data Visualization - What is MatPlotLib?

Data Visualization - Line Graphs and ShortHand Notations

Data Visualization - Bar Graphs in MatPlotLib

Data Cleaning - Introduction, Data & Null Values

Data Cleaning - Removing Column and Rows

Data Cleaning - Normalizing Data

Capstone Project Part-1

Capstone Project Part-2

Capstone Project Part-3

Capstone Project Part-4

Capstone Project Part-5

Capstone Project Part-6

Referral Program

What did you feel about the entire Course

Instructions