Oracle Developer Training in Gurgaon

What you will learn
Learn the SQL essentials using SQL Developer on Linux. This course offers students an introduction to Oracle Database 10g database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. Demonstrations and hands-on practices reinforce the fundamental concepts. In this course, students use Oracle SQL Developer on Linux as the main development tool.

    1. Learn to:
  • Use SQL Statements to retrieve data from tables
  • Create and Manage Tables
  • Employ SQL functions to generate and retrieve customized data
  • Run data manipulation statements (DML) to update data in the
  • Oracle Database 11g
  • 2. Duration: 24 Hrs
  • Application Developers
  • Business Intelligence Developer
  • Database Administrators
  • Database Designers
  • End Users
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • 3. SQL Fundamentals Course Topics
  • Introduction
  • List the Oracle Database 11g Main
  • Features An Overview of: components, internet platform, app server and
  • developer suite
  • Describe Relational and Object Relational Database Designs
  • Review the System Development Life Cycle
  • Define the term Data Models
  • Describe different means of Sorting Data
  • Show how Multiple Tables can be related
  • Describe how SQL Communicates to the Database
    4. Writing SQL SELECT statements
  • Define projection, selection, and join terminology
  • Review the basic SQL SELECT statement syntax
  • Select all columns using a wildcard notation from a table
  • State simple rules and guidelines for writing SQL statements
  • Write a query containing the arithmetic operators
  • Use aliases to customize column headings
  • Create a character expression with the concatenation operator
  • Use the quote operator q to control text strings containing the quote character
  • 5. Using the Oracle SQL Developer Environment
  • Creating a Database Connection
  • Browsing Database Objects
  • Using the SQL Worksheet
  • Executing SQL Statements
  • Formatting the SQL Code
  • Saving SQL Statements
  • Running Script Files
  • 6. Restricting Data
  • Limit Rows Using a Selection
  • Use the WHERE Clause
  • List the main Comparison Conditions
  • Use the LIKE Condition to Compare Literal
  • Values List the Logical Conditions AND, OR, NOT
  • Use Multiple Conditions in the WHERE clause
  • Describe the Rules of Precedence
  • 7. Sorting Data
  • Sorting Rows with the ORDER BY Clause
  • Use the && Substitution Variable
  • Use the VERIFY Command
  • 8. SQL Functions

    Differentiate between Single Row and Multiple Row SQL Functions Categorize the Character Functions into Case Manipulation and Character Manipulation types Explain the Numeric Functions ROUND, TRUNC, and MOD List the Rules for Applying the Arithmetic Operators on Dates Use the Arithmetic Operators with Dates in the SELECT Clause Explain the DATE functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY, ROUND, and TRUNC Explain Implicit and Explicit conversion Nest Functions to Perform Multiple Tasks in One Statement

    9. Conditional Expressions
  • Use the CASE Expression
  • Explain the DECODE Expression

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Branch Office

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website