Questions?

  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).

Yes, I can't wait to start learning SQL like the pros... and I know there is no time to lose. Thanks for the lifetime guarantee - that takes all the pressure off my decision. In fact, it allows me to see everything for free, if I choose. Option 1. Introduction to T-SQL Video Tutorials (CD and DOWNLOAD) - You can start learning SQL today for just $147.00 $67.00. That's $80.00 off the regular price. Click Here To Start Option 1 Securely Option 2. Introduction to T-SQL Video Tutorials Package DOWNLOAD ONLY - You can start learning SQL today for just $127.00 $47.00. That's $80.00 off the regular price. Click Here To Start Option 2 Securely For corporate and educational multi-licenses, please contact our sales department at (866) 894-0705 for more information.