SQL Server Database Design and Development

By Max Hodges

Running Time: 1 hours, 48 minutes

Overview

In this series, trainer Max Hodges gets you started in database design and development. First, Max will introduce you to the concepts and terminology of database design. Next, you'll be led through a tour of SQL Server Enterprise Manager and SQL Query Analyzer, the primary tools for creating and managing SQL Server databases. Max will then walk you through the creation of databases and tables, spending some time on issues of special interest along the way.

Detailed Video Descriptions

1 - Introduction (Running Time: 1:43)

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 - Enterprise Manager (Running Time: 14:23)

Enterprise Manager is the primary administrative tool for SQL Server. In this video, Max takes you on a quick tour of the tools and features of Enterprise Manager.

3 - Query Analyzer (Running Time: 12:59)

In this video, Max introduces SQL Query Analyzer, the primary tool for creating queries and stored procedures for SQL Server databases. You'll learn some tips and tricks that will bring you up to speed in using this powerful tool.

4 - Key Concepts (Running Time: 15:40)

This video introduces some key concepts and terminology of database design and data modeling. You'll learn about entities, attributes, and relationships, as well as techniques to get you started in designing your database.

5 - Normalization (Running Time: 12:49)

In this video Max introduces normalization, the process of removing redundant data from relational tables by decomposing these tables into smaller tables. A working knowledge of normalization is essential in order to build efficient databases free of redundant data.

6 - Creating a Database (Running Time: 15:30)

In this video, Max shows you several ways to create a database and discusses the consequences of the various decisions you will have to make regarding permissions, filegroups, file locations, and the settings affecting data file growth.

7 - Understanding NULL (Running Time: 12:14)

In the world of database design, NULL is a concept that even professional database developers often confuse and misuse. In this video, Max explains what NULL means and provides some examples to help you determine when--and when not--to use NULL in your designs.

8 - Creating a Table (Running Time: 22:43)

In this final video, Max demonstrates table creation by using the graphical tools of Enterprise Manager and by using scripts in Query Analyzer. You'll also learn how to create relationships between those tables, and how relationships and relationship properties affect the behavior of SQL Server when adding, modifying and deleting records data in those tables.

Our Risk-Free Lifetime Money-Back
Guarantee

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

Option 1. SQL Server Database Design and Development Video Tutorials You can start learning SQL right now with our video training for just ~~$147.00~~ $67.00. That's $80.00 off the regular price.

Here's a summary of Option 1:

You get the SQL Server Database Design and Development videos. That's almost 1 hours of video training you can download immediately.
We will also ship you all the videos on CD so you will have a back-up.

Option 2. SQL Server Database Design and Development Video Tutorials DOWNLOAD ONLY - You can start learning SQL right now with our video training for just ~~$127.00~~ $47.00. That's $80.00 off the regular price.

Here's a summary of Option 2:

You get the SQL Server Database Design and Development videos. That's almost 1 hours of video training you can download immediately.

ALSO NOW AVAILABLE, TWO BIG WAYS TO SAVE ON OUR TRAINING!

1. Our New Flash Definitive Membership. Save over 82% on ALL of our Flash Training PLUS you will get ALL future Flash releases while you are a member!

2. Our Flash CS3 Complete Training Bundle - This training bundle includes six of our best titles. Get our Flash CS3 Complete Training Bundle NOW for just ~~$282.00~~ $197.00. That's a savings of almost $85.

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. SQL Server Database Design and Development 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. SQL Server Database Design and Development 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.