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
- Anatomy of a relational database
- Relational operations
Data extraction
- Best practices for SQL query construction
- SELECT statement syntax
- Retrieving all columns
- Applying arithmetic operations in queries
- Column aliasing
- Use of literals
- String concatenation
Result filtering
- Utilizing the WHERE clause
- Comparison operators
- LIKE condition
- Range filtering with BETWEEN ... AND
- Handling null values with IS NULL
- Membership testing with IN
- Logical operators
- Combining multiple conditions in the WHERE clause
- Operator precedence
- Eliminating duplicates with DISTINCT
Data sorting
- The ORDER BY clause
- Sorting by multiple columns or complex expressions
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function usage
- Managing NULL values
Data aggregation via grouping functions
- Core grouping functions
- Behavior of grouping functions with NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering aggregated results with the HAVING clause
Data retrieval from multiple tables
- Various join types
- Table aliasing
- Defining joins within the WHERE clause
- INNER JOIN mechanics
- External joins (LEFT, RIGHT)
- Cartesian products
Subqueries
- Embedding subqueries within SELECT statements
- Single-row and multi-row subqueries
- Single-row subquery operators
- Multi-row subquery operators (IN, ALL, ANY)
Set operators
- UNION operation
- INTERSECT operation
- EXCEPT operation
Data modification: Insert, Update, and Delete
- INSERT command usage
- UPDATE command usage
- DELETE command usage
Transactions
Requirements
- Basic computer proficiency
- Familiarity with standard operating systems
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
