Python Programming and Computer Science: Class XII (CBSE)

Learn how Python libraries and modules streamline coding by importing and using prebuilt functions, explore Python, native, and built-in modules, and create your own module with add and subtract functions.

Learn how to open, read, write, and close text and binary files in Python, including csv handling, append and read line operations, and splitting lines for data processing.

Learn to read text files in Python using modes such as read and readlines, practice with the with clause, and count lines, words, and characters, including palindrome words.

Master absolute and relative paths in Python, and explore the current working directory with the OS module. Learn file handling basics, including flush and standard input, output, and errors.

Explore binary file handling in Python by opening files in binary mode, writing and reading with byte arrays, encoding to utf-8, and typecasting data for binary input and output.

Learn to search and replace data in binary files with Python, including counting spaces, encoding strings in utf-8, and performing seek-based in-place updates.

Learn to search and update file contents in Python using the pickle module, including reading and writing binary data with dump and load, and using a temporary file workflow.

Explore data structures in Python, including built-in and user defined types. Understand stack and queue concepts, linear and non-linear structures, and core operations like push, pop, and peek.

Learn to implement a stack using a Python list, performing push, pop, and display operations, with overflow and underflow checks in a menu-driven program.

Learn how to implement a queue in Python using a list, including enqueue and dequeue operations, display, and handling overflow and underflow with a first in, first out (fifo) approach.

Explore how to implement a stack in Python using a step-by-step algorithm, covering push and pop operations, overflow and underflow checks, top index management, and animated practice examples.

Explore MySQL, the open source relational database management system, and see how its features: foreign keys, triggers, stored procedures, full-text indexing, and replication, drive web applications.

Install and configure MySQL using the installer, choose server only, set port 3306 and root password, then access the database via MySQL command line to show databases and use test.

Establish a Python-MySQL workflow by using the MySQL connector to connect from Python, create and modify databases and tables, and perform insert, update, delete, and search operations with a cursor.

Learn how to fetch data from a MySQL database using Python, with fetch one, fetch all, fetch many, and row count, demonstrated on a Tata Yahoo table.

Learn to update tuples in MySQL with a Python program, including altering tables, adding or dropping columns, and updating records with where clauses.

Learn to delete records from a MySQL database using a Python program, using cursor.execute with delete from, where clauses, and deleting by SR number or address.

Learn how to search records in a MySQL database using Python by executing a select query with a cursor and a user-specified serial number, printing matching results.

Learn to display data from a MySQL table in Python using fetchone, fetch all, and fetch many, and count rows with the cursor row count.

Develop a Python dice rolling program with a menu-driven interface, MySQL connectivity, and a database-backed leaderboard tracking winners and points.

This lecture demonstrates building a student record system in Python with MySQL, implementing a menu-driven application to add, delete, update, search, and view student records using PyCharm and MySQL connector.