Database administration has become indispensable for enterprises seeking to stay in control of today’s avalanche of information, and database management training can give IT professionals the skills they need to help.Database managers work within organizations to develop the best ways for information to be stored, used, organized, analyzed, and presented. Our Database management training prepares aspiring administrators to

  • Examine and tighten the nuts and bolts of database platforms
  • Test and modify the system when necessary
  • Monitor system performance
  • Troubleshoot software issues as they arise


CERTIFYING BODY

  • ORACLE

CAREER PROSPECTS

This course is meant for everyone who would like to visualize how information gets stored and delivered to end users and a solid understanding of the Oracle products used in professional job roles.

  • Application Developer
  • Database Developer
  • Support Analyst

SYLLABUS

    Introduction to DBMS
    • DBMS, Data, Information, Database
    Data models – FMS/ HDBMS/
    NDBMS/ RDBMS/ ORDBMS
    • E-R Diagram, Normalization, Codd Rules
    • RDBMS Packages • Versions
    SQL (Structured Query Language)
    • SQL and SQL*Plus Commands
    • Types of commands in SQL
    • How to login into SQL
    • HR user, locking & unlocking user
    Retrieving data
    • Select statement usage
    • Alias names – columns & expressions
    • Applying filters using operators
    • Operators – Relational/ Logical / Special
    • Distinct clause, Order by clause
    • Sorting NULL values
    Working with tables
    • Datatypes in Oracle
    • Naming conventions; Rules – tables/columns
    • Creating Tables in different methods
    DML operations
    • Insert data in different methods
    • Update / Delete data
    DDL commands
    • Alter / Truncate / Rename / Drop table
    • Recyclebin concept • Flashback / Purge
    Table Constraints
    • Data Integrity and importance
    • Not Null/Unique/Primary Key/ Check
    • References/Foreign Key
    • Add/enable/disable/drop constraints
    • Composite primary key/unique key
    • About ‘User_constraints’ table
    TCL commands (Transaction Handling)
    • About login session • Redo log files
    • Commit / Rollback / Savepoint
    • Working with multiple savepoints
    DCL Commands
    • User management, SYSTEM user
    • Create user, Grant basic privileges
    • Change password, lock/unlock user
    • Grant/Revoke a user as DBA
    • Data sharing between users
    • Grant and Revoke commands
    • Accessing another user data
    • Dead lock situations
    About ‘User_tab_privs_made’, ‘User_tab_privs_recd’
    Database functions
    • Group / Row / Numeric / String
    • Conversion functions
    • Dates & date formats
    • Date functions, Misc. functions
    • Pseudo columns
    Data grouping
    • Group by / Having clause
    • ‘where’ versus ‘having’ clause
    • Using expressions in group by
    Set operators
    • Union/ Intersect/ Minus/ Union All
    Subqueries
    • Simple / Multiple row subquery
    • Nested / Co-related subquery
    Joins tables
    • Simple join (equi and non-equi)
    • Self/ inner / Outer join (Left/Right/Full)
    • Cartesian/Cross join
    • ANSI Standard of joins
    Oracle Database objects
    • Synonyms • Views
    • Sequences • Indexes
    PLSQL
    PL/SQL architecture
    • PL/SQL engine
    • Structure of a PL/SQL program
    • Different section of a program
    • Datatypes in PL/SQL
    • Operators, I/O operations
    • Write expressions, simple program
    • Extracting data from tables
    Control statements
    • If-Then-Else – Simple, Nested
    • Compound conditions (and/or/not)
    • Case – End Case
    • Loops – For/ While/ Simple/ ForALL
    Exception Handling
    • Introduction • Types of Exceptions
    • Runtime errors vs Exceptions
    • System / User defined exceptions
    • Using multiple exceptions
    • Raise_Application_Error()
    Cursor management
    • Cursor types – Implicit / Explicit
    • Cursor attributes
    • Declaring, opening, closing
    • Fetching, checking End of cursor
    • Parameterized cursor
    • For loops in cursor processing
    • DML operations using cursors
    • Cursor using joins
    Sub programs
    Stored Procedures
    • Creating a simple procedure
    • Compiling, verifying errors
    • Executing procedure from SQL prompt
    • Calling procedure in another PL/SQL program
    • Procedure including DML operations
    • Procedures with parameters
    • Types of parameters (IN, OUT & IN OUT)
    • Cursors in a procedure
    User defined Functions
    • Writing a user’s function
    • About ‘Return’ statement
    • Compiling, verifying errors
    • Executing from SQL prompt
    • Functions with parameters (IN, OUT & IN OUT)
    Packages
    • Create package specification / body
    • Calling the elements of a package
    • Adv of package over procedure/function
    • Implementing Polymorphism
    • Function overloading
    • Procedure overloading
    Database Triggers
    • Types of triggers
    • Creating before/after triggers
    • :OLD, :NEW reference for data references
    • DML operations using triggers
    • ‘Instead of’ triggers • Triggers Vs constraints
    • Transaction auditing using triggers

RDBMS, sql training institutes in ameerpet,  sql training institutes in ameerpet,sql training institute hyderabad,best institute for sql server dba in hyderabad,optimize sql technologies hyderabad,sql training institutes in ameerpet hyderabad,sql server training hyderabad,oracle pl/sql training institutes in ameerpet,best oracle training institutes in hyderabad,best institute for oracle in ameerpet,best institute for oracle dba in hyderabad,oracle training fees in hyderabad