Oracle Database 19c: SQL Workshop
This course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
Lecturer:
Jurijs Oļeiņikovs
Gints Plivna
Juris Trošins
Jānis Ozoliņš
Signis Vāvere
Jurijs Oļeiņikovs
Jurijs Oleinikovs is an Oracle infrastructure expert - planning, implementation, maintenance - all stages of the process. The lecturer is an expert in troubleshooting and performance tuning. As a competent professional in the field, he has participated in countless conferences and seminars on the relevant topic. The instructor's knowledge is so extensive that it is impossible to list everything done: Oracle Database Server, Oracle Application Server and server technologies such as Unix (Sun Solaris), Linux (RedHat, Suse), as well as Windows platforms (NT, 2000, XP) and Ms Exchange. Unix/Linux programming, C++, SQL and XHTML/CSS, etc.
Gints Plivna
Gints Plivna works as a data architect at Swedbank. The lecturer has a deep interest in databases, professional experience with relational database management systems (RDBMS) Oracle, Teradata, SQL Server, MySQL, as well as NoSQL DBMS - MongoDB. Instructor of Oracle SQL and PL/SQL certified courses since 2007.
Course target
- Working with Multiple Tables
- Manipulating Data
- Using Advanced SQL Techniques
- Managing Database Objects
- Controlling User Access
- Tuning SQL Statements
Audience
- Developer
- Systems Administrator
At Course Completion
- Retrieve Data using the SQL SELECT Statement
- Restrict and Sort Data
- Customize Output Using Single-Row Functions
- Use Conversion Functions and Conditional Expressions
- Report Aggregated Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Manage Tables by Using DML Statements
- Create Sequences, Synonyms, Indexes, Views, and Schema Objects
- Manage Data by Using Subqueries and Advanced Queries
- Control User Access and Manage Data in Different Time Zones
Prerequisites
Training materials
- Retrieve Data using the SQL SELECT Statement
- Restrict and Sort Data
- Customize Output Using Single-Row Functions
- Use Conversion Functions and Conditional Expressions
- Report Aggregated Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Manage Tables by Using DML Statements
- Create Sequences, Synonyms, Indexes, Views, and Schema Objects
- Manage Data by Using Subqueries and Advanced Queries
- Control User Access and Manage Data in Different Time Zones
Certification Exam
This course helps you prepare for the following Oracle certification exam: Oracle Database SQL Certified Associate
Course outline
- Introduction
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables Using Joins
- Using Subqueries to Solve Queries
- Using Set Operators
- Managing Tables Using DML Statements
- Introduction to Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequences, Synonyms, and Indexes
- Creating Views
- Managing Schema Objects
- Retrieving Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Controlling User Access
- Manipulating Data Using Advanced Queries
- Managing Data in Different Time Zones
If you want to get more information about this course, contact us by phone +371 67505091 or send us an e-mail at mrn@bda.lv.
