Structured Query Language ( SQL )

5,900.00


Course Overview

DURATION

80 Hours (40 Hours LIVE Teaching + 40 Hours of assignments and project work)

TEST & EVALUATION

1. During the program, the participants will have to take all the assignments given to them for better learning.
2. At the end of the program, a final assessment will be conducted.

CERTIFICATION

1. All successful participants will be provided with a Certificate of Merit / Achievement from RCPL INDIA
2. Students who complete the course BUT do not take the final test will be provided with a certificate of participation from RCPL INDIA
3. Students who do not complete the course / leave it midway will NOT be awarded any certificate.

LOCATION

Online Live

TENTATIVE DATE & SCHEDULE

1st and 15th of every month

Syllabus

SQL Tutorial

  • Introduction to SQL
  • SQL Syntax
  • SQL Data Types
  • SQL Operators

 

SQL Database

  • SQL CREATE Database
  • SQL DROP Database
  • SQL RENAME Database
  • SQL SELECT Database

 

SQL Table

  • What is Table
  • SQL TABLE Variable
  • SQL CREATE TABLE
  • SQL DROP TABLE
  • SQL DELETE TABLE
  • SQL RENAME TABLE
  • SQL TRUNCATE TABLE
  • SQL COPY TABLE
  • SQL TEMP TABLE
  • SQL ALTER TABLE

 

SQL Insert

  • INSERT Statement
  • INSERT INTO Values
  • INSERT INTO SELECT
  • INSERT Multiple Rows

 

SQL Select

  • SELECT Statement
  • SQL SELECT UNIQUE
  • SQL SELECT DISTINCT
  • SQL SELECT COUNT
  • SQL SELECT TOP
  • SQL SELECT FIRST
  • SQL SELECT LAST
  • SQL SELECT RANDOM
  • SQL SELECT AS
  • SQL SELECT IN
  • SQL SELECT Multiple
  • SQL SELECT DATE
  • SQL SELECT SUM
  • SQL SELECT NULL

 

  • SQL Clause

  • SQL WHERE
  • SQL AND
  • SQL OR
  • SQL WITH
  • SQL AS

 

SQL Order By

  • ORDER BY Clause
  • ORDER BY ASC
  • ORDER BY DESC
  • ORDER BY RANDOM
  • ORDER BY LIMIT
  • ORDER BY Multiple Cols

 

SQL Update

  • UPDATE Statement
  • SQL UPDATE JOIN
  • SQL UPDATE DATE

 

SQL Delete

  • DELETE Statement
  • SQL DELETE TABLE
  • SQL DELETE ROW
  • SQL DELETE All Rows
  • DELETE Duplicate Rows
  • SQL DELETE DATABASE
  • SQL DELETE VIEW
  • SQL DELETE JOIN

SQL Join

  • SQL JOIN
  • SQL Outer Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Cross Join

 

SQL Keys

  • Primary Key
  • Foreign Key
  • Composite Key
  • Unique Key
  • Alternate Key

 

Difference SQL Vs. NoSQL

Difference between SQL and NoSQL

PL/SQL Tutorial

PL/SQL Introduction

Interview

SQL Interview

PL/SQL Interview

Prerequisite

No Prerequisite

General Information
  • Please ensure to use a secure internet connection.
  • Please ensure to check your details before submitting.
  • The discounts are applicable only on full payment.
  • You can use only one discount for a course in a particular program it can be either of the discounts as per the discount validity.
  • Ensure to use the proper discount code.
  • Gateway charges are as applicable.
  • In case of any transaction issue, please inform us by mailing at [email protected] or call us at 9335469335
  • Please ensure to note down your order id and transaction id at the time of communication with us.
  • All the payments are subject to realization.

Enquire Now