MySQL creating and managing relational databases
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.
2. CRUD - Basics
3. Text functions
-
11
2.1. Types of data -
12
2.2. Defining tables and inserting values
-
13
2.2. Exercises #5, #6 * -
14
2.3. Advanced variables
-
15
2.3. Exercise #7 *
-
16
2.4. Data display (part.1 – selected range)
-
17
2.5. Data display (part.2 – limiting and selecting)
-
18
2.5. Exercises #8 - #11 *
-
19
2.6. Aliases
-
20
2.6. Exercise #12 *
-
21
2.7. Code to copy
-
22
2.7. Updating data and removing it
-
23
2.7. Exercise #13 *
-
24
2.8. Windows support for UTF-8
-
25
2.8. Loading data from files
-
26
2.8. Exercise #14 **
-
27
2.8. Small note for further materials
-
28
2.9. Accessing any location on the computer
-
29
2.9. Saving data to files
-
30
2.9. Exercise #15 **
4. Aggregative functions
-
31
3. Text functions
-
32
3.1. Combining text
-
33
3.2. Selecting parts of the text
-
34
3.2. Exercise #16 **
-
35
3.3. Replacing text
-
36
3.3. Exercise #17 *
-
37
3.4. Inverting, number and size of characters, unique values, breaking the text
-
38
3.4. Exercise #18 *
-
39
3.5. Ordering
-
40
3.5. Exercise #19 *
-
41
3.6. Search for text
-
42
3.6. Exercises #20 - #22 **
5. Dates
