Self Study, Tutorial Video on CD - DVD. Tutor Mark Long guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
These Microsoft Transact SQL tutorials are an ideal way for system and database administrators to gain a solid working knowledge of not only the data definition, manipulation, and the language syntax but you will also be better prepared for the MCDBA certification exam 70 – 229. By the conclusion of this training CD users will have a strong understanding of all the TSQL tools, the Query Analyzer and also the Enterprise Manager . Watch our free Microsoft Transact SQL Tutorial Videos by clicking the blue lesson links below.
Microsoft Transact SQL Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.
Problems Playing the Demos?
Benefits
- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac
Just Released This Week
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Course Intro
Course Intro
- Welcome/Intro
- What Is Transact SQL?
- A Few Words About TSQL
- History of Databases
- History of SQL
- What Flavor Would You Like?
- SQL Terminology/Acronyms
- What Is A Database?
- Two Main Types of Databases
- Normalization
- Denormalization
- Database Relationships
- Database Design Concerns
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
Language Basics
$149.95
- SQL Statement Types
- Transact SQL Elements
- Data Types Overview
- SQL 2000 Data Types
- Wildcards & Escape Characters
- Logic Flow
- Scripts
- Batches
- Transactions
- Functions
- Stored Procedures
- Views
- Triggers
- Debugging
- Query Analyzer Lesson 1
- Query Analyzer Lesson 2
- Enterprise Manager
- QA vs. EM
- ISQL / OSQL
- ISQL / OSQL Examples
- Notepad
- Third Party Apps
- Creating Databases
- A Word About NULLS
- Creating Tables
- Creating Constraints
- Creating Defaults
- Creating Relationships
- Basic SELECT
- Column Aliasing
- SELECT INTO Clause
- SELECT FROM Clause
- Using JOINS
- JOIN Examples
- Table Aliasing
- SELECT WHERE Clause
- Looking For NULLS
- SELECT GROUP BY Clause
- SELECT HAVING Clause
- SELECT ORDER BY Clause
- SELECT COMPUTE Clause
- UNION
- Basic INSERT Syntax
- Using INSERT
- Advanced INSERT
- Basic UPDATE Syntax
- Using UPDATE
- Advanced UPDATE
- Basic DELETE Syntax
- Using DELETE
- DELETE or TRUNCATE TABLE?
- What Is An Index?
- Types Of Indexes
- Determining Indexes(Guidelines)
- Creating Indexes
- What Is A View?
- Creating Views
- Advantages of Views
- Overview of System Tables
- Querying System Tables
- Overview Of Variables
- Declaring Variables
- Using Variables
- Variables As Object Names
- System Variables
- What Is A Stored Procedure?
- Creating A Stored Procedure
- Using Input Variables
- Using Output Variables
- Extended Stored Procedures
- What Are Cursors?
- What Are Functions?
- Partial List Of Functions
- User Defined Functions
- Scalar UDF
- Multi-Statement UDF
- InLine UDF
- What Are Triggers?
- Creating A Trigger
- How Triggers Work
- Nesting & Recursive Triggers
- What Is XML?
- FOR XML
- Misc XML Info
- Limiting Results
- Utilizing Indexes
- Graphical Exec Plan/Profiler
About this Microsoft Transact SQL Training CD
| Title : | Microsoft Transact SQL |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 101 Lessons- Video run time: 8 Hours |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2002 |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
160 In Stock
Purchase Orders from Schools, Colleges, Government and Military Accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $695
10 Multi User $695 Why use this method of video training?
- Learn Microsoft Transact SQL from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
MCDST Certification | Microsoft SQL Reporting Services | Crystal Reports | Microsoft Visual Basic 2008 | Microsoft SQL Server 2008 Admin | Microsoft SQL Server 2008 Development | Microsoft LINQ Tutorial
Microsoft Transact SQL Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your free certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract , No minimum period, and no commitment on your part.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
