Name: Oracle SQL Fundamentals, 3 Days
Price: 750 GBP
Availability: InStock

Redhill

<h3><b>REXX training course description</b></h3>
      <p> A hands on training course covering the Restructured EXtended eXecutor (REXX) language. A large number of exercises are used to reinforce and emphasise lecture sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	   <li>Write REXX programs.</li>
					    <li>Debug REXX programs.</li>
                        <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>REXX training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to learn REXX.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>REXX training course contents</b></h3>
      <ul>
				<li>Introduction to REXX </li><p>
				What is REXX? REXX environments, invoking a REXX exec, a sample REXX exec, REXX clause types.

</p><li>REXX variables and data </li><p>
Literal data, variable data, assignment, simple variables, compound variables, stem variables, constant data, numeric data, arithmetic operations, character manipulation, hexadecimal data.

</p><li>The parse instruction </li><p>
Parse format, Parse examples, Parse arg, Parse pull, Parse value, special templates, place holders, literal templates, numeric templates, variable templates.

</p><li>Control structures </li><p>
Relational conditions, logical operators, simple selection, looping: uncontrolled and controlled loops, infinite loops, conditional loops, controlling loops, leave, iterate, multiple selection, instructions for subroutines, exit.

</p><li>Sub routines and functions </li><p>
Internal and external subroutines, call, ARG(), ARG(n)return, exit, scope of variables, procedure, functions, built in functions, overriding built in functions.

</p><li>Performing I/O </li><p>
Command conventions, preparing to read a file, execio, limitations, execio for reading, DISKR, DISKRU, DISKW, return codes.

</p><li>External functions </li><p>
listdsi, msg, outtrap, prompt, sysdsn, sysvar, storage

</p><li>Tracing </li><p>
Immediate commands, the trace facility, signal and call statements.

</p><li>Built in functions </li><p>
Text handling functions, string handling, word handling, arithmetic, data conversion, bit manipulation, environment.

</p><li>The data stack </li><p>
Data stack structure, REXX instructions for the data stack, REXX functions for the data stack, TSO/E commands for the data stack.

</p><li>REXX in batch </li><p>
TSO/E foreground. TSO/E background.</p>
			
      </ul>

REXX training course description
 A hands on training course covering the Restructured EXtended eXecutor (REXX) language. A large number of exercises are used to reinforce and emphasise lecture sessions.
What will you learn
Write REXX programs.
Debug REXX programs.
Examine existing code and determine its function.
REXX training course details
Who will benefit:
Anyone wishing to learn REXX.
Prerequisites:
None although experience in another high level language would be useful. 
Duration
3 days 
REXX training course contents
Introduction to REXX
 What is REXX? REXX environments, invoking a REXX exec, a sample REXX exec, REXX clause types. 
REXX variables and data

Literal data, variable data, assignment, simple variables, compound variables, stem variables, constant data, numeric data, arithmetic operations, character manipulation, hexadecimal data. 
The parse instruction

Parse format, Parse examples, Parse arg, Parse pull, Parse value, special templates, place holders, literal templates, numeric templates, variable templates. 
Control structures

Relational conditions, logical operators, simple selection, looping: uncontrolled and controlled loops, infinite loops, conditional loops, controlling loops, leave, iterate, multiple selection, instructions for subroutines, exit. 
Sub routines and functions

Internal and external subroutines, call, ARG(), ARG(n)return, exit, scope of variables, procedure, functions, built in functions, overriding built in functions. 
Performing I/O

Command conventions, preparing to read a file, execio, limitations, execio for reading, DISKR, DISKRU, DISKW, return codes. 
External functions

listdsi, msg, outtrap, prompt, sysdsn, sysvar, storage 
Tracing

Immediate commands, the trace facility, signal and call statements. 
Built in functions

Text handling functions, string handling, word handling, arithmetic, data conversion, bit manipulation, environment. 
The data stack

Data stack structure, REXX instructions for the data stack, REXX functions for the data stack, TSO/E commands for the data stack. 
REXX in batch

TSO/E foreground. TSO/E background.

Systems & Network Training

Network & Security

