Database Management course for advanced learners by Astute institute of Software Engineering

Introduce the entire SQL Server platform and its major tools
Best design practices on SQL Server tables
Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints and investigate cascading FOREIGN KEY constraints
Determine appropriate single column and composite indexes strategies
Read and interpret details of common elements from execution plans
Design effective non-clustered indexes
Design and implement views
Design and implement stored procedures
Work with table types, table valued parameters
Design and implement functions, both scalar and table-valued
Use both traditional T-SQL error handling code and structured exception handling
Design and implement DML triggers
Work with the GEOGRAPHY and GEOMETRY data types
Implement and query a full-text index

Identify the major components of Oracle Database 11g
Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Execute complex queries, DDL statements, and DML statements
Control database access to specific objects and add new users with different levels of access privileges
Manage schema objects and objects with data dictionary views
Manipulate large data sets in the Oracle database by using sub queries
Manage data in different time zones
Write multiple-column, scalar, and correlated sub queries
Use the regular expression support in SQL

Identify the major components of Oracle Database 11g
Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Execute complex queries, DDL statements, and DML statements
Control database access to specific objects and add new users with different levels of access privileges
Manage schema objects and objects with data dictionary views
Manipulate large data sets in the Oracle database by using sub queries
Manage data in different time zones
Write multiple-column, scalar, and correlated sub queries
Use the regular expression support in SQL