Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 15 hrs 
  • Life Time Job Support
  • Job Profile Tagging
Skills you will learn!
Curriculum

14 Topics
Client/Server Basics
What is a Data?
What is a Database?
What is DBMS or Database Management System?
Data Models
Relational Theory
Relational Model
Databases and Tables
What is RDBMS?
RDBMS Architecture
Database Communication Protocols
SQL and the Relational Model
Relational Operations
SQL Evolution

9 Topics
SQL Lexical Structure
SQL Identifiers
SQL Literals
SQL Escape Characters
SQL Statements
SQL Whitespaces
Case Sensitivity in SQL
SQL Comments
SQL Reserved Words

4 Topics
Constraints in SQL
Primary Key
Foreign Key
Other Constraints in SQL

7 Topics
Database Schema
Creating Database Schemas
Alter Schema
Drop Schema
Create Database
Alter Database
DROP TABLE

3 Topics
Create Table
Alter Table
Drop Table

3 Topics
The SELECT Statement
The SQL SELECT LIMIT
SELECT TOP Statement

5 Topics
DISTINCT clause
FROM Clause
WHERE Clause
GROUP BY
HAVING Clause

4 Topics
Cross Join
Inner Join
Outer join
Self-join

3 Topics
Boolean Expressions
Numeric Expression
Date Expressions

5 Topics
Arithmetic Operators
Comparison Operators
Character Operators
Logical Operators
Set Operators

6 Topics
Types of Function
Mathematical Functions
String Functions
Aggregate Functions
Branch Functions
Date/Time Functions

9 Topics
SQL Subquery
Stored Procedures
Trigger
Views
Transactions
Database Design
Database Normalization
SQL Standards
SQL Coding Standard

  Write a Review

Certified SQL Language Professional

Go to Paid Course