Network Engineer

Complete REXX programming

General Admission

<h3><b>Advanced UNIX shell scripting training course description</b></h3>
      <p>A follow on hands on course from the Introduction to
shell programming course covering the powerful sed
and awk tools along with the extra Korn shell
programming features.
 </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			<li>Use regular expressions within grep, ed and many
other utilities.</li>
					<li>Use awk and sed.</li>
                    <li>Integrate sed and awk into shell scripts.</li>
                    <li>Recognise the role of shell scripts within the UNIX system. </li>
					<li>Write shell scripts using new Korn shell features
						including:</li>
						<ul><li>The select construct</li>
							<li>Arrays</li>
							<li>Arithmetic evaluation</li>
                  </ul>
				</ul>
        <h5>
        <b> Advanced UNIX shell scripting training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers developing applications under UNIX.<br />
Administrators who need time saving utilities. <br />Technical
personnel who wish to make the most out of the Korn
Shell.
                   </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>UNIX shell scripting<br />
								
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b> Advanced UNIX shell scripting training course contents</b></h3>
      <ul>
				<li>Regular Expressions</li>

<p>What are REs? How can they be used? How to
write REs

</p><li>More REs </li><p>
e REs
Tagging, matching words, repetitions.


</p><li>The sed editor</li><p>
Basic usage: Saving output, options. sed script
files, sed commands, Specifying lines to edit, Hold
space and pattern space, advanced commands


</p><li>Awk
</li><p>
Basic usage, nawk script files, Patterns, Records
and fields,<br />
		  <b>Actions</b>
if, while, do, for...<br />
		  <b>System variables</b>
NF, NR, RS...<br />
Arrays<br />
		  <b>Functions</b>
length, printf, cos, user defined...
Using nawk in shell scripts


</p><li>Korn shell scripts
</li><p>
Review of Bourne shell scripts<br />
functions...<br />
Variables<br />
typeset, manipulating strings
Arrays<br />
Arithmetic evaluation<br />
the let command, (( )),<br />
typeset -i<br />
The select construct<br />
Syntax, workings, REPLY, PS3<br />
Miscellaneous<br />
Enhanced I/O, ${10}</p>
      </ul>

Advanced UNIX shell scripting training course description
A follow on hands on course from the Introduction to
shell programming course covering the powerful sed
and awk tools along with the extra Korn shell
programming features. 
What will you learn
Use regular expressions within grep, ed and many
other utilities.
Use awk and sed.
Integrate sed and awk into shell scripts.
Recognise the role of shell scripts within the UNIX system.
Write shell scripts using new Korn shell features including:
The select construct
Arrays
Arithmetic evaluation
Advanced UNIX shell scripting training course details
Who will benefit:
Programmers developing applications under UNIX.

Administrators who need time saving utilities. 
Technical
personnel who wish to make the most out of the Korn
Shell. 
Prerequisites:
UNIX shell scripting
 
Duration
3 days 
 Advanced UNIX shell scripting training course contents
Regular Expressions
What are REs? How can they be used? How to
write REs 
More REs

e REs
Tagging, matching words, repetitions. 
The sed editor

Basic usage: Saving output, options. sed script
files, sed commands, Specifying lines to edit, Hold
space and pattern space, advanced commands 
Awk

Basic usage, nawk script files, Patterns, Records
and fields,
 Actions
if, while, do, for...
 System variables
NF, NR, RS...

Arrays
 Functions
length, printf, cos, user defined...
Using nawk in shell scripts 
Korn shell scripts

Review of Bourne shell scripts

functions...

Variables

typeset, manipulating strings
Arrays

Arithmetic evaluation

the let command, (( )),

typeset -i

The select construct

Syntax, workings, REPLY, PS3

Miscellaneous

Enhanced I/O, ${10}

Advanced UNIX shell programming

<h3><b>Complete C programming training course description</b></h3>
      <p> A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
		   <li>Write ANSI C programs</li>
					<li>Use the C libraries</li>
                    <li>Debug C programs</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>Complete C programming training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers wishing to learn C.<br />
                    Programmers wishing to learn C++ or Java.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> None, although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Complete C programming training course contents</b></h3>
      <ul>
				<li>Getting started </li><p>
