Page 42 | CodeGym's Java course: lesson list

Advanced grouping
Module 4. Working with databases
Level 2, Lesson 4
HAVING Statement HAVING Usage Example Statement Execution Order
Available
Aggregate functions
Module 4. Working with databases
Level 2, Lesson 5
List of aggregate functions Analyze employee salaries
Available
Selecting data from multiple tables
Module 4. Working with databases
Level 3, Lesson 0
dependent table. Query on multiple tables. We remove meaningless lines.
Available
Aliases
Module 4. Working with databases
Level 3, Lesson 1
Change the column names. Table aliases. primary key.
Available
JOIN statement
Module 4. Working with databases
Level 3, Lesson 2
Prerequisites for the appearance of the JOIN operator. Introduction to the JOIN operator.
Available
OUTER JOIN statement
Module 4. Working with databases
Level 3, Lesson 3
Reasons for OUTER JOIN. JOIN types. Interview question.
Available
Subqueries
Module 4. Working with databases
Level 3, Lesson 4
Nested queries in SQL. Subquery with a scalar result. Subquery with a list of values.
Available
Subqueries with tables
Module 4. Working with databases
Level 3, Lesson 5
The subquery returns a table. Using the WITH statement.
Available
Data Types in SQL
Module 4. Working with databases
Level 4, Lesson 0
Introduction to data types in SQL. Numeric types in SQL. String types in SQL. Temporary types in SQL. Storing objects in SQL.
Available
Numeric functions
Module 4. Working with databases
Level 4, Lesson 1
List of numeric functions. Arithmetic operations. bit operations. rounding functions.
Available
Date Functions
Module 4. Working with databases
Level 4, Lesson 2
List of functions for working with date and time Calling functions Grouping data by year and month
Available
Date functions, practical examples
Module 4. Working with databases
Level 4, Lesson 3
Looking for events in the last 30 days. How to find the difference between two dates.
Available

1
...
40
41
42
43
44
...
66