MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | Lec: 15 | 165 MB
Genre: eLearning | Language: English
Learn Transact-SQL Language by a Project Fast
For those of you who have not written a line of code in SQL Server it may look a bit a bit of pain in brain but actually when you get used to it you will never go for GUI!
Waht is GUI by the way?! It is the graphical side to SQL Server and it is amazing! But it has one big drawback; it does not keep records of the steps yu take to create and manage your data!
When you write codes, not only you can check your steps and actions later, your colleagues can understand what is going on there because everything is saved in scripts.
What you get here is a primer but I promise this will be and ever changing course in case you ask for improvements and more information to digest!
And of course, this course is downloadable and you can watch it offline anywhere.
You can post your questions and discussions here and I will try to answer all of them and in case you do not like this course, you can opt out the course in a month from your enrollment.
In this crash course you will learn:
concepts of relational databases
how to create a database with its most common parameters such as size, maxsize, disk placements and file growth
how to define tables with a look at common data types used for storing data
best practices for data sizing and most efficient storage usage
adding primary keys to a table so that you can locate a piece of data uniquely and order data phisycally
-creating relations between tables using foreign keys and implementing the concept of normalization so that you do not need to store duplicate information
manipulation commands such as INSERT, UPDATE and DELETE and seeing them in action
SELECT command for retrieving data stored in tables
using JOINs for retrieving data from two or more tables where you can apply INNER JOIN and get relative information or apply OUTER JOIN and receive all information in one category and related information if exists
programming in T-SQL and using local and system variables, executing multiple commands and manipulating data
creating stored procedures so that you can combine multiple commands into one compiled unit that can be called with a name, used in other batches and stored procedures and hide the structure of tables
T-SQL Primer Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, T-SQL Primer Torrents and Emule Download or anything related.