Certified Software Developer Advance (Python)

1.   Introduction to Python, Python Basics

• Features and uses of Python
• Program execution
• Installation of IDE
• Identifiers and keywords
• Types of comments
• Data types
• Variables
• Arithmetic operators
• Assignment operators
• Input and print statements

2. Strings, Decision Control Statements

• Definition of string
• Operations accessing string elements
• Relational operators
• Logical operators
• Conditional expressions
• If, If..else, If..elif 

3. Repetition Statements and Console Input-Output

• Use of while and for
• Break and continue
• Pass and else statements
• Formatted input and output

4. Lists, Tuples, Sets, Dictionary

• Use of while and for
• Break and continue
• Pass and else statements
• Formatted input and output

5. Functions and Recursion, Functional Programming and Lambda Functions

• Read-write operations
  • With the keyword
  • File opening modes
  • Moving within a file
• Serialization
  • File and directory operations
• Importing a module
  • Variations of import
  • Third-party packages

6. File Input-Output and Modules

• Read-write operations
  • With the keyword
  • File opening modes
  • Moving within a file
• Serialization
  • File and directory operations
• Importing a module
  • Variations of import
  • Third-party packages

7. Classes and Objects

• Class variables
• Methods
• Operator overloading
• Reuse
• Containership
• Inheritance

8.Exception Handling, Iterators and Generators

• Iterables and iterators
• Syntax errors and exceptions for:
  • try-except
  • else
  • finally blocks

9. Data Analysis with Pandas

• Installing Pandas
• Loading files
  • CSV files
  • JSON files
• Dataframes

10. Numeric and Scientific Computing using NumPy

• NumPy: Introduction
• OpenCV
• Images and NumPy Arrays

11. Graphical User Interfaces with Tkinter

• Introduction to Tkinter
• Setting up a GUI with widgets
• Connecting GUI widgets with callback functions

12. Interacting with Databases

• SQLite: Introduction
• Connecting and inserting data to SQLite via Python
• Selecting, deleting, and updating SQLite records