Data Matters
13 training courses found | Help me choose

Oracle Training

The SETC certified complete Database course targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part I of the course focusses on the essentials of the SQL language as it is applied to a variety of database platforms. If you work in a multi-platform environment, this course will provide you with a comprehensive overview of the SQL language as it is defined by the ANSI standard. Custom training course titled The Complete Database Administrator Course Part 1 : Mastering the SQL Language that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person
This SETC certified course covers the essentials skills that are necessary to design. implement and troubleshoot Oracle Forms and Reports in an Oracle 11g environment. Whether you need to build a report that highlights sales in the last quarter or build a form that allows sales to be entered into an Oracle database, this is the couese for you. Come learn how to leverage the power and flexibility of Oracle Forms and Reports with this informative and fast-paced SETC certified course. Custom training course titled A Complete Introduction to Forms and Reports that will allow you to hone your professional skills.

Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person
This SETC Certified course provides developers with a comprehensive overview of the powerful and flexible development language of PL/SQL. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction. Custom training course titled An Introduction to PL/SQL Development for Professional Developers that will allow you to hone your professional skills.

Dec 6 to Dec 8, 2017$1,675/person Jan 10 to Jan 12, 2018$1,675/person Feb 7 to Feb 9, 2018$1,675/person Mar 7 to Mar 9, 2018$1,675/person
This SETC Certified course focuses on the art, functionality and application of Data Mining and Data Warehousing as performed within an Oracle OLAP database environment. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive. Custom training course titled Building a Data Warehouse with Oracle that will allow you to hone your professional skills.

Jan 22 to Jan 26, 2018$3,000/person Feb 19 to Feb 23, 2018$3,000/person Mar 19 to Mar 23, 2018$3,000/person
This SETC Certified course covers the essential elements of the PL/SQL language. This course includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. Having covered the basics of relational database manipulation, the course introduces participants to the more formal elements of the PL/SQL language including blocks, data types, variables and program flows. The course concludes with a preliminary exploration of procedures and functions in the context of PL/SQL packages. Custom training course titled Mastering Relational Database Programming with PL/SQL that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person
This SETC Certified database course introduces the MySQL Relational Database Management System. Every aspect of MySQL database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you. Custom training course titled MySQL Core Administration Skills that will allow you to hone your professional skills.

Jan 30 to Feb 2, 2018$3,000/person Feb 27 to Mar 2, 2018$3,000/person Mar 27 to Mar 30, 2018$3,000/person
This SETC Certified course provides a comprehensive exploration of the installation, configuration and maintenance of a production Oracle environment on a UNIX-LINUX platform. Topics covered include an overview of the different architectures, performance optimization through caching/tuning, backup and recovery and security. This comprehensive course discusses every aspect of Oracle database administration Custom training course titled Oracle Core Administration Skills that will allow you to hone your professional skills.

Jan 8 to Jan 12, 2018$2,500/person Feb 5 to Feb 9, 2018$2,500/person Mar 5 to Mar 9, 2018$2,500/person
This SETC Certified course covers the advanced elements of the PL/SQL language. Beginning with procedures and functions, the exploration includes database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling and object oriented programming in PL/SQL. And if that was not enough, the course concludes with a detailed study of XML processing, Java integration and performance tuning and optimization. Now that is a full learning week. Custom training course titled PL/SQL and Objects: Objects, Libraries, XML, Exceptions and More that will allow you to hone your professional skills.

Jan 24 to Jan 26, 2018$1,675/person Feb 21 to Feb 23, 2018$1,675/person Mar 21 to Mar 23, 2018$1,675/person
This intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database administration. Starting with the basic tools of the trade, the course quickly accelerates to coverage of installation, configuration, databases, tablespaces, files and more. This is followed by modules covering enterprise manager, fault tolerance, high availability, security, partitioning, and flashback management amongst others. And no course on Oracle administration course would be complete in the absence of indexing. So we do that too. Fine tune your Oracle database administration skills with this exceptionally effective SETC certified course. Custom training course titled Professional Oracle Administration that will allow you to hone your professional skills.

Jan 15 to Jan 19, 2018$2,500/person Feb 12 to Feb 16, 2018$2,500/person Mar 12 to Mar 16, 2018$2,500/person
This intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database performance tuning and optimization. Starting with the basic tools of the trade, the course quickly accelerates to coverage of structural SQL optimization techniques and PL/SQL optimization. This is followed by modules covering the concepts of indexing as well as server and memory optimization techniques. And no course on Oracle tuning would be complete in the absence of a comprehensive performance tuning lab. So we do that too. Fine tune your Oracle database with this exceptionally effective SETC certified course. Custom training course titled Professional Oracle Database Tuning and Optimization that will allow you to hone your professional skills.

Nov 27 to Dec 1, 2017$2,275/person Jan 29 to Feb 2, 2018$2,500/person Feb 26 to Mar 2, 2018$2,500/person Mar 26 to Mar 30, 2018$2,500/person
This SETC Certified database course introduces the SQL Server relational database management system. Every aspect of SQL Server database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the SQL Server database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a SQL Server database in your organization, this is the course for you. Custom training course titled SQL Server Core Administration Skills that will allow you to hone your professional skills.

Jan 9 to Jan 12, 2018$2,500/person Feb 6 to Feb 9, 2018$2,500/person Mar 6 to Mar 9, 2018$2,500/person
The SETC certified complete Database course targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part II of the course focusses on the components of a production environment that allow database professionals to excel in their mission critical responsibilities. Custom training course titled The Complete Database Administrator Course Part II : Mastering MySQL and Oracle Administration that will allow you to hone your professional skills.

Nov 27 to Dec 1, 2017$2,500/person Jan 8 to Jan 12, 2018$2,500/person Feb 5 to Feb 9, 2018$2,500/person Mar 5 to Mar 9, 2018$2,500/person
This intensive SETC certified course provides a comprehensive and detailed exploration of the PL/SQL language and it many nooks and crannies. Starting with the basic concepts of the SQL language, the course quickly accelerates to coverage of advanced SQL techniques and PL/SQL programming fundamentals. This is followed by modules covering the concepts of cursors, triggers, procedures and functions and packages. An no course on PL/SQL would be complete in the absence of object oriented programming, Java integration and XML processing. So we do that too. Finally, we conclude our grand tour of PL/SQL with a look at performance and an introduction to performance tuning concepts. If you want to learn PL/SQL, this is the course for you. Custom training course titled The Complete PL/SQL Programming Course that will allow you to hone your professional skills.

Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person