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
Module 4. SQL & Hibernate
Level 5
Advanced knowledge of databases
Module 4. Working with databases
Level 5,
Lesson 0
The principle of constructing SQL lectures and everything, everything, everything Behind the brackets
Popular databases (DBMS)
Module 4. Working with databases
Level 5,
Lesson 1
Oracle. MySQL. PostgreSQL. NoSQL.
Installing MySQL
Module 4. Working with databases
Level 5,
Lesson 2
Loading. Installation. Setting. Service start and stop. MySQL Console.
Task - install MySQL server
Module 4. Working with databases
Level 5,
Lesson 3
Task - install MySQL server
Workbench installation
Module 4. Working with databases
Level 5,
Lesson 4
Loading. Installation. We connect to the database. Server status. How to view the list of databases.
Task - install Workbench, connect to local database
Module 4. Working with databases
Level 5,
Lesson 5
Task - install Workbench, connect to local database
Database creation
Module 4. Working with databases
Level 5,
Lesson 6
Schema creation. Default encoding. Finishing up the schema.
Task - create 3 schemes
Module 4. Working with databases
Level 5,
Lesson 7
Task - create 3 schemes
Creating tables
Module 4. Working with databases
Level 5,
Lesson 8
Creating a table. Design: how to choose the right column names and types. Specify the field names. SQL query to create a table.
Task - create 6 tables in the previously created three schemas
Module 4. Working with databases
Level 5,
Lesson 9
Task - create 6 tables in the previously created three schemas
Adding data to a table
Module 4. Working with databases
Level 5,
Lesson 10
View tables. Adding data to a table. Changing data in a table.
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
Show more
1
2
Please enable JavaScript to continue using this application.