30% OFF Marked Prices & FREE Shipping!   -   ENDS 4PM FRIDAY!   -   Use Discount Code 303

Microsoft Transact SQL Tutorial

A professionally created, self-study video training course
Includes 7 hours of easy to follow Microsoft Transact SQL video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Transact SQL tutorial videos by clicking a blue link below:
  • Tutor: Mark Long
  • Duration: 7 hours
  • Video lessons: 93
  • Product code: 02021
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 8th December 2014
Using step by step training movies, Microsoft certified Systems Engineer Mark Long presents this beginners Microsoft Transact SQL tutorial that demonstrates the stages involved in creating a database, how to include tables, using stored procedures and so much more.

Commencing from the basics, the courses spans over seven hours stating from the fundamentals of Microsoft SQL Server and TSQL foundations.
Once the basic concepts have been covered, trainer Mark covers the steps involved with creating a database using TSQL and how to query with TSQL
You will also learn about changing data with TSQL, how to program objects, and towards the conclusion Mark even covers some of the more advanced concepts such as normalization and transactions.
Throughout the course, Mark uses and makes frequent reference to real TSQL files. These are included with the DVD, online and download purchases helping you to easily keep pace with his on-screen actions and verbal instruction.

The complete course contents are listed below and you can start your MS Transact SQL education right away. Click any of the blue linked lessons below to sample the free video tutorials and discover how effective this practical teaching guide is...
What Our Customers Are Saying

"I thank you so much for the Training CD's. I've pushed my working knowledge considerably. I would recommend your materials to anybody. Thank you again for a great support relationship with Marrutt."Daniel Kiermaier, FL
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
T-SQL Foundations
The Nature Of SQL
SQL Books Online
DDL And DML
The Four Horsemen Of T-SQL
How Queries Are Executed
Working With Queries And Scripts

Creating A Database With T-SQL
Creating A Database - Lesson 1
Creating A Database - Lesson 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 - Lesson 1
Using Synonyms - Lesson 2

Querying With T-SQL
Understanding SELECT
Column Aliasing
Ordering Results
Using JOIN - Lesson 1
Using JOIN - Lesson 2
Inner And Outer And Cross Joins - Lesson 1
Inner And Outer And Cross Joins - Lesson 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
The INSERT Statement
Inserting Multiple Rows
INSERT SELECT
The UPDATE Statement - Lesson 1
The UPDATE Statement - Lesson 2
The DELETE Statement
SELECT Then DELETE

T-SQL Programming Basics
Delimiters
Concatenation
Comments
T-SQL Variables
SET And SELECT
Operators And Expressions
Batches
Using EXECUTE - Lesson 1
Using EXECUTE - Lesson 2

Control-Of-Flow Language Elements
IF Statements
GOTO
TRY CATCH
WHILE
CASE Statements

Programming Objects
Understanding Views
Stored Procedures
Creating A Stored Procedure
Input Parameters
User-Defined Functions
Creating A Function

Indexing
Index Basics
Creating And Dropping Indexes
Index Considerations

Understanding Normalization
Normalization
Normalization Example
Normalization And Data Usage

Understanding Transactions
Understanding Transactions
Explicit Transactions
Transactions And Locking

Conclusion
Wrap Up
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
Item(s):
   
Once purchased, you will receive 93 Microsoft Transact SQL training videos (listed left), lasting a total of 7 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Microsoft Transact SQL course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Transact SQL course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
We recommend the Beginners SQL Tutorial
We also recommend the Oracle 12c
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Transact SQL. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"With all the training Manuals I've purchased, I must say that this is the best instructional on this piece of software i've come across. I feel that I will now be able to tap into that power with this excellent tutorial."Ian Ramsden, Fusion Systems;