Mini Bootcamp - Python for Programming with SQL

PYTHON OVERVIEW

1. History of Python

2. Python Features

3. Local Environment Setup

4. Getting Python

5. Installing Python

6. Python Environment Variables

7. Running Python (Google Colab)

PYTHON – BASIC SYNTAX

1. First Python Program

2. Python Identifiers

3. Python Keywords

4. Lines and Indentation

5. Multi-Line Statements

6. Quotation in Python

7. Comments in Python

8. Using Blank Lines

9. Waiting for the User

10. Multiple Statements on a Single Line

11. Multiple Statement Groups as Suites

12. Command Line Arguments

13. Accessing Command-Line Arguments

14. Parsing Command-Line Arguments

15. getoptgetopt method

16. Exception getoptGetoptError

PYTHON – VARIABLE TYPES

1. Assigning Values to Variables

2. Assigning Values to Variables

3. Multiple Assignment

4. Standard Data Types

5. Python Numbers

6. Python Strings

7. Python Lists

8. Python Tuples

9. Python Dictionary

10. Data Type Conversion

PYTHON – BASIC OPERATORS

1. Types of Operators

2. Python Arithmetic Operators

3. Python Comparison Operators

4. Python Assignment Operators

5. Python Bitwise Operators

6. Python Logical Operators

7. Python Membership Operators

8. Python Identity Operators

9. Python Operators Precedence

PYTHON – DECISION MAKING AND LOOPS

1. If Statement

2. If…else Statement

3. The elif Statement

4. Single Statement Suites

5. While Loop

6. The Infinite Loop

7. Using else Statement with Loops

8. Single Statement Suites

9. For Loop

10. Iterating by Sequence Index

11. Using else Statement with Loops

12. Nested Loops

13. Loop Control Statements

14. Break Statement

15. Continue Statement

16. Pass Statement

PYTHON – FUNCTIONS AND MODULES

1. Defining a Function

2. Calling a Function

3. Passing by Reference Versus Passing by Value

4. Function Arguments

5. Required Arguments

6. Keyword Arguments

7. Default Arguments

8. Variable Length Arguments

9. The Anonymous Functions

10. The return Statement

11. Scope of Variables

12. Global vs Local variables

13. The import Statement

14. The from…import Statement

15. The from…import * Statement

16. Locating Modules

17. The PYTHONPATH Variable

18. Namespaces and Scoping

19. The dir( ) Function

20. The globals() and locals() Functions

21. The reload() Function

22. Packages in Python

PYTHON – CLASSES AND OBJECTS

1. Overview of OOP Terminology

2. Creating Classes

3. Creating Instance Objects

4. Accessing Attributes

5. Built-In Class Attributes

6. Class Inheritance

PYTHON – DATABASE ACCESS

1. What is MySQLdb?

2. How do I Install MySQLdb?

3. Database Connection

4. Creating Database Table

5. INSERT Operation

6. READ Operation

7. Update Operation

8. DELETE Operation

9. Performing Transactions

10. COMMIT Operation

11. ROLLBACK Operation

12. JOIN Operation

13. Disconnecting Database

14. Handling Errors

SQL

INTRODUCTION

1. Install

2. Xampp

3. Create Database

4. Field

5. SQL Using Python

EXTRACT DATA

1. Read

2. Delete

3. Updates

4. Create

5. Data warehouse