SQL_Practice_Files

Structured Query Language with the help of MS-SQL

• SQL is used to perform operations on records stored in the database such as updating records, creating and modifying database tables, views etc.
• SQL is a standard language for relational database management system.

SQL Commands

• DDL (Data Definition Language)

• DML (Data Manipulation Language)

SQL Practice files are:

• Clauses

• Datetime

• Constraint

• Set Operator

• Partition by

• Joins

• Sub query and Co-relational query

• Row number, Dense rank and Rank

• Server functions

• Views

• Store procedures

• Triggers

• solved practice set

Thank You.☻