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.

Key Features

100% Money Back Guarantee
No questions asked refund*

At Simplilearn, we value the trust of our patrons immensely. But, if you feel that a course does not meet your expectations, we offer a 7-day money-back guarantee. Just send us a refund request via email within 7 days of purchase and we will refund 100% of your payment, no questions asked!
  • In-depth coverage of SQL fundamentals
  • Covers all of the important query tools and SQL commands
  • Industry-recognized course completion certificate
  • Lifetime access to self-paced learning

Skills Covered

  • Database and relationships
  • Query tools and SQL commands
  • Aggregate functions
  • Group by clause
  • Tables and joins
  • Subqueries
  • Data manipulation
  • Transaction control
  • Views and procedures

Training Options

Self-Paced Learning

$ 499

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support
Enroll now

Course Curriculum

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.
Read More

Pre-requisites

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

Course Content

  • SQL Training

    Preview

    • Lesson 01 - Introduction

      04:38Preview
      • 1.1 Course Overview
        04:38

    • Lesson 02 - Installation and getting started

      06:24Preview
      • 2.1 Installation
        06:24

    • Lesson 03 - Case Study Demo

      10:44Preview
      • 3.1 Case study part one
        04:27
      • 3.2 Case study part two
        06:17

    • Lesson 04 - Fundamental SQL statements

      01:17:31Preview
      • 4.1 CREATE
        11:46
      • 4.2 Exercise one Create DB and Table
        01:24
      • 4.3 INSERT
        09:07
      • 4.4 Import data from File
        04:59
      • 4.5 Exercise two Inserting and Importing
        00:57
      • 4.6 SELECT statement
        03:45
      • 4.7 SELECT DISTINCT
        06:05
      • 4.8 WHERE
        04:02
      • 4.9 Logical Operators
        06:10
      • 4.10 Exercise three SELECT and WHERE
        01:16
      • 4.11 UPDATE
        05:25
      • 4.12 DELETE
        04:11
      • 4.13 ALTER
        17:21
      • 4.14 Exercise four Updating Table
        01:03

    • Lesson 05 - Restore and Back-up

      08:29
      • 5.1 Restore and Back-up
        07:38
      • 5.2 Exercise five Restore and Back up
        00:51

    • Lesson 06 - Selection commands Filtering

      19:47Preview
      • 6.1 IN
        04:24
      • 6.2 BETWEEN
        05:40
      • 6.3 LIKE
        08:52
      • 6.4 Exercise six In Like and Between
        00:51

    • Lesson 07 - Selection commands Ordering

      13:21
      • 7.1 Side Lecture Commenting in SQL
        01:21
      • 7.2 ORDER BY
        07:42
      • 7.3 LIMIT
        03:38
      • 7.4 Exercise 7 Sorting
        00:40

    • Lesson 08 - Alias

      03:33
      • 8.1 AS
        03:33

    • Lesson 09 - Aggregate Commands

      17:07Preview
      • 9.1 COUNT
        05:13
      • 9.2 SUM
        03:24
      • 9.3 AVERAGE
        02:53
      • 9.4 MIN and MAX
        04:18
      • 9.5 Exercise eight Aggregate functions
        01:19

    • Lesson 10 - Group by Commands

      18:09
      • 10.1 GROUP BY
        11:52
      • 10.2 HAVING
        05:04
      • 10.3 Exercise nine Group By
        01:13

    • Lesson 11 - Conditional Statement

      05:18
      • 11.1 CASE WHEN
        05:18

    • Lesson 12 - JOINS

      41:20Preview
      • 12.1 Introduction to Joins
        02:25
      • 12.2 Inner Join
        08:05
      • 12.3 Left Join
        07:32
      • 12.4 Right Join
        06:27
      • 12.5 Full Outer Join
        04:59
      • 12.6 Cross Join
        04:21
      • 12.7 Except
        03:00
      • 12.8 Union
        03:13
      • 12.9 Exercise ten Joins
        01:18

    • Lesson 13 - Subqueries

      15:51
      • 13.1 Subqueries
        14:35
      • 13.2 Exercise eleven Subqueries
        01:16

    • Lesson 14 - Views and Indexes

      14:43Preview
      • 14.1 VIEWS
        07:21
      • 14.2 INDEX
        06:39
      • 14.3 Exercise tweleve Views
        00:43

    • Lesson 15 - String Functions

      33:15Preview
      • 15.1 LENGTH
        03:31
      • 15.2 UPPER LOWER
        02:10
      • 15.3 REPLACE
        04:13
      • 15.4 TRIM, LTRIM, RTRIM
        06:56
      • 15.5 CONCATENATION
        02:56
      • 15.6 SUBSTRING
        06:01
      • 15.7 LIST AGGREGATION
        05:01
      • 15.8 Exercise thirteen String Functions
        02:27

    • Lesson 16 - Mathematical Functions

      19:16Preview
      • 16.1 CEIL and FLOOR
        03:34
      • 16.2 RANDOM
        05:06
      • 16.3 SETSEED
        04:11
      • 16.4 ROUND
        02:27
      • 16.5 POWER
        02:25
      • 16.6 Exercise fourteen Mathematical Functions
        01:33

    • Lesson 17 - Date-Time Functions

      18:01
      • 17.1 CURRENT DATE and TIME
        04:31
      • 17.2 AGE
        03:50
      • 17.3 EXTRACT
        08:17
      • 17.4 Exercise fifteen Date-time functions
        01:23

    • Lesson 18 - PATTERN (STRING) MATCHING

      24:32
      • 18.1 PATTERN MATCHING BASICS
        07:44
      • 18.2 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
        15:21
      • 18.3 Exercise sixteen Pattern Matching
        01:27

    • Lesson 19 -Data Type conversion functions

      16:45
      • 19.1 Converting Numbers Date to String
        10:52
      • 19.2 Converting String to Numbers Date
        05:53

    • Lesson 20 - User Access Control Functions

      13:41Preview
      • 20.1 User Access Control
        13:41

    • Lesson 21 - Bonus Section Nail that Interview

      10:53
      • 21.1 Tablespace
        05:44
      • 21.2 PRIMARY KEY and FOREIGN KEY
        05:09

    • Lesson 22 - Performance tuning tips

      19:37Preview
      • 22.1 EXPLAIN
        04:07
      • 22.2 Soft Delete vs Hard Delete
        01:17
      • 22.3 Update vs Case
        02:32
      • 22.4 VACCUM
        00:34
      • 22.5 Truncate vs Delete
        01:59
      • 22.6 STRING FUNCTIONS
        02:20
      • 22.7 JOINS
        01:57
      • 22.8 SCHEMAS
        04:51

    • Lesson 23 - Bonus Section Database Basics

      12:20
      • 23.1 What is SQL
        01:56
      • 23.2 Tables and DBMS
        03:10
      • 23.3 Types of SQL commands
        04:44
      • 23.4 PostgreSQL
        02:30

