SQL & NoSQL
25 Years - The IT Training specialist

  SQL & NoSQL

NoSQL and SQL Courses  |   Microsoft T-SQL Courses  |   PostgreSQL Courses 
Oracle SQL Courses 


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.

Course Schedule for May to August 2018


  SQL & NoSQL Courses



Dates don't suit? Let us know your preference!

 

  NoSQL and SQL Courses

COURSE     DAYS MAY JUNE JULY AUG FEE (£)
MongoDB Essentials (MONGOE)
2 29   16 995 
Introduction to SQL (ISQL)
1   1 21 20 20 23 23 30 28 450 
Introduction to MySQL (MYSI)
3   27 9 1 995 
Introduction to MariaDB (MARI)
3   27 9 1 995 
View Next Four Months
 

  Microsoft T-SQL Courses

COURSE     DAYS MAY JUNE JULY AUG FEE (£)
Querying Microsoft SQL Server with Transact-SQL (TSQLI)
3 21   2 20 1,125 
Advanced Querying Microsoft SQL Server with Transact-SQL (TSQLA)
2 24   5 23 750 
Microsoft SQL Server with Transact-SQL (TSQL)
5 21   2 20 1,750 
Programming Microsoft SQL Server with Transact-SQL (TSQLP)
2 31   12 750 
View Next Four Months
 

  PostgreSQL Courses

COURSE     DAYS MAY JUNE JULY AUG FEE (£)
SQL for PostgreSQL (PSQL)   New
3   4 16 1,150 
PostgreSQL Administration (PSQLADM)   New
5   11 23 1,995 
View Next Four Months
 

  Oracle SQL Courses

COURSE     DAYS MAY JUNE JULY AUG FEE (£)
Introduction to SQL (ISQL)
1   1 21 20 20 23 23 30 28 450 
Introduction to SQL on Oracle (ISQLO)
1   11 18 18 25 9 9 16 30 30 6 13 20 450 
Oracle SQL (OSP)
3   11 18 18 25 9 9 16 30 30 6 13 20 1,350 
Oracle PL/SQL (OPI)
2   4 14 21 21 28 12 12 19 23 2 2 9 16 23 895 
Oracle SQL & PL/SQL Fundamentals (OFUN)
5   11 18 18 25 9 9 16 30 30 6 13 20 2,120 
Oracle SQL Advanced (OSA)
2   14 21 21 28 12 12 19 2 2 9 16 23 895 
Oracle SQL Fundamentals (OSF)
5   11 18 18 25 9 9 16 30 30 6 13 20 2,120 
Oracle Introduction for Experienced SQL Users (OIEU)
2   25 13 895 
Oracle 11g Release 2 SQL Performance Tuning (O11GSPT)
2 21   16 895 
Oracle 12c SQL Performance Tuning (O12CSPT)
2 21   16 895 
COURSE     DAYS MAY JUNE JULY AUG FEE (£)

  SQL & NoSQL Courses




Quick Search...

Next Four Months Enquiry


 

StayAhead Training Centres



If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.


Virtual Events StayAhead Virtual Courses available

Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

Business Analysis, ITIL & Prince2

Overview of our SQL & NoSQL courses

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.

Recent Course Reviews

Well paced and informative course. Documentation was excellent, trainer communication was excellent - I've learned more about Linux this week than in the last 5 years.
Jonathan - IT Operations Team Lead
Finance - May 2018
Very informative course. Covered a lot of ground in the time given. Good basis to further develop upon. I look forward to further follow up training in due course. Instructor was very engaging and knowledgeable.
Naj - Analyst
Finance - March 2018
Thank you, the course was brilliant. All questions answered, a lot of practical exercises and really good attention to details. I enjoyed it very much.
Tanya - DBA, BI reporter
IT - March 2018

More Reviews

See what our clients say . . .

Well paced and informative course. Documentation was excellent, trainer communication was excellent - I've learned more about Linux this week than in the last 5 years.

Jonathan - IT Operations Team Lead - Finance - May 2018

More Reviews

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