Here are some Free Videos From TrainingSpot.com
Joining Tables using INNER Joins
Joining tables to find related data in your database is the true power of any relational database management system and SQL Server 2005. This video will show you the fundamentals of performing INNER JOINS and show you how to write them on your own.
Joining Tables using LEFT, RIGHT and FULL OUTER Joins
This video will introduce you to OUTER JOINS and show you the differences between LEFT, RIGHT and FULL OUTER JOINS. You will see several examples and will understand which type of join is right for you in any situation.
This video will introduce you to OUTER JOINS and show you the differences between LEFT, RIGHT and FULL OUTER JOINS. You will see several examples and will understand which type of join is right for you in any situation.
Using Aggregate Functions to Group Data
Calculating an average or determining the sum of multiple records can be achieved by using the Aggregate functions provided with SQL Server 2005. This video will show you how to use the most common aggregate functions and explain to you when they can be used.
Understanding SQL Server 2005 Ranking Functions
This video will introduce the Ranking functions that are a new category of functions introduced with SQL Server 2005. The ranking functions allow you to rank the records returned in your result sets, and more. You will see several examples on how they can be used.
This video will introduce the Ranking functions that are a new category of functions introduced with SQL Server 2005. The ranking functions allow you to rank the records returned in your result sets, and more. You will see several examples on how they can be used.
Filtering results using the WHERE clause
This video will demonstrate how to filter and find data that is stored in your database tables by using the WHERE clause. You will also be introduced to the Comparison Operators and learn how they are used.
Using Logical Operators
Logical Operators allow you to perform more sophisticated searches to find data in your database and this video will provide you with an introduction to the AND, OR, BETWEEN, IN and LIKE operators and show you how they are used.
Logical Operators allow you to perform more sophisticated searches to find data in your database and this video will provide you with an introduction to the AND, OR, BETWEEN, IN and LIKE operators and show you how they are used.
Display Alternate Values using the CASE Function
The CASE function allows you to display alternate values in your result sets. In this video, you will see several examples of how to use the CASE function and how to use them in your SQL statements.
Implementing and using Indexes
This video will walk you through how to create indexes on your tables using the visual tools provided within SQL Server 2005. You will see how to create both clustered and non-clustered indexes and explore some additional properties for indexes as well.
This video will walk you through how to create indexes on your tables using the visual tools provided within SQL Server 2005. You will see how to create both clustered and non-clustered indexes and explore some additional properties for indexes as well.
No comments:
Post a Comment