Certificate ID:
718899
Authentication Code:
9d6f5
Certified Person Name:
Shauna McDaid
Certified Person Email:
Trainer Name:
Philip Isham
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Introduction
Course Date:
16 May 2023 09:30 to 17 May 2023 16:30
Course Outline:
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
Certificate Sent:
Certificate Sent