We provide virtual workshop in english about Oracle Database 23ai: Introduction to SQL. This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language.
Course description:
It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects. You'll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.
Versions supported: 23ai, 21c, 19c
In this course you will learn to:
• 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
Course topics:
• Lesson 1: Course Overview
• Lesson 2: Oracle Database 23ai SQL Enhancements
• Lesson 3: Introduction to SQL and Database Concepts
• Lesson 4: Retrieving Data using SQL SELECT
• Lesson 5: Restricting and Sorting Data
• Lesson 6: Using Single-Row Functions to Customize Output
• Lesson 7: Using Conversion Functions and Conditional Expressions
• Lesson 8: Reporting Aggregated Data Using Group Functions
• Lesson 9: Displaying Data from Multiple Tables Using Joins
• Lesson 10: Using Subqueries to Solve Queries
• Lesson 11: Using Set Operators
• Lesson 12: Managing Tables Using DML Statements
• Lesson 13: Introduction to Data Definition Language
• Lesson 14: Introduction to Data Dictionary Views
• Lesson 15: Creating Sequences, Synonyms, and Indexes
• Lesson 16: Creating Views
• Lesson 17: Managing Schema Objects
• Lesson 18: Retrieving Data by Using Subqueries
• Lesson 19: Manipulating Data by Using Subqueries
• Lesson 20: Controlling User Access
• Lesson 21: Manipulating Data Using Advanced Queries
Target audience:
Database administrator and developer
Prerequisites:
• Familiarity with data processing concepts and techniques
Language:
• English course material, english speaking instructor
Course material:
Digital course documentation and hands-on exercises
Uttalelse fra fornøyd kursdeltaker:
After many years of school and different courses I have seen my fair share of teachers and instructors. Cuneyt is hands down the best I have ever had. From his knowledge and understanding of the subject to his ability to get me to understand - he was just amazing. No complaints only praise.
- Course delegate