AI Academy
Promotion
CodeGym University
Learning
Courses
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
My Progress
Courses
University
Quest Map
Lessons
Java
SQL & Hibernate
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.