Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Relational database models
- Architecture of relational databases
- Relational operators
Data retrieval
- Conventions for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Queries involving arithmetic operations
- Column aliases
- Use of literals
- String concatenation
Filtering results
- The WHERE clause
- Comparison operators
- The LIKE condition
- The BETWEEN ... AND condition
- The IS NULL condition
- The IN condition
- Logical operators
- Combining multiple conditions within the WHERE clause
- Operator precedence
- The DISTINCT clause
Data sorting
- The ORDER BY clause
- Sorting based on multiple columns or expressions
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions
- Managing NULL values
Aggregating data with grouping functions
- Aggregation functions
- Behavior of grouping functions with NULL values
- Forming data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Querying multiple tables
- Various types of joins
- Table aliases
- Defining joins within the WHERE clause
- INNER JOIN (Inner join)
- Outer joins: LEFT and RIGHT
- Cartesian product
Subqueries
- Incorporating subqueries into SELECT statements
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
Set operators
- UNION operator
- INTERSECT operator
- EXCEPT operator
Data modification: Insert, update, and delete
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Transactions
Requirements
- Basic computer proficiency
- Familiarity with any operating system
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
The practical examples, which already had more realistic information prepared in the database.
Enrique Pruneda Sandoval - GEODIS
Course - SQL language in MSSQL
Machine Translated