SQL (Structured Query Language) is a standard
language used for manipulating relational databases, SQL Server become more
popular nowadays. Although other flavor of sql (oracle sql) available in the
market, Microsoft got good business users. We are going to explain each and
every topic in subject from fundamentals to advanced level. we are having one more tab in our site T-SQL which covers regular issues,configurations,
Following are topics
which we are going to cover here:-
·
TSQL
(Transact Structured Query Language)
Introduction To T-SQL
Introduction To T-SQL
·
Data
Manipulation Language
·
Data
Query Language (DQL)
·
Built
In Functions
·
Top
n Clause, Set Operators
·
Joins
·
Sub
Queries
·
Indexes
·
Security
·
Views
·
Transaction
Management
·
T-SQL
Programming
·
Cursors
·
Stored
Sub Programs
·
CLR
Integration
·
Working
With XML Data Type
Backup and Restore Of Database
Attach and Detach of Database
Normalization
Backup and Restore Of Database
Attach and Detach of Database
Normalization