Database & ERP Courses

Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information

Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table

Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements

Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables

Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes

Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows

Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions

Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings

Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases

Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration

SQL Server 2012 security models, logins and users

Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles

Partial database containment option provided by SQL Server 2012

SQL Profiler

Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries

Auditing SQL Server 2012 environments

Monitoring and maintaining SQL Server 2012 databases

Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications

Authenticate and authorize users

Assign server and database roles

Authorize users to access resources

Protect data with encryption and auditing

Describe recovery models and backup strategies

Backup SQL Server databases

Restore SQL Server databases

Automate database management

Configure security for the SQL Server agent

Manage alerts and notifications

Managing SQL Server using PowerShell

Trace access to SQL Server

Monitor a SQL Server infrastructure

Troubleshoot a SQL Server infrastructure

Import and export data

Describe key capabilities and components of SQL Server

Describe T-SQL, sets, and predicate logs

Write a single table SELECT statement

Write a multi-table SELECT statement

Write SELECT statements with filtering and sorting

Describe how SQL Server uses data types

Write DML statements

Write queries that use built-in functions

Write queries that aggregate data

Write subqueries

Create and implement views and table-valued functions

Use set operations to combine query results

Write queries that use window ranking, offset, and aggregate functions

Transform data by implementing pivot, unpivot, rollup and cube

Create and implement stored procedures

Add programming constructs such as variables, conditions, and loops to T-SQL code

Design and implement tables.

Advanced table designs.

Ensure data integrity through constraints.

Indexes, including optimized and column store indexes.

Design and implement views.

Design and implement stored procedures.

Design and implement user-defined functions.

Respond to data manipulation using triggers.

Design and implement in-memory tables.

Implement managed code in SQL Server.

Store and query XML data.

Work with spatial data.

Store and query BLOBs and text documents.

Structural elements in Oracle Database 11g’s architecture, including and Automatic Storage Management (ASM), and the steps for managing storage using disk groups

Steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog

Steps for preparing a database for backup and for performing various types of RMAN backups and monitoring them using reports and dynamic performance views

Steps for performing user-managed backups and recoveries

Ways to use RMAN to ensure that data is not lost in Oracle Database 11g by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time

Steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks and for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g’s flashback features

Steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and for enabling and configuring automatic memory management and automatic shared memory management

Steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces

Ways to ensure that resources are being put to best use and database jobs are performed when they should be using the Database Resource Manager and the Scheduler

Steps for utilizing Oracle Database 11g’s globalization support features to ensure that information and data is displayed in a user’s native language and that territory and language-dependent conventions are adhered to

Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules

Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters

Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules

Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures

Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters

Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their ex

Steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code

Steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings

Steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies

Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software

Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance

Steps for configuring new Oracle Net Listeners and database connectivity

Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users

Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency

Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds

Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups

Ways to make use of Oracle Database 11g’s tools for moving and recovering data, reporting on problems, and installing updates to enhance a database

Install Oracle Clusterware and RAC

Administer a RAC Database and Oracle Clusterware

RAC Performance Tuning

Configure, Manage, and Use Database Services in a RAC environment

Administer Oracle Clusterware

Diagnose Oracle Clusterware and Node Management

High Availability in RAC

Add/Remove a node to/from a cluster

Patch Oracle Clusterware and RAC software

Enterprise Manager Cloud Control

Creating Container Databases (CDB) and Pluggable Databases (PDB)

Managing CDB and PBD, and Data Optimization

Using Automatic Data Optimization, Storage, and Archiving

Managing Security

High Availability and Database Management

Tuning Structured Query Language (SQL) and Using Automatic Database Diagnostic Monitor (ADDM)

Resource Manager, Online Operations, and Automatic Diagnostic Repository (ADR)

Transporting Databases and Managing Data

Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information

Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table

Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements

Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables

Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes

Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows

Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions

Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings

Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases

Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration

SQL Server 2012 security models, logins and users

Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles

Partial database containment option provided by SQL Server 2012

SQL Profiler

Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries

Auditing SQL Server 2012 environments

Monitoring and maintaining SQL Server 2012 databases

Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications

Authenticate and authorize users

Assign server and database roles

Authorize users to access resources

Protect data with encryption and auditing

Describe recovery models and backup strategies

Backup SQL Server databases

Restore SQL Server databases

Automate database management

Configure security for the SQL Server agent

Manage alerts and notifications

Managing SQL Server using PowerShell

Trace access to SQL Server

Monitor a SQL Server infrastructure

Troubleshoot a SQL Server infrastructure

Import and export data

Describe key capabilities and components of SQL Server

Describe T-SQL, sets, and predicate logs

Write a single table SELECT statement

Write a multi-table SELECT statement

Write SELECT statements with filtering and sorting

Describe how SQL Server uses data types

Write DML statements

Write queries that use built-in functions

Write queries that aggregate data

Write subqueries

Create and implement views and table-valued functions

Use set operations to combine query results

Write queries that use window ranking, offset, and aggregate functions

Transform data by implementing pivot, unpivot, rollup and cube

Create and implement stored procedures

Add programming constructs such as variables, conditions, and loops to T-SQL code

Design and implement tables.

Advanced table designs.

Ensure data integrity through constraints.

Indexes, including optimized and column store indexes.

Design and implement views.

Design and implement stored procedures.

Design and implement user-defined functions.

Respond to data manipulation using triggers.

Design and implement in-memory tables.

Implement managed code in SQL Server.

Store and query XML data.

Work with spatial data.

Store and query BLOBs and text documents.

Structural elements in Oracle Database 11g’s architecture, including and Automatic Storage Management (ASM), and the steps for managing storage using disk groups

Steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog

Steps for preparing a database for backup and for performing various types of RMAN backups and monitoring them using reports and dynamic performance views

Steps for performing user-managed backups and recoveries

Ways to use RMAN to ensure that data is not lost in Oracle Database 11g by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time

Steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks and for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g’s flashback features

Steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and for enabling and configuring automatic memory management and automatic shared memory management

Steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces

Ways to ensure that resources are being put to best use and database jobs are performed when they should be using the Database Resource Manager and the Scheduler

Steps for utilizing Oracle Database 11g’s globalization support features to ensure that information and data is displayed in a user’s native language and that territory and language-dependent conventions are adhered to

Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules

Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters

Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules

Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures

Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters

Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their ex

Steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code

Steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings

Steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies

Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software

Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance

Steps for configuring new Oracle Net Listeners and database connectivity

Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users

Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency

Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds

Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups

Ways to make use of Oracle Database 11g’s tools for moving and recovering data, reporting on problems, and installing updates to enhance a database

Install Oracle Clusterware and RAC

Administer a RAC Database and Oracle Clusterware

RAC Performance Tuning

Configure, Manage, and Use Database Services in a RAC environment

Administer Oracle Clusterware

Diagnose Oracle Clusterware and Node Management

High Availability in RAC

Add/Remove a node to/from a cluster

Patch Oracle Clusterware and RAC software

Enterprise Manager Cloud Control

Creating Container Databases (CDB) and Pluggable Databases (PDB)

Managing CDB and PBD, and Data Optimization

Using Automatic Data Optimization, Storage, and Archiving

Managing Security

High Availability and Database Management

Tuning Structured Query Language (SQL) and Using Automatic Database Diagnostic Monitor (ADDM)

Resource Manager, Online Operations, and Automatic Diagnostic Repository (ADR)

Transporting Databases and Managing Data