Introduction to SQL

SQL Training Singapore: Course Outline:

Introduction to SQL 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.

Objectives of the SQL Training Course

The objective is to teach you all the key skills, knowledge, tips and tricks to use and manipulate any relational database with ease, only using SQL. We will teach you the following topics in detail.

Introduction to RDBMS & SQL

• Features & Benefits of SQL
• Understanding RDBMS Concepts
• Installing SQL with Various Client Tools

RDBMS Database Design 

1. Understand Data & Column Types
2. Create an Efficient Database Design

Basic Data Extraction Techniques using SQL

• Extract Information using  SELECT
• Build Single Table Queries

Data Manipulation using SQL

• Update & Delete Data
• Performance Considerations

Advanced Data Extraction Techniques

• Grouping Query Data with Aggregation
• Retrieve Data from Multiple Tables using SQL
• Perform Nested Sub-Queries
• Creating Custom Functions with SQL
• Perform SET Operations

Advanced SQL Concepts

• Creating Views
• Exporting & Importing Data using SQL
• SQL Storage Engines & Transaction Processing

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

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

Learn to 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.

What Do You Need To Learn SQL?

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

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

Who Should Attend The SQL Training Class in Singapore?

The SQL Training Workshop 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 of any database will benefit from this SQL class.

Applies to any RDBMS, irrespective of Version:

• ORACLE,
• MySQL,
• Microsoft SQL Server,
• Access
• Postgre SQL

Training Material Provided in SQL Training Class:

Software Installation Assistance, Installation Instructions, Notes in folders, Sample SQL Databases, and Exercise Files  will be provided.

Size of Class for SQL Training Singapore 

8-15 participants in a typical SQL class in Singapore, with safe distancing. 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.