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 June to September 2018


  SQL & NoSQL Courses



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

 

  NoSQL and SQL Courses

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

  Microsoft T-SQL Courses

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

  PostgreSQL Courses

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

  Oracle SQL Courses

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

The training was brilliant. I've learned in two days more than I've learned in my college. Excellent trainer. Thank you very much :)
Antonie - System Manager
- May 2018
I was really impressed with how much we managed to achieve in one day. I now feel confident to put some of the learnings into practice and feel that it will really help in my day-to-day role. Really impressed with the instructor, all concepts were explained in a very clear manner and I really enjoyed the day.
Janine - CRM Assistant
Retail / Hire - May 2018
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

See what our clients say . . .

The training was brilliant. I've learned in two days more than I've learned in my college. Excellent trainer. Thank you very much :)

Antonie - System Manager - - May 2018

More Reviews

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