Oracle SQL for Development and Database Management

• An understanding of relational databases
• Experience with basic SQL queries
• Familiarity with database management concepts

Audience

• Database developers
• Database administrators
• IT professionals working with Oracle databases

Oracle SQL is a powerful tool for database development and management. This course introduces participants to key SQL concepts, focusing on building efficient queries, managing databases, and optimizing data processing in Oracle environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.

By the end of this training, participants will be able to:

• Build and optimize complex SQL queries.
• Manage databases efficiently using Oracle SQL tools.
• Apply best practices in database development and maintenance.
• Administer user access and database security in an Oracle environment.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Database Development

• Recapping the basic principles behind relational databases
  • Concepts and terminology     
• Retrieving data using the SELECT statement
• Using simple and more complex JOINS to retrieve data from multiple tables
  • SELF, INNER and OUTER joins
• Restricting and sorting data, conditional expressions
  • Single row functions: string, date and time manipulation
  • IF-THEN-ELSE statements
• Conversion of data between types
• Creating aggregated reports
• Using correlated and uncorrelated subqueries in SELECT statements
• Retrieving and manipulating data using subqueries
• Running Data Manipulation Statements in Oracle to manage database transactions
• Query optimisation and efficiency

Database Management

• The Oracle Data Dictionary: introduction and usage
• Creating views, indexes, constraints and synonyms
• Controlling and revoking user access to schema objects (tables, views)
• Managing indexes and constraints

Summary and Next Steps