Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle/SQL Server Training in Mohali Chandigarh

No Reviews Yet

Mohali, Chandigarh

Course ID: 26857

Mohali, Chandigarh

Students Interested 0 (Seats Left 0)

₹ 15,000

No Reviews Yet

Date and Time

Not decided yet.

ThinkNEXT Technologies

B.Tech, M.Tech

About ThinkNEXT Technologies

Expert in Oracle/SQL Server Training.
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 15,000

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now
₹ 15,000 Enquire

Enquire

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

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

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