T-SQL Primer (2016)

TheCornor · 17 Październik 2016

T-SQL Primer

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

DOWNLOAD

Ukryta Zawartość