SQL: Basics to Intermediate

• An understanding of basic computer operations
• Experience with any programming language is beneficial but not required

Audience

• Data analysts
• Database professionals
• Software developers

SQL is the standard language for relational database management systems.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.

By the end of this training, participants will be able to:

• Understand and use fundamental SQL commands and queries.
• Create and manipulate tables and databases.
• Use SQL to sort, filter, and summarize data.
• Implement more complex operations like joins, subqueries, and set operations.
• Apply intermediate techniques such as indexes, views, stored procedures, and triggers.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Part 1: SQL Basics

Introduction to SQL and Databases

• Understanding databases
• Introduction to SQL
• Setting up the SQL environment

SQL Syntax and Basic Queries

• SQL syntax overview
• SELECT statements
• Filtering data with WHERE clause

Working with Functions and Aggregates

• Common SQL functions
• Aggregate functions: COUNT, SUM, AVG, MAX, MIN
• Grouping data with GROUP BY

Joining Tables

• Understanding JOINs
• INNER JOIN
• LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN

Subqueries and Set Operations

• Writing subqueries
• UNION, INTERSECT, and EXCEPT operations

Data Manipulation

• INSERT INTO statement
• UPDATE statement
• DELETE statement

Part 2: Intermediate SQL

Advanced Data Filtering

• Advanced WHERE clause techniques
• LIKE operator and pattern matching
• IN and BETWEEN operators

Complex Joins and Subqueries

• Self-joins
• Non-correlated and correlated subqueries
• EXISTS clause

Working with Indexes and Views

• Understanding indexes and their impact on performance
• Creating and using views

Advanced Functions and Stored Procedures

• User-defined functions
• Stored procedures and triggers
• Error handling in SQL

Data Transformation and Analysis

• Pivoting and unpivoting data
• Window functions: ROW_NUMBER, RANK, DENSE_RANK
• CTEs (Common Table Expressions)

Database Design and Normalization

• Database design principles
• Normal forms and normalization
• Entity-Relationship (ER) modeling

Performance Tuning and Optimization

• Query optimization techniques
• Execution plans
• Performance tuning best practices

SQL in the Real World

• Integrating SQL with other technologies
• Case studies and real-world scenarios
• Final project: Building a database solution from scratch

Summary and Next Steps