MySQL creating and managing relational databases

Learn how MySQL defines data types to distinguish text and numerical data using char, varchar, int, decimal, float, and date-time types, and understand a column's type cannot be changed later.

Define tables by name and column types, insert values with insert into, and query data using select; manage tables with show tables and drop table.

Enforce data integrity with not null and default values, define primary keys, and apply automatic numbering to uniquely identify rows in relational tables, shown using fastest and unique fastest examples.

Explore the general possibilities of the select query in MySQL, including choosing specific columns and limiting results. Use the film table to display title, length, and rating.

Limit and select from film to show specific results, using where to filter by rating general, order by length or title, and apply operators like greater than or not equal.

Learn how to alias columns in a select query with as, renaming headers like title as name and length as duration in minutes. Use quoted multiword aliases for clear results.

Perform updates and deletions in MySQL: modify emails or names with update set where, and remove rows with delete from where, while considering primary keys and safe mode settings.

Load data from CSV files into MySQL using LOAD DATA INFILE. Manage UTF-8 encoding, separators, optional enclosed fields, headers, and missing values while preparing tables and adjusting data types.

Save query results to a file in MySQL by using select author and title from books into outfile, exporting them with UTF-8 encoding, field terminators, and quotes.

Master text functions in MySQL by learning to combine text, select parts of text, reverse strings, organize results, and search for specific constructions in your data.

Learn how to concatenate text in MySQL using the concatenate function to join author and title, add separators, and alias the result from the books table with a five-row limit.

Learn how substring selects a text fragment by index, including positive and negative indexing; apply to a title to limit to 12 characters and concatenate dots with cat.

Explore how to use the replace function to modify text, including case-sensitive substitutions, replacing substrings, and applying replacements to shorten titles.

Master MySQL text functions like reverse, length, upper, and lower. Learn to split names with substring index and to fetch unique values with distinct in queries.

Learn how to order SQL query results with the order by clause, choosing ascending or descending order, applying limit for top results, and optionally ordering by a column position.

Explore how to search text in MySQL using the like function and wildcards, including exact and partial matches, escaping the percent sign, and four-character patterns via underscores.

Learn aggregated functions in Basquel, covering counting, grouping, and descriptive statistics. Apply methods to count by cases and compute means, max, min, and modulo.

Use the count function to tally all records and count distinct values, then apply like, length, and substring to analyze titles and last names.

Learn how to group and count books by author using the group by clause in MySQL, counting rows per author with count(*) and aliases, and interpreting grouped results.

Explore descriptive statistics in MySQL by computing min and max ratings, summing votes, averaging ratings, and using group by, order by, and round to analyze books data.

Learn to store and format dates in MySQL using current date and now, date format to extract day, month, year, and time components, including day name and month name.

Learn to perform date operations in MySQL, using date_add and date_sub, and implement created_at and updated_at timestamps that auto-update.

Explore the logic of operations in MySQL, write conditions that govern when queries run, and combine them into sequences to tackle more advanced tasks.

Learn how to use MySQL logical operators—equals, not equals, greater/less than, between, and, or, like, and not like—to build queries that filter books by publication year, rating, and titles.

Use cast to transform data types, converting text to dates or numbers to text for proper operations, and apply in to filter books by Tolkin, Rolling King, and Orwell.

Explore sql conditional statements in MySQL by using case and if to label books by rating, from books, and to select title and rating with between and else cases.

Discover how relational databases use separate tables for users, books, and orders, linked by unique primary keys and references to manage data efficiently.

Explore relational tables in MySQL by creating users, orders, and cart tables, and learn one-to-one, one-to-many, and many-to-many relations with primary keys and references.

Create the orders and cart tables with foreign keys referencing users(id) and books(id), use an auto increment id and a timestamp order_date, and follow clear naming to indicate table relationships.

Explore how to retrieve data from two related tables using select queries and joins, starting with a cross join and moving toward matching user IDs in orders and users.

Explore seven types of joins in MySQL—left, exclusive left, right, exclusive right, inner, cross, and full outer—using a two-table, one-to-many example with authors and books.

Learn how to safely delete an author by using on delete cascade to automatically remove related books, enforce foreign keys, and perform corresponding removal to maintain referential integrity.

Master joining multiple tables in MySQL by building queries that connect orders, cart, and books, then extend to users. Practice by solving exercises to reinforce multi-table joins.

Explore MySQL triggers that respond to insert, update, or delete events to automate inventory updates, stock management, and orders and cart workflows.

Solve problems on your own and build your own MySQL projects to expand your knowledge. Thank you for being part of this course community.