Page 44 | CodeGym's Java course: lesson list

The task is to fill two of the previously created tables with data
Module 4. Working with databases
Level 5, Lesson 11
The task is to fill two of the previously created tables with data
Available
Data backup
Module 4. Working with databases
Level 5, Lesson 12
The need for a database backup Create a database backup Create a table schema backup Create a data backup Deploy a backup
Available
Task - deploy backup from file
Module 4. Working with databases
Level 5, Lesson 13
Task - deploy backup from file
Available
Working from IDEA
Module 4. Working with databases
Level 5, Lesson 14
IDEA setup. We connect MySQL IDEA. Display the contents of the database. Display table contents.
Available
Working with SQL Server
Module 4. Working with databases
Level 6, Lesson 0
SQL is everything. Creating a schema in a database. Select current scheme. Creating View.
Available
Creating tables
Module 4. Working with databases
Level 6, Lesson 1
Meaningful creation of tables. Keys in the table. Data type settings.
Available
Inserting data into a table
Module 4. Working with databases
Level 6, Lesson 2
INSERT INTO VALUES() statement. INSERT INTO SELECT statement.
Available
Changing data in a table
Module 4. Working with databases
Level 6, Lesson 3
UPDATE SET statement Advanced data modification scenarios
Available
Deleting data in a table
Module 4. Working with databases
Level 6, Lesson 4
DELETE FROM statement Delete everything in general
Available
Changing the structure of a table
Module 4. Working with databases
Level 6, Lesson 5
Changing the Database Structure ALTER TABLE Statement Adding and Removing a Primary Key
Available
INDEX: indexes
Module 4. Working with databases
Level 6, Lesson 6
Causes of Indexes Adding Indexes to a Table
Available
CONSTRAINT: database integrity
Module 4. Working with databases
Level 6, Lesson 7
Database integrity control. Adding FOREIGN KEY. FOREIGN KEY and changing data.
Available

1
...
42
43
44
45
46
...
66