The compilation process, comments, main(), statement blocks, printf().

</p><li>C data types and operators </li><p>
char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity.

</p><li>Basic I/O </li><p>
C libraries, stdin and stdout, getchar(), putchar(), printf() formatting.

</p><li>Flow control </li><p>
if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos.

</p><li>Functions </li><p>
Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables.

</p><li>The preprocessor </li><p>
Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation.

</p><li>More data types and operators </li><p>
Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers.

</p><li>Arrays </li><p>
Declaring and handling arrays, common gotchas, multidimensional arrays.

</p><li>Pointers </li><p>
What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments.

</p><li>More pointers </li><p>
Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection.

</p><li>Character/string manipulation </li><p>
Arrays of characters, string definition, working with strings, String library.

</p><li>Program arguments </li><p>
argc and argv, example uses,char *argv[] versus char ** argv.

</p><li>Program structure and storage classes </li><p>
Globals (externals), multi source programs, the look of a C program.

</p><li>Structures </li><p>
Declaration, the . and - operators, unions and bitfields.

</p><li>Library functions </li><p>
File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()</p>
			
      </ul>

Complete C programming training course description
 A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs.
What will you learn
Write ANSI C programs
Use the C libraries
Debug C programs
Examine existing code and determine its function.
Complete C programming training course details
Who will benefit:
Programmers wishing to learn C.
 Programmers wishing to learn C++ or Java.
Prerequisites:
 None, although experience in another high level language would be useful. 
Duration
5 days 
Complete C programming training course contents
Getting started

The compilation process, comments, main(), statement blocks, printf(). 
C data types and operators

char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity. 
Basic I/O

C libraries, stdin and stdout, getchar(), putchar(), printf() formatting. 
Flow control

if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos. 
Functions

Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables. 
The preprocessor

Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation. 
More data types and operators

Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers. 
Arrays

Declaring and handling arrays, common gotchas, multidimensional arrays. 
Pointers

What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments. 
More pointers

Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection. 
Character/string manipulation

Arrays of characters, string definition, working with strings, String library. 
Program arguments

argc and argv, example uses,char *argv[] versus char ** argv. 
Program structure and storage classes

Globals (externals), multi source programs, the look of a C program. 
Structures

Declaration, the . and - operators, unions and bitfields. 
Library functions

File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()

Complete C programming

<h3><b>Oracle SQL training course description</b></h3>
        <p>The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Create SQL statements to query database tables.</li>
<li>Use standard aggregate functions and related SELECT statement clauses.</li>
<li>Join Tables.</li>
<li>Use basic subqueries and the set operators.</li>
<li>Use numeric, character and date functions.</li>
<li>Use conversion and other miscellaneous functions.</li>
<li>Use SQL parameters.</li>
<li>Use complex subqueries.</li>
<li>Create and alter tables and views.</li>
<li>Insert, update and delete rows in database tables.</li>
<li>Manage sequences and synonyms.
</li>
                  </ul>
        <h5>
        <b>Oracle SQL training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Oracle SQL training course contents</b></h3>
      <ul>
        <li>Retrieving data with the SELECT statement </li><p>
The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators.

</p><li>Aggregate functions </li><p>
Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause.

</p><li>Joining tables </li><p>
Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins.

</p><li>Basic subqueries and set operators </li><p>
Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators.

</p><li>Numeric, character and data functions </li><p>
Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions.

</p><li>Conversion and miscellaneous functions </li><p>
Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions.

</p><li>SQL parameters </li><p>
Command line substitution parameters, The accept command, The define and undefine commands.

</p><li>Complex subqueries </li><p>
Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators.

</p><li>Managing data </li><p>
Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer.

</p><li>Managing tables </li><p>
Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables.

</p><li>Managing indexes and views </li><p>
Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views.

</p><li>Managing sequences and synonyms </li><p>
Create a sequence, View sequence details, Create a synonym, List synonyms.
				</p>
      </ul>

