readme.md

SQL Server Guide

In this repository i will explain somethings about the SQL Server, like hints and tricks to work with this powerfull database. Think in this repository like a book and each folder as a chapter, if you find any error, please warn me.

1.Working with T-SQL

In this chapter we will find some concepts of SQL Standard and what is the T-SQL (Transact SQL), involving the basics commands used in any relational database.

2.Advanced T-SQL commands

I will describe some advanced components about T-SQL and show how we can use it.

3.Programming with T-SQL

Before the chapters 1 and 2, you see the basic concepts and some components and in this chapter i will write some codes that use this skills.

Summary

1. Working with T-SQL:
   1. Create Transact-SQL SELECT Queries
   2. Query multiple tables with joins
   3. Implement functions and aggregate data
   4. Modify data
2. Advanced T-SQL commands:
   1. Query data by using subqueries and APPLY
   2. Query data with table expressions
   3. Group and pivot data
   4. Query temporal and non-relational data
3. Programming with T-SQL
   1. Create database objects with T-SQL
   2. Handling errors and transactions
   3. Implement data type and NULLs

Notes

This repository contains my assimilated concepts obtained in this book, if you wanna a complete and oficial guide please read it.