Oracle Training – Techienest

Oracle Training

oracle training in jaipur

Oracle Training

Introduction to Oracle Training in Jaipur

Attend the Oracle training in Jaipur/Hyderabad/Noida with Techienest training Institute, that is valuable for B Tech students. And experience the basic programming concepts and relational databases that will be helpful to your bright future. The Windows Operating System and Computer Fundamentals are very useful to get knowledge is an advantage.

Our Training Program Details

[ult_tab_element tab_style=”Style_3″ tab_animation=”Slide-Horizontal” tab_title_color=”#333333″ tab_background_color=”#ededed” tab_hover_title_color=”#ededed” tab_hover_background_color=”#333333″ acttab_title=”#ffffff” acttab_background=”#c5202e” tabs_border_radius=”0″ tab_describe_color=”#333333″ enable_bg_color=”#fcfcfc” container_border_style1=”border-style:none;|border-width:1px;border-radius:3px;|border-color:#e2e2e2;” title_font_style=”font-weight:bold;” title_font_size=”desktop:16px;” main_heading_font_family=”font_family:|font_call:”][single_tab icon=”Defaults-list-alt” title=”Course” tab_id=”course”]
Oracle Training
Course : Oracle 
Certification By : TechieNest, An ISO 9001:2008 Certified Company
Study Material : Book free to each participant (Soft Copy)
Fee :
INR 10000/- + Taxes
Duration : 30 Days

Course Details

 

DATA  NETWORKING
DAY TOPIC DURATION
Day 1

Introduction

  • Listing the features of Oracle Database 11g
  • Discussing the basic design, theoretical and physical aspects of a relational database
  • Describing the development environments for SQL
  • Describing Oracle SQL Developer
  • Describing the data set used by the course
 2 Hours
Day 2

Retrieving Data Using the SQL SELECT Statement 

  • Listing the capabilities of SQL SELECT statements.
  • Generating a report of data from the output of a basic SELECT statement
  • Using arithmetic expressions and NULL values in the SELECT statement
  • Using Column aliases
  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Displaying the table structure using the DESCRIBE command
 2 Hours
Day 3 Restricting and Sorting Data 

  • Writing queries with a WHERE clause to limit the output retrieved
  • Using the comparison operators and logical operators
  • Describing the rules of precedence for comparison and logical operators
  • Using character string literals in the WHERE clause
  • Writing queries with an ORDER BY clause to sort the output
  • Sorting output in descending and ascending order
  • Using the Substitution Variables
 2 Hours
Day 4

Using Single-Row Functions to Customize Output 

  • Differentiating between single row and multiple row functions
  • Manipulating strings using character functions
  • Manipulating numbers with the ROUND, TRUNC and MOD functions
  • Performing arithmetic with date data
  • Manipulating dates with the date functions
 2 Hours
Day 5

Using Conversion Functions and Conditional Expressions

  • Describing implicit and explicit data type conversion
  • Nesting multiple functions
  • Applying the NVL, NULLIF, and COALESCE functions to data
  • Using conditional IF THEN ELSE logic in a SELECT statement
 2 Hours
Day 6

Reporting Aggregated Data Using the Group Functions

Using the aggregation functions in SELECT statements to produce meaningful reports

  • Using AVG, SUM, MIN, and MAX function
  • Handling Null Values in a group function
  • Creating queries that divide the data in groups by using the GROUP BY clause
  • Creating queries that exclude groups of date by using the HAVING clause
 2 Hours
Day 7

Displaying Data From Multiple Tables

  • Writing SELECT statements to access data from more than one table
  • Joining Tables Using SQL:1999 Syntax
  • Viewing data that does not meet a join condition by using outer joins
  • Joining a table by using a self join Creating Cross Joins
 2 Hours
Day 8

Using Sub-queries to Solve Queries

  • Using a Subquery to Solve a Problem
  • Executing Single-Row Sub-queries
  • Using Group Functions in a Sub-query
  • Using Multiple-Row Subqueries
  • Using the ANY and ALL Operator in Multiple-Row Sub-queries
 2 Hours
Day 9

Using the SET Operators

  • Describing the SET operators
  • Using a SET operator to combine multiple queries into a single query
  • Using UNION, UNION ALL, INTERSECT, and MINUS Operator
  • Using the ORDER BY Clause in Set Operations
 2 Hours
 Day 10

Manipulating Data

  • Adding New Rows to a Table Using the INSERT statement
  • Changing Data in a Table Using the UPDATE Statement
  • Using DELETE and TRUNCATE Statements
  • Saving and discarding changes with the COMMIT and ROLLBACK statements
  • Implementing Read Consistency
  • Using the FOR UPDATE Clause

Using DDL Statements to Create and Manage Tables

  • Categorizing Database Objects
  • Creating Tables using the CREATE TABLE Statement
  • Describing the data types
  • Describing Constraints
  • Creating a table using a subquery
  • Altering and Dropping a table
  2 Hours
 Day 11

Creating Other Schema Objects

  • Creating, modifying, and retrieving data from a view
  • Performing Data manipulation language (DML) operations on a view
  • Dropping a view
  • Creating, using, and modifying a sequence
  • Creating and dropping indexes
  • Creating and dropping synonyms
  2 Hours
 Day 12

Exploring the Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Interacting with an Oracle Database
  • Process Architecture
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Tablespaces and Data Files
  • SYSTEM and SYSAUX Tablespaces
  • Segments, Extents, and Blocks
  2 Hours
 Day 13

Preparing the Database Environment

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Database Configuration Options
  • Advanced Installation Options

Creating an Oracle Database

  • Planning the Database
  • Configuring the Listener
  • Using the DBCA to Create a Database
  • Password Management
  • Using the DBCA to Delete a Database
  • Using DBCA For Additional Tasks
  2 Hours
 Day 14

Managing the Oracle Instance

  • Initialization Parameter
  • Database Startup and Shutdown
  • Shutdown Modes
  • Viewing the Alert History
  • Using Trace Files
  • Data Dictionary: Overview
  2 Hours
 Day 15

Configuring the Oracle Network Environment

  • Oracle Net Services & Listener
  • Establishing Net Connections
  • Tools for Configuring and Managing the Oracle Network
  • Net Services Administration Pages
  • Naming Methods
  • Directory Naming

Managing Database Storage Structures

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  2 Hours
 Day 16

Administering User Security

  • Database User Accounts
  • Predefined Accounts: SYS and SYSTEM
  • Administrator Authentication
  • Benefits of Roles
  • Predefined Roles
  • Implementing Password Security Features
  • Assigning Quota to Users

Managing Schema Objects

  • What Is a Schema?
  • Accessing Schema Objects
  • Specifying Data Types in Tables
  • Creating and Modifying Tables
  • Understanding Data Integrity
  • Indexes & Views
  • Sequences
  • Temporary Tables
  2 Hours
 Day 17

Managing Data and Concurrency

  • Resolving Lock Conflicts Using SQL
  • Deadlocks

Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Using the Undo Advisor

Backup and Recovery Concepts

  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Media Failure
  • Archive Log Files
  2 Hours
 Day 18

Performing Database Backups

  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
  2 Hours
 Day 19

Performing Database Recovery

  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views
  2 Hours
 Day 20

Moving Data

  • Moving Data: General Architecture
  • Directory Object: Overview
  • SQL*Loader: Overview
  • Data Pump: Overview
  • Performance Initialization Parameters
  • Using Enterprise Manager to Monitor Data Pump Jobs
  • Data Dictionary
  2 Hours
 Day 21

Database Architecture and ASM

  • Oracle Database Architecture Overview
  • ASM General Architecture
  • Creating an ASM Instance
  • Using Enterprise Manager to Manage ASM Users
  • ASM Storage Concepts
  • The ASMCMD Utility
  • ASM Scalability and Performance
  2 Hours
 Day 22

Configuring for Recoverability

  • Purpose of Backup and Recovery Functionality
  • Typical Backup and Recovery Tasks
  • Oracle Backup and Recovery Solutions
  • Using Recovery Manager (RMAN)
  • Using a Flash Recovery Area
  • Flash Recovery Area Space Management
 Day 23

Using the RMAN Recovery Catalog

  • RMAN Repository Data Storage: Comparison of Options
  • Storing Information in the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Recovery Catalog Resynchronization: Concepts
  • Using RMAN Stored Scripts
  • Backing Up and Recovering the Recovery Catalog
  • Using a Virtual Private Catalog
  • Feasible Distance / Feasible Successors /Administrative distance
  2 Hours
 Day 24

Configuring Backup Specifications

  • Using RMAN to Create Backups
  • Configuring Persistent Settings for RMAN
  • Using Enterprise Manager to Configure RMAN Settings
  • Control File Auto-backups
  • Managing Persistent Settings
  • Configuring Devices for Backup
  • Configuring and Allocating Channels for Use in Backups
  • Configuring Backup Optimization
  2 Hours
 Day 25

Creating Backups

  • Creating an Oracle-Suggested Backup
  • Creating Backup Sets & Image Copies
  • Creating a Whole Database Backup
  • RMAN Backup Types
  • Monitoring Block Change Tracking
  • Creating Duplex Backup Sets
  • Archival Backups: Concepts
  • Encrypting Backups
  2 Hours
 Day 26

Performing User-Managed Backup and Recovery

  • Restoring and Recovering
  • Causes of File Loss
  • Critical Versus Non-critical
  • Recovering from a TEMPFILE Loss
  • Re-creating Indexes
  • Recovering from a Lost Index Tablespace
  • Authentication Methods for Database Administrators
  • Recovering a Read-Only Tablespace

Using RMAN to Duplicate a Database

  • Using RMAN to Create a Duplicate Database
  • Creating a Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance
  • Allocating Auxiliary Channels
  • Understanding the RMAN Duplication Operation
  • Using EM to Clone a Database
  • Cloning a Running Database

Monitoring and Tuning RMAN

  • Parallelization of Backup Sets
  • Monitoring RMAN Sessions
  • Interpreting RMAN Message Output
  • Using the DEBUG Option
  • Tuning RMAN
  2 Hours
 Day 27

Using Flashback Technology

  • Flashback Technology
  • Transactions and Undo
  • Guaranteeing Undo Retention
  • Preparing Your Database for Flashback
  • Flashback Drop and the Recycle Bin
  • Using Flashback Technology to Query Data
  • Possible Workflow

Using Flashback Database

  • Flashback Table
  • Flashback Database Architecture
  • Configuring Flashback Database
  • Flashback Database Considerations
  • Flashback Data Archive

Performance Tunning

  • Application Tunning
  • Memory Tunning  
  • partitioning
  • heath check report
  • indexing
  2 Hours
 Day 28

Project Continued…

  2 Hours
 Day 29

Project Completion and Presentation…

  2 Hours
 Day 30

QUERY SOLVING SESSION

  2 Hours
Register Now
[/single_tab][single_tab icon=”Defaults-sign-out” title=”How to Enroll” tab_id=”enroll”]

Step 1

Register online for any desired course, duration & location of your training course & obtain a Registration-ID. Registration-ID is a Unique Registration Number which is generated by our system after successful registration for training A student can have multiple IDs for multiple courses & batches. It is displayed while successful registration and it is also mailed to you immediately after registration by our server. if you don’t find it in your mail then, please check your SPAM folder or junk folder of your mail ID.

Step 2

Please deposit your Course fee to any one of our payment gateway/ Bank Account/ paytm.

Payment Gateway link: Pay through PayUmoney

Bank Account Details –
A/C Name: TechieNest Pvt. Ltd.
Bank A/C No: 201000689491
IFSC: INDB0000592
Bank Name: Indusind Bank Limited
Address: Malviya Nagar, Jaipur ( Rajasthan)
Paytm Number – 9251494002

Step 3

Update us regarding your fee payment by sending picture/scan copy of bank receipt to: [email protected] and you will receive a confirmation mail on your mail id.

[/single_tab][single_tab icon=”Defaults-money” title=”Fee & Discount” tab_id=”fee”]

SUMMER TRAINING OFFERS:

When someone says yes you can do it….it means you can achieve it and when you decide to take an action we come with the surprising offers:

1) Branch toppers up to 30% off