Oracle SQL training course description
The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.
What will you learn
Create SQL statements to query database tables.
Use standard aggregate functions and related SELECT statement clauses.
Join Tables.
Use basic subqueries and the set operators.
Use numeric, character and date functions.
Use conversion and other miscellaneous functions.
Use SQL parameters.
Use complex subqueries.
Create and alter tables and views.
Insert, update and delete rows in database tables.
Manage sequences and synonyms.
Oracle SQL training course details
Who will benefit:
Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database.
Prerequisites:
None.
Duration
3 days
Oracle SQL training course contents
Retrieving data with the SELECT statement

The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. 
Aggregate functions

Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. 
Joining tables

Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. 
Basic subqueries and set operators

Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. 
Numeric, character and data functions

Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. 
Conversion and miscellaneous functions

Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. 
SQL parameters

Command line substitution parameters, The accept command, The define and undefine commands. 
Complex subqueries

Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. 
Managing data

Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. 
Managing tables

Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. 
Managing indexes and views

Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. 
Managing sequences and synonyms

Create a sequence, View sequence details, Create a synonym, List synonyms. 

Oracle SQL foundation

<h3><b>MySQL foundation training course description</b></h3>
        <p> The MySQL foundation course covers the basics of the
SQL language as implemented by MySQL. The course
is designed to give delegates practical experience in
writing SQL statements using the MySQL client
program and MySQL Workbench. The basic SQL
statements, including the use of SQL functions and the
basic table and view handling statements are
introduced.    </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Create, alter and drop a MySQL database.</li>
						<li>Write SQL statements.</li>
						<li>Use SQL expressions and functions.</li>
                        <li>Create and alter tables, indexes and views.</li>
                        <li>Use transactions.</li>
                        <li>Grant and revoke access privileges.</li>
                        <li>Export and import data.</li>
                  </ul>
        <h5>
        <b>MySQL foundation training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to access and work with a MySQL Database.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>An understanding of databases and exposure to
information technology in general would be useful.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL foundation training course contents</b></h3>
      <ul>
        <li>Database concepts </li><p>
What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases.
<br /><span>Hands on</span> using a database.

</p><li>Using the MySQL client </li><p>
What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts.
<br /><span>Hands on</span> Using the MySQL client.

</p><li>Basic SELECT </li><p>
The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators.
<br /><span>Hands on</span> querying the sample database.

</p><li>LIMIT, UNION and AGGREGATE functions </li><p>
The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.
<br /><span>Hands on</span> using limit, union and aggregate functions.

</p><li>Subqueries and joins </li><p>
Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. <br /><span>Hands on</span> using subqueries and joins.

</p><li>Numeric and character functions </li><p>
Function types, testing functions, numeric functions character functions.
<br /><span>Hands on</span> using numeric and character functions.

</p><li>Data, time and other functions </li><p>
Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions.
<br /><span>Hands on</span> using date, time and other functions.

</p><li>Databases and tables </li><p>
Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables.
<br /><span>Hands on</span> maintaining databases and tables.

</p><li>Indexes and views </li><p>
What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.
<br /><span>Hands on</span> maintaining indexes and views.

</p><li>Managing data </li><p>
Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.
<br /><span>Hands on</span> managing data.

</p><li>Access control </li><p>
Creating users, renaming users, dropping users, granting privileges, revoking privileges. <br /><span>Hands on</span> creating users, granting and revoking.

</p><li>Import and export </li><p>
Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.
<br /><span>Hands on</span> export and import data.
</p>
      </ul>

MySQL foundation training course description
 The MySQL foundation course covers the basics of the
SQL language as implemented by MySQL. The course
is designed to give delegates practical experience in
writing SQL statements using the MySQL client
program and MySQL Workbench. The basic SQL
statements, including the use of SQL functions and the
basic table and view handling statements are
introduced. 
What will you learn
Create, alter and drop a MySQL database.
Write SQL statements.
Use SQL expressions and functions.
Create and alter tables, indexes and views.
Use transactions.
Grant and revoke access privileges.
Export and import data.
MySQL foundation training course details
Who will benefit:
Anyone who needs to access and work with a MySQL Database.
Prerequisites:
An understanding of databases and exposure to
information technology in general would be useful.
Duration
3 days
MySQL foundation training course contents
Database concepts

