Oracle sql courses

... and Configuring OracleCreating and Managing an Oracle DatabaseAdministering an Oracle DatabaseConfiguring the Oracle Network EnvironmentCreating and Managing Database Storage StructuresManaging Redo Log Files and Control FilesManaging Schema ObjectsManaging Users, Profiles, Privileges and RolesManaging Undo... Learn about: Database training, Network Training, IT Auditing...

... for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs. Oracle 12c focuses on Oracle’s cloud-based offerings with a new architecture – Plugable Databases (PDBs... Learn about: Database Management, Database training...

... design cursors; improve memory usage with PL/SQL result caching and SQL result sets. Suitable for: This course, designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors...

...By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically. Suitable for: This course is designed for Oracle programmers and developers and provides practical experience... Learn about: To provide the skills needed to develop, Stored program units and packages, Write and maintain PL/SQL scripts...

...This course will give you an introduction to Oracle Corporation's proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures... Learn about: Database training, SQL Database, IT Development...

...Installing the Oracle Database Server and Other Software Using Oracle SQL Developer, SQL Plus and iSQL Plus Writing Basic SQL SELECT Statements Restricting and Sorting Data Single-Row Functions Displaying Data from Multiple Tables Aggregating Data Using Group Functions Subqueries Producing Readable... Learn about: SQL Database...

...By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features. They will also be able to describe and use some of the Oracle-supplied packages. Suitable for: This course, designed for Oracle software development personnel... Learn about: To provide the skills needed to develop, Write and maintain triggers, Stored program units and packages...

...By the end of this course, the delegate will be able to: Use SQL*Plus and SQL Developer effectively Write SQL statements to query an Oracle Database Create and run SQL script files Use Oracle's numeric, character and date functions Implement Oracle's enhanced grouping functions Create and alter...

...Installing the Oracle Database Server and Other Software Using Oracle SQL Developer, SQL Plus and iSQL Plus Writing Basic SQL SELECT Statements Restricting and Sorting Data Single-Row Functions Displaying Data from Multiple Tables Aggregating Data Using Group Functions Subqueries Producing Readable...

... and Configuring OracleCreating and Managing an Oracle DatabaseAdministering an Oracle DatabaseConfiguring the Oracle Network EnvironmentCreating and Managing Database Storage StructuresManaging Redo Log Files and Control FilesManaging Schema ObjectsManaging Users, Profiles, Privileges and RolesManaging Undo... Learn about: IT Auditing, Network Training, Database training...

...The Knowledge Academy Oracle Database 11g: Data Guard Administration Release 2 4 day course covers the following topics: Introduction In the Oracle Database 11g: Data Guard Administration Release 2 Applications course candidates will gain knowledge and skills. Candidates will learn how to create... Learn about: Database training, Data guard, Oracle 11g...

...•Introduction to RDBMS Concepts. Relational Database Design Overview. Understanding SQL Concepts including DML, DDL and DCL. Retrieving and Sorting Data. Filtering Data. Utilising Calculated Fields. Data Manipulation Functions. Grouping and Summarising Data. Introduction to Subqueries. Joining...

... on the course are also applicable to other Database Management Systems such as SQL Server and Oracle... Learn about: Database Administration...

... on the course are also applicable to other Database Management Systems such as SQL Server and Oracle. The course will cover the use of scripts for database administration and backup in a generic way. (i.e. knowledge of scripting languages such as Perl or Tcl, or... Learn about: Database Administration...

... Understand how Hive tables are defined and implemented Use Hive to run SQL-brke queries to perform data analysis Perform a multi-table select in Hive Design... Learn about: Big Data...

... and Configuring OracleCreating and Managing an Oracle DatabaseAdministering an Oracle DatabaseConfiguring the Oracle Network EnvironmentCreating and Managing Database Storage StructuresManaging Redo Log Files and Control FilesManaging Schema ObjectsManaging Users, Profiles, Privileges and RolesManaging Undo... Learn about: IT Auditing, Network Training, Database training...

... sector of IT. This bundle includes over 150 hours of training, giving you a well-rounded approach to all areas of database technology! Here are just a few of the topics this course bundle will cover: How to write basic Transact-SQL queries for Microsoft SQL The skills to maintain Microsoft SQL Server... Learn about: Server 2013, Core Solutions, Database training...

...Features: Dimensional modelling per Ralph Kimball. Platform: Multi-platform: DB2 for z/OS, DB2 UDB for Linux/UNIX/Windows, Oracle, SQL Server, Sybase...

...The Knowledge Academy Oracle SQL 3 day course covers the following topics: Our Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle... Learn about: Database Design, Database training, Data Collection...

...This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers...