Learn Python Programming, GUI, Database and System Design

Download and install python from the python dawg site, configure idle, and write your first program with print to display hello universe on Windows, Mac, or Linux.

Learn how to use variables and data types in Python, assign names for readability, and format outputs with the format function while exploring integers, floats, strings, and operators including modulo.

Explore variables and data types in Python using the shell and IDLE; learn arithmetic, typecasting, string conversion, formatting, and basic if statements with hex, octal, and binary representations.

Practice arithmetic operations and type casting in Python with print formatting, converting between integers, strings, and floats, and exploring hexadecimal, octal, and binary representations, if statements, comparisons, and string concatenation.

Learn to read keyboard input via prompts, store values in variables, and print results. Convert inputs to numbers, handle type errors, and discuss basic data validation with examples.

Explore how Python lists serve as a mutable data structure to store, access, index, nest, slice, and concatenate data, with common operations like extend, remove, add, append, insert, and sort.

Explore Python lists through hands-on lab activities, learning how to sort, insert, append, extend, and remove elements, access indices, and handle strings and numbers.

Explore Python lists and slicing syntax, including start, end, and step values, negative indices, and practical examples using for loops and the title method to format names.

Students learn to copy and modify lists using slicing, replace an element by index, and apply append and remove to demonstrate before-and-after outputs with Timmy and Caroline.

Explore how to work with Python sets, including unique, unordered elements, creation methods, membership tests, and operations such as add, update, remove, discard, and pop.

Practice Python set operations through hands-on examples: create and print sets, test membership, iterate with for loops, and add, update, discard, remove, pop, clear, and delete elements.

Explore Python tuples, immutable data structures defined with parentheses, including indexing, slicing, and functions like count, index, and len, plus deletion and replication for efficient data handling.

Learn how to work with tuples in Python: create, access, count, search, slice, duplicate, and delete tuples; explore immutability and common operations through a hands-on lab.

Learn how to use Python dictionaries, create and modify key-value pairs, clear and copy dictionaries, initialize with keys, and retrieve values, keys, and updates with dict methods.

Explore dictionary operations in Python, including creating and copying dictionaries, accessing keys and values, using update, clear, delete, and pop, and inspecting types for debugging.

Master Python for loops by using range, iterating over lists and strings, printing with format specifiers, checking types, and maintaining proper indentation to control program flow.

Explore for loop fundamentals: iterate strings and numbers, nest loops with ranges, print formatted results, and apply simple data processing and else clauses.

Learn how while loops control execution by counting with a counter, incrementing x, and terminating when a range condition is met, avoiding infinite loops.

Learn to implement while loops in Python, exploring infinite loops, break conditions, and range-based counting. See how incrementing x by one and using the shorthand affect loop behavior.

Master conditional statements and branching with if tests and comparisons. Use while loops, break, and input prompts to manage menus and validate user choices (A, B, C, Q).

Explore conditional statements and branching by stepping through a while loop that increments ai, uses a two-condition if with and, and observes how print and continue affect the loop's flow.

Practice conditional statements and branching with a menu-driven Python program that uses if-elif-else, an infinite while loop, and input validation to navigate shopping cart or specials, with a quit option.

Master conditional statements and branching in lab 3 by using if, elif, and else with user input, loops, and break to quit.

Explore conditional statements and branching in this lab by iterating through a string character by character, breaking on a blank and printing characters until the end.

Define and call python functions using def, specify arguments, and return results. Inspect a sample process_string function that processes input strings, checks length, and returns a tailored message.

Compute tax with a global x of 30 using a tax calc function and a local t, print the total, and illustrate modular, reusable Python coding.

Learn how to define and invoke a Python function that takes price and tax percent, computes a total including tax, and returns and prints the result.

Explore nested functions in Python by tracing calls from main to query and total cost. Follow input handling, type conversion, and tax calculations as the program prints results.

Demonstrate using *args and **kwargs to pass an unknown number of positional and keyword arguments to functions, sum numeric inputs with a for loop, and access dictionary items by key.

Explore Python file IO and storage concepts by creating, writing, reading, and appending flat files on disk, with persistent storage and basic modes like w, r, and a.

Learn file IO basics with mode w to write at position 0, creating or overwriting files, using open, write, and close, plus ASCII text handling and path considerations.

Demonstrate file io and storage concepts by appending text to an existing file, opening it in append mode, and writing data to the end of the file.

