Oracle DBA

Course Overview


Harshitha Technology Solutions is a leading provider of Oracle Database Administration and Developer training for clients across india. We have successfully trained thousands of DBAs and Developers, and will continue to be the measure of excellence for these essential classes in the future. Your HTS instructor will first and foremost be an experienced Oracle professional – someone with years of experience in architecting and implementing Databases, Java, SQL and PL/SQL, APEX, and other foundational technologies.

This course gives students the opportunity to explore and do hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g. The course covers benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of concern for database administrators.

Course Content

  • Oracle for Experienced Users
  • SQL Server Training Course Objective
  • Learn Database models
  • Overview of SQL Server Management Studio and Transact-SQL language
  • Master writing simple and complex queries that retrieve data from the database
  • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
  • Insert, update, and delete data
  • Retrieve data from tables
  • Joins
  • Sub-queries
  • Working with Data Types
  • Procedure and Functions
  • Understand the different Views
  • Working with Triggers
  • Design a database
  • Maintain databases, tables, and sequences with SQL statements
  • Create and manage views
  • Ensure the integrity of multiple, related database updates by using transactions
  • Retrieve data using cursors
  • Manage binary data using BLOBs

Introduction To SQL Server

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
  • Connecting To Server
  • Server Type
  • Server Name
  • Authentication Modes
  • Sql Server Authentication Mode
  • Windows Authentication Mode
  • Login and Password
  • Sql Server Management Studio and Tools In Management Studio
  • Object Explorer
  • Object Explorer Details
  • Query Editor
  • TSQL (Transact Structured Query Language)
  • History and Features of TSQL
  • Types Of TSQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)
  • Database
  • Creating Database
  • Altering Database
  • Deleting Database
  • Constrains
  • Procedural Integrity Constraints
  • Declarative Integrity Constraints
  • Not Null, Unique, Default and Check constraints
  • Primary Key and Referential Integrity or foreign key constraints
  • Data Types In TSQL
  • Table
  • Creating Table
  • Altering Table
  • Deleting Table

Data Manipulation Language

  • Insert
  • Identity
  • Creating A Table From Another Table
  • Inserting Rows From One Table To Another
  • Update
  • Computed Columns
  • Delete
  • Truncate
  • Differences Between Delete and Truncate

Data Query Language (DQL)

  • Select
  • Where clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() function
  • Column aliases
  • Predicates
  • Between … And
  • In
  • Like
  • Is Null

Built In Functions

  • Scalar Functions
  • Numeric Functions
  • Character Functions
  • Conversion Functions
  • Date Functions
  • Aggregate Functions
  • Convenient Aggregate Functions
  • Statistical Aggregate Functions
  • Group By and Having Clauses
  • Super Aggregates
  • Over(partition by …) Clause
  • Ranking Functions
  • Common Table Expressions (CTE)

Top n Clause
Set Operators

  • Union
  • Intersect
  • Except

Joins

  • Inner Join
  • Equi Join
  • Natural Join
  • Non-Equi Join
  • Self Join
  • Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

Sub Queries

  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Any or Some
  • ALL
  • Nested Sub Queries
  • Co-Related Sub Queries
  • Exists and Not Exists

Indexes

  • Clustered Index
  • NonClustered Index
  • Create , Alter and Drop Indexes
  • Using Indexes

Security

  • Login Creation
  • SQL Server Authenticated Login
  • Windows Authenticated Login
  • User Creation
  • Granting Permissions
  • Revoking Permissions
  • Roles

Views

  • Purpose Of Views
  • Creating , Altering and Dropping Indexes
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

Transaction Management

  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction
  • Role Of Log File In Transaction Management
  • Implicit Transactions

TSQL Programming

  • Drawbacks Of TSQL that leads to TSQL Programming
  • Introduction To TSQL Programming
  • Control statements In TSQL Programming
  • Conditional Control Statements
  • If
  • Case
  • Looping Control Statements
  • While

Cursors

  • Working With Cursors
  • Types Of Cursors
  • Forward_Only and Scroll Cursors
  • Static, Dynamic and Keyset Cursors
  • Local and Global Cursors

Stored Sub Programs

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements
  • Stored Procedures
  • Creating , Altering and Dropping
  • Optional Parameters
  • Input and Output Parameters
  • Permissions on Stored Procedures
  • User Defined Functions
  • Creating, Altering and Dropping
  • Types Of User Defined Functions
  • Scalar Functions
  • Table Valued Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions
  • Permissions On User Defined Functions
  • Triggers
  • Purpose of Triggers
  • Differences Between Stored Procedures and User Defined Functions and Triggers
  • Creating, Altering and Dropping Triggers
  • Magic Tables
  • Instead Of Triggers
  • Exception Handling
  • Implementing Exception Handling

Course Training


About Database Training

Harshitha Technology Solutions is a leading provider of Oracle Database Administration and Developer training for clients across india. We have successfully trained thousands of DBAs and Developers, and will continue to be the measure of excellence for these essential classes in the future.

Your HTS technologies instructor will first and foremost be an experienced Oracle professional – someone with years of experience in architecting and implementing Databases, Java, SQL and PL/SQL, APEX, and other foundational technologies.

DBA Training Duration
Normal Track 45 Working days for each course, daily one and half hour.
Weekend Batches(saturday,sunday) 2to3 hours for day total 16 working days.

Prospects

MNC’s are looking for these skills but can’t find enough MCAs and engineers who are trained in this.

Database administrators are in high demandner.Statistics forecasts that the job outlook for DBAs is excellent, with continued growth expected until at least 2018. As a result, DBAs are able to enjoy premium salaries and a wide variety of employment opportunities. While database administration is typically a desk job, the vital nature of databases can make this an exciting yet stressful field.

Successful DBAs must have a variety of IT skills and know their way around both hardware and software. Troubleshooting and strong analytical skills are a must. With high salary ranges and solid long-term prospects, becoming a DBA is a career choice that makes sense in today’s economy.

Trainer Profile


Real Training with Real Time experience. He has around 13 years of Experience in Training,Designing and Implementing the Applications based on DBA.