Visual Studio Code
•Installing Visual Studio Code
•Variables & Data Types
•Variables
•Python Data Types
•Python Variables
•Data Types
•Python Data Type Conversion
•Variable Operators
•Write a simple “Hello World” Program
•If-Statements and Conditional Logic
•If-Statements and Conditional Logic in Python
•Loops and Iteration
•Loops and Iteration in Python
•Arrays
•2D Arrays
•Multidimensional Arrays & Examples
•Functions
•Function in Python
•File Input/ Output
•Input/ Output and Files in Python
•Python Introduction Quiz
•Hyper Coding Practice Test
•Object-oriented Programming
•Objects and Classes
•Methods
•Encapsulation and Data Hiding
•Message Passing
•Inheritance
•Polymorphism
•Generalization and Specification
•Links and Associations
•Super Coding Practice Test
•Advanced Concepts in Python
•Sending Emails to multiple receivers with Python
•XML parsing
•Multithreading in Python
•Create a function that will add 2 integers and print their sum.
•Write a “Greetings” Function
•Print the sum of the numbers 1 to n
•Write a Python program to check if the input number is prime or not.
•Python Program to Find the Factorial of a Number
•Python Program to Check Armstrong Number
•Write a Program to Check if a Given Number is an Ugly Number.
•Python Mid Quiz
•Beyond Python: From Python to SQL – Using Databases to Store Data
•Why SQL is so important?
•Setting up XAMPP, Apache, MySQL Database Server and SQLYOG as a Database Client
•Starting Database Services
•Creating our 1st Database
•Dropping your 1st Database and Recreating it
•Creating our First Tables in our Database
•Dropping Tables in a Database
•Insert Statements
•Create a Table based on Another Table
•Select Statement
•Where Clause
•Operators in SQL Statements
•Update Data using Update Queries
•Delete Data with Delete Statements
•Like Operators in Where Clause
•Limit Data using LIMIT/ TOP/ ROWNUM in MYSQL/ MSSQL/ Oracle Databases
•Using Order-By Clause to Order Data
•Using Group-By Clause to Group Data Based on Columns
•Using Distinct Clause To Return only Unique Values
•TRUNCATE TABLE Command to Delete the Data Inside a Table and Conclusions
•Introduction to Programming & Sequence and Python Programming Language
•3 Tips to Get More Value Out of this Course
•Introduction to Python
•