Offer code: TNBT30

For Branch toppers we have the superb fascinating offer 30% off on summer training Courses.

T&C apply:

  • This offer can be redeemed by only two candidates i.e. 1 male and 1 female candidate.
  • Certification proof is mandatory for the validation of branch toppers.

E.g.: Photo-print of Result or Provisional Mark sheet from University

2) On the basis of 12th result, upto Rs. 2000/- off

Offer code: TN12-2000

Upto Rs. 2000/- off will be awarded in all the courses offered in summer training to those Students who had scored more than 85% in 12th

T&C apply:

  • Certification proof of 12th is mandatory to validate the percentage.

3) Group Discount:

Offer code: TNGD-10

Offer code: TNGD-20

Offer code: TNGD-25

  • If a group size is of: 5 -10 then 10% discount on training

10-20 then 20% discount on training

20 and above then 25% discount on training

4) Referral Offer:

Offer code: TNR3

Offer code: TNR5

  • 3% additional discount to the person who is referring
  • 5% additional discount to the one who is being referred

5) For Former students up to 30% off:

Offer code: TNFS30

  • There will be upto 30% discount on students who already did training

6) Nobel Cause students Rs. 1000/- off:

Offer code: TNNC1000

  • Discount of Rs. 1000/- will be given to students who has worked for Noble cause and proof of all certifications related to that span of work are need to be shown.

