Language

Sign In|Join

///Chapter 5. SQL 2005

SQL 2005

Chapters

  1. 1. How Do I?
  2. 2. Tailspin Spyworks
  3. 3. Building 3.5 Applications
  4. 4. Authentication
  5. 5. SQL 2005
  6. 6. Visual Studio 2005
  7. 7. Migrating
  8. 8. Building 2.0 Applications
  9. 9. General IIS Tips
  10. 10. General VS 2010 Tips
  11. 11. Ajax Control Toolkit
  12. 12. ASP.NET AJAX
  13. 13. Data Access
  14. 14. ASP.NET Dynamic Data
  15. 15. ASP.NET 3.5
  16. 16. jQuery
  17. 17. .NET 4
  18. 18. ASP.NET Web Forms vNext
  19. 19. ASP.NET vNext
  20. 20. Visual Studio vNext
  21. 21. Pluralsight Introduction to ASP.NET 4 WebForms

In this chapter, you'll learn:
How to work with SQL Server Express to add database capabilities to your ASP.NET applications.

  1. What is a Database

    By Microsoft ASP.NET Team|

    This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from ...

  2. Understanding Database Tables and Records

    By Microsoft ASP.NET Team|

    SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns...

  3. More about Column Data Types and Other Properties

    By Microsoft ASP.NET Team|

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

  4. Designing Relational Database Tables

    By Microsoft ASP.NET Team|

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

  5. Manipulating Database Data

    By Microsoft ASP.NET Team|

    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.

  6. More Structured Query Language

    By Microsoft ASP.NET Team|

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

  7. Understanding Security and Network Connectivity

    By Microsoft ASP.NET Team|

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

  8. Connecting your Web Application to SQL Server 2005 Express Edition

    By Microsoft ASP.NET Team|

    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.

  9. Using SQL Server Management Studio

    By Microsoft ASP.NET Team|

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

  10. Getting Started with Reporting Services

    By Microsoft ASP.NET Team|

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

  11. Building and Customizing Reports in Business Intelligence Development Studio

    By Microsoft ASP.NET Team|

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

  12. Creating and Using Stored Procedures

    By Microsoft ASP.NET Team|

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

  13. Enabling Full-Text Search in your Text Data

    By Microsoft ASP.NET Team|

    Full-Text search allows you to save large portions of text - even Microsoft Word documents, or other file formats - into your database and perform complex queries based on this textual data while e...

ASP.NET Web Forms Books

Microsoft's Jon Galloway recommends these books for learning ASP.NET Web Forms:

Beginning ASP.NET 4.5: in C# and VB

Beginning ASP.NET 4.5: in C# and VB

by Imar Spaanjaars

Professional ASP.NET 4.5 in C# and VB

Professional ASP.NET 4.5 in C# and VB

by Jason N. Gaylord, Christian Wenz, Pranav Rastogi, Todd Miranda, Scott Hanselman

Pro ASP.NET 4 in C# 2010

Pro ASP.NET 4 in C# 2010

by Matthew MacDonald