Introduction to SQL on Oracle Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais.The Introduction to SQL on Oracle course is designed to give delegates practical experience in using SQL.Exercises and examples Introduction to SQL on Oracle Training Course Course Contents - DAY 1 Session 1: RELATIONAL DATABASE CONCEPTS What is an Oracle Database Relational Database Structures Tables,Rows and Columns Indexes,Primary Keys and Foreign Keys Data Types The Data Dictionary Session 2: USING SQL*PLUS What is SQL*Plus Getting Started Entering and Executing SQL Statements The SQL*Plus Command Line History Editing SQL Statements The login.sql File Creating,Editing and Executing SQL Files The SQLcl Utility Session 3: USING SQL DEVELOPER What is Oracle SQL Developer Starting SQL Developer Configure a Connection Navigation Tabs SQL Worksheet Query Builder Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT The SELECT Statement The SELECT and FROM Clauses
