SQL Training

Course Information

Start DateAnytime
End Date1 Year Access
ModeSelf-Paced E-Learning
Fee$399 (excluding GST)
Contact6720 3333 (Ms Roshini) training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

In Partnership with Simplilearn

This is an ONLINE course. Participants are able to access to the online course upon completion of registration.

Once activated, the licenses will be valid for ONE YEAR from the date of activation.

Course include 3 hours of learning.

Course Overview

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

Eligibility

This online SQL certification course is ideal for freshers, programmers, software developers, and testing professionals who want to learn SQL. It’s also ideal for marketing professionals and salespeople who want to better understand their company’s data.

Pre-requisites
There are no prerequisites for this database training course. This course can be taken up by anyone who wants to learn SQL.
 
Course Content

Lesson 01 – Introduction

Lesson 02 – Installation and getting started

Lesson 03 – Case Study Demo

Lesson 04 – Fundamental SQL statements

Lesson 05 – Restore and Back-up

Lesson 06 – Selection commands Filtering

Lesson 07 – Selection commands Ordering

Lesson 08 – Alias

Lesson 09 – Aggregate Commands

Lesson 10 – Group by Commands

Lesson 11 – Conditional Statement

Lesson 12 – JOINS

Lesson 13 – Subqueries

Lesson 14 – Views and Indexes

Lesson 15 – String Functions

Lesson 16 – Mathematical Functions

Lesson 17 – Date-Time Functions

Lesson 18 – PATTERN (STRING) MATCHING

Lesson 19 -Data Type conversion functions

Lesson 20 – User Access Control Functions

Lesson 21 – Bonus Section Nail that Interview

Lesson 22 – Performance tuning tips

Lesson 23 – Bonus Section Database Basics