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

✦

Premium

Access structured lessons, quizzes, and practice materials.

0.0

☆☆☆☆☆

👥

781 View

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 Start Quiz

Student Reviews

What learners say about this course.

0.0

☆☆☆☆☆

0 reviews

✅ Valuable Information

✅ Clear Explanations

✅ Engaging Delivery

✅ Helpful Practice

✅ Accurate Description

✅ Knowledgeable Instructor

No reviews yet. Be the first learner to review this course.

Course Curriculum

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

SQL*Plus Article

Connect with System User Article

Create a new Database User Article

Log into new User Article

Create Database Article •2 Q

Delete or Drop Database Article

Use Database Article

Create Database in SQL Server Article

Rename Database Article

Create Table in SQL Server Article

Delete or Drop table Article •1 Q

Insert Data into table Article

Select Distinct Article

Select Top Article

Where Clause Article

Aliases Article

Update Table Article •1 Q

AND, OR, NOT Article

IN Article

Between Article

Order By Article

Group By Article

Having Article

Exists Article

ANY and ALL Article

CASE Statement Article

Select Into Article

Alter Table Article

Order of execution of a Query Article

Create table Article •2 Q

Constraints Introduction Article

Not Null Article

Unique Article •1 Q

Primary Key Article •1 Q

Foreign Key Article •1 Q

Check Article

Default Article

Index Article •5 Q

Auto Increment Field Article

Cascading referential integrity constraint Article

Identity Column in SQL Server Article •1 Q

Keywords Introduction Article

Data Types Introduction Article

Operators Introduction Article

Wildcard Introduction Article

Like Article

Joins Introduction Article •2 Q

Inner Join Article •1 Q

Left Join Article •2 Q

Right Join Article •2 Q

Full Join Article •1 Q

Self Join Article •1 Q

Union Article

Cross Join Article

Advanced Join Article

Introduction Article

Min Article

Max Article

Count Article

Avg Article

Sum Article

Views Introduction Article •1 Q

Advantages of View Article

Updateable Views Article

Limitations of views Article

Dates Introduction Article

Stored Procedures Introduction Article •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 Article •4 Q

Table Valued Functions Article •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 Article •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 Article •1 Q

Common table expression (CTE) Article

Backup in SQL Server Article

Database Restore Article

About SQL Tutorial Article •4 Q

SQL Basic Overview Article •11 Q

Query Language Article •2 Q

Microsoft SQL Server Article

MySQL Article

Oracle Database 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

Student Reviews

Course Curriculum

M1 SQL Database User 4 topics

M2 SQL Database 5 topics

M3 SQL Table 21 topics

M4 SQL Constraints 11 topics

M5 SQL Keywords 1 topics

M6 SQL Data Types 1 topics

M7 SQL Operators 1 topics

M8 SQL Wildcard Characters 2 topics

M9 SQL Joins 9 topics

M10 SQL Aggregate Function 6 topics

M11 SQL Views 4 topics

M12 SQL Dates 1 topics

M13 SQL Stored Procedures 6 topics

M14 SQL Functions 7 topics

M15 String Functions in SQL Server 18 topics

M16 SQL Server Date Functions 9 topics

M17 Other Functions in SQL Server 2 topics

M18 Mathematical Functions in SQL Server 1 topics

M19 Temporary tables 2 topics

M20 Indexes 4 topics

M21 SQL Server Trigger 6 topics

M22 Backup and Restore 2 topics

M23 SQL Introduction 6 topics

SQL

Course Details

Related Courses

⭐ 0.0 course rating • 0 ratings