Practice file io and storage concepts by writing, appending, and reading a file, printing its contents, and closing the file, while experimenting and learning through code.

Explore how classes group functions into methods, define parent and child classes, and apply inheritance to share traits among superheroes, with upcoming terminology and hands-on lab.

Explore class terminology, including classes, inheritance, child/derived subclasses, methods, overloading, and instantiation, while learning to import libraries, access variables with dot notation, and initialize class instances.

explore base classes in Python through a temperature class with celsius to fahrenheit and fahrenheit to celsius methods. it covers instantiation and using self to access these methods.

Explore derived classes and inheritance by extending a base class to create a temperature range subclass, initializing with a derived constructor, and printing centigrade to fahrenheit ranges.

Build a base class named temp with class and instance variables to perform Celsius Fahrenheit conversions, and explore external versus local variables and initialization order.

Explore derived classes and inheritance by implementing a temperature class and its derived temp range, performing Celsius–Fahrenheit conversions and type inspections.

Learn how to build a polished GUI in Python using tkinter by creating a window with labels and buttons, wiring events with callbacks, and managing the main event loop.

Import the library, instantiate a window, create two labels with text label one and label two, pack them, and start the event loop.

Build a GUI with two labels and a button, handle a press event to print output and dynamically update the button text and colors while the program waits for events.

Build a two-frame gui window with frame 1 and frame 2, each hosting labels, entries, and submit buttons, using pack and get to capture and display input.

build a window with two frames one above the other, using labels, entry fields, and submit buttons to display inputs and explore event-driven python gui behavior.

Learn how small logic changes in a Python GUI program alter data-entry forms by rearranging two form definitions and packing them to the left in a live demo.

Adjust frames and packing to side left to create side-by-side windows. Experiment with graphs, charts, and calculations by moving widgets, saving a copy to avoid rewriting.

Position graphical user interface widgets with a grid layout and sticky anchors (north, east, west, south), using rows and columns and grid coordinates in practical code examples.

Explore grid and pack layouts in a GUI, learn to use frame and sticky, and see how grid delivers similar functionality with different design choices.

Explore SQLite databases with Python to store customer master data, sales, and production information, linking bills of materials and schedules for rapid retrieval and record updates via a user interface.

learn to create a contact table in a sqlite database with python, importing sequel lite 3, connecting to a db file, and defining id as integer primary key not null.

Define a function insert_records to insert data into a sqlite3 database from Python using execute on the contact table with fields id, name, age, st_address, city, and state, then commit.

Retrieve a record from the contact table where name equals Paul Slagle using a select query in sqlite3, read fields from the cursor into variables, and close the connection.

updates a database record using the update records function, setting notes in the contact table where id equals 1, then logs and reads the updated record to verify.

delete four records in a sequel light database by connecting, executing delete from contact where id in (1,2,3,4), committing, and verifying deletions with total_changes.

Execute a full database lab demonstrating create table, insert, select, update, and delete operations with a DV Connect workflow; print results, commit changes, and preview next project.

Learn to design robust systems using flow charts and mind mapping, plan with functional and technical specifications, and implement with Python and SQLite while collaborating with users.

Learn flow charting basics, from terminator, process, and decision symbols to connectors, and explore mind maps and ERP diagrams for system design.

Explore system design fundamentals through a technical specification overview that distinguishes it from a functional spec, covering project scope, risks, risk mitigation, data extraction, transformation, loading, interfaces, and program modules.

Explore a system design diagram and a user interface with fields for name, address, city, state, notes, with an event handler coordinating search, list, save, and delete.

Explore tutorial lab showing database connections, a contact table, and inserting, updating, and deleting records with values substituted for question marks. See how select and commit flows manage test data.

Learn to implement a python gui database workflow, including a delete record routine with a name-based delete, safeguards against sql injection, and core create, insert, select, update, and delete operations.

Develop a system design lab that uses a list box to populate names from a database, select an item, and update the display and log.

Design a two-window gui with a list box and scrollbar, bind selection events, and load sorted contact data from a database into a form with search and delete options.

Learn to build a database-backed graphical user interface app in this lab, from creating a test database to insert, update, delete, and search operations.

Learn to design reusable system modules by replicating a contact database across applications, with modular database access, graphical user interface forms, and Python processing you can adapt with minor adjustments.

Build on your basic Python programming and database skills to create interactive systems with confidence. Stay curious, keep learning, and remember you are in control of your IT career.