Oracle Database 11g SQL Fundamentals...

General Information

Posted on the 11/04/16

Ad details

Oracle Database 11g SQL Fundamentals

Program Summary
This Oracle Database: Introduction to SQL training helps you write sub queries, 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.
Retrieving Data Using the SQL SELECT Statement
• List the capabilities of SQL SELECT statements
• Execute a basic SELECT statement
Restricting and Sorting Data
• Limit the rows that are retrieved by a query
• Sort the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output
• Describe various types of functions available in SQL
• Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions
• Describe various types of conversion functions that are available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
• Identify the available group functions
• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
• Write SELECT statements to access data from more than one table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using outer joins
• Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
• Define subqueries
• Describe the types of problems that the subqueries can solve
• List the types of subqueries
• Write single-row and multiple-row subqueries
Using the Set Operators
• Describe set operators
• Use a set operator to combine multiple queries into a single query
• Control the order of rows returned
Manipulating Data
• Describe each data manipulation language (DML) statement
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions
Using DDL Statements to Create and Manage Tables
• Categorize the main database objects
• Review the table structure
• List the data types that are available for columns
• Create a simple table
• Explain how constraints are created at the time of table creation
• Describe how schema objects work
Creating Other Schema Objects
• Create simple and complex views
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

Program Name : Oracle Database 11g SQL Fundamentals
Training Track : DBA
Duration : 2 Months
For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 3498-OMNI (6664) | M: 03377222191 | 0312216 9325 I03122169321 E: info@omni-academy.com| www.omni-academy.com IFb: www.facebook.com/Omniacademy

Report this ad