Course Oracle SQL Language Basics
SQL (Structured Query Language) is a computer language for manipulating data (DML - selection, insertion, modification a...
SQL (Structured Query Language) is a computer language for manipulating data (DML - selection, insertion, modification and deletion), and for defining database objects (DDL). It also enables database administration and setting rights to objects (DCL). It is currently the most commonly used language of this type in relational database management systems.
Minimum input knowledge
Knowledge of working in MS Windows and some experience with data processing is expected. Previous experience with SQL, Oracle or other databases is not required.
Course dates Oracle SQL Language Basics
Daily courses (3 days): 09:00 - 15:00
Course price: 490.00 / 602.70 EUR
without VAT / incl. VAT
Training syllabus Oracle SQL Language Basics
Introduction to Relational Databases
- Database terminology, principles of relational model design, normalization, database optimization, familiarization with Oracle 10g technology, tools and environment
Introduction to the SQL Language
- SQL standards and Oracle SQL implementation, data types in Oracle databases
DML - Working with Data
- Data selection, basic syntax of the SELECT command, projection - selection of columns and use of column aliases, limiting selected records with the WHERE clause, use of BETWEEN, IN, IS NULL, LIKE operators, sorting records with the ORDER BY clause, eliminating duplicate rows (DISTINCT), creating expressions, use of arithmetic and text operators, grouping data (GROUP BY and HAVING clauses), nested SQL - single-row queries, multi-row queries (ALL, ANY, IN operators), correlated queries, use of pseudocolumns, selecting data from multiple tables in sequence (UNION, UNION ALL), intersection (INTERSECT) and difference (MINUS) of two tables, selecting data by inner (WHERE, INNER JOIN) and outer table join (LEFT, RIGHT and FULL OUTER JOIN), inserting data, direct data insertion into a table (INSERT), inserting data by selection from another table, checking uniqueness of inserted data, modifying data, modifying all rows and selected rows (UPDATE), updating with a constant value, function result, value derived from the original value, value derived from another column of the same table, or value from another table, deleting data, deleting all and selected rows (TRUNCATE, DELETE), deleting duplicate rows, use of functions, single-row functions (numeric functions, functions for working with text, date and time functions, conversion functions), aggregate functions, analytic functions, other functions
DDL - Creating and Modifying Database Structures
- Creating (CREATE TABLE) and changing table structure (ALTER TABLE), creating and changing views (CREATE OR REPLACE VIEW), integrity constraints, materialized views, indexes, sequences, deleting objects (DROP)
Transaction Control
- Committing transactions (COMMIT), rolling back changes (ROLLBACK), creating savepoints (SAVEPOINT)
DCL - Control of Database Objects
- Managing rights to database objects (GRANT, REVOKE)
Output knowledge
Course participants will become familiar with the basic tools and Oracle environment, database terminology and principles, and will gain a comprehensive overview of the SQL language.
Recommended courses after completing Oracle SQL Language Basics
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Oracle SQL Language Basics
Average rating