SQL Introduction

None

This instructor-led, live training (online or onsite) is aimed at providing an introduction of the SQL programme language.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange.

Introduction

• Relational and Object Relational Database Management Systems
• Structured Query Language (SQL)
• Concept of 'Schema' in Oracle Database

SQL Developer

• Overview of using Oracle SQL Developer

Retrieve Data using the SQL SELECT Statement

• Capabilities of SELECT Statement
• Basic SELECT statements
• SELECT all columns
• Column Aliases
• Retrieving Distinct Values
• Introduction to SQL Operators

Restrict and Sort Data

• WHERE clause
• Comparison operators and logical operators
• Rules of precedence for comparison and logical operators
• Character string literals
• Date queries