Promotion
CodeGym University
Learning
Course
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
Quest map
Lessons
Level 5
Advanced knowledge of databases
SQL & Hibernate
Level 5,
Lesson 0
The principle of constructing SQL lectures and everything, everything, everything Behind the brackets
Popular databases (DBMS)
SQL & Hibernate
Level 5,
Lesson 1
Oracle. MySQL. PostgreSQL. NoSQL.
Installing MySQL
SQL & Hibernate
Level 5,
Lesson 2
Loading. Installation. Setting. Service start and stop. MySQL Console.
Workbench installation
SQL & Hibernate
Level 5,
Lesson 3
Loading. Installation. We connect to the database. Server status. How to view the list of databases.
Database creation
SQL & Hibernate
Level 5,
Lesson 4
Schema creation. Default encoding. Finishing up the schema.
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.
Adding data to a table
SQL & Hibernate
Level 5,
Lesson 6
View tables. Adding data to a table. Changing data in a table.
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
Working from IDEA
SQL & Hibernate
Level 5,
Lesson 8
IDEA setup. We connect MySQL IDEA. Display the contents of the database. Display table contents.
Please enable JavaScript to continue using this application.