SQL Server Tutorials

An Introduction about SQL Server:

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language.

Microsoft SQL Server is a relational database management system developed by Microsoft Inc.. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.

Source: Wiki

This tutorial will give you quick start with SQL:

I. SQL (Structure Query Language) Basic

1.1 http://www.sqlserver2005tutorial.com/

1.2 http://msdn.microsoft.com/en-us/library/ms169620(v=sql.90).aspx

1.3 http://www.w3schools.com/sql/

1.4 http://www.tutorialspoint.com/sql/sql-primary-key.htm

1.5 http://beginner-sql-tutorial.com/vi/sql-tutorial-tips.htm

1.6 http://www.tutorialspoint.com/sql/sql-insert-query.htm

1.7 http://vietshare.vn/54/co-so-du-lieu.aspx

1.8 SQL Server tutorial for beginners

1.9 http://bit.sparcs.org/~dinggul/tools/1423902017.pdf

II. SQL ADVANCE
2.1.Stored Procedures:

2.1.1 Introduction to creating Basic stored procedures in SQL Server

2.1.2 SQL Stored Procedures

2.1.3 Using Stored procedure in C#

2.2. Flow control in SQL Server

2.2.1 Flow control statements
2.2.2 SQL - IF Statements

2.3. Kết nối tới SQL Server với C#

2.3.1Kết nối tới SQL Server sử dụng C# by ictsharing

2.4 Access Control

2.4.1 RELATIONAL DATABASE ACCESS CONTROLS

2.4.2 Implementing Reﬂective Access Control in SQL⋆

2.5 T-SQL FUNCTION
2.5.1 SQL Server Functions: The Basics _ SimpleTalk

2.6 Set Operations in SQL server
2.6.1 Set Operators in SQL Server (UNION, UNION ALL, INTERSECT, EXCEPT)
2.6.2 SQL set operators _ gplivna.eu
2.6.3 techonthenet.com/sql

2.7 Database Design

2.7.1 Normalization Forms

2.7.2 Relational Algebra
Relational algebra exercises & here

III. SQL TUTORIAL E-BOOKS

3.1 Câu lệnh truy vấn SQL
3.2 MÔ HÌNH CLIENT/SERVER TRÊN SQL SERVER
3.3 TutorialPoint.com SQL ebook
This tutorial will give you quick start with SQL
3.4 SAS/ACCESS® 9.2 for Relational Databases Reference
3.5 Teach Yourself SQL in 21 Days, Second Edition
3.6 Chuẩn hóa CSDL
3.7 Database management system ( Vietnamese )
3.8 Bài giảng của TS Vũ Tuyết Trinh
3.9 Tập 31 bài viết về CSDL _ Thư viện IT

IV. Useful tutorial videos:
4.1 SQL 2012 for SQL 2008 Experts
4.2 SQL Server tutorial for beginners
4.3 Database Normalization

BACK TO TOP