MySQL creating and managing relational databases

Name: MySQL creating and managing relational databases
Rating: 4.7 (124 reviews)

A flash course on managing and processing data in relational databases using MySQL with many exercises

Created byKrzysztof Raczynski

Last updated 1/2022

English

What you'll learn

MySQL
SQL
databases
relational databases
CRUD
creating databases in MySQL
managing databases
loading data from files
saving data to files
joining tables
managing tables with multilevel relations

Course content

7 sections • 76 lectures • 5h 31m total length

One monitor tip0:40
Resources0:30
Meet your instructor2:05
Use this setting when needed0:13
1.1. SQL Language3:46
Learn the SQL language, a declarative approach for creating and querying relational databases, and discover how relational database systems support stored procedures, triggers, views, replication, and multilingual encoding.
Installation note0:10
1.2. MySQL Workbench Installation10:05
Install MySchool (MySQL Workbench) with the full installer, choose standalone server, and configure Python connectors, root password, and samples for console access and database scripting.
1.3. MySQL Console and Workbench navigation, creating and deleting databases15:10
1.3. Excesises #1 - #4 *

2.1. Types of data13:11
2.2. Defining tables and inserting values15:58
2.2. Exercises #5, #6 *
2.3. Advanced variables20:32
2.3. Exercise #7 *
2.4. Data display (part.1 – selected range)4:01
2.5. Data display (part.2 – limiting and selecting)9:00
2.5. Exercises #8 - #11 *
2.6. Aliases3:29
2.6. Exercise #12 *
2.7. Code to copy0:24
2.7. Updating data and removing it14:44
2.7. Exercise #13 *
2.8. Windows support for UTF-80:08
2.8. Loading data from files25:45
2.8. Exercise #14 **
2.8. Small note for further materials0:15
2.9. Accessing any location on the computer0:22
2.9. Saving data to files4:42
2.9. Exercise #15 **

3. Text functions0:43
3.1. Combining text4:25
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.
3.2. Selecting parts of the text6:12
3.2. Exercise #16 **
3.3. Replacing text3:04
Explore how to use the replace function to modify text, including case-sensitive substitutions, replacing substrings, and applying replacements to shorten titles.
3.3. Exercise #17 *
3.4. Inverting, number and size of characters, unique values, breaking the text10:10
3.4. Exercise #18 *
3.5. Ordering4:09
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.
3.5. Exercise #19 *
3.6. Search for text9:34
3.6. Exercises #20 - #22 **

7. Relations2:33
7.1. Relational tables16:05
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.
7.2. Reference to other tables10:35
7.3. Multiple tables queries5:09
7.3. Exercise #39 ***
7.4. Code to copy0:23
7.4. Types of joins – theory (Join part.1)14:51
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.
7.4. Exercise #40 *
7.5. Deleting entries from tables with references4:13
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.
7.6. Joining two tables (Join part.2)6:12
7.6. Exercises #41 - #44 **
7.7. Joining more than two tables (Join part.3)7:27
7.7. Exercise #45 *****
7.7. Exercises #46 - #51 ****
7.8. Triggers11:34
Explore MySQL triggers that respond to insert, update, or delete events to automate inventory updates, stock management, and orders and cart workflows.
Thank you0:22
The end note0:34
Learn more0:21

Requirements

willingness to learn

Description

The course is designed for people who have not had contact with the SQL language yet, but want to learn how to work with relational databases. In the course, we discuss all the necessary issues, work with examples and exercises, starting from the basics: what is SQL and how to install and run a local MySQL server on your home computer, how to use SQL itself from both the console and MySQL Workbench. Then we discuss the topic of CRUD: Create, Read, Update, Delete where we discuss all these activities in detail. The next stage will be text and aggregate functions where you will learn to modify the results of database queries. Next, an important step will be learning how to create queries with a logic layer and calling the appropriate conditions that will make the query result dependent on their fulfillment. Finally, we discuss the topic of relations - their types, how to create and invoke, handle them or activate events with triggers. At the end of the course, we will work on the data set in several tables connected by relations. In each section you will also find additional exercises that will allow you to check your knowledge and skills as well as notes summarizing the issues discussed.

Who this course is for:

beginner database administrators
beginner database developers
students
people who need to organize their data systems
researchers
everyone interested

MySQL creating and managing relational databases

What you'll learn

Explore related topics

Course content

1. Preparation of the environment9 lectures • 33min

2. CRUD - Basics20 lectures • 1hr 53min

3. Text functions12 lectures • 38min

4. Aggregative functions7 lectures • 26min

5. Dates2 lectures • 17min

6. Logic8 lectures • 25min

7. Relations18 lectures • 1hr 20min

Requirements

Description

Who this course is for: