Last Update September 6, 2022

About This Course

This online programme gives you complete insight of the relational database language, i.e. SQL (Structured Query Language)


Learning Objectives

Learn SQL to a foundational level
Be able to write data retrieval queries and evaluate the result set.
Be able to write SQL statements that edit existing data.
Be able to write SQL statements that create database objects.
Understand the structure and design of relational databases.
Understand the importance and major issues of database security and the maintenance of data integrity.

Target Audience

  • Software Developers, IT Professionals, Engineers, Analysts, Tech Support Professionals, Freshers


64 Lessons

Introduction to Basic Database Concepts

What is Data, Field, Record and database? Limitations of File Management System.
Basic Concepts of Advantages of DBMS.

Exploring Relational DBMS

E-R Modeling and Diagram


First Normal Form Second Normal Form

Introduction to SQL Server

Introduction to SQL

Basics of SQL Types of SQL Statements DDL, DML, DQL, DCL and TCL

DDL and DML Statements

Working with Queries (DQL)

Aggregate Functions

Using functions in Queries Count, Sum, Min, Max, Avg Group By and Having Clause

Joins and Set Operations

Introduction to Joins Cross Joins Inner Join Outer Join Self Join

Implementation of Data integrity

In this module , we will learn correctness of data and types of integrity and types of constraints.

Working with Constraints

Unique Not NULL Primary Key Default Check Foreign Key

Implementing Views

Data Control language (DCL)

Working with Indexes

Writing Transact-SQL (T-SQL)

What is T-SQL?

Working with Stored Procedures and Functions

Introduction to stored procedures Benefits of Stored Procedures

Implementing Triggers

Introduction to triggers

Working with Cursors

Creating Cursors

Transaction Control Language (TCL)

Introduction Transactions process

Backup and Restore

Your Instructors


18 Courses
1 Review
66 Students
See more
All Levels
64 lectures
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare ×
Let's Compare! Continue shopping