Page 54 | CodeGym's Java course: lesson list

Changing the structure of a table
SQL & Hibernate
Level 6, Lesson 5
Changing the Database Structure ALTER TABLE Statement Adding and Removing a Primary Key
Available
INDEX: indexes
SQL & Hibernate
Level 6, Lesson 6
Causes of Indexes Adding Indexes to a Table
Available
CONSTRAINT: database integrity
SQL & Hibernate
Level 6, Lesson 7
Database integrity control. Adding FOREIGN KEY. FOREIGN KEY and changing data.
Available
Connecting to the database from a Java application
SQL & Hibernate
Level 7, Lesson 0
Java DataBase Connectivity. JDBC Driver Manager. We connect to the MySQL server.
Available
First JDBC Program
SQL & Hibernate
Level 7, Lesson 1
Maven. First request to the database. Full listing of the program.
Available
Getting data from ResultSet
SQL & Hibernate
Level 7, Lesson 2
Managing the current line. Getting data from the current row. Getting different data about the ResultSet.
Available
Data type negotiation in JDBC
SQL & Hibernate
Level 7, Lesson 3
Data types. JDBC and NULL. What's wrong with data types in JDBC?
Available
Working with time
SQL & Hibernate
Level 7, Lesson 4
The current state of affairs over time. Modern problems require modern solutions. Getting a date. Setting the time zone in MySQL.
Available
Executing queries
SQL & Hibernate
Level 7, Lesson 5
Introduction to Statements. executeUpdate(). execute().
Available
Dealing with bugs
SQL & Hibernate
Level 7, Lesson 6
Tears and pain. SQL Exception. Error examples.
Available
Transactions when working with a database
SQL & Hibernate
Level 8, Lesson 0
Why are transactions needed? Transactions in JDBC. Save points.
Available
Working with PreparedStatement
SQL & Hibernate
Level 8, Lesson 1
Types of statements. PreparedStatement. An example of using PreparedStatement.
Available

1
...
52
53
54
55
56
...
61