SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1

Discover MySQL, a relational database management system, by learning installation, creating databases and tables, importing and exporting data, and using SQL to store, retrieve, and manipulate information.

Install XAMPP to set up Apache, MySQL, and phpMyAdmin; launch the control panel, start Apache and MySQL, access localhost/phpmyadmin, and prepare for Workbench in the next video.

Install MySQL Workbench from the official download page on Windows, Mac, or Linux, install prerequisites, then open the app and create a local connection to an example database.

Explore the common MySQL data types and how they split into numeric, date time, and strings, with guidance on selecting the best type for storage and use.

Explore MySQL data types, including size-limited and spatial types, and learn how they affect storage, ordering, and how to choose based on stored data and reporting needs.

Compare phpMyAdmin and MySQL Workbench, then create databases, tables, and columns in phpMyAdmin, including an id primary key with autoincrement and Unicode-friendly collations.

Learn how to create a database and tables in MySQL Workbench, including creating schemas, defining primary keys, adding columns, and establishing relationships between tables.

Design tables to avoid redundant data and use primary keys and foreign keys to connect records. Manage access with per-table permissions and privileges such as read, write, update, and delete.

Import data from external sources into existing tables using CSV formats. Export table data to CSV or Excel files, previewing and applying settings in workbench.

Explore the basics of MySQL queries by learning the select, insert, update, and delete actions, their location and restrictions via where clauses and operators like equals, greater-than, and like.

Practice practical SQL inserts, updates, and deletes, learn two insert formats, understand the dangers of delete without a where clause, and use select previews with where to target changes.

Compare csv, myisam, memory, and innodb storage engines and their trade-offs for queries, updates, and data integrity. Learn to change engines in phpmyadmin and workbench to fit your needs.

Learn how to join data across multiple tables using inner, left, right, and full outer joins, with examples on name and purchase tables and the having clause.

Join multiple tables using aliases to clarify column names, select specific fields for a cleaner result, and apply the having clause to filter data after joins.

Order results with order by, asc or desc, and sort by date and product ids, then apply arithmetic and string functions like concat and substring.

Explore using custom query elements to restrict searches with where and having, group by product totals, and calculate averages while validating data.

Master sql data grouping by consolidating rows, computing the most recent purchase date with max, and summing totals, illustrated through a James Donovan example.

Explore advanced SQL grouping with group by, using name.date for unique totals per person, and learning having and subqueries for per-product totals and latest purchases.

Master sub-queries and nested queries to pull the most recent records and join purchase data with product data using inner selects.

Master inner joins and subqueries to fetch the most recent purchase records, calculate totals by product, and handle missing data with is null and is not null.

Explore sequences and transactions to safely manage autoincremented ids and atomic inserts, using start transaction, commit, and rollback to ensure data integrity during each operation.

Master the basics of PHP by declaring variables with a dollar sign, using concatenation to join strings, and outputting results to a web page.

Explore conditional statements in PHP advanced: if, else, and else-if, with operators like equals and greater-than-or-equal-to, and foreach to process arrays and share database information in a user interface.

Learn PHP advanced techniques for handling get requests: use a form with method get, check if a get variable exists with isset, and display results on the same page.

Learn to handle PHP forms with post and get, move from displaying entire arrays to echoing specific values, and build and access indexed arrays using zero-based indexes.

Explore advanced PHP array manipulation, including creating, updating, printing lists, and using foreach to iterate and modify elements. Learn how to echo results and manage list state.

Delve into PHP advanced concepts with multidimensional arrays, iterating with for each, managing nested values, and implementing multi-select inputs and array formatting in forms.

Learn how to create a PHP MySQL database connection to the person database, run insert and select queries, and process results into an array to display names.

learn to streamline php mysql queries with a function that returns results, handle single values or result sets, and build an html table from joined purchases and product data.

Explore a basic Python introduction focused on variables, data types, and simple comparisons. Learn to connect to a database, create tables, and visualize data on a web page.

Learn about Python data types, including booleans, strings, integers, floats, lists, sets, and dictionaries, and how division and indexing affect their behavior.

Connect to a MySQL server from Python, create a database and tables, define fields and a primary key, and fetch results to verify the structure.

Connect to a MySQL database with Python, load owner and pet data from text files, and insert records into tables using format strings and a cursor.

Learn how to display database data in HTML tables using a Python script, including querying data, building table headers, iterating rows, and rendering output to an HTML file.

Learn to use Python classes to create and manage databases, define tables and columns, and insert data with SQL commands.

Explore ESC Lite and SQLite as free, open source, embedded, serverless relational databases that are self-contained, zero-configuration, transactional, and store a complete SQL database in a single disk file.

Explore SQLite features such as being free and open source, serverless, cross-platform, with no setup or administration, variable length columns, and extensive language APIs across many platforms.