An Intensive 5-day Training Course
Oracle Database 19c: Introduction to SQL
Querying, Manipulating and Managing Data with SQL in Oracle Database 19c
CLASSROOM DATES
INTRODUCTION
This highly participative training course will help participants cultivate a thorough, practical command of SQL in Oracle Database 19c, from writing your first query to building sophisticated multi-table statements. Through hands-on practice you will learn to retrieve, restrict, sort and transform data, combine information from multiple tables, and summarise results using aggregate functions. The course balances a clear understanding of relational concepts with abundant practical exercises, giving you the confidence to work effectively with Oracle data in development, reporting and administrative contexts.
This EuroMaTech training course will help you to cultivate fluency not only in querying data but also in manipulating and defining it. You will practise inserting, updating and deleting rows, creating and managing tables and other schema objects, and controlling transactions reliably. Working throughout in Oracle Database 19c with realistic datasets, you will leave able to write clear, correct and efficient SQL and to apply it confidently to everyday data tasks across a wide range of business and technical roles.
Course Highlights
- Write SQL queries to retrieve, filter and sort data
- Use single-row and aggregate functions to transform data
- Join data from multiple tables and use subqueries
- Insert, update and delete data and manage transactions
- Create and manage tables, views and other schema objects
- Apply Oracle Database 19c SQL features in practice
TRAINING OBJECTIVES
This Oracle Database 19c training course aims to enable participants to achieve the following objectives:
- Write SELECT statements to retrieve and restrict data
- Sort, format and transform data using SQL functions
- Aggregate data and group results meaningfully
- Join multiple tables and construct subqueries
- Manipulate data using INSERT, UPDATE and DELETE
- Create and manage tables, views and schema objects
WHO SHOULD ATTEND?
This EuroMaTech training course is designed specifically for those professionals who are working with Oracle databases and who need practical SQL skills to query, manipulate and manage data in Oracle Database 19c.
- Application developers working with Oracle databases
- Data analysts and report writers
- Database administrators and support staff
- Business intelligence and ETL developers
- Technical professionals new to Oracle SQL
- Anyone needing a practical foundation in Oracle SQL
TRAINING METHODOLOGY
This training course will combine presentations with interactive practical exercises, supported by video materials, activities and case studies. Delegates will be encouraged to participate actively in relating the principles of SQL and relational database concepts to their own data and reporting needs. The blended approach reinforces learning through hands-on query labs, worked examples and discussion, ensuring each technique is both understood and ready to apply on return to the workplace.
TRAINING SUMMARY
This Oracle Database 19c training course provides a comprehensive, hands-on introduction to SQL in Oracle Database 19c, suitable for developers, analysts and administrators alike. Beginning with the fundamentals of the relational model and the SELECT statement, participants progress through filtering, sorting, single-row and aggregate functions, multi-table joins and subqueries. The programme then extends to data manipulation and definition, covering INSERT, UPDATE and DELETE, transaction control, and the creation and management of tables, views and other schema objects. With extensive practical exercises on realistic datasets, delegates finish able to write clear, correct and efficient Oracle SQL for everyday data tasks.
TRAINING OUTLINE
Day 1: Getting Started with Oracle SQL
- The relational model and Oracle 19c architecture
- Tools for running SQL: SQL Developer and SQL*Plus
- Writing basic SELECT statements
- Column aliases, expressions and concatenation
- Lab: your first queries against sample schemas
Day 2: Restricting and Sorting Data
- Filtering rows with the WHERE clause
- Comparison, logical and range operators
- Pattern matching and handling NULLs
- Sorting results with ORDER BY
- Lab: retrieving precise result sets
Day 3: Functions and Grouping
- Single-row functions for characters and numbers
- Working with dates and conversion functions
- Conditional expressions with CASE and DECODE
- Aggregate functions and the GROUP BY clause
- Lab: transforming and summarising data
Day 4: Joins and Subqueries
- Equijoins, non-equijoins and outer joins
- ANSI join syntax in Oracle
- Single-row and multiple-row subqueries
- Set operators: UNION, INTERSECT and MINUS
- Lab: combining data from multiple sources
Day 5: Manipulating and Defining Data
- Inserting, updating and deleting rows
- Transaction control with COMMIT and ROLLBACK
- Creating and managing tables and constraints
- Creating views and other schema objects
- Capstone query project and individual action planning
CALL ME BACK
Do you wish for us to conduct this course at your premises?
Discover In-House Solutions
ACCREDITATION
EuroMaTech is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.
FAQ
We are happy to share the profiles of our expert instructors. To learn more about their qualifications and experience, please contact us info@euromatech.com
We provide flexible training formats to suit your preferences:
- Classroom Training: Experience in-person learning with expert instructors. Engage in interactive discussions, hands-on activities, and benefit from face-to-face networking.
- Online Training: Join live online sessions from anywhere, offering flexibility for those with busy schedules or who prefer remote learning.
- In-House Training: We can bring our training directly to your organization, allowing for tailored sessions that address your specific needs and objectives.
Yes, we provide tailored training solutions designed to meet the specific needs of your organization. Customized courses can be delivered either in-person or online, and you can select the dates and duration that best fit your schedule. For more details, please contact us at inhouse@euromatech.com
Yes, we can assist you with the following:
- Corporate Discount: If available, we can extend our corporate discount for your stay at selected hotels.
- Hotel Suggestions: We can provide recommendations for nearby hotels based on your preferences and budget.
Feel free to explore online booking platforms for the most cost-effective options.
