Introduction to SQL

Introduction to SQL (Structured Query Language)

SQL is an extremely powerful relational database query language can make your life easy while working with any Relational database (RDBMS).

Manage and maintain large amounts of data using SQL in any Relational database. This instructor led, hands-on class on SQL covers the fundamentals of SQL and the querying of any relational databases using the structured query language.

SQL training at Intellisoft in Singapore
SQL training Class at Intellisoft in Singapore

If you want to learn how to query any database using the SQL Query language, you are in the right place.

SQL is used in almost all Relational Database Systems, like:

  • Oracle
  • MySQL
  • Microsoft SQL Server
  • Microsoft Access
  • MariaDB

SQL Course Duration: 2 Full Days ( 9am to 5pm ),
Instructor Led Classroom Training – The Best Way To Learn SQL

SDF Funding is available to Singapore Companies (For company sponsored SG/PR candidates) who want to learn to use SQL Basics to query any database. Call +65 6296-2995 for Details. SkillsFuture credits ready for Singaporeans.

Recommended Reading: 3 Reasons Why You Should Learn SQL

Whether you work in Business, Finance, IT, Services, Sales, Marketing, Human Resources, Manufacturing, R&D or any other domain, it is important for you to learn SQL.

It empowers you to query any database, since you will learn how to write SQL queries, How to Retrieve Data from any RDBMS, How to Manipulate data using SQL, and How to Update or Delete it easily.

You may be wondering – What the heck is SQL? Why should I learn it. To read more, please visit 3 Reasons Why You Should Learn SQL

SQL training in Singapore
SQL training in Singapore

Objectives of the SQL Training Course

The SQL Course is Instructor led, conducted in a highly interactive classroom setting with many exercises to learn the practical aspects of SQL.

A PC will be provided to each student. during SQL class. You can bring in your own laptop & notebook, if it is pre-loaded with any RDBMS.

Use simple cases and exercises to build SQL Scripts, which interact with the database, and do Insert, Update, Delete and Select operations using SQL in any Relational Database.

We use MySQL database in the classroom for doing the SQL exercises. If you want, You can bring your own laptop with Oracle database, or SQL Server database pre-installed, for doing the SQL language exercises. Other Databases are fine too.

Who Should Attend The SQL Training Class?

The SQL Tutorial Course suits both Beginners and Experienced Users of SQL.

Whether you have a little or no previous experience with a relational database management system, or are an experienced SQL user, you will benefit from the strong foundation and fundamentals of SQL query language class.

Both new SQL Developers and Database Administrators will benefit from this class.

Applies to Any RDBMS, irrespective of Version:

  • ORACLE,
  • MySQL,
  • MS SQL Server,
  • Access
  • MySQL

SQL Training Certificate:
An eCertificate of attendance would be given to all participants who complete this 2 Day SQL training course.

Training Material Provided in SQL Training Class:
Notes in folders, Sample SQL Databases, and Exercise Files  will be provided.

Class Size:
8-12 participants in a typical SQL class. We keep the class size small to give enough attention & support to all participants in learning to write their first SQL statements with confidence and understanding.

It is very practical, and hands-on experience for all participants to learn the power of SQL.

Introduction to SQL Query Language To Create, Update and Query Any Database

  • Installing SQL, command-line and graphical clients/tools.
  • Understand the features and benefits of Using SQL
  • Understand the basics of Using a Relational Database Management System
  • Understand the usage of a Database and SQL query language
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to modify or delete a database
  • Be able to modify or delete table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Understand the primary methods for exporting and importing data using SQL
  • Understand SQL storage engines, transactions and features of the common engines.

What Do You Need To Learn SQL?

Basic computer literacy is required. Knowledge of database concepts would be helpful but is not necessary.

This course would lay the foundation for RDBMS Concepts, and applying them to real world database applications, using the Structured Query Language.

Access to a personal or company database or corporate system can be helpful to practice writing SQL after attending this course.

SQL training in Singapore
SQL training in Singapore

Objectives of the SQL Training Course

The SQL Course is Instructor led, conducted in a highly interactive classroom setting with many exercises to learn the practical aspects of SQL.

A PC will be provided to each student. during SQL class. You can bring in your own laptop & notebook, if it is pre-loaded with any RDBMS.

Use simple cases and exercises to build SQL Scripts, which interact with the database, and do Insert, Update, Delete and Select operations using SQL in any Relational Database.

We use MySQL database in the classroom for doing the SQL exercises. If you want, You can bring your own laptop with Oracle database, or SQL Server database pre-installed, for doing the SQL language exercises. Other Databases are fine too.

Go To Top

Who Should Attend The SQL Training Class?

The SQL Tutorial Course suits both Beginners and Experienced Users of SQL.

Whether you have a little or no previous experience with a relational database management system, or are an experienced SQL user, you will benefit from the strong foundation and fundamentals of SQL query language class.

Both new SQL Developers and Database Administrators will benefit from this class.

Applies to Any RDBMS, irrespective of Version:

  • ORACLE,
  • MySQL,
  • MS SQL Server,
  • Access
  • MySQL

SQL Training Certificate:
An eCertificate of attendance would be given to all participants who complete this 2 Day SQL training course.

Training Material Provided in SQL Training Class:
Notes in folders, Sample SQL Databases, and Exercise Files  will be provided.

Class Size:
8-12 participants in a typical SQL class. We keep the class size small to give enough attention & support to all participants in learning to write their first SQL statements with confidence and understanding.

It is very practical, and hands-on experience for all participants to learn the power of SQL.

Go To Top

Introduction to SQL Query Language To Create, Update and Query Any Database

  • Installing SQL, command-line and graphical clients/tools.
  • Understand the features and benefits of Using SQL
  • Understand the basics of Using a Relational Database Management System
  • Understand the usage of a Database and SQL query language
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to modify or delete a database
  • Be able to modify or delete table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Understand the primary methods for exporting and importing data using SQL
  • Understand SQL storage engines, transactions and features of the common engines.

Go To Top

What Do You Need To Learn SQL?

Basic computer literacy is required. Knowledge of database concepts would be helpful but is not necessary.

This course would lay the foundation for RDBMS Concepts, and applying them to real world database applications, using the Structured Query Language.

Access to a personal or company database or corporate system can be helpful to practice writing SQL after attending this course.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need below. We’ll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Ready To Learn SQL Basics & Fundamentals?

Register for the 2 Days of Introduction to SQL Training today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at +65 6296-2995, SMS / WhatsApp: +65 9066 – 9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Introduction to SQL training.

We also offer Customized Corporate Training for SQL Query Language for Any RDBMS. If you have a group of 10 or more participants, we can conduct this SQL training course at your office location too. Contact us for more information or a quotation.

Master SQL
&
Accelerate Your Career

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!