(All course fees are in USD)

Course Description

This SQL online 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.

Offered in Partnership  with

Simplilearn

Course Delivery

Online self-paced learning: 7 hours

Benefits

• In-depth coverage of SQL fundamentals
• Covers all of the more important query tools and SQL commands

 Skills to be Learned

Award upon Successful Completion

SQL “Certificate of Achievement” from Simplilearn

Awarding Organisation

Simplilearn

Learning Outcome

After finishing this online course, you are expected to obtain understanding with the more commonly used query tools and SQL commands

Assessment

Course-end assessment

Prerequisites

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

Course Overview

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 – Section 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

Accessible Period of Course

1 year from date of enrolment