Name: Structured Query Language(SQL)
Price: 30 GBP
Availability: InStock

Structured Query Language(SQL)

This intermediate SQL course is designed for learners who already understand SQL fundamentals and want to improve their query-writing and database management skills. The course introduces advanced querying techniques, joins, subqueries, set operators, views, indexes, and transaction management.

Course Prerequisites:

Structured Query Language (SQL) - Beginner Course

What you will learn?

1. SQL Fundamentals Review

Review of SELECT queries
Filtering and sorting
Aggregate functions
Joins recap

2. Advanced Joins

Self joins
Cross joins
Multiple table joins
Complex join conditions

3. Subqueries

Single-row subqueries
Multiple-row subqueries
Correlated subqueries
Nested subqueries

4. Set Operators

UNION
UNION ALL
INTERSECT
MINUS / EXCEPT

5. Advanced Functions

CASE expressions
COALESCE
NULLIF
Conditional logic in SQL

6. Working with Dates and Time

Date calculations
Formatting dates
Extracting date parts

7. Database Constraints

Advanced constraint management
Altering constraints
Referential integrity

8. Views

Creating views
Updating views
Complex views
Materialized views basics

9. Indexes

What are indexes?
Creating indexes
Unique indexes
Performance basics

10. Transactions

COMMIT
ROLLBACK
SAVEPOINT
Transaction control

11. SQL Performance Basics

Query optimization basics
Reading execution plans
Avoiding common mistakes

12. Data Import and Export

Importing CSV data
Exporting query results

13. Real-World SQL Scenarios

Sales database queries
HR database reporting
Inventory management queries

14. Intermediate SQL Project

Multi-table database project
Reporting system queries
Business analytics queries

Join us: to stay updated on new courses, discounts, free learning opportunities, and more

Join us toGrow Skills,together!

Get Updates