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: IT Auditing, Database training, Network Training...

... 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 training, Database Management...

... 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: Write and maintain PL/SQL scripts, To provide the skills needed to develop, Stored program units and packages...

...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: Programming Application, Programming with PL/SQL, Database training...

...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...

... and database administrators who need to write new, or maintain existing, PL/SQL triggers, program units and packages... Learn about: To provide the skills needed to develop, Stored program units and packages, Write and maintain triggers...

...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: Data guard, Database training, 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: Network Training, Database training, IT Auditing...

... 2012 databases Creating a data warehouse with SQL Server 2012 Implement ETL with SQL Server Integration Services Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services... Learn about: Server 2013, Database training, Core Solutions...

...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, Data Collection, Database training...

...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...