4.73 out of 5
4.73
31 reviews on Udemy

MySQL creating and managing relational databases

A flash course on managing and processing data in relational databases using MySQL with many exercises
Instructor:
Krzysztof Raczynski
1,127 students enrolled
English [Auto]
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

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.

1. Preparation of the environment

1
One monitor tip
2
Resources
3
Meet your instructor
4
Use this setting when needed
5
Note for beginning
6
1.1. SQL Language
7
Installation note
8
1.2. MySQL Workbench Installation
9
1.3. MySQL Console and Workbench navigation, creating and deleting databases
10
1.3. Excesises #1 - #4 *

2. CRUD - Basics

1
2.1. Types of data
2
2.2. Defining tables and inserting values
3
2.2. Exercises #5, #6 *
4
2.3. Advanced variables
5
2.3. Exercise #7 *
6
2.4. Data display (part.1 – selected range)
7
2.5. Data display (part.2 – limiting and selecting)
8
2.5. Exercises #8 - #11 *
9
2.6. Aliases
10
2.6. Exercise #12 *
11
2.7. Code to copy
12
2.7. Updating data and removing it
13
2.7. Exercise #13 *
14
2.8. Windows support for UTF-8
15
2.8. Loading data from files
16
2.8. Exercise #14 **
17
2.8. Small note for further materials
18
2.9. Accessing any location on the computer
19
2.9. Saving data to files
20
2.9. Exercise #15 **

3. Text functions

1
3. Text functions
2
3.1. Combining text
3
3.2. Selecting parts of the text
4
3.2. Exercise #16 **
5
3.3. Replacing text
6
3.3. Exercise #17 *
7
3.4. Inverting, number and size of characters, unique values, breaking the text
8
3.4. Exercise #18 *
9
3.5. Ordering
10
3.5. Exercise #19 *
11
3.6. Search for text
12
3.6. Exercises #20 - #22 **

4. Aggregative functions

1
4. Aggregative functions
2
4.1. Counting
3
4.1. Exercises #23, #24 *
4
4.2. Grouping
5
4.2. Exercise #25 *
6
4.3. Descriptive statistics
7
4.3. Exercises #26 - #28 **+

5. Dates

1
5.1. Storing and using dates
2
5.2. Operations on dates

6. Logic

1
6. Logic
2
6.1. Logical operators
3
6.1. Exercises #29 - #35 **+
4
6.1. Exercise #36 ****
5
6.2. Transformations and choices lists
6
6.2. Exercise #37 **
7
6.3. Conditions
8
6.3. Exercise #38 ***

7. Relations

1
7. Relations
2
7.1. Relational tables
3
7.2. Reference to other tables
4
7.3. Multiple tables queries
5
7.3. Exercise #39 ***
6
7.4. Code to copy
7
7.4. Types of joins – theory (Join part.1)
8
7.4. Exercise #40 *
9
7.5. Deleting entries from tables with references
10
7.6. Joining two tables (Join part.2)
11
7.6. Exercises #41 - #44 **
12
7.7. Joining more than two tables (Join part.3)
13
7.7. Exercise #45 *****
14
7.7. Exercises #46 - #51 ****
15
7.8. Triggers
16
Thank you
17
The end note
18
Learn more
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
31 Ratings

Detailed Rating

Stars 5
27
Stars 4
2
Stars 3
1
Stars 2
0
Stars 1
1
10ecf2f62a2cb4f7b2d94016ad8ad046
FREE For First 1000 Enrolls

Includes

5 hours on-demand video
37 articles
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW