Course duration
- 2 days
Course Benefits
- History of SQL and relational databases.
- Structure of relational databases.
- PostgreSQL.
- Our database.
- SQL comments.
- SQL syntax.
- Selecting all rows from a table.
- Sorting record sets.
- Filtering record sets.
- Retrieving a portion of the rows generated by a query.
- Retrieving calculated values.
- Aggregate functions and grouping.
- SQL's data manipulation functions.
- Subqueries.
- Joins.
- Unions.
- The CASE statement.
- Inserting new records.
- Updating records.
- Deleting records.
- Creating a database with pgAdmin.
- Creating tables.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Learn at your own pace with 24/7 access to an On-Demand course.
Course Outline
- Relational Database Basics
- Brief History of SQL
- Relational Databases
- PostgreSQL
- Simple SELECTs
- Introduction to the Jokes Database
- Some Basics
- SELECTing All Columns in All Rows
- Running Queries in pgAdmin
- Exercise: Exploring the Tables
- SELECTing Specific Columns
- Exercise: SELECTing Specific Columns
- Sorting Records
- Exercise: Sorting Results
- The WHERE Clause and Logical Operator Symbols
- Exercise: Using the WHERE Clause to Check for Equality or Inequality
- Checking for Greater or Less Than
- Exercise: Using WHERE to Check for Greater or Less Than
- Checking for NULL
- Exercise: Checking for NULL
- WHERE and ORDER BY
- Exercise: Using WHERE and ORDER BY Together
- Checking Multiple Conditions with Boolean Operators
- Exercise: Writing SELECTs with Multiple Conditions
- The WHERE Clause and Logical Operator Keywords
- Exercise: More SELECTs with WHERE
- Advanced SELECTs
- LIMIT and OFFSET
- Calculated Fields
- Exercise: Calculating Fields
- Aggregate Functions and Grouping
- Exercise: Working with Aggregate Functions
- Selecting Distinct Records
- Built-in Data Manipulation Functions for Math and Strings
- Exercise: Data Manipulation Functions for Math and Strings
- Date/Time Types, Operators, and Functions
- Exercise: Date/Time Manipulation
- Subqueries, Joins and Unions
- Subqueries
- Exercise: Subqueries
- Joins
- Exercise: Using Joins
- Outer Joins
- Exercise: Using Outer Joins
- Unions
- Exercise: Working with Unions
- Conditional Processing with CASE
- Using CASE
- Exercise: Working with CASE
- Inserting, Updating and Deleting Records
- INSERT
- Exercise: Inserting Records
- UPDATE
- DELETE
- Exercise: Updating and Deleting Records
- Creating Tables
- Creating a Database with pgAdmin
- How to Create Tables
- Exercise: Creating Tables
- CASCADE and RESTRICT
- Exercise: Using CASCADE
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.