Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Dates & Prices
Back to course information
This Introduction to SQL training course explores the following modules:
SQL – An Overview
Working with tables
Data Manipulation Language
Aggregation and grouping
This training course is designed for anyone who is interested in learning more about SQL language and databases.
There are no formal prerequisites - this course is open to any individuals looking to develop their knowledge of Structured Query Language. Some experience of using Windows and relational databases would be useful, but is not compulsory.
SQL (Structured Query Language) is the most popular database language in the world. It is used widely by a variety of database systems to create queries and manipulate data. SQL is generic and compatible with the majority of database systems, which explains its widespread use and why SQL certified individuals are highly valued by businesses.
During this SQL training course, delegates will be introduced to the fundamentals of SQL and will gain an insight into the essentials of relational databases. As this is a 1-day course, delegates will quickly acquire an understanding of vital querying language concepts and will emerge from this course as well-informed individuals who are able to implement their knowledge immediately within their own organisation.
Throughout this training course, delegates will engage in tasks and exercises to ensure that they become familiar with the basic features of SQL in practical terms. On course completion, delegates will be able to comfortably use SQL to select, organise, insert, delete, and review data within a database. They will also understand some advanced SQL statements and be familiar with the main functions of SQL such as conversions, SQL syntax, and dates.
Attendees will not be experts (if this is desired, see our Advanced SQL training course), but will be able to use SQL to conduct daily tasks and queries.
During this course you will:
Stored Procedure Basics
Parameters and Return Values
Avoiding Scalar Functions
Temporary Tables and Table Variables
Table Valued Functions
Derived Tables and CTEs
This course is for individuals who are familiar with SQL and would like to improve their skills and expand on their knowledge.
It is required that delegates have a prior understanding of SQL, and so it is necessary for delegates to have attended the Introduction to SQL training course before enrolling on this Advanced SQL course.
SQL (Structured Query Language) is the world’s most widely used database language, utilised by a large variety of database systems for creating queries and manipulating data. Advanced SQL Developers are currently greatly in demand by the IT industry, and a high level of understanding of advanced SQL techniques can put individuals at an advantage when planning to enter into this field of work, or when wishing to enhance their position within their current SQL-based working environment.
This Advanced SQL training course, which has a duration of two days, builds upon the prior knowledge and understanding of SQL, as taught in the Introduction to SQL course. Thus, this Advanced SQL course focusses on sharing new, complex SQL techniques, allowing the delegates to understand the core innovative SQL concepts currently present in the database world. This course creates capable SQL users, confident in executing more complicated commands when viewing and managing tables and running complex queries.
SQL techniques taught during the course include creating and managing tables, Data Manipulation Language (DML), enabling the production of Databases and Apps, and scaling emerging and dynamic technological networks. On completion of the training course, delegates will have a thorough understanding of these techniques, and will have obtained the skills necessary to effectively manage a relational database.
The Fundamentals of MySQL training course will cover the following topics:
This course is ideal for professionals who are required to work with a MySQL Database
There are no official prerequisites for this course
MySQL is an open-source relational database management system (RDBMS) which is based upon SQL (Structured Query Language). SQL is the most commonly used language for adding, accessing, and managing the content within a database and is used by a large variety of database systems, including MySQL. This course aims to teach delegates the basics of MySQL, including managing data, database concepts, and SQL expressions. By completing this course, delegates will be able to apply what they have learned and improve how they use MySQL, subsequently improving the quality of their organisation’s databases.
The SQL Training Server Reporting Service Masterclass includes the following modules:
Module 1: Introducing SQL Server Reporting Services (SSRS)
Module 2: Reporting Services Framework
Module 3: Simple Report Design
Module 4: Layout and Formatting
Module 5: Advanced Report Design
Modules 6: Tables and Charts Reports
Modules 7: Data Access Design
Module 8: Content Management and Server Administration
This SQL course is suitable for delegates who work with any and all versions of SQL, and who would like to know how to use this system and expand their knowledge.
There are no required pre-requisites for this course, however, it does presume that the delegate will have a prior understanding of SQL language.
SQL (Structured Query Language) is the world’s most widely used database language, utilised by a large variety of database systems for creating queries and manipulating data. SQL users are currently greatly in demand by the IT industry, and a level of understanding of how to create, publish, and manage reports using SQL techniques can put individuals at an advantage when planning to enter into this field of work, or when wishing to enhance their position within their current SQL-based working environment.
The SQL Training Server Reporting Services Masterclass course, with a duration of one day, will provide a thorough understanding of what makes up SQL Server Reporting Services, looking at its architecture and the terminology used. Delegates will learn how to use this server, and to create, design, utilise, secure, and manage reports. The first part of the course will introduce delegates to the Visual Studio and ReportBuilder 3.0 application for creating, saving, and issuing reports.
Delegates will also learn to add customisation to expressions and functions, and also learn how to format reports, implement shared data, and create parameter-based reports using Report Designer. Further, they will be taught how to deploy and manage Reporting Services, in order to save it to SSRS repository, alongside managing the security of reports through user accounts.
Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +64 800 446148 or Enquire.
Our training experts have compiled a range of course packages to compliment a variety of categories in order to help fast track your career. The packages consist of the best possible qualifications in each industry and allows you to purchase multiple courses at a discounted rate.
Introduction to SQLNZD1339
Microsoft Power BI TrainingNZD1529
Total without package: NZD4783
Package price: NZD3595 (Save NZD1188)
Swipe for more. Don’t miss out!
Good instructor gave clear explanations
Really enjoyed the course, the instructor went at a steady pace and was great to be hands on too and use SQL as we learnt.
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
We are accredited by PeopleCert on behalf of AXELOS
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell