Course Code : 0104
Duration : 5 Days
SQL (Structured Query Language) Structured query language (SQL) is a programming language for storing and processing information in a relational database. A relational database stores information in tabular form, with rows and columns representing different data attributes and the various relationships between the data values. We will be studying SQL using Microsoft SQL Server.
Microsoft SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft that is used to manage relational databases.
T-SQL is an extension of SQL with procedural constructs created by Microsoft for SQL Server.
- Overview
- Databases
- Tables
- Normalisation
- Views
- Queries
- Joins
- Built-in Functions
- Insert, Delete, Update
- Cursors
- Temporary Tables
- Transactions
- Create, Alter Drop Tables
- Stored Procedures & Functions
- Error handling
- Exercises
- Interview Questions
Reviews
There are no reviews yet.