Oracle Database 23ai: Introduction to SQL Workshop
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. 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
«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.»
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
About the instructor Cuneyt Yilmaz
Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB and PostgreSQL.
Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed!
Audience:
- Database Administrator
- Developer
Prerequisites:
- Familiarity with data processing concepts and techniques
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
