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
All quests
All levels
String Functions
Module 4. Working with databases
Level 4,
Lesson 4
List of string functions. Let's convert the string. Complex actions with strings.
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.
Show more
1
...
41
42
43
44
45
...
66
Please enable JavaScript to continue using this application.