Introduction to SQL

Introduction to the SQL Relational Database

SQL, A powerful relational database management system can make your life easy.

Manage and maintain large amounts of data using the SQL database. This instructor led, hands-on class on SQL covers the fundamentals of SQL and relational databases using SQL.

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

If you want to masters in SQL Scripting  languages, you are in the right place.

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

Course Duration: 2 Full Days

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6296-2995 for Details. SkillsFuture credits ready for Singaporeans.

Course Objectives

SQL training in Singapore
SQL training in Singapore

Instructor led, highly interactive classroom setting with many exercises.

PC will be provided to each student. You can bring in your own laptop & notebook.

Use simple cases and exercises to build SQL Scripts, which interact with the database, and do Insert, Update, Delete and Select operations in the SQL 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.

Target Audience

New or existing users of SQL, who have little or no previous experience with a relational database management system. Both new SQL Developers and Database Administrators will benefit from this class.

Applies to SQL Version:
ORACLE, MySQL, MS SQL Server, Access SQL

SQL Training and Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders, and Exercise Files  will be provided.

Class Size:
8-12 participants

Course Outline

SQL, command-line and graphical clients/tools.

  • Understand the features and benefits of SQL
  • Understand the basics of Relational Database Management Systems
  • Understand the SQL and SQL languages
  • 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
  • Describe SQL connectors, their major features and differences.
  • Understand SQL storage engines, transactions and features of the common engines.

Pre-Requisites

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.

Course Objectives

SQL training in Singapore
SQL training in Singapore

Instructor led, highly interactive classroom setting with many exercises.

PC will be provided to each student. You can bring in your own laptop & notebook.

Use simple cases and exercises to build SQL Scripts, which interact with the database, and do Insert, Update, Delete and Select operations in the SQL 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.

Go To Top

Target Audience

New or existing users of SQL, who have little or no previous experience with a relational database management system. Both new SQL Developers and Database Administrators will benefit from this class.

Applies to SQL Version:
ORACLE, MySQL, MS SQL Server, Access SQL

SQL Training and Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders, and Exercise Files  will be provided.

Class Size:
8-12 participants

Go To Top

Course Outline

SQL, command-line and graphical clients/tools.

  • Understand the features and benefits of SQL
  • Understand the basics of Relational Database Management Systems
  • Understand the SQL and SQL languages
  • 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
  • Describe SQL connectors, their major features and differences.
  • Understand SQL storage engines, transactions and features of the common engines.

Go To Top

Pre-Requisites

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.

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

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

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

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!

computer-training-participants

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

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 Database. If you have a group of 10 or more participants, we can conduct this training at your office too. Contact us for details.

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!