by | Released December 2014 | ISBN: 9781771373302

In this Microsoft Transact - SQL training course, expert author Mark Long teaches you the basics of Transact - SQL, and helps you understand how to create databases, tables, stored procedures, and much more. This course is designed for the absolute beginner, meaning no previous experience with Transact is required.You will start by learning about databases, then jump into learning about the Microsoft SQL server. From there, Mark will teach you about the T-SQL foundations, how to create a database with T-SQL, and querying with T-SQL. This video tutorial also covers how to modify data with T-SQL, as well as T-SQL programming basics, such as comments, set and select, and batches. You will also learn how to program objects and create and drop indexes. Finally, you will learn to understand normalization and transactions.Once you have completed this computer based training course, you will be fully capable of using Transact-SQL to create your own databases and tables to select, insert, and manage data. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Introduction
   • Introduction To Transact-SQL 00:01:19
   • About The Author 00:02:18
   • Course Overview 00:02:53
   • What Is Transact SQL? 00:06:12
   • Why Should I Learn T-SQL? 00:05:27
   • Certifications 00:05:54
2. Understanding Databases
   • History Of Databases 00:06:16
   • What Is A Database? 00:06:09
   • Database Structures And Purposes 00:05:50
   • Terminology And Acronyms 00:06:19
3. Microsoft SQL Server
   • SQL Server Editions 00:04:55
   • Getting SQL Server Express 00:04:06
   • Installing SQL Server Express - Part 1 00:05:23
   • Installing SQL Server Express - Part 2 00:04:47
   • SSMS On Windows 7 00:06:04
   • SSMS On Windows 8 00:02:46
   • The Query Analyzer 00:06:12
   • Attaching The Sample Database 00:04:56
4. T-SQL Foundations
   • The Nature Of SQL 00:05:36
   • SQL Books Online 00:05:30
   • DDL And DML 00:03:44
   • The Four Horsemen Of T-SQL 00:05:02
   • How Queries Are Executed 00:06:28
   • Working With Queries And Scripts 00:05:40
5. Creating A Database With T-SQL
   • Creating A Database - Part 1 00:05:13
   • Creating A Database - Part 2 00:06:16
   • Understanding Filegroups 00:05:25
   • Understanding Tables 00:04:38
   • T-SQL Character Datatypes 00:06:13
   • Understanding Unicode Data Types 00:04:51
   • T-SQL Numeric Datatypes 00:06:15
   • T-SQL Data Type Synonyms 00:05:13
   • Creating A Table 00:05:16
   • Understanding Primary Keys 00:05:35
   • Adding A Primary Key 00:05:02
   • Schema Basics 00:05:07
   • Working With Schemas 00:05:07
   • Using Synonyms - Part 1 00:03:34
   • Using Synonyms - Part 2 00:03:33
6. Querying With T-SQL
   • Understanding SELECT 00:06:01
   • Column Aliasing 00:05:21
   • Ordering Results 00:04:34
   • Using JOIN - Part 1 00:06:22
   • Using JOIN - Part 2 00:05:39
   • Inner And Outer And Cross Joins - Part 1 00:05:50
   • Inner And Outer And Cross Joins - Part 2 00:05:39
   • Refreshing Intellisense 00:02:14
   • Aggregate Functions 00:05:22
   • Grouping Data 00:05:07
   • Group By Example 00:04:35
   • The HAVING Clause 00:04:17
   • HAVING And WHERE 00:04:47
   • Select Into 00:04:34
   • Multipart Naming 00:04:50
   • Using Graphical Tools 00:05:47
7. Modifying Data With T-SQL
   • The INSERT Statement 00:05:50
   • Inserting Multiple Rows 00:01:47
   • INSERT SELECT 00:04:52
   • The UPDATE Statement - Part 1 00:04:51
   • The UPDATE Statement - Part 2 00:03:42
   • The DELETE Statement 00:04:23
   • SELECT Then DELETE 00:03:08
8. T-SQL Programming Basics
   • Delimiters 00:06:04
   • Concatenation 00:03:49
   • Comments 00:02:32
   • T-SQL Variables 00:05:11
   • SET And SELECT 00:05:28
   • Operators And Expressions 00:05:18
   • Batches 00:04:10
   • Using EXECUTE - Part 1 00:04:50
   • Using EXECUTE - Part 2 00:02:19
9. Control-Of-Flow Language Elements
   • IF Statements 00:04:24
   • GOTO 00:04:01
   • TRY CATCH 00:05:25
   • WHILE 00:03:03
   • CASE Statements 00:04:59
10. Programming Objects
    • Understanding Views 00:05:37
    • Stored Procedures 00:04:06
    • Creating A Stored Procedure 00:02:56
    • Input Parameters 00:03:48
    • User-Defined Functions 00:01:52
    • Creating A Function 00:05:14
11. Indexing
    • Index Basics 00:05:52
    • Creating And Dropping Indexes 00:05:28
    • Index Considerations 00:03:53
12. Understanding Normalization
    • Normalization 00:03:51
    • Normalization Example 00:03:19
    • Normalization And Data Usage 00:04:07
13. Understanding Transactions
    • Understanding Transactions 00:03:51
    • Explicit Transactions 00:03:27
    • Transactions And Locking 00:03:19
14. Conclusion
    • Wrap Up 00:05:05
Show and hide more