Oracle Database 12c: SQL I – Introduction
Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This textbook introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform.
Since SQL is an industry standard language, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms, such as Microsoft SQL Server, IBM DB2, the open-source databases MySQL and PostgreSQL, and others.
This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
The first portion of this course considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data.
No prerequisites needed, although some affinity with the Oracle Database and Oracle SQL is recommended.
Relational Databases & Data Models
Selection & Setup Of The Database Interface
Using The Database Interface
Introduction To The SQL Language
The SELECT statement
Restricting results with the WHERE clause
Sorting data with the ORDER BY clause
Pseudo columns, Functions & TOP N Queries
Using the SET operators
Aggregating data within groups
Use DDL to create and manage tables
Use DML to manipulate Data
The Exam Oracle SQL Expert exam 1Z0–047 is retired on July 31, 2017. The suggested alternative is 1Z0-071 to earn the Oracle Database SQL Certified Associate Certification.
This training prepares you for the Oracle Database 12c: SQL II - Intermediate course.
Note that this course is a recommended prerequisite for Oracle Database 12c: PL/SQL I - Introduction.
Next training dates
15 to 17 January 2019
13 to 15 March 2019
13 to 15 May 2019
3 to 5 July 2019
2.250 EUR (VAT excluded) per person
From 9 AM to 5 PM
De Villermontstraat 9
This training in-company?
Upon your request we can organize this training for you.