Self Study, Microsoft SQL Server Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.
Macromedia Dreamweaver MX2004 Tutorials Adobe Photoshop video Tutorials.
Microsoft SQL Server Tutorial CD / DVD
Creates the perfect self-paced learning environmenton your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Try 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.
Benefits
- Professional Tuition by expert
- Free Certificate with each Tutorial
- Works on PC or Mac
Topics Covered on this Training Video Include:
SQL Server Overview
- Course Intro
- SQL Server Terminology
- SQL 2000 & Windows 2000
- SQL 2000 Features
- SQL Applications (2/3/n Tier)
- Transact SQL
Course Description
Logical Data Modeling
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
$99.95
Creating a Database
- Creating a Database
- Database Parameters
- Data File Placement
- Creating Tables
- Data Types Explained
- Data Types Used
- NULLS
- Altering Tables
- Generating Values
- Generating Scripts
Data Integrity
- Types of Data Integrity
- Enforcing Data Integrity
- Primary Key
- Foreign Key
- Unique Constraints
- Check Constraints
- Default Constraints
- Disabling Constraints
- Cascading Referential Integrity
Using Transact SQL
- Query Analyzer
- Transact SQL Elements
- Language Elements
- Functions
- Controlling Logic Flow
- Commenting TSQL
- Batches
- Transactions
- Scripts
- XML (Brief XML tutorial)
Transact SQL Specifics
- SELECT
- Grouping Data with SELECT
- Summarizing Data with SELECT
- INSERT
- UPDATE
- DELETE
- XML (XML in query)
Data Import/Export
- Importing and Exporting Data
- Data Import/Export Methods
- Using DTS
Heterogenous Data
- Distributed Queries
- Linked Servers
- OPENQUERY
- OPENROWSET/OPENXML
Stored Procedures
- What Is a Stored Procedure?
- Creating and Executing Stored Procedures
- Altering and Dropping Stored Procedures
- Input Parameters
- Returning Values with Output Parameters
- Recompiling Stored Procedures
- Error Handling
- Permissions Required
- Guidelines for Stored Procedures
User Defined Functions
- What is a UDF?
- Creating a UDF
- UDF Guidelines
- Scalar UDF
- Multi-Statement UDF
- InLine UDF
Triggers
- What is a Trigger?
- When to Use Triggers/Considerations
- Creating a Trigger
- Under the Hood
- Nesting Triggers
Views
- What is a View?
- Creating and Using a View
- Advantages of Views
Indexes
- Index Basics
- Indexes in SQL Server 2000
- Guidelines for Indexing
- Selectivity
- Creating an Index
- Index Options
- Maintaining Indexes
- Rebuilding Indexes
- Statistics
- Index Tuning Wizard
- Graphical Query Plan
Query Optimizer
- Query Optimizer
- Cost Limit
- Viewing STATISTICS
- Graphical Execution
- General Query Guidelines
SQL Profiler
- SQL Profiler
- Using the SQL Profiler
Locking
- Database Locking
- Locking Levels
- Lock Types
- Session Locking Options
- Deadlocks
- Displaying Locking Info
About this Microsoft SQL Server Training CD
| Title : | Microsoft SQL Server |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 102 Lessons- Video run time: 8 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 98, 2000, NT, XP, Mac OS, OSX |
| Released | 2002-08-20 |
| Price US / Canadian Sales | $99.95   |
146 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 $500
10 Multi User $500 Why use this method of video training ?
- Learn Microsoft SQL Server from an accredited expert in days.
- Ideal for beginners, easy to follow videos that offer visual clarity.
- Master a full application 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
- Cost effective tuition from leading expert tutors
- You control the pace, training can be stopped, rewound or fast forwarded as required.
- High Quality Tutorial Videos on CD / DVD or Online. PC / Mac Compatible. Great tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
Microsoft Transact SQL | Microsoft SQL Server | ASP.NET | Microsoft Visual Basic .NET | Microsoft Visual Studio .Net| Data Modeling
Microsoft SQL Server Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a Microsoft SQL Server training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Microsoft SQL Server 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 watch as much as you like.
When your finished cancelling is easy, just click the cancel button, that's it, no questions, your in total control.
