SQL: Introduction to Query Writing
This course offers end-users a sound background on the concepts of a Relational Database Management System. It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database either directly or through third-party Query and Reporting Tools.
Users who will be querying the corporate database either directly or through third-party Query and Reporting Tools.
There are no particular requirements for this course.
At the end of the course students will be able to:
- Understand the basics of what a database is
- Formulate simple SELECT statements
- Qualify queries using the WHERE clause
- Summarise data using the GROUP BY and HAVING clauses
- Formulate complex queries which span multiple tables
- Gain an appreciation for performance when developing queries
- Gain confidence in developing accurate and efficient SQL queries
Introduction to Databases
- Defining a Databases Management System
- Defining a Relational Database Management System
- Defining Normalisation
- What Does SQL Do?
Basic SELECT Statement
- The SELECT Statement
- Restricting Columns
- Performing Arithmetic Computing
- SQL Functions
- Eliminating Duplicate Rows
- Sorting Data
- The WHERE Clause
- Comparison Operators
- Logical Operators
- Selecting NULL Values
- ANY and ALL Predicates
- String Components
- What is a Join?
- Why We Join Tables?
- How to Get a Good Join
- Formulation of a Join
- Aggregate Functions
- Grouping Data
- Qualifying Groups of Data
- The Having Clause
More Complex SQL
- Exists Predicate
- Outer Joins
- Pattern Matching and String Manipulations
- Handling Date Comparisons and Manipulation