COURSE DESCRIPTION
ORACLE Database Introduction to SQL
This Oracle Database 11g : Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Key Learning:
- Introduction to SQL
- 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 the 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
- Managing Data in Different Time Zones
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database.
International Student Fee : 300 USD | 395 CAD | 1,125 AED | 1,125 SAR
Flexible Class Options
- Evening Classes | Workshops | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle Techno Functional Consultant – Oracle Apps R12
Diploma SAP ERP Complete All-in-One Course
Oracle ERP R12 Supplychain Management
R12i Oracle E Business Suite Fundamentals
Oracle E-Business Suite R12 Applications DBA
Oracle Fusion Financials Cloud – 1Z0-408
