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
- Introduction
- Understanding Databases
- Microsoft SQL Server
- T-SQL Foundations
-
Creating A Database With T-SQL
- Creating A Database - Part 1
- Creating A Database - Part 2
- Understanding Filegroups
- Understanding Tables
- T-SQL Character Datatypes
- Understanding Unicode Data Types
- T-SQL Numeric Datatypes
- T-SQL Data Type Synonyms
- Creating A Table
- Understanding Primary Keys
- Adding A Primary Key
- Schema Basics
- Working With Schemas
- Using Synonyms - Part 1
- Using Synonyms - Part 2
-
Querying With T-SQL
- Understanding SELECT
- Column Aliasing
- Ordering Results
- Using JOIN - Part 1
- Using JOIN - Part 2
- Inner And Outer And Cross Joins - Part 1
- Inner And Outer And Cross Joins - Part 2
- Refreshing Intellisense
- Aggregate Functions
- Grouping Data
- Group By Example
- The HAVING Clause
- HAVING And WHERE
- Select Into
- Multipart Naming
- Using Graphical Tools
- Modifying Data With T-SQL
- T-SQL Programming Basics
- Control-Of-Flow Language Elements
- Programming Objects
- Indexing
- Understanding Normalization
- Understanding Transactions
- Conclusion
Product information
- Title: Learning Microsoft Transact - SQL
- Author(s):
- Release date: December 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771373302
You might also like
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
video
SQL for Beginners with Microsoft SQL Server Database
This video course will teach you how to extract data on your own and will give …
book
Learn T-SQL Querying
Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features Discover …
book
SQL
SQL is a solid guide and reference to the key elements of SQL and how to …