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