Course Content

• List and List Method
• Dictionary and Dictionary Methods
• Tuple and Tuple Methods
• Creating GUI using Tkinter
• Creating Labels and Entry fields using Tkinter
• Introduction to SQL
• Installing SQL package
• SQL using command prompt:
  • Creating Table
  • Adding items to the table
  • View data of a table
  • Update data of table
  • View a single row and column
  • Update a single row and column
  • Delete a single row and column
  • Adding Primary Key to the data
  • Viewing the structure of the table
  • Grouping items having the same attribute together
• Installing SQL software and SQL Workbench.
• Integrating SQL with Python
• Connecting to the server.
• Creating a database to store students data
• Creating a table with different columns
• Project: Students Data Management System Creating a function to add and update user data on the server.
• Creating a function to clear user data in software. Creating a function to delete users data on a server
• Creating a function to Search users data using different attributes
• Rules to insert and display data

Duration: 24 hours