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.
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• 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