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 6
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.
Creating tables
Module 4. Working with databases
Level 6,
Lesson 1
Meaningful creation of tables. Keys in the table. Data type settings.
Inserting data into a table
Module 4. Working with databases
Level 6,
Lesson 2
INSERT INTO VALUES() statement. INSERT INTO SELECT statement.
Changing data in a table
Module 4. Working with databases
Level 6,
Lesson 3
UPDATE SET statement Advanced data modification scenarios
Deleting data in a table
Module 4. Working with databases
Level 6,
Lesson 4
DELETE FROM statement Delete everything in general
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
INDEX: indexes
Module 4. Working with databases
Level 6,
Lesson 6
Causes of Indexes Adding Indexes to a Table
CONSTRAINT: database integrity
Module 4. Working with databases
Level 6,
Lesson 7
Database integrity control. Adding FOREIGN KEY. FOREIGN KEY and changing data.
Please enable JavaScript to continue using this application.