• logo
  • + 91-7065069985
  • query@innozant.com
My Courses

MICROSOFT SQL SERVER-WEEKEND-7PM-20TH SEP 2025

A
Administrator Expert

About Course

MICROSOFT SQL SERVER-WEEKEND-7PM-20TH SEP 2025

Course Content

SQL DEMO SESSION

  • SQL DEMO SESSION
    00:00

CLASS-1-SQL SERVER INSTALLATION

CLASS-2-SQL INTRODUCTION

CLASS-3- CREATE COMMAND

CLASS-4-PRIMARY KEY , DEFAULT

CLASS-5-FOREIGN KEY , CHECK CONSTRAINT

CLASS-6-DROP, DELETE, TRUNCATE ,ALTER

CLASS-7-ALTER_INDENTIY COLUMN_UPDATE

CLASS-8-MERGE AND COMMIT

CLASS-9-COMMIT, ROLLBACK, SAVE POINT, ARITHMETIC, LOGICAL, COMPARISON

CLASS-10-IN, BETWEEN, NULL, LIKE, NOT, GROUP, HAVING

CLASS-11-GROUP AND HAVING

CLASS-12-DISTINCT, GROUP HAVING AND UNION

CLASS-13-INTERSECT EXCEPT AND SELF JOIN

CLASS-14-FULL OUTER JOIN AND LEFT JOIN

CLASS-15-CROSS JOIN AND SELF JOIN

CLASS-16-SUBQUERY

CLASS-17-STRING AND SUBQUERY

CLASS-18-DATE FUNCTION

CLASS-19-STRING FUNCTION

CLASS-20-SUBQUERY

CLASS-21-Exists_correalted_subquer

CLASS-22-WINDOW FUNCTION

CLASS-23-FRAME

CLASS-24-RANKING WINDOW FUNCTION

CLASS-25-LEAD_LAG_FIRST_LAST_VALUE

CLASS-26-CTE

CLASS-27-CAST and CONVERT in SQL

CLASS-28-Isnull_Coalesce in SQL , Pivot in SQL and RECURSIVE CTE in SQL

CLASS-29-VIEW IN SQL

CLASS-30-PROCEDURES

CLASS-31-FUNCTION IN SQL SERVER

CLASS-32-TRIGGERS

CLASS-33-FLIGHT_PROJECT

CLASS-34-INSTEAD

₹9,999.00
  • Course level: Expert
₹9,999.00
image

The Most Rapidly Growing Hybrid Training Institute For Data Analytics, Data Science ,Digital Marketing, Web Development and others

Quick Links

Courses

Get In Touch

C-54 ,Third Floor, Sector-2, Near Sec-15 Metro Station, Noida ,Landmark-Priyagold Building , Uttar Pradesh , 201301

+91-7065069985
query@innozant.com

Copyright @ 2025 innozant. All Rights Reserved. Designed and Developed by Cybetiq.com

  • Follow Us:
whatsapp whatsapp