Duration
Querying Relational Database Using SQL
2 days
Outline
This course provides participants with a comprehensive introduction to SQL (Structured Query Language) and its application for querying relational databases. Participants will learn fundamental SQL concepts, syntax, and techniques for retrieving, manipulating, and analysing data stored in relational database management systems (RDBMS).
Prerequisite
- Basic Computer Skills
- Familiarity with Database Concepts is an added advantages
Course Objectives
- To provide participants with a comprehensive understanding of SQL fundamentals and advanced querying techniques.
- To equip participants with the necessary skills to query relational databases effectively.
- To enable participants to manipulate data within a database using SQL commands.
- To familiarize participants with optimization techniques for improving query performance.
Course Suitability
This course is suitable for individuals who want to gain a strong foundation in SQL querying techniques and relational database management. It is ideal for:
- Beginners
- Database Administrators
- Data Analysts
- Software Developers
- IT Professionals
- Beginners
- Students
- Career Switchers
Methodology
Interactive Lecture and Practical Work with PowerPoint slide and MSSQL/MySQL Server
Training Outcome
- Participants will gain a solid understanding of SQL fundamentals and advanced querying techniques.
- Participants will be able to write SQL queries to retrieve, filter, and sort data from relational databases.
- Participants will acquire skills to manipulate data within a database using SQL commands such as INSERT, UPDATE, and DELETE.
- Participants will learn optimization techniques to improve query performance, enhancing their ability to work efficiently with databases.
Day 1: Fundamentals of SQL and Basic Querying
Morning Session: Understanding SQL Basics
- Introduction to SQL
- Definition and purpose
Importance of SQL in database management
- Relational Databases Overview
- Understanding tables, rows, and columns
Primary keys and foreign keys
- SQL Syntax Fundamentals
- Basic SQL commands: SELECT, INSERT, UPDATE, DELETE
- Data types in SQL: VARCHAR, INT, DATE, etc.
Creating and dropping databases and tables
Afternoon Session: Basic Querying
- Retrieving Data with SELECT Statement
- Syntax of SELECT
- Retrieving all columns vs. specific columns
- Using aliases for column names
- Filtering Data with WHERE Clause
- Basic comparison operators: =, <, >, <=, >=, <>
- Using logical operators: AND, OR, NOT
- Filtering with NULL values
- Sorting Results with ORDER BY Clause
- Sorting data in ascending and descending order
- Sorting by multiple columns
Day 2: Advanced Querying and Data Manipulation
Morning Session: Advanced Querying Techniques
- Joining Tables
- Understanding different types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Using aliases for table names
- Handling NULL values in joins
- Aggregating Data with GROUP BY and HAVING
- Grouping data with GROUP BY clause
- Filtering grouped data with HAVING clause
- Using aggregate functions: COUNT, SUM, AVG, MAX, MIN
- Subqueries and Derived Tables
- Understanding subqueries and their syntax
- Correlated vs. non-correlated subqueries
- Using derived tables for complex queries
Afternoon Session: Data Manipulation and Optimization
- Modifying Data with INSERT, UPDATE, DELETE
- Inserting new records into tables
- Updating existing records
- Deleting records from tables
- Transaction Management
- Understanding transactions and their properties: ACID
- Committing and rolling back transactions
- Optimizing Queries
- Understanding query optimization techniques
- Indexing for performance improvement
- Avoiding common performance pitfalls Conclusion and Review
- Summary of key concepts covered during the training
- Q&A session to address any remaining doubts or questions
- Distribution of training materials and resources for further learning
Programme scope, delivery arrangements and suitability are confirmed during enquiry.