Contact Us

1-844-532-7688

( Toll Free )

Exam & Certification

SQL Certificate

  • What do I need to do to unlock my certificate?

    To obtain the SQL training course certification, you must:

    • Complete 85 percent of the online self-learning course

  • What are the system requirements to take the exam?

    You must have a computer with:

    • Chrome or Chromium browser
    • Strong internet access
    • Webcam
    • Microphone, speakers, and headset

FAQs

  • How would a certificate from Simplilearn help me?

    In today’s era where technologies and best practices are changing rapidly, and demand for qualified candidates is significantly increasing, a certificate from Simplilearn is the key to your success and a valuable add-on in your resume. Our training courses are designed and updated by 2000+ renowned industry experts, and more than 40 global training organizations have recognized us as an official provider of certification training.

  • Who are the trainers?

    All our trainers are certified and are highly qualified, with multiple years of experience in working with front-end development technology.

  • What are the prerequisites for SQL training course?

    There are no prerequisites for this SQL Training course.

  • What are the payment options?

    Payments can be made using any of the following options and a receipt will be issued to you automatically via email.

    • Visa debit/credit card
    • American Express and Diners Club card
    • MasterCard
    • PayPal

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide a complete refund after deducting the administration fee. To know more, please review our refund policy.

Related Courses

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.