Videos tagged with MSSQL

This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures, how to execute your stored procedures from the query window, and finally ...

Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications. Date: 22 October 2006

SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. Suitable for print or online distribution, these reports and it allows you to get professional results very quickly. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and des...

SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more. Date: 23 October 2006

SQL Server beginners will walkthrough the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Date: 20 March 2006

SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions. Date: 20 March 2006

SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods. Date: 29 March 2006

SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. Date: 29 March 2006 This lesson requires Management Studio Express and MSXML

Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization. Date: 29 March 2006

SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls. Date: 22 February 2006