| Available 24 Hours Monday - Friday | +60 1800812339
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

SQL Training | SQL Courses

  • SQL training by qualified database experts
  • SQL is an essential programming language for databases
  • SQL certifications are highly sought after in the IT industry
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Learn the basics of SQL
  • Course includes materials and manuals
Schedule
Course Dates, Locations & Prices (Top) | View Course Info
Course Name Date Location Duration Price Book Online
Introduction to SQL 28/07/17 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 25/08/17 Limited Seats Kuala Lumpur
1 day $1289 Book now Enquire
Introduction to SQL 22/09/17 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 27/10/17 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 24/11/17 Limited Seats Kuala Lumpur
1 day $1289 Book now Enquire
Introduction to SQL 22/12/17 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 26/01/18 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 23/02/18 Limited Seats Kuala Lumpur
1 day $1289 Book now Enquire
Introduction to SQL 23/03/18 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 27/04/18 Kuala Lumpur
1 day $1679 Book now Enquire
Introduction to SQL 25/05/18 Limited Seats Kuala Lumpur
1 day $1289 Book now Enquire
Introduction to SQL 22/06/18 Kuala Lumpur
1 day $1679 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Introduction

This 1 day Introduction to SQL course will teach you the basics of relational databases and the fundamentals of SQL. It has been designed specifically for beginners to SQL and provides a gentle introduction to the programming language using practical examples and without assuming any prior knowledge. By the end of the course, you will be able to confidently create SQL code and carry out queries and edit databases.

 

Prerequisites

As this is a beginner’s course, there are no prerequisites.

 

Who Should Attend?

We recommend this course for anybody interested in understanding SQL and creating queries using the language.

 

Course Structure

The course consists of one day of classroom-based training.

 

Course Content

The course covers the following content:

Course Introduction:

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

 

Relational Database Concepts:

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

 

Essentials of the SQL Language:

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases

Summarising and Grouping Data:

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause

 

Querying Multiple Tables:

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins

 

Why choose The Knowledge Academy?

  • You will receive world-class learning material, including presentation slides and exam guidance
  • We make the learning experience enjoyable using practical examples and group exercises
  • We are trusted by globally leading brands such as JP Morgan, HSBC and Sony as a learning partner of choice.
  • We provide pre- and post-course support so you never feel alone
  • All of our SQL training is hands-on, not just based on theory
  • As a market leader, we have an extremely high global pass rate
  • Over 90% of our delegates come back to us for further training
  • We have the best instructors in the industry which is reflected in our position as the market leader for professional qualifications
  • We provide value for money and trained over 25,000 delegates last year
  • We have some of the most luxurious course venues worldwide

Click ‘Book Now’ or ‘Enquire’ next to the date of your choice and our expert advisors will be in touch.

 

What is SQL?

Structured Query Language (SQL) is a standardised programming language used in Relational Database Management Systems for creating queries and manipulating databases. It is the most used database language in the world, and supported by database systems such as MySQL, Microsoft SQL Server and Oracle Database.

 

Advantages of SQL

  • SQL is a long-established standard which has been adopted by both ANSI and ISO
  • SQL queries can be used to retrieve large amounts of records quickly
  • SQL databases are easy to manage as they do not require the writing of substantial amounts of code
  • SQL is easy to create with and understand, as many of its statements use English
FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.


  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am


What's Included?
  • The Knowledge Academy Courseware Book
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments

best-price      customer-charter

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews
 Contact Us  More Courses

Happy Customers

There hasn't been any testimonials submitted to this topic