Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy

Learn to use Replit as the Python editor, create repls, adjust settings, run code to see console output, and debug syntax errors with strings and quotes.

Learn the basics of values and types in Python, including strings, integers, floats, and booleans, and how encoding, decoding, and printing reveal data types.

Learn how variables in Python store and label data by assigning values to named containers, with examples for numbers, strings, and floats, and rules for valid names and assignment.

Master Python operators: perform addition, subtraction, multiplication, and division; learn exponentiation, modulus, and string operations, plus the Pemdas precedence rule and debugging tools like Tony and Replit.

Explore how to gather user input in Python using the input function, with prompts, variable assignment, and simple string concatenation. Use backslash n to create a new line in prompts.

Learn how Python comments document code, explain variables, and skip execution, using the hash symbol and the mac command forward slash or windows control forward slash.

Learn how to name Python variables for readability by using underscores like user_name or camel casing, avoid spaces and numbers at the start, and skip reserved words like class.

Explore how boolean expressions drive conditional execution in Python, using operators such as ==, !=, >, <, >=, <=, and is not, while distinguishing booleans true/false from strings and assignments.

Explore conditional execution in Python with if-else statements and indentation, using mortgage eligibility by salary and weather decisions, and learn operators such as >, >=, !=, <=

Explore nested conditionals by embedding if statements within another, using indentation and flowcharts, and apply them to a mortgage calculator example with salary and credit score.

Explore the difference between chained if-elif-else and multiple independent if statements in Python, and learn to apply checks to adjust a mortgage rate based on salary, credit score, and disability.

Master Python logical operators and, or, not to combine multiple conditions on one line, with examples using if and elif and a mortgage calculator with credit scores 900 to 1000.

Handle value error in Python with try and except to prevent crashes when a string is entered for salary in a mortgage calculator. Use else and finally for safe flow.

Discover how Python functions work, including built-in, user-defined, and lambda functions. Learn to call them with examples like input, print, len, type, max, min, and type conversion functions.

Explore the Python math module for advanced mathematical operations, import and use modules, access functions and constants like pi, and organize code with separate modules for scalable projects.

Explore generating randomness in Python with the random module, using randint for integers and random for floats. Understand the role of Mersenne Twister and how randomness powers games.

Define and reuse Python functions with the def keyword, naming, parentheses, and a colon, then indent the body and call the function to execute its statements.

Explore how Python uses indentation to define function blocks and if-elif statements, compare spaces and tabs, and set four-space indents in editors per the style guide.

Learn how to define and call functions in python using def, pass inputs with parameters and arguments, and customize output with f-strings, including examples like grid and greet with name.

Learn how to declare a Python function with two parameters, exploring positional and keyword arguments and how order and naming affect outputs.

Define functions with outputs using def and return to produce values from inputs. Explore examples like arithmetic, the math sqrt function, and a name formatter that returns a title-cased name.

Discover how to write doc strings in Python using triple quotes, placing the doc string on the first line after the function declaration, and using multi-line explanations for clear documentation.

Explore Python lists as a data structure and use them to understand iteration, covering zero-based and negative indexing, printing and updating items, and appending new elements.

Explore how Python uses for loops to iterate over lists and other data structures, printing items and performing repeated actions with proper indentation and colon syntax.

Learn how to update Python variables using the old value, initialize before use, and accumulate sums in loops with examples like a = a + 2 and s = 0.

Learn to define a custom function that validates passwords by length and call it inside for and while loops to process a list of passwords and display results.

Learn to use the range function with a for loop to sum numbers from 1 to 100 (end not included), adjust start, end, and step, and accumulate totals.

Explore the while loop in Python, comparing it with for loops, understanding condition-driven execution, and debugging infinite loops by printing the loop condition to diagnose issues.

Learn how continue and break statements control loops in Python. Use for and while loops with range to skip iterations or terminate the loop, with practical number examples.

Explore how strings work in Python, from quoting to indexing and slicing. Learn to use length and negative indices to access characters and substrings.

Explore string operations in Python, including concatenation with plus, the in operator for substrings, and string comparisons, while understanding string immutability and slicing to build new strings.

Explore core Python string methods and how to invoke them on string objects. Learn to use type, dir, capitalize, upper, lower, find, and strip, and how to access help.

Learn string parsing in Python by using find, slicing, and split to extract the domain, and join to reconstruct strings with underscores or spaces.

Master escaping single and double quotes, using triple quotes, backslashes, and raw strings in Python to print complex strings and paths without errors.

Explore Python string formatting with old style percent formatting, str.format, and f-strings, and learn how to format strings, numbers (including hex), and mappings.

Define data as information about anything and explain how a database, an organized collection of that data, enables easy access, management, and updates, including relational versus non-relational databases and queries.

Explore relational databases, tables, rows, and primary- and foreign-key relations, plus basic SQL queries and Python connections to SQLite, MySQL, and PostgreSQL.

Explore non-relational databases, learning how JSON documents, key-value stores, columnar, and graph models differ from relational tables, with MongoDB as a primary NoSQL example.

Explore the Python database api, learn how a connection object and cursor enable cross-database access with sqlite, mysql, and postgresql, and perform commits and rollbacks.

Learn what SQL is and how it interacts with relational databases using declarative statements to create, query, and manage data, including joins and table relationships.

Explore how SQLite in Python provides a light, serverless relational database that runs locally, stores data on disk, and is easy to use.

Connect sqlite3 with Python by importing sqlite3, creating a connection to HR.db, and using a cursor to execute a create table command for employees, then commit and close.

learn to view and explore SQLite databases with the DB Browser for SQLite; download, install, create a database and table, browse data, and run simple SQL queries.

Create table statements in SQLite using the syntax, including table name, column data types (integer, real, text, blob), commas, and a semicolon; use if not exist to avoid errors.

