DBA Training

Oracle SQL

(0 review)
Free
oracle_sql

                                       ORACLE SQL TRAINING

COURSE OVERVIEW

Oracle SQL also known as structured query language is a database language to manage data in relational databases. SQL provides an easy and efficient way to access and maintain data. Tamil Technologies provides best SQL training in Chennai. Our SQL training course in Chennai gives you the understanding of database entity, data normalization and the basic functions which is been used in any DBMS. Oracle SQL is one of the best available DBMS which is further separated into two different tracks i.e. PLSQL in development track and DBA in Administration track. It is useful for any Programmer or Tester to get a better understanding of their work and technology.

COURSE FEATURES

  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Missed Sessions Covered
  • Multiple Batches
  • Flexible Timings
  • Practice Course Material
  • Assistance will be provided for Oracle certification.

 

PREREQUISITES:

  • Basic Computer Fundamental Skills

 

DURATION:  30 Hours

WHO CAN JOIN THIS COURSE?

  • Individuals who want to become DBA

 

ORACLE SQL TRAINING SYLLABUS

 

Writing Basic SQL SELECT Statements

    • SQL Overview
    • Arithmetic Expressions
    • NULL Value
    • Column Alias
    • Concatenation Operator
    • Literals
    • Eliminating Duplicate Rows

Restricting and Sorting Data

    • WHERE clause
    • Logical Operators
    • SQL Operators
    • LIKE Operator
    • AND, OR and NOT Operators
    • ORDER BY Claus

Row Functions

    • Character Functions
    • Number Functions
    • Date Functions
    • Conversion Functions
    • General Functions

Displaying Data from Multiple Tables

    • Types of Joins in Oracle
    • SQL Joins

Aggregating Data Using Group Functions

    • Group Functions
    • Group By Clause
    • HAVING Clause

Subqueries

    • Single Row subqueries
    • Multiple Row Subqueries
    • Correlated Subqueries

Manipulating DataManipulating Data

    • INSERT Statement
    • UPDATE Statement
    • DELETE Statement
    • MERGE Statement
    • Transaction Control
    • Locks

Creating and Managing Tables

    • Data Definition Language
    • Data Types
    • CREATE TABLE Statement
    • ALTER TABLE Statement
    • Rename an Object
    • Comments

Including Constraints

    • Primary Constraints
    • FOREIGN KEY Constraint
    • NOT NULL Constraint
    • UNIQUE Constraint
    • CHECK Constraint
    • ALTER statement
    • Dropping a constraint
    • Disabling Constraints
    • Enabling Constraints
    • Cascading Constraints
    • Viewing Constraint

Views

    • Creating a View
    • Retrieving Data from a View
    • Modifying a View
    • Destroying a View
    • User‐View

Other Database Objects

    • Sequence
    • Index
    • Synonyms

Controlling User Access

    • Privileges
    • System Privileges
    • Object Privileges
    • Role

Using SET Operators

    • UNION Operator
    • UNION ALL Operator
    • INTERSECT Operator
    • MINUS Operator

Oracle Datetime Functions

    • Oracle 9i Date time Support
    • CURRENT_DATE
    • CURRENT_TIMESTAMP
    • LOCALTIMESTAMP
    • DBTIMEZONE and SESSIONTIMEZONE
    • EXTRACT
    • FROM_TZ
    • TO_TIMESTAMP and TO_TIMESTAMP_TZ
    • TO_YMINTERVAL & TZ_OFFSET

 

Course Features

  • Students 0 student
  • Max Students1000
  • Duration10 week
  • Skill levelall
  • LanguageEnglish
  • Re-take courseN/A
Curriculum is empty

Instructor

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Related Courses