MicroDegree

Welcome Message

Course Preview

What is Python

Who should Learn Python?

Join Developer Community

Why Python

How to learn Python

Basics Of Programming

Python Installation & Setup

My First Python Program

Instruction Execution in Python

Variables

Taking User Input

Build Calculator Exercise

Concepts Quiz

Strings from Beginning

String Manipulation

Working With Numbers

Strings and Numbers Quiz

How do you feel about the course till Now ?

Intro to DataStructures

Lists in Python

List Methods

Number List Manipulation

Tuples

If Else Statements

Logical Operators

Comparison Operators

Build a Converter App

Loops Intro

While Loop

Guessing Game Project

Student Feedback - Basics And Foundation

Keep Updated!

For Loops In Python

2D Lists & Nested Loops

Dictionaries

Functions Intro

Parameters in Functions

Return Statements in Functions

Word Counter Exercise

Intermediate Project - Student Management System

Student Feedback - Intermediate Section

Handling Errors

Generic Exceptions & Finally

Modules

Packages in Python

File IO

Object Oriented Programming (OOPs)

Classes and Objects

PyPI And Pip

Coding Standards

Student Feedback - Advanced Section

Price Tracker App - Intro

Web Scraping Using Beautiful Soup

Parsing Data

Dynamic Multiple Inputs

Price Check Logic

Write Output File

Python Career Path

Project Wrap Up

What did you feel about the entire Course

Congratulations!

Certification Instructions

Referral Program

Course Preview

Welcome to this course

What is Database?

Installing MySQL

Alternative Mysql Installation

Xampp-2

Creating a database

Creating first table

Insert Value to table

Select statement

logical AND and OR

BETWEEN and NOT Operator

Primary Key, Default and Null

Customers table

Testing the customer table

Answering questions

How do you feel about the course till Now ?

Getting specific data

Updating the customers table

Deleting the customers table

Aggregate Functions

CONCAT()

REPLACE()

SUBSTRING()

CHAR_LENGTH()

UPPER()

Student Feedback - Basics And Intermediate

Keep Updated!

Look into Distinct

ORDER BY

LIMIT

Pattern Matching

COUNT()

GROUP BY

MIN MAX and SUBQUERIES

GROUP BY with MAX and MIN

SUM and AVG

having

Student Feedback - Advance Section

foreign key

largedataset

DATE, DATETIME and JSON

date time code

let's Join

Types of JOINS

INNER JOIN

Relationships in MYSQL

join 3 tables

LEFT JOIN

Right Join

OUTER JOINS & UNIONS

Views

Indexes

Assignment Info

Certification Instructions

Referral Program

Welcome Message

What is Github?

Why Github?

Build Github Profile from Zero

Upload Project Files to Github

Upload Folder + Profile Hack + Summary

Git Installation

Git Environment Config

New Project Config

Upload New Project

Regular Code update