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
Advanced configuration
Module 5. Spring
Level 18,
Lesson 10
HttpSecurity .oauth2Login() provides a number of configuration options for setting up OAuth 2.0 authorization. The main configuration options are grouped by their protocol endpoint counterparts.
The final project of Codegym university
Module 5. Spring
Level 19,
Lesson 0
This is the final project
Additional materials
Module 5. Spring
Level 19,
Lesson 1
Useful additional materials: Gradle, Database Migration (Liquibase), JSON Web Token, Apache Kafka Basics
Introduction to databases
Module 4. Working with databases
Level 1,
Lesson 0
The history of the emergence of databases: DB and DBMS. Popular DBMS and MySQL. Tables in a database: columns and columns.
SQL language
Module 4. Working with databases
Level 1,
Lesson 1
Familiarization with the SQL language Advanced view of SQL query Comments in SQL queries Pronunciation of SQL
WHERE: conditions in SQL queries
Module 4. Working with databases
Level 1,
Lesson 2
Value comparison: <, >, =, <> Logical operations AND, OR, NOT BETWEEN: range of values IN: list of values LIKE: pattern of strings
Data Display Control
Module 4. Working with databases
Level 1,
Lesson 3
LIMIT, OFFSET, SELECT DISTINCT, ORDER BY, ORDER BY across multiple columns
The special null value
Module 4. Working with databases
Level 1,
Lesson 4
No value Compare with NULL IS NULL and IS NOT NULL
Conditional Functions
Module 4. Working with databases
Level 2,
Lesson 0
List of conditional functions IF() function IFNULL() and NULLIF() functions
CASE statement
Module 4. Working with databases
Level 2,
Lesson 1
CASE statement The second version of the CASE statement Solve the problem using the CASE statement
Grouping data
Module 4. Working with databases
Level 2,
Lesson 2
GROUP BY operator Complex queries with GROUP BY Column names in the result
Grouping by multiple columns
Module 4. Working with databases
Level 2,
Lesson 3
Grouping columns Grouping by calculated columns Grouping by multiple columns
Show more
1
...
39
40
41
42
43
...
66
Please enable JavaScript to continue using this application.