Page 53 | CodeGym's Java course: lesson list

Installing MySQL
SQL & Hibernate
Level 5, Lesson 2
Loading. Installation. Setting. Service start and stop. MySQL Console.
Available
Workbench installation
SQL & Hibernate
Level 5, Lesson 3
Loading. Installation. We connect to the database. Server status. How to view the list of databases.
Available
Database creation
SQL & Hibernate
Level 5, Lesson 4
Schema creation. Default encoding. Finishing up the schema.
Available
Creating tables
SQL & Hibernate
Level 5, Lesson 5
Creating a table. Design: how to choose the right column names and types. Specify the field names. SQL query to create a table.
Available
Adding data to a table
SQL & Hibernate
Level 5, Lesson 6
View tables. Adding data to a table. Changing data in a table.
Available
Data backup
SQL & Hibernate
Level 5, Lesson 7
The need for a database backup Create a database backup Create a table schema backup Create a data backup Deploy a backup
Available
Working from IDEA
SQL & Hibernate
Level 5, Lesson 8
IDEA setup. We connect MySQL IDEA. Display the contents of the database. Display table contents.
Available
Working with SQL Server
SQL & Hibernate
Level 6, Lesson 0
SQL is everything. Creating a schema in a database. Select current scheme. Creating View.
Available
Creating tables
SQL & Hibernate
Level 6, Lesson 1
Meaningful creation of tables. Keys in the table. Data type settings.
Available
Inserting data into a table
SQL & Hibernate
Level 6, Lesson 2
INSERT INTO VALUES() statement. INSERT INTO SELECT statement.
Available
Changing data in a table
SQL & Hibernate
Level 6, Lesson 3
UPDATE SET statement Advanced data modification scenarios
Available
Deleting data in a table
SQL & Hibernate
Level 6, Lesson 4
DELETE FROM statement Delete everything in general
Available

1
...
51
52
53
54
55
...
61