loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle/SQL Server Training in Mohali Chandigarh

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With ThinkNEXT Technologies Pvt. Ltd.

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Oracle/SQL Server Training in Mohali Chandigarh

Oracle/SQL Server Training in Mohali Chandigarh

Mohali, Chandigarh

15,000

No Reviews Yet
0 Interested

About the Course


An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Topics Covered

Oracle DBA Concepts - An Overview

What is an Oracle Instance?
Installing Oracle
Oracle Optimal Flexible Architecture (OFA)
Locating initialization, listener.ora & sqlnet.ora files
Finding the alert log
Common environment variables
Structures in an Oracle Instance
Oracle Memory Structures, SGA and PGA

Oracle10g Database Architecture

Oraclde10g management framework
Using the Database Creation Assistant (DBA)
Creating and dropping a database
Tablespaces
Tables and Indexes
Clusters
Partitioning of Tables and Indexes
Gathering and applying patches

Concurrency Management

Transactions, serialization, locks and latches
Lock modes
Detecting and resolving lock conflicts
Managing deadlocks
Oracle transaction management
Using SQL*Plus and iSQL*Plus
Using embedded Oracle with Pro*C & Java
PL/SQL & Triggers
Pining PL/SQL packages & compiling PL/SQL
System-level triggers – startup trigger, logon trigger, PL/SQL error trigger

DBA Management

Dictionary Managed Tablespaces
Locally Managed Tablespaces
Automatic Segment Space Management
Moving tablespaces online and offline

Oracle Performance Tuning

Locate invalid and unusable objects
Gather SQL optimizer statistics with dbms_stats
Basic Oracle performance metrics
Use OEM and dbms_alert to set warning and critical alert thresholds
The SQL Tuning Advisor
The SQL Access Advisor
Interpreting server generated alerts

Oracle security and user management

Creating Users
Altering users
User Profiles
User resource groups
Granting privileges & roles
Auditing user activity with dbms_audit

Oracle Security

Password use in Oracle
Password encryption and password aging
External authentication
Object security
Virtual Private Databases (VPD) in Oracle
Register for security updates

Backup & Recovery

Oracle backup & recovery planning
Parallel instance recovery
Basics of checkpoints, redo log files, and archived log files
Creating consistent Oracle backups
Online hot backups
Incremental Oracle backups
Automating database backups with dbms_scheduler
Monitor the flash recovery area
Recovering from loss of a Control file

Who should attend

Any one interested to explore field of Database and Development.

Pre-requisites

English,basic computer literacy.

What you need to bring

Notebook and pen or laptop"

Key Takeaways

After completing this course, you would be ready to work as Oracle developer DBA and You would be able to pass exam Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

ThinkNEXT Technologies

B.Tech, M.Tech


Expert in Oracle/SQL Server Training.
Seats Left-

Students Interested 0

Course Id: 26857