SQL Server is a combination of two core items The first is the administration side of the house. Creating databases, managing logins and users, backups,… etc.
The second part of the equation is that of developing code in a language called Structured Query Language.
Microsoft’s flavor of SQL is called Transact-SQL.
Transact was designed primarily to work with relational databases. Transact is the language used to talk to SQL Server.
When we want to create a database a database we use DDL or Data Definition Language. I’m defining an object when I use the statement with the code.
When we want to see data inside a table we use DML or Data Manipulation Language. I’m not creating an object I’m manipulating the data inside that object.
In this course we are going to learn the basics of Transact-SQL or T-SQL.
We will cover the fundamentals of Transact using real world examples. Additionally, we will discuss some of the best practices associated with crafting clean, high performance code.
You’ll learn why stored procedures are so important to well-designed applications and why ad hoc queries aren’t.
The knowledge you gain from the course will not only help you learn to develop but will also give you a great first step to learning how to pinpoint performance issues due to poorly written code.
Thanks for your interest in “Real World Transact-SQL from the Ground Up.”
See you in the course.