What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases.

Hands on using a database. 
Using the MySQL client

What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts.

Hands on Using the MySQL client. 
Basic SELECT

The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators.

Hands on querying the sample database. 
LIMIT, UNION and AGGREGATE functions

The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.

Hands on using limit, union and aggregate functions. 
Subqueries and joins

Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. 
Hands on using subqueries and joins. 
Numeric and character functions

Function types, testing functions, numeric functions character functions.

Hands on using numeric and character functions. 
Data, time and other functions

Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions.

Hands on using date, time and other functions. 
Databases and tables

Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables.

Hands on maintaining databases and tables. 
Indexes and views

What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.

Hands on maintaining indexes and views. 
Managing data

Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.

Hands on managing data. 
Access control

Creating users, renaming users, dropping users, granting privileges, revoking privileges. 
Hands on creating users, granting and revoking. 
Import and export

Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.

Hands on export and import data.


MySQL foundation

<h3><b>COBOL training course description</b></h3>
      <p> A hands on training course providing an introduction to COBOL.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Write COBOL programs</li>
				  	<li>Debug COBOL programs</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>COBOL training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
            <p>Programmers working with COBOL.
							</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>COBOL training course contents</b></h3>
      <ul>
				<li>Introduction to COBOL </li><p>
Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure.

</p><li>COBOL statement structure </li><p>
COBOL words, format of statements.

</p><li>Divisions </li><p>
Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry.

</p><li>File and Working-Storage Sections </li><p>
Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause.

</p><li>Procedure Division </li><p>
File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification.

</p><li>Perform statement </li><p>
Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement.

</p><li>Program design </li><p>
Design techniques, design considerations, procedure names, program structure.

</p><li>Printing </li><p>
Printed output, Write, advancing option, editing characters; Initialize.

</p><li>Condition testing </li><p>
Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue.

</p><li>Arithmetic </li><p>
Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute.

</p><li>Non-sequential files </li><p>
File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start.

</p><li>Declarative routines </li><p>
Clauses.

</p><li>Subroutines </li><p>
Call, Using clause - calling program/called program, Linkage Section, returning control.

</p><li>Table handling </li><p>
Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing.

</p><li>Data Manipulation </li><p>
Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.</p>
			
      </ul>

COBOL training course description
 A hands on training course providing an introduction to COBOL.
What will you learn
Write COBOL programs
Debug COBOL programs
Examine existing code and determine its function.
COBOL training course details
Who will benefit:
Programmers working with COBOL. 
Prerequisites:
None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming. 
Duration
5 days 
COBOL training course contents
Introduction to COBOL

Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure. 
COBOL statement structure

COBOL words, format of statements. 
Divisions

Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry. 
File and Working-Storage Sections

Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause. 
Procedure Division

File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification. 
Perform statement

Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement. 
Program design

Design techniques, design considerations, procedure names, program structure. 
Printing

Printed output, Write, advancing option, editing characters; Initialize. 
Condition testing

Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue. 
Arithmetic

Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute. 
Non-sequential files

File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start. 
Declarative routines

Clauses. 
Subroutines

Call, Using clause - calling program/called program, Linkage Section, returning control. 
Table handling

Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing. 
Data Manipulation

Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.

Complete COBOL programming

<h3><b>Linux shell scripting training course description</b></h3>
      <p> A practical introduction to writing scripts using the Bourne shell under any Linux operating system. Applicable for those using the Korn shell as well. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			  <li>Read shell scripts.</li>
																			<li>Write shell scripts.</li>
                   <li>Use different types of quotes.</li>
                   <li>Recognise the role of shell scripts within the Linux system. </li>
                  </ul>
        <h5>
        <b>Linux shell scripting training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers developing programs under UNIX.<br />
                    Administrators / support personnel who wish to find out more about the workings of Linux or write simple utility programs.</p>
						   
              
							<li><b>Prerequisites:</b></li>
							
              <p>Linux Fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Linux shell scripting training course contents</b></h3>
      <ul>
				<li><b>Review of Linux fundamentals</b> </li><p>
