Preview Learn Python + JavaScript + Microsoft SQL for Data science

Intrducion

Introduction

How to ask a Great Questions

Installing Code Editor (Sublime Text)

What is JavaScript

Hello World Program

Getting Output

Internal JavaScript

External JavaScript

Inline JavaScript

Async and defer

Source Code File

Java Script Basics

Variables

Data Types

Numbers

Strings

String Formatting

Java Script Operators

Arithmetic operators

Assignment operators

Comparison operators

Logical operators

Java Script Conditional Statements

If-else statement

If-else-if statement

Java Script Control Flow Statements

While loop

Do-while loop

For loop

Coding Exercise

Solution for Coding Exercise

Java Script Functions

Creating a Function

Function Call()

Function with parameters

Java Script Error Handling

Try-catch

Try-catch-finally

Java Script Client-Side Validations

On Submit Validation

Input Numeric Validation

Python Introducion

Introduction to Python

Python vs Other Languages

Why Its Popular

Command Line Basics

Python Installation (Step By Step)

PyCharm IDE Installation

Getting Start PyCharm IDE

First Python Hello World Program

Python Basic

Variables

Data Types

Type Casting

User Inputs

Comments

Python Strings

Strings

String Indexing

String Slicing

String Built-in Functions

Formatting String (Dynamic Data)

Python Operators

Arithmetic Operators

Assignment Operators

Comparison Operators

Logical Operators

AND Operator

OR Operator

NOT Operator

Booleans

Python Data Structures

Arrays in Earler

Lists

Add List Items

Remove List Items

Sort Lists

Join Lists

Tuples

Update tuples

Join tuples

Dictionaries

Add Dictionary Items

Remove Dictionary Items

Nested Disctionaries

Sets

Add Set Items

Remove Set Items

Join Set Items

Python Conditional Statements

If Statement

If-else Statement

If-elif-else Statement

If Statement Coding Excercise

Python Control Flow Statements

Flow Charts

While Loops Statement

For Loops Statement

The range() Function

Nested Loops

2D List using Nested Loop

Python Core Games

Guessing Game

Car Game

Python Functions

Creating a Function

Calling a Function

Function with Arguments

Python args, KW args for Data Science

args, Arbitary Arguments

kwargs, Arbitary Keyword Arguments

Python Project

Project Overview

ATM RealTime Project

Python Object Oriented Programming (OOPs)

Introduction to Class

Create a Class

Calling a Class Object

Class Parameters - Objects

Access Modifiers(theory)

Python Methods

Introduction to methods

Create a method

Method with parameters

Method default parameter

Multiple parameters

Method return keyword

Method Over loading

Python Class and Objects

Introduction to OOPs

Classes and Objects

Class Constructors

Python Inhertance and Polymorphism

Introduction

Inheritance

Polymorphism

Assessment Test

Solution for Assessment Test

Python Encapsulation and Abstraction

Introduction

Access Modifiers (public, protected, private)

Encapsulation

Abstraction

Python OOPs Games

Dice Game

Card and Deck Game Playing

Python Modules and Packages

PIP command installations

Modules

Built-in Modules

Packages

Reading CSV files

Python Error Handling

Errors – Types of Errors

Try - Except Exceptions Handling

Try-Except-Finally Blocks

Microsoft SQL[MS] Introduction

Introduction

Overview of Databases

MSSQL Installation

MSSQL SSMS Installation

Connecting to MS-SQL (Windows Authentication)

Connecting to MS-SQL (SQL Server Authentication)

MS SQL Statements

SQL statement basic

SELECT Statement

SELECT DISTINCT

Column AS Statement

COUNT

MS SQL Filtering Data

SELECT WHERE Clause – One

SELECT WHERE Clause – Two

ORDER BY

TOP in MSSQL

BETWEEN

IN Operator - Condition

MS SQL Functions

Overview of GROUP BY

Aggregation Function – SUM()

Aggregation Function – MIN()-MAX()

GROUP BY – One(theory)

GROUP BY – Two(practical)

HAVING

MS SQL Joins

Overview of JOINS

Introduction to JOINS

AS Statement

INNER Join

Full Outer Join

Left Outer Join

Right Outer Join

Union

MS SQL Advanced Commands

Basic of Advanced SQL Commands

Timestamp

Extract from Timestamp

Mathematical Scalar Functions

String Functions

SubQuery

MS SQL Structure and Keys

Basic of Database and Tables

Data Types

Select Datatype on SSMS

How to set Primary Key

How to set Foreign Key

Create Table using SQL Script

MS SQL Queries

Insert

Update

Delete

MS SQL Structure Queries

Alter Table

Drop Table

MS SQL Constraints

Check Constraint

NOT NULL Constraint

UNIQUE Constraint

MS SQL Backup and Restore

Overview of Database and Tables

Creating a Database backup using SSMS

Restoring a Database from backup using SSMS

Preview - Learn Python + JavaScript + Microsoft SQL for Data science