SQL Querying

Expand all

Course Description

In this SQL Querying course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, understanding indexes and avoid common errors and pitfalls.

This one-day, hands-on course is designed to help participants master the SELECT statement and explore various SQL techniques for querying Microsoft SQL Server databases. The course will focus on the best practices for writing robust queries, testing them for performance, understanding how indexes work, and avoiding common errors. Participants will also learn how to handle common tasks like filtering, sorting, and working with multiple tables. By the end of the course, attendees will be able to write optimized queries and effectively manage data retrieval from SQL Server for reporting and system development purposes.

Course Highlights:

•     Writing and optimizing SQL SELECT queries.
•     Working with SQL Server data types and metadata.
•     Performing complex operations like JOINs, UNIONs, and subqueries.
•     Understanding SQL indexes, execution plans, and best practices for query performance.
•     Working with SQL CASE, ISNULL, and date functions to manipulate data.

 

Course Outline

Module 1: Getting Started

• Tools for Getting Started
• Connecting to a Microsoft SQL Server
• Writing Queries
• Database Components
• SQL Server Data Types
• Querying SQL Server Metadata

Module 2: SQL Server Queries

• SQL Statements
• SQL DML and DDL
• USE Statement
• The SQL SELECT Statement
• The SQL SELECT DISTINCT Statement
• The WHERE Clause
• SQL Operators
• ORDER BY Clause
• The LIKE condition IN
• BETWEEN ... AND
• Column Aliases
• Working with Dates
• ISNULL function
• SQL CASE Expression
• The SELECT INTO Statement
• Creating temporary tables
• Automatically generate a SELECT statement

Module 3 Executing Queries and Performance

• Index Structures
• Evaluating Execution Plans
• Best Practices

Module 4: Querying Multiple tables

• Join and Keys
• Types of Joins
• Using SQL LEFT JOIN and SQL RIGHT JOIN
• UNION
• UNION ALL
• INTERSECT
• EXCEPT
• Using APPLY

 

Exam

N/A

Ways to Attend

• Join one of our instructor-led live online courses. See our Schedule for details.
• We can also organise private team training, and design a programme to suit your exact business requirements. Training can be delivered both onsite at a location of your choice, or live online for you, anywhere in the world. Why not contact us, we would be delighted to discuss your training needs with you.