</p><li>Basic shell scripts </li><p>
What does the shell do? How are commands
executed? Different shells. what is a shell script?
Comments, creating shell scripts.
</p><li>Variables </li><p>
Setting variables, using variables, set, scope,
export, sourcing, environmental variables, read.
</p><li>Positional parameters </li><p>
$0 to $9, $#, $* and others. shift parameter
substitution.
</p><li>Control statements </li><p>
The test command
The if statement
while loops
for loops
The case statement.
</p><li>Special characters </li><p>
Redirection of errors, here documents, quoting.
</p><li>Arithmetic in shell scripts </li><p>
The expr command.
</p><li>System shell scripts </li><p>
</p><li>Screen handling </li><p>
The terminfo database,
The tput command.
</p><li>Advanced issues (optional session) </li><p>
Shell functions, getopts, xargs, debugging shell
scripts, portability issues. Extras in the Korn shell.
</p><li>Optimising shell scripts </li><p>
The time command, performance tips.</p>
      </ul>

Linux shell scripting training course description
 A practical introduction to writing scripts using the Bourne shell under any Linux operating system. Applicable for those using the Korn shell as well. 
What will you learn
Read shell scripts.
Write shell scripts.
Use different types of quotes.
Recognise the role of shell scripts within the Linux system.
Linux shell scripting training course details
Who will benefit:
Programmers developing programs under UNIX.
 Administrators / support personnel who wish to find out more about the workings of Linux or write simple utility programs.
Prerequisites:
Linux Fundamentals 
Duration
2 days 
Linux shell scripting training course contents
Review of Linux fundamentals


Basic shell scripts

What does the shell do? How are commands
executed? Different shells. what is a shell script?
Comments, creating shell scripts.

Variables

Setting variables, using variables, set, scope,
export, sourcing, environmental variables, read.

Positional parameters

$0 to $9, $#, $* and others. shift parameter
substitution.

Control statements

The test command
The if statement
while loops
for loops
The case statement.

Special characters

Redirection of errors, here documents, quoting.

Arithmetic in shell scripts

The expr command.

System shell scripts


Screen handling

The terminfo database,
The tput command.

Advanced issues (optional session)

Shell functions, getopts, xargs, debugging shell
scripts, portability issues. Extras in the Korn shell.

Optimising shell scripts

The time command, performance tips.

Linux shell scripting

<h3><b>UNIX shell programming training course description</b></h3>
      <p>This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			<li>Read shell scripts.</li>
					<li>Write shell scripts.</li>
                    <li>Use different types of quotes.</li>
                    <li>Recognise the role of shell scripts within the UNIX system. </li>
                  </ul>
        <h5>
        <b>UNIX shell programming training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers developing programs under UNIX.<br />
                    Anyone working with XML.<br />
                    Administrators<br />Support personnel who wish to find out more about the workings of UNIX or write simple utility programs.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>UNIX fundamentals<br />
								Some programming experience would be useful although not essential.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>UNIX shell programming training course contents</b></h3>
      <ul>
				<li>Review of UNIX fundamentals </li><p>

</p><li>Basic shell scripts </li><p>
What does the shell do? How are commands executed? Different shells. What is a shell script? Comments, creating shell scripts.

</p><li>Variables </li><p>
Setting variables, using variables, set, scope, export, sourcing, environmental variables, read.

</p><li>Positional parameters </li><p>
0 to $9, $#, $* and others. shift parameter substitution.

</p><li>Control statements </li><p>
The test command, 
The if statement, 
while loops, 
for loops, 
The case statement, 
Special characters, 
Redirection of errors, here documents, quoting.

</p><li>Arithmetic in shell scripts </li><p>
The expr command.

</p><li>System shell scripts </li><p>
</p><li>Screen handling </li><p>
The terminfo database<br />
The tput comand
</p><li>Avanced issues (optional session) </li><p>
Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell.

</p><li>Optimising shell scripts </li><p>
The time command, performance tips.</p>
      </ul>

