Structured Course Premium Access 23 Modules

SQL

In this tutorial you will learn about SQL. Here you will get all the programs with explanations also you will get all MCQ question and answers for your examination also you will get all interview questions and answers chapterwise.

Enroll Now View Syllabus Share

Modules

Topics

129

Instructor

Rumman Ansari

Access

Paid

Course Overview

Everything a learner needs before starting the course.

Rumman Ansari

rummanansari6@gmail.com

Rumman Ansari is a Software Engineer and Professional Educator with over a decade of experience in technical architecture and digital instruction. A specialist in Microsoft Dynamics 365 Finance & Supply Chain Management, Rumman has authored extensive coursework on X++ programming, SSRS reporting, and MB-500 certification prep.

Through his platform, rummanansari.com, and a library of nearly 1,000 technical tutorials, he has mentored thousands of students in mastering ERP solutions, Web Development (PHP, Bootstrap 5), and Database Management. With a background as a System Engineer at Tata Consultancy Services (TCS), Accenture and an M-Tech in Computer Science, Rumman combines enterprise-level expertise with a passion for simplified, project-based learning.

Share Course Open Syllabus Copy Course Link Start Quiz

Course Curriculum

Explore modules, topics, MCQs, questions, and coding items.

About SQL Tutorial 4 Q

SQL Basic Overview 11 Q

Query Language 2 Q

Microsoft SQL Server Article

MySQL Article

Oracle Database Article

SQL*Plus Article

Connect with System User Article

Create a new Database User Article

Log into new User Article

Create Database in SQL Server Article

Rename Database Article

Create Database 2 Q

Delete or Drop Database Article

Use Database Article

Select Distinct Article

Select Top Article

Where Clause Article

AND, OR, NOT Article

Order By Article

Update Table 1 Q

IN Article

Between Article

Aliases Article

Group By Article

Having Article

Exists Article

ANY and ALL Article

CASE Statement Article

Select Into Article

Alter Table Article

Create Table in SQL Server Article

Order of execution of a Query Article

Create table 2 Q

Delete or Drop table 1 Q

Insert Data into table Article

Constraints Introduction Article

Not Null Article

Unique 1 Q

Primary Key 1 Q

Foreign Key 1 Q

Check Article

Default Article

Index 5 Q

Auto Increment Field Article

Cascading referential integrity constraint Article

Identity Column in SQL Server 1 Q

Keywords Introduction Article

Data Types Introduction Article

Operators Introduction Article

Wildcard Introduction Article

Like Article

Joins Introduction 2 Q

Inner Join 1 Q

Left Join 2 Q

Right Join 2 Q

Full Join 1 Q

Self Join 1 Q

Union Article

Cross Join Article

Advanced Join Article

Introduction Article

Min Article

Max Article

Count Article

Avg Article

Sum Article

Views Introduction 1 Q

Advantages of View Article

Updateable Views Article

Limitations of views Article

Dates Introduction Article

Stored Procedures Introduction 3 Q

Advantages of Stored Procedures Article

Simple Store Procedure Article

Stored procedure with input parameters Article

Stored Procedure with OUTPUT Parameters Article

Alter Procedure Article

Functions Introduction 4 Q

Table Valued Functions 1 Q

Scalar Valued Functions Article

Stored Procedure VS Function Article

Multi-Statement Table Valued Functions Article

Function WITH ENCRYPTION Article

Function WITH SCHEMABINDING Article

Ascii() Article

Char() Article

Ltrim() Article

Rtrim() Article

Lower() Article

Upper() Article

Reverse() Article

Len() Article

Left() Article

Right() Article

CharIndex() Article

SubString() Article

Function Real time Example Article

Replicate() Article

Space() Article

Patindex() Article

Replace() Article

Stuff() Article

ISDATE() Article

DAY() Article

MONTH() Article

YEAR() Article

DATENAME() Article

DATEPART() Article

DATEADD () Article

DATEDIFF() Article

Real time Example Article

Cast() Article

Convert() Article

Mathematical Functions in SQL 1 Q

Local Temporary tables Article

Global Temporary tables Article

Clustered Index Article

Non Clustered Index Article

Unique Index Article

Advantages and disadvantages of indexes Article

Triggers in SQL Server Article

After update trigger Article

Instead of insert trigger Article

Instead of update triggers Article

Instead of delete trigger 1 Q

Common table expression (CTE) Article

Backup in SQL Server Article

Database Restore Article

SQL

₹99

~~₹99~~ (0% OFF)

Enroll Now

Course Details

Quick overview of the learning content.

Chapters 23
Topics 129
MCQ 0
Questions 52
Programs 0

Related Courses

Explore similar subjects that complement this course.

SQL

Course Overview

Course Curriculum

M1 SQL Introduction 6 topics

M2 SQL Database User 4 topics

M3 SQL Database 5 topics

M4 SQL Table 21 topics

M5 SQL Constraints 11 topics

M6 SQL Keywords 1 topics

M7 SQL Data Types 1 topics

M8 SQL Operators 1 topics

M9 SQL Wildcard Characters 2 topics

M10 SQL Joins 9 topics

M11 SQL Aggregate Function 6 topics

M12 SQL Views 4 topics

M13 SQL Dates 1 topics

M14 SQL Stored Procedures 6 topics

M15 SQL Functions 7 topics

M16 String Functions in SQL Server 18 topics

M17 SQL Server Date Functions 9 topics

M18 Other Functions in SQL Server 2 topics

M19 Mathematical Functions in SQL Server 1 topics

M20 Temporary tables 2 topics

M21 Indexes 4 topics

M22 SQL Server Trigger 6 topics

M23 Backup and Restore 2 topics

SQL

Course Details

Related Courses