Most popular
70-462: Administering Microsoft SQL Server 2012 eLearning
What you'll learn
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
Free
70-764: Administering a SQL Server 2016 Database Infrastructure eLearning
What you'll learn
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
Free
70-761: Querying Data with Transact-SQL eLearning
What you'll learn
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
Free
70-762: Developing SQL Databases eLearning
What you'll learn
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.
Oracle 11g: Administration II eLearning
What you'll learn
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
Oracle 11g: Programing with PL/SQL eLearning
What you'll learn
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
Oracle11g Admin eLearning
What you'll learn
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
Oracle Database 11g: RAC Administration eLearning
What you'll learn
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
Oracle 12c: New Features for Administrators eLearning
What you'll learn
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
Oracle 11g: Programming with SQL Intro eLearning
What you'll learn
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
Trending
70-462: Administering Microsoft SQL Server 2012 eLearning
What you'll learn
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
Free
70-764: Administering a SQL Server 2016 Database Infrastructure eLearning
What you'll learn
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
Free
70-761: Querying Data with Transact-SQL eLearning
What you'll learn
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
Free
70-762: Developing SQL Databases eLearning
What you'll learn
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.
Oracle 11g: Administration II eLearning
What you'll learn
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
Oracle 11g: Programing with PL/SQL eLearning
What you'll learn
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
Oracle11g Admin eLearning
What you'll learn
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
Oracle Database 11g: RAC Administration eLearning
What you'll learn
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
Oracle 12c: New Features for Administrators eLearning
What you'll learn
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
Oracle 11g: Programming with SQL Intro eLearning
What you'll learn
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
All Database & ERP Courses
Best Database & ERP Online Training Courses - E-Learning
Filter by Topic
Filter by Vendor
Free
70-764: Administering a SQL Server 2016 Database Infrastructure eLearning
Course Description In this instructor-led, online training course, students will …
What you'll learn
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
Free
70-761: Querying Data with Transact-SQL eLearning
Course Description In this instructor-led, online training course, students will …
What you'll learn
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
Free
70-762: Developing SQL Databases eLearning
Course Description In this instructor-led, online training course, students will …
What you'll learn
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.
70-462: Administering Microsoft SQL Server 2012 eLearning
Course Description The 70-462: Administering Microsoft SQL Server 2012 online …
What you'll learn
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
Oracle 11g: Programming with SQL I and II eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
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
Oracle 11g: Programming with SQL Intro eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
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
Oracle 12c: New Features for Administrators eLearning
Course Description: In this course, you’ll learn about the new …
What you'll learn
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
Oracle Database 11g: RAC Administration eLearning
Course Description: In this course, you will be introduced to …
What you'll learn
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
- 1
- 2