Writing SQL Queries Training
Course Outline
Attend this Writing SQL Queries course and learn the essentials of the SQL language used by all relational database products. In this course, you gain the knowledge and skills to write SELECT statements for data retrieval. This SQL query writing course is intended for users and developers who are new to the technology and interested in getting started with the SQL language.
Writing SQL Queries Training Benefits
-
In this course, you will learn how to:
- Write SQL SELECT statements based on ANSI/ISO standards to retrieve data from relational databases
- Identify the fundamental database building blocks
- Apply filter conditions to extract specific data
- Combine multiple tables with different types of joins
-
Prerequisites
You should have familiarity with basic programming and database concepts a the level of:
- Learning Tree course 382, Relational Database Design Training: Tools and Techniques
Important Writing SQL Queries Course Outline
Training Modules
- Retrieving data from tables
- Applying conditions to filter retrieved rows
- Joining multiple tables
- Sorting query results
- choosing a selection results in a full page refresh