Learning Microsoft Transact - SQL

Video description

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.

Table of contents

  1. Introduction
    1. Introduction To Transact-SQL
    2. About The Author
    3. Course Overview
    4. What Is Transact SQL?
    5. Why Should I Learn T-SQL?
    6. Certifications
  2. Understanding Databases
    1. History Of Databases
    2. What Is A Database?
    3. Database Structures And Purposes
    4. Terminology And Acronyms
  3. Microsoft SQL Server
    1. SQL Server Editions
    2. Getting SQL Server Express
    3. Installing SQL Server Express - Part 1
    4. Installing SQL Server Express - Part 2
    5. SSMS On Windows 7
    6. SSMS On Windows 8
    7. The Query Analyzer
    8. Attaching The Sample Database
  4. T-SQL Foundations
    1. The Nature Of SQL
    2. SQL Books Online
    3. DDL And DML
    4. The Four Horsemen Of T-SQL
    5. How Queries Are Executed
    6. Working With Queries And Scripts
  5. Creating A Database With T-SQL
    1. Creating A Database - Part 1
    2. Creating A Database - Part 2
    3. Understanding Filegroups
    4. Understanding Tables
    5. T-SQL Character Datatypes
    6. Understanding Unicode Data Types
    7. T-SQL Numeric Datatypes
    8. T-SQL Data Type Synonyms
    9. Creating A Table
    10. Understanding Primary Keys
    11. Adding A Primary Key
    12. Schema Basics
    13. Working With Schemas
    14. Using Synonyms - Part 1
    15. Using Synonyms - Part 2
  6. Querying With T-SQL
    1. Understanding SELECT
    2. Column Aliasing
    3. Ordering Results
    4. Using JOIN - Part 1
    5. Using JOIN - Part 2
    6. Inner And Outer And Cross Joins - Part 1
    7. Inner And Outer And Cross Joins - Part 2
    8. Refreshing Intellisense
    9. Aggregate Functions
    10. Grouping Data
    11. Group By Example
    12. The HAVING Clause
    13. HAVING And WHERE
    14. Select Into
    15. Multipart Naming
    16. Using Graphical Tools
  7. Modifying Data With T-SQL
    1. The INSERT Statement
    2. Inserting Multiple Rows
    3. INSERT SELECT
    4. The UPDATE Statement - Part 1
    5. The UPDATE Statement - Part 2
    6. The DELETE Statement
    7. SELECT Then DELETE
  8. T-SQL Programming Basics
    1. Delimiters
    2. Concatenation
    3. Comments
    4. T-SQL Variables
    5. SET And SELECT
    6. Operators And Expressions
    7. Batches
    8. Using EXECUTE - Part 1
    9. Using EXECUTE - Part 2
  9. Control-Of-Flow Language Elements
    1. IF Statements
    2. GOTO
    3. TRY CATCH
    4. WHILE
    5. CASE Statements
  10. Programming Objects
    1. Understanding Views
    2. Stored Procedures
    3. Creating A Stored Procedure
    4. Input Parameters
    5. User-Defined Functions
    6. Creating A Function
  11. Indexing
    1. Index Basics
    2. Creating And Dropping Indexes
    3. Index Considerations
  12. Understanding Normalization
    1. Normalization
    2. Normalization Example
    3. Normalization And Data Usage
  13. Understanding Transactions
    1. Understanding Transactions
    2. Explicit Transactions
    3. Transactions And Locking
  14. Conclusion
    1. Wrap Up

Product information

  • Title: Learning Microsoft Transact - SQL
  • Author(s):
  • Release date: December 2014
  • Publisher(s): Infinite Skills
  • ISBN: 9781771373302