SQL & NoSQL
Course List
Schedule & Reviews
 
 
 
 

SQL & NoSQL Course List

  Course Code Duration Price (exc. VAT)  
Advanced Querying Microsoft SQL Server with Transact-SQL TSQLA 2 days £750.00
Introduction to MariaDB MARI 3 days £995.00
Introduction to MySQL MYSI 3 days £995.00
Introduction to SQL ISQL 1 day   £450.00
Introduction to SQL on Oracle ISQLO 1 day   £450.00
Microsoft SQL Server with Transact-SQL TSQL 5 days £1,750.00
MongoDB Essentials MONGOE 2 days £995.00
Oracle 11g Release 2 SQL Performance Tuning O11GSPT 2 days £895.00
Oracle 12c SQL Performance Tuning O12CSPT 2 days £895.00
Oracle Introduction for Experienced SQL Users OIEU 2 days £895.00
Oracle PL/SQL OPI 2 days £895.00
Oracle SQL OSP 3 days £1,350.00
Oracle SQL & PL/SQL Fundamentals OFUN 5 days £2,120.00
Oracle SQL Advanced OSA 2 days £895.00
Oracle SQL Fundamentals OSF 5 days £2,120.00
PostgreSQL Administration PSQLADM 5 days £1,995.00
Programming Microsoft SQL Server with Transact-SQL TSQLP 2 days £750.00
Querying Microsoft SQL Server with Transact-SQL TSQLI 3 days £1,125.00
SQL for PostgreSQL PSQL 3 days £1,150.00
 

SQL & NoSQL Overview

 

Structured Query Language - aka SQL

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system.

The standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.

MongoDB

MongoDB is an open source database that uses a document-oriented data model.

MongoDB is one of several database types to arise in the mid-2000s under the NoSQL banner. Instead of using tables and rows as in relational databases, MongoDB is built on an architecture of collections and documents. Documents comprise sets of key-value pairs and are the basic unit of data in MongoDB. Collections contain sets of documents and function as the equivalent of relational database tables.

Training Options

StayAhead Training offer a range of SQL courses on various platforms including Microsoft, Postgres, MySQL, MariaDB and Oracle. All StayAhead SQL courses can be modified or tailored for delivery on your premises.

 



Our Course Curriculum

 
 
 
 
 
 

Established 1992, with centres throughout the UK, featuring a team of full-time dedicated professional training consultants...

StayAhead Training is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP and Web Development training. These technical courses are complemented by a range of ITIL & Business Analysis courses.

Scheduled courses are available in 7 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds, Sunderland and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client. Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java and HP-UX.

Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price. Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.

 
+44 (0)20 7600 6116
Copyright © 2018 StayAhead Training Ltd
Cookies   /   Privacy Policy
sales@stayahead.com