SQL Database Training Course - Simplilearn | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

SQL Database Training Course - Simplilearn


Format What’s this?
Starting From
RM 2145.70
  1. 6 Hours
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  3. 180 days of access from date of purchase
  1. 0 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy




Thank You

Our learning consultant will get back to you in 1 business day

SQL Database Training Course - Simplilearn


This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure your database, author efficient SQL statements and clauses, and manage your SQL database for scalable growth.


• Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL

• Marketing, Sales people who want to understand their company data better


There are no prerequisite for the course. This course can be taken up by anyone who wants to learn SQL.


• Understand Databases & Relationships

• Use Common Query Tools and work with SQL commands

• Understanding Transactions, create Tables and Views

• Comprehend and Execute Stored Procedures

Expand All


Module 1 – Relational Databases

• What are Databases?

• What's the Role of Databases in Application Programming?
• Tables and Relations
• Primary and Foreign Keys and Other Constraints

Module 2 – SQL Querying

• What is Querying?

• The ANSI SQL Standard

• DML, DDL and More

• Common Query Tools

Module 3 – Your First Queries

• The SELECT Statement

• Limiting Output Columns

• Formatting and Sorting Output

• Column Aliases

Module 4 – Filtering Your Results

• The WHERE Clause

• Creating a Filter Condition

• Applying Multiple Filter Conditions

• More Filter Options

Module 5 – Consolidating Your Data

• Counting Records

• Common Aggregate Functions: SUM, AVG, MIN, MAX

• Do's and Dont's When Consolidating

• Unions and Other Multiset Consolidations

Module 6 – Grouping Your Data

• Grouping Your Data

• The HAVING Clause

• Do's and Dont's When Grouping

Module 7 – Joining Tables

• Table Aliases

• Inner Joins

• Outer Joins

• Self Joins

• Complex Multi Table Joins

Module 8 – Subqueries

• Filtering Using Subqueries

• The EXISTS Clause

• Subqueries as Alternative to Joins

• Derived Tables

Module 9 - Manipulating Your Data

• The INSERT Statement

• The UPDATE Statement

• The DELETE Statement

Module 10 - Transaction Control

• What are Transactions

• Initiating a Transaction

• The COMMIT and ROLLBACK Commands

Module 11 – Creating Database Objects And Adding Business Logic

• Creating Tables

• Creating and Using Views

• Developing and Calling Stored Procedures

• Implementing Triggers

To Be Confirm

To Be Confirm

Read More

Course Reviews

No Remarks


0 Ratings