This 1-day SQL Fundamentals of Querying training course provides a suitable Introduction to SQL. Students will learn about the essentials of using the Structured Query Language (SQL) and how SQL will enable them to access data within a database in order to answer business questions.
The course focuses solely on the SQL SELECT command for retrieving data from a Relational Database system such as Microsoft SQL Server, Oracle, MySQL, Sybase, or DB2.
Upon successful completion of this course, students will be able to:
- Define what a relational database is.Identify some uses for the SQL language.
- Recognise and use proper syntax for an SQL statement.
- Use aggregate functions and grouping.
- Apply column aliases, and use mathematical expressions in a query statement.
- Use the WHERE clause to select specific rows of information from a database.
- Search for specific character strings or numeric data in a database.
- Write queries that return both aggregate and non-aggregate information simultaneously.
- Write queries that select information from two tables simultaneously.
- Use inner joins, outer joins, and self-joins.
- Use built-in functions to transform data for output.
- Use a simple sub-query.