Introduction to SQL Server 2000 Desktop Engine

SQL Server Database Design and Development 

Introduction to T-SQL

By William Iverson
Running Time: 3 Hour and 40 Minutes

  Overview

Professor William Iverson presents the basics of using the SQL language in the Microsoft PC environment. Examples are chosen specifically for their availability to all users, and provide continuity of work throughout the video series; from the first basic selections, into more complicated joins, and right into expanding this example with real world help resources. SQL statements are built gradually, to help present the logic of deriving a useful thought process, including error diagnostics and corrections.

  Detailed Video Descriptions

  1 - Introduction to T-SQL (Running Time: 8:15)

The Microsoft version of the Structured Query Language is commonly called Transact-SQL. History of this product and the context of use in database clients, servers, and web components is reviewed and demonstrated.

  2 - SQL Server Installations (Running Time: 11:32)

Both client and server side components must be installed to demonstrate processing of T_SQL statement. During my examples, Microsoft SQL Server 2000 will be providing database services on a Windows 2000 operating system, while the client side most easily uses Query Analyzer to send requests out to the Server and display query results.

  3 - Tables, keys, fields, and data types (Running Time: 17:02)

The heart of any database is the data, which is stored in Table. The columns in each Table are called fields which define the data types used. Special fields used to link Tables together are called keys, which form the arteries for a relation database.

  4 - SELECT fields from Tables (Running Time: 17:33)

An example which selects products with prices higher than the current average price in the database is demonstrated in detail. Subtle syntax variations are thoroughly described and demonstrated. In all video titles, any valid SQL statements remain in upper case letters.

  5 - WHERE conditions are LIKE you need (Running Time: 22:58)

Conditions for searching through records and returning only the results you’d like to see are summarized through the most commonly used expressions. The declaration of variables and Boolean comparisons are used to build the desired syntax.

  6 - ORDER BY sorting and GROUP BY aggregates (Running Time: 16:15)

Sorting results by number or alphabetically is normally required, along with combining groups of results through aggregate functions. Most common aggregates are counting and averaging of data within the database.

  7 - JOIN Tables or a UNION (Running Time: 18:00)

Combining Tables together into a useful result can be a tricky operation which has many options and possibilities. The connection of a primary key to a foreign key is accomplished correctly. While examples of incorrect results are shown, as complete understanding requires recognition of both errors and successes.

  8 - INSERT new data (Running Time: 10:28)

The insertion of new data into a database can be very simple when done consistently with the structure of the Tables. Specifically, the primary and foreign key constraints must be honored. We present a couple aspects of database design, so our INSERT will work as desired.

  9 - DROP, CREATE, and DELETE (Running Time: 15:10)

These common SQL operations show up repeatedly in the modification of database Tables. In our ongoing example throughout this series, we find that the DROP, CREATE, DELETE (and more) process is required to simply add a column into the first position of a Table design.

  10 - UPDATE other records (Running Time: 15:31)

Simple changes can be trivial in some cases, but the subtle aspects of search for what to change, and how those changes propagate through the database into other Tables can create a complex situation. Examples of cascading are presented, along with the errors that commonly are created when updates are not structured properly.

  11 - COMMIT or ROLLBACK your work (Running Time: 9:17)

The T in T-SQL stands for Transaction, and we finally discover the definition of a transaction in SQL. By introducing a simple timer into our ongoing example, the process of aborting or proceeding on with database processing can be succinctly demonstrated.

  12 - Stored Procedures (Running Time: 15:14)

A commonly used set of SQL statements can be stored on the Server for quick access by users. Using a variable to pass into the stored procedure is a central concept of this process, and contrasts with storage of a VIEW for displaying a commonly accessed set of data.

  13 - Special Functions (Running Time: 12:46)

Date, mathematical, string, and other system functions are demonstrated in this video, along with their organization on the Server, so the user can discover where to find their special function when the need arises, as it always does.

  14 - Security Concepts (Running Time: 12:58)

Up to this point in this video series, we have been operating as a system administrator, with full privileges. Of course this is not how real life T-SQL works with a database, so we demonstrate the concepts of applying security to limit the rights of outside users.

  15 - SQL Server Help (Running Time: 17:40)

Even after hours, days, or years of experience with T_SQL, everyone needs to access help resources at some point. This final video of the series demonstrates how experienced T-SQL author accesses real resources for obtaining help, well beyond the help menu, specifically how to let the pros at Microsoft write my T-SQL statement for me (and they do it for free now).

Our Risk-Free Lifetime Money-Back Guarantee

Purchase as many videos as you like. If you discover that the videos do not completely and successfully train you on that subject, simply contact us anytime at support@technicallead.com and we will give you a complete refund.

Why such a generous guarantee? It is simple. We know how powerful the videos are and we know that they will help you. It is our way of assuring you that – in the case that you do not receive maximum benefit from the videos or if for whatever reason you are not completely satisfied – you won’t have to pay for something you can’t use.

However, you will never know until you try. That’s why we are giving you as much time as you need to evaluate the videos. If they don’t live up to your expectations you are not out a dime.

Introduction to T-SQL Video Tutorials - You can take advantage of our unique video tutorials for just $47.00.

Here's what you get with Option 1:

* You get the Introduction to T-SQL videos. That's over 3 hours of video training you can download immediately.
* We will also ship you the videos on CDs so you will have a back-up.