(Python Diploma (Desktop & Web

1-Introduction and Overview

• Compiler vs Interpreter applications
• Overview about Python applications
• overview about libraries
• Declaring and initializing variables
• How to print in Console
• How to scan values from user

2-Control Structure and Dictionaries

• If, if-else statements
• While loop
• Foreach loop
• Built-in Functions
• Sets
• Dictionaries

3-Lists And Strings

• Lists and Indices
• Tuples and built-in Functions
• Modifying Lists
• Built-in Functions on Lists
• Processing List Items
• Slicing
• Aliasing
• Strings

4-Storing and Retrieving Data with File System I/O

• Reading and writing files.
• Creating, deleting and renaming files.
• Obtaining directory and file information.
• Handling exceptions with try and except.

5-OOP

• Overview about traditional programming
• Introduction to classes and methods.
• Introduction to object oriented programming
• Encapsulation
• Inheritance

6-SQL

• Introduction to SQL and Database design
• DDL SQL statements
• Study create, alter and drop statements
• DML SQL statements
  • Select types
  • How to search in database
  • Condition operators
  • Sorting data
  • Aggregation functions
  • Joins
• Study insert, Update and Delete statements
• study Select statement

7- GUI

• Introduction to Graphics User Interface,
• Introduction to Dialogs and message boxes.
• Tkinter Module
• Basic GUI Construction
• Message boxes Styles

8- Django

• Introduction to Django
• Install Django
• Start a Django project
• Urls and views
• Apps, models, migrations
• Django ORM
• Django Admin
• Templates and Static Content
• Forms and Authentication