SQL Training

Course Information

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

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.

This self-paced E learning course is done in partnership with SimpliLearn. It consists of a few videos that will take approximately 5 hours in total to finish the course. Upon successful completion of the SQL Training online course, you will receive an industry-recognized course completion certificate from SimpliLearn and Aventis that will be able to enhance your portfolio.

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