7) 5% additional Discount for Campus Ambassador:

Offer code: TNA5

  • Additional 5% discount will be given on training program

8) Previous Workshop attended students 10% off:

Offer code: TNPW10

  • For this category students discount of 10% on summer training

9) IIT, NIT students Rs. 2000/- off:

Offer code: TNIN2000

Students belongs to IIT and NIT will be getting off up to Rs. 2000/- on training programs.

NOTE- All the discounts are applicable to the courses whose course fee worth above Rs 5500/-.

[/single_tab][single_tab icon=”Defaults-bookmark” title=”Certification” tab_id=”certification”]

Certification

All participants will get Certificate from TechieNest Pvt. Ltd. in association with Aavriti’18 IIT Bombay

Why TechieNest

  • Vast experience of having conducted Big Outreach Workshop collaborating with over 300+ colleges in all over India including IIT Bombay, IIT Hyderabad, IIT Bhubaneswar, IIT Jodhpur, IIT Mandi, NIT Raipur, MNIT Jaipur, MANIT Bhopal, NIT Jalandhar, NIT Patna, NIT Srinagar, IIIT Kalyani, BITS Pilani and likewise.
  • Trained more than 20,000 students in the field of EMBEDDED SYSTEMS & ROBOTICS, MATLAB & Machine Vision, Internet of Things, PLC_SCADA, PYTHON, C/C++, Andriod, VLSI & VHDL, JAVA and such top notch courses.
  • Our trainers are efficient in Raspberry pi, Arduino, PLCs, etc. which forms essential hardware in Electronic Industries nowadays.
  • Outreach workshop partner of Sanchaar-Wissenaire’18, IIT Bhubaneswar, 2017-18
  • Zonal workshop partner of Techkriti’18 IIT Kanpur, 2017-2018
  • Outreach workshop partner of Techfest’15 IIT Bombay & Techfest’16 IIT Bombay
  • Zonal workshop partner of Techkriti’17 IIT Kanpur, 2016-2017
  • Outreach workshop & Training partner of nVision’17 IIT Hyderabad, 2016-17
  • Outreach workshop partner of Ignus’17 IIT Jodhpur, 2016-17
  • AIRC’18 (All India Robotics Championship) in association with Techkriti’18 IIT Kanpur.
  • AIRC’17 (All India Robotics Championship) in association with nVision’17 IIT Hyderabad, 2016-17
  • Offering Project Based Training, Projects on Demand, Corporate Projects, Commercial Projects, and Consultancy in Engineering Projects.
    Dedicated 24×7 R&D lab.
  • Trained over 50+ international students in TechieNest Technology Transfer Program 2014-15.
  • TechieNest has Research Engineers having excellent research aptitude, teaching pedagogy who illustrates their finding through practical demos during workshop/training.
  • Manufacturer of Electronic products delivering the same across the country.