Discover how SQLite cursors enable row-by-row data traversal under the Python database API, by creating a connection, creating a cursor, and iterating only when data returns.

Learn to insert data into a SQLite table using insert into with explicit column names and values, and prevent SQL injection with parameterized queries.

Read a CSV file and insert its data into a SQLite database using the CSV library; create the table, insert rows, and commit changes.

Retrieve data from SQLite using a simple select from a table, optionally listing columns or using star to fetch all, and fetch results with fetchone or fetchall in Python.

Master the where clause in SQLite to filter data, using operators such as =, >, and between, with and, or, in, like, not equal, and case sensitivity.

Learn how to update data in a SQL table using update, set, and where clauses, perform single or multi-column updates, and apply parameterized queries in Python with SQLite.

Delete data in SQL with delete from employees, using an optional where clause and commit; then drop table if exists to avoid errors.

Learn how to join SQLite tables by linking employees and departments via department ID to retrieve combined data, using aliases and selective column choices like department name.

Build a password manager with a SQLite database to store website, email, and password, with add, clear, generate, and search features. Upcoming lectures cover front-end and back-end design and integration.

Design and implement a tkinter front end for a password manager: a canvas logo, labels and entries for website, email, password, and four buttons (generate, add, clear, search).

Use the grid geometry manager to place canvas, labels, entries, and buttons on rows and columns, adjust column spans and sticky paddings, and set the password manager title.

Develop the backend by creating a sqlite-backed password manager class that initializes the database, creates the password table, and implements save, search, and generate password method.

Connects the frontend to the backend by creating a backend instance and wiring generate, search, and save data actions to the user interface.

Explore how SQLAlchemy bridges Python with relational databases through core and ORM, using the SQL expression language to query, map objects, and simplify database work.

Connect to a database using SQLAlchemy core, create an engine and a connection, and build an employees table with id, name, and position, then create the database and table.

Learn to insert data into sqlite using sqlalchemy core by inserting into the employees table, executing via a connection, and handling single and multiple rows with dictionaries.

Load the employees table from an SQLite database using SQLAlchemy core, build and execute queries with select and where clauses, and fetch results via the result proxy.

Update data in a sql-like database with SQLAlchemy core, using where clauses and set expressions. See the employees table update and verify changes via execution and fetch result.

Learn how to delete records in a database using SQLAlchemy core, including composing a delete expression with a where clause, executing it via a connection, and verifying the result.

Join employees and departments with SQLAlchemy core by building table objects, configuring an engine and connection, and executing a joined select to fetch results.

Replace SQLite3 with SQLAlchemy core in the password manager project, updating the backend with init, save data, and search password methods, while keeping generate password unchanged.

Develop backend logic with SQLAlchemy core by creating an engine, connecting to SQLite, and building a passwords table with id, website, email, and password with insert and select operations.

Explore SQLAlchemy ORM basics, mapping Python classes to database tables and synchronizing object states with relational databases like SQLite, MySQL, and PostgreSQL, using declarative base and create engine.

Create a session bound to engine with session maker, instantiate an employees object, and insert data into employees table using SQLAlchemy ORM by calling add or add_all and then commit.

Retrieve data from a database using SQLAlchemy ORM by querying with a session, selecting the employees class, iterating results to print names and positions; use filter and get for records.

Explore SQLAlchemy ORM filter operations, including equal, not equal, like, in, and, and/or, with examples filtering by id and names starting with e.

Learn to update table rows with SQLAlchemy ORM by assigning new values and committing, and by using the update method with filters to persist changes.

Delete data from a database using SQLAlchemy ORM by selecting a row, calling session.delete on the target, and committing to remove the first employee.

Explore SQLAlchemy ORM relationships by linking a projects table to an employees table with a foreign key and back_populates, then insert related data and verify the results.

Apply SQLAlchemy ORM to join employees and projects, retrieve related data with filter and join methods, and iterate results to display employee and project names.

Learn to implement the password manager project using SQLAlchemy ORM, converting the logic from sqlite3 and SQLAlchemy core to ORM while preserving add and search operations.

Learn to build a backend with the SQLAlchemy ORM by creating the passwords table, defining the model, configuring the engine and session, and implementing save data and search password methods.

Discover MySQL, a server-based relational database management system, its client–server architecture, and how Python interacts with it via MySQL connector or SQLAlchemy ORM.

Install MySQL on Mac by downloading the MySQL community server and MySQL workbench, verify installation, configure the root password, and connect via terminal or GUI to manage databases.

Install and open MySQL Workbench on Mac, verify the local MySQL server is running on port 3306, then connect to the local instance and run the show database command.

Create a MySQL database and two related tables (employees and tasks) in MySQL workbench, then insert data and establish a foreign key relationship via employee_id.

Connect to a MySQL database from Python using the MySQL connector, create a connection and cursor, and execute a select query to fetch and print employees from the employees table.

Learn how to insert data into a MySQL database from Python by encapsulating operations in functions, using parameterized inserts, commits, and handling related tasks.

Connect a MySQL database using SQLAlchemy ORM by installing the MySQL connector and SQLAlchemy, creating an engine, and defining declarative models for employees and tasks in an HR schema.

Learn to insert and retrieve data in a MySQL database using SQLAlchemy ORM, including creating a session, adding employees and tasks, committing transactions, and querying with filters.

Implement a MySQL challenge by adding a department_id to employees, setting a foreign key to departments, and using ORM to insert IT and HR departments and assign IDs by position.

Import csv data into a mysql database using python, reading csv with the csv module, creating the database and an agent table, and inserting rows with a four-value insert.

Learn to read a csv with pandas and import it into a MySQL table using SQLAlchemy ORM, ensuring column names match and using to_sql with append and index handling.