Microsoft SQL Server Video Course

Description

The Microsoft SQL Server Video Course from Innozant is a structured training program designed to teach you how to work with Microsoft’s popular relational database system — SQL Server. It’s crafted for beginners and advanced learners who want to build strong database skills for careers in IT, data analytics or software development

📘 What the Course Covers

This video course includes comprehensive lessons on essential SQL Server concepts such as:
✔ Basics of Databases & Relational Data Models
✔ SQL Language Fundamentals (Structured Query Language)
✔ Working with DDL (Data Definition Language), DML (Data Manipulation Language) and DQL (Data Query Language)
✔ Understanding and using Joins (Inner, Outer, Self, etc.)
✔ Creating and manipulating databases, tables, and relationships
✔ Using Stored Procedures, Functions, Triggers, Cursors, and Indexes
✔ Practical examples to write, retrieve, and manage data using SQL Server queries

The content typically helps learners gain the confidence to work with SQL Server tools and commands — valuable for jobs in database support, reporting, data management, and analytics

📦 Course Benefits & Features

✅ Self-paced Video Lessons — Learn at your convenience
✅ Lifetime Access to Master Videos — Review content anytime
✅ Student Portal / Learning App — Centralized access to all materials
✅ Verifiable Course Certificate — Can be showcased on resumes
✅ Interview Preparation & Mock Interviews — Helps boost placement readiness
✅ Support & Membership — Lifetime membership for course resources and mentoring

📌 Format & Practical Details

📍 Language: Hindi
📍 Format: Video Course (Self-Study)
📍 Skill Level: Beginner to Advanced
📍 Includes Practical SQL Examples & Query Writing

Topics for this course

46 Lessons

SQL CLASSWISE ASSIGNMENT MASTER

CLASS-1-SQL INTRODUCTION

CLASS-2-SQL INTRO AND DATATYPES

CLASS-3-CREATE COMMAND

CLASS-4-SCHEMA

CLASS-5-INSERT COMMAND

CLASS-6-CONSTRAINTS

CLASS-7-PRIMARY KEY

CLASS-8-SURROGATE KEY

CLASS-9-FOREIGN KEY

CLASS-10-NOT NULL UNIQUE CHECK

CLASS-11-PRACTICE QUESTION CONSTRAINTS

CLASS-12 ALTER COMAMAND

CLASS-13 TRUNCATE DROP DELETE

CLASS-14 ARITHMATIC OPERATOR

CLASS-15 COMPARISON OPERATOR

CLASS-16 LOGICAL OPERATOR

CLASS-17 NOT NULL

CLASS-18 LIKE OPERATOR

CLASS-19 UNION & UNION ALL OPERATOR

CLASS-20 INTERSECT EXCEPT

CLASS-21 AGGREGATE FUNCTION

CLASS-22 GROUP BY CLAUSE

CLASS-23 HAVING CLAUSE

CLASS-24 SUBQUERY INTRODUCTION

CLASS-25 SUBQUERY IN FROM

CLASS-26 SUBQUERY IN WHERE

CLASS-27 CORRELATED NON CORELATED SUBQUERY

CLASS-28 EXISTS AND NON EXISTS CLAUSE IN SUBQUERY

CLASS-29 ANY AND ALL CLAUSE IN SUBQUERY

CLASS-30 JOINS INTROUDUCTION INNER-JOIN

CLASS-31 LEFT JOIN

CLASS-32 SELF JOIN

CLASS-33 ANTI JOIN

CLASS-34 OUTER JOIN

CLASS-35 JOIN QUESTIONS

CLASS-36 STRING FUNCTIONS PART 1

CLASS-37 STRING FUNCTIONS PART 2

CLASS-38 STRING FUNCTIONS PART 3

CLASS-39 STRING FUNCTIONS PART 4

CLASS-40 STRING FUNCTIONS END

CLASS-41-DATE FUNCTION PART – 1

CLASS-42-DATE FUNCTION PART – 2

CLASS-43-DATE FUNCTION PART – 3

CLASS-44-DATE FUNCTION PART – 4

CLASS-45-DATE FUNCTION PART – 5

₹2,999.00

Course level: Expert