[/single_tab][single_tab icon=”Defaults-cog gear” title=”Training Kit” tab_id=”kit”]

Training Kit- will be updated soon

[/single_tab][single_tab icon=”Defaults-map-marker” title=”Center” tab_id=”center”]
[bsf-info-box icon_type=”custom” icon_img=”id^352758|url^http://techienest.in/wp-content/uploads/2018/08/jaipur.png|caption^null|alt^null|title^jaipur|description^null” img_width=”150″ icon_animation=”pulse” title=”Jaipur Center” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#cd202e” desc_font_color=”#333333″]

Address : Plot No. 262, Muktanand Nagar, Opp. Pooja Tower, Gopalpura Mode, Jaipur (302018), Rajasthan(India)

Phone : +91-7340033094

[/bsf-info-box]

[bsf-info-box icon_type=”custom” icon_img=”id^352757|url^http://techienest.in/wp-content/uploads/2018/08/hyderabad.png|caption^null|alt^null|title^hyderabad|description^null” img_width=”150″ icon_animation=”pulse” title=”Hyderabad Center” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#cd202e” desc_font_color=”#333333″]

Address : CYBERAEGIS 7-4 & 7-5, Srigiri Complex Dilsukhnagar, Main road Hyderabad 500060

Phone : +91-8686654444

[/bsf-info-box]

[bsf-info-box icon_type=”custom” icon_img=”id^352759|url^http://techienest.in/wp-content/uploads/2018/08/raipur.png|caption^null|alt^null|title^raipur|description^null” img_width=”150″ icon_animation=”pulse” title=”Raipur Center” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#cd202e” desc_font_color=”#333333″]

Address : SIMPLY C COMPUTERS (IT) Pvt. Ltd. Opp Vandana Auto Raod, Near Nagar Nigam Water Tank, Idgahabhata Road, Raipur

Phone : +91-9251494002

[/bsf-info-box]

[/single_tab][/ult_tab_element]

Why TechieNest ?

[bsf-info-box icon_type=”custom” icon_img=”id^352707|url^http://techienest.in/wp-content/uploads/2018/08/01.png|caption^null|alt^null|title^01|description^null” img_width=”48″ title=”Certified Organization” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#ffffff” desc_font_color=”#ffffff”]

TechieNest is a certified ISO 9001:2008, technology service provider and training organization.

[/bsf-info-box]

[bsf-info-box icon_type=”custom” icon_img=”id^352708|url^http://techienest.in/wp-content/uploads/2018/08/02.png|caption^null|alt^null|title^02|description^null” img_width=”48″ title=”350+ Colleges” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#ffffff” desc_font_color=”#ffffff”]

Our team has successfully delivered the impactful service to more than 350 colleges, including prestigious institutions..

[/bsf-info-box]

[bsf-info-box icon_type=”custom” icon_img=”id^352709|url^http://techienest.in/wp-content/uploads/2018/08/03.png|caption^null|alt^null|title^03|description^null” img_width=”48″ title=”Work Ideology” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#ffffff” desc_font_color=”#ffffff”]

TechieNest is moving ahead with an ideology where practical and theory are equally emphasized.

[/bsf-info-box]

[bsf-info-box icon_type=”custom” icon_img=”id^352710|url^http://techienest.in/wp-content/uploads/2018/08/04.png|caption^null|alt^null|title^04|description^null” img_width=”48″ title=”Creating “Techie-Brains”” heading_tag=”h5″ read_more=”box” pos=”top” title_font_color=”#ffffff” desc_font_color=”#ffffff”]

In the vast growing ‘Technical Era’ we are rising with a mission to expand the set boundaries..

[/bsf-info-box]

Request call From Us

Drop an email at [email protected]

or

Raise a Query Here

[contact-form-7 id=”75″]

Express Fee Payment System for Training Program Netbanking/Debit Card/Credit Card

For Assistance Call

+91-9251094002, +91-7340033091

Pay Instantly with Credit Card/ Debit Card/ Net Banking from any of the following gateway
Make Payment

For Assistance Mail

Mail us : [email protected]

We’ll be glad to help
Contact us

Jaipur
+91-7340033094
Hyderabad
+91-9251094002
Raipur
+91-9251494002
Email ID
[email protected]
admin
admin