You are not Logged in! Log in to check your messages.
Check todays hot jobs or HR Solutions
UNIRAC.IN
Oracle Database SQL Training - Online
Pricing | Duration | Timings | Offers
We offer world class Oracle SQL Online Training.
Actual Price : 12000Rs/- 10000/-
Recommended Experience
None
Related Job Functions
Data analyst
Database administrator
Database developer
Database designer
Power BI
Business Intelligence
Oracle SQL Training Overview
Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language, data modeling and using SQL to create amd manipulate tables in an Oracle Database.
Introduction Relational Database Design Using Oracle- Position the Server Technologies
- Understand Relational Structures
- Create the Demonstration Schemas
- List the Capabilities of SQL SELECT Statements
- Execute a Basic SELECT Statement
- Limit the Rows Retrieved by a Query
- Sort the Rows Retrieved by a Query
- Ampersand Substitution
- Describe Various Types of Functions Available in SQL
- Use Character, Number, and Date Functions in SELECT Statements
- Describe Various Types of Conversion Functions Available in SQL
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Apply Conditional Expressions in a SELECT Statement
- Describe the Group Functions
- Identify the Available Group Functions
- Group Data Using the GROUP BY Clause
- Include or Exclude Grouped Rows Using the HAVING Clause
- Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- Join a Table to Itself Using a Self-Join
- View Data that Does Not Meet a Join Condition Using Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Define Subqueries
- Describe the Types of Problems That the Subqueries Can Solve
- List the Types of Subqueries
- Write Single-Row and Multiple-Row Subqueries
- Describe the Set Operators
- Use a Set Operator to Combine Multiple Queries into a Single Query
- Control the Order of Rows Returned
- Describe Each Data Manipulation Language (DML)Statement
- Inserting rows into a table
- Update rows in a table
- Delete rows in a table
- Control Transactions
- DML Statement Failures
- 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
- Sequences
- Synonyms
- Indexes
- Views
- DCL,TCL commands
- USer Management
Jobs at:
Recruitment:
Job Seekers - Join for Free
15000 Recruiters See your resume.
Employers - Join for Free
Search 2Lakhs Resumes. Post Unlimited Jobs.
Top IT JOBS:
ORACLE DBA /APPDBA /CRM
Required Freshers/3+yrs Oracle DBA Professionals Immediately.
SAP BW/ BI /HR /CRM
Required SAP ABAP,BW/BI Freshers,Exp Immediately for MNC's