UNIX shell programming training course description
This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents. 
What will you learn
Read shell scripts.
Write shell scripts.
Use different types of quotes.
Recognise the role of shell scripts within the UNIX system.
UNIX shell programming training course details
Who will benefit:
Programmers developing programs under UNIX.
 Anyone working with XML.
 Administrators
Support personnel who wish to find out more about the workings of UNIX or write simple utility programs.
Prerequisites:
UNIX fundamentals
 Some programming experience would be useful although not essential. 
Duration
2 days 
UNIX shell programming training course contents
Review of UNIX fundamentals
 
Basic shell scripts

What does the shell do? How are commands executed? Different shells. What is a shell script? Comments, creating shell scripts. 
Variables

Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. 
Positional parameters

0 to $9, $#, $* and others. shift parameter substitution. 
Control statements

The test command, The if statement, while loops, for loops, The case statement, Special characters, Redirection of errors, here documents, quoting. 
Arithmetic in shell scripts

The expr command. 
System shell scripts


Screen handling

The terminfo database

The tput comand

Avanced issues (optional session)

Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell. 
Optimising shell scripts

The time command, performance tips.

UNIX shell programming

<h3><b>Total PHP training course description</b></h3>
      <p>   PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                        <li>Create dynamic web sites using PHP.</li>
					<li>Write PHP programs.</li>
                    <li>Debug PHP programs.</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>Total PHP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone creating dynamic web sites.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Software development fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total PHP training course contents</b></h3>
      <ul>
				<li>What is PHP? </li><p>
PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues.

</p><li>A first PHP web page </li><p>
A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML.

</p><li>PHP forms </li><p>
HTML forms, taking values from forms.

</p><li>PHP and HTML </li><p>
Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript.

</p><li>Variables operators and expressions </li><p>
Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables.

</p><li>Operators </li><p>
Arithmetic, logical, relational, Boolean, others.

</p><li>Control statements </li><p>
Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit.

</p><li>Functions </li><p>
Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name.

</p><li>Arrays </li><p>
Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions.

</p><li>String handling </li><p>
What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs.

</p><li>PHP and databases </li><p>
Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling.

</p><li>File I/O </li><p>
Opening, reading, writing files. Permissions, ownership, locking, directories.

</p><li>PHP, cookies and sessions </li><p> 
State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs.

</p><li>PHP and email </li><p>
Emailing from servers, attachments.

</p><li>Objects </li><p>
OOP, PHP classes, constructors, instances.</p>
			
      </ul>

Total PHP training course description
 PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.
What will you learn
Create dynamic web sites using PHP.
Write PHP programs.
Debug PHP programs.
Examine existing code and determine its function.
Total PHP training course details
Who will benefit:
Anyone creating dynamic web sites.
Prerequisites:
Software development fundamentals 
Duration
3 days 
Total PHP training course contents
What is PHP?

PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues. 
A first PHP web page

A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML. 
PHP forms

HTML forms, taking values from forms. 
PHP and HTML

Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript. 
Variables operators and expressions

Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables. 
Operators

Arithmetic, logical, relational, Boolean, others. 
Control statements

Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit. 
Functions

Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name. 
Arrays

Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions. 
String handling

What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs. 
PHP and databases

Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling. 
File I/O

Opening, reading, writing files. Permissions, ownership, locking, directories. 
PHP, cookies and sessions
 State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs. 
PHP and email

Emailing from servers, attachments. 
Objects

OOP, PHP classes, constructors, instances.

Total PHP for developers

London

<div>
	                  <h5>Oracle SQL Fundamentals Course Summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  At this Oracle SQL Fundamentals couse, we cover SQL  queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom funtions, table variables.		  
					<br />Course level is beginners to intermediate.
				   
					 
					 
					 
				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Oracle SQL Fundamentals Course Outline</h5>
	                  </div>
	                  <div></div>
	                   
	    <div>
			<strong>Session 1: Database Concepts Revision: </strong> 
			 <p>  What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
	 
			</p>
		</div>
		<div>
			<strong>Session 2: </strong>  
			<p> 	
			</p><ul>
			<li>
			  The SQL SELECT statement:WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,smaller and bigger than ,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT  TOP, Distinct 
			</li>
			</ul> 
			<p></p>
		</div>	 
		<div>
			<strong>Session 3:</strong>  
			<p> 
			</p><li> Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

			</li>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 4: </strong>  
			<p></p><ul>
				<li>SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.
				</li> 
				</ul>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 5:</strong>  
			<p></p><ul> <li> Joins: SQL Cartesian products, 
			 </li><li>SQL Joins (Inner join, Left join, Right join, Full join
			 </li><li>Table aliases, Natural joins, Multi-table joins. 
			 </li><li>Union, Union All, Except, Intersect
			 </li></ul>
			<p></p>
		</div>	
		<div>
			<strong>Session 6:</strong>  
			<p></p><ul> <li>
			Sub-queries: SQL Subqueries, Nested Subqueries, 
			</li><li>'WITH AS',
			</li><li>			Correlated and uncorrelated subqueries.  
			 </li></ul>
			<p></p>
		</div>

		<div>
			<strong>Session 7:</strong>  
			<p></p><ul> <li>
			 Numeric Functions, 
			 </li><li>String Functions, 
			</li><li>			 Date Functions
			Date, time and timezone support,  
			</li><li>Conversion and 
			</li><li>Formatting
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 8:</strong>  
			<p></p><ul> <li>
			SQL Views: Create, alter and drop Views 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 9:</strong>  
			<p></p><ul> <li>
			Inserting rows, 
			</li><li>Replacing rows, 
			</li><li>Updating rows, 
			</li><li>Deleting rows
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 10:</strong>  
			<p></p><ul> <li>
			Session 10: Managing indexes 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 11:</strong>  
			<p></p><ul> <li>
			 Creating Databases and 
			 </li><li>Creating Tables (Create, alter and drop); </li><li>Constraints (Add, alter and drop)  
			 </li><li>Temp tables
			</li><li>Managing sequences and synonyms 
			 </li></ul>
			<p></p>
		</div>
		<div>
					<strong>Session 12:</strong>  
					<p></p><ul> <li>
					 Import data into SQL and Export from SQL
					
					 </li></ul>
					<p></p>
		</div>		
		 
		 
		 
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the SQL Advanced Course:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>SQL Advanced Course Certificate on completion  </li>
	                        <li>SQL Advanced Course notes</li>
	                        <li>Practical SQL Course exercises, SQL Code Sample</li>
	                         
	                        <li>After the course, 1 free session for questions online SQL Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this SQL Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Oracle SQL Fundamentals Course 
 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 
Oracle SQL Fundamentals Course Outline
Session 1: Database Concepts Revision:
 What is a database? Tables, rows and columns, Indexes, primary keys, foreign keys, 
Session 2:
 The SQL SELECT statement: WHERE clause, Boolean operators (AND and OR), and SQL conditional operators (=,!=, smaller and bigger than, IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT TOP, Distinct

Session 3:
Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

Session 4:
SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.

Session 5:
Joins: SQL Cartesian products,
SQL Joins (Inner join, Left join, Right join, Full join)
Table aliases, Natural joins, Multi-table joins.
Union, Union All, Except, Intersect

Session 6:

Sub-queries: SQL Subqueries, Nested Subqueries,
'WITH AS',
Correlated and uncorrelated subqueries.

Session 7:

Numeric Functions,
String Functions,
Date Functions Date, time and timezone support,
Conversion and
Formatting

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

Creating Databases and
Creating Tables (Create, alter and drop);
Constraints (Add, alter and drop)
Temp tables
Managing sequences and synonyms

Session 12:

Import data into SQL and Export from SQL

What is included in the Oracle SQL Course:
Oracle SQL Course Certificate on completion
Oracle SQL Course notes
Practical Oracle SQL Course exercises, Oracle SQL Code Sample
After the course, 1 free session for questions online Oracle SQL Course 
Max group size, online and in classroom, on this Oracle SQL Course is 4.

PCWorkshops

Database Design & Development

Oracle SQL

Database Programming

Database Administration

 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 

Educators providing Arithmetic courses in London delivered Live Online