New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Understanding Microsoft SQL Server

From: ASP.NET Essential Training

Video: Understanding Microsoft SQL Server

Most dynamic websites built with Microsoft ASP.NET need a database, a place on the server where data can be stored and retrieved to generate the pages that are requested by the client. I recommend using Microsoft SQL Server. SQL Server is one of a class of databases known as Enterprise Databases meaning that they can handle very large amounts of data and a large number of simultaneous users. There are many database products available on the market. MySQL, which is now owned by Sun Microsystems, is a free database that provides powerful relational database support. There is also Oracle, one of the best of the Enterprise Database class and IBM DB2, and you can also select Microsoft Access.

Understanding Microsoft SQL Server

Most dynamic websites built with Microsoft ASP.NET need a database, a place on the server where data can be stored and retrieved to generate the pages that are requested by the client. I recommend using Microsoft SQL Server. SQL Server is one of a class of databases known as Enterprise Databases meaning that they can handle very large amounts of data and a large number of simultaneous users. There are many database products available on the market. MySQL, which is now owned by Sun Microsystems, is a free database that provides powerful relational database support. There is also Oracle, one of the best of the Enterprise Database class and IBM DB2, and you can also select Microsoft Access.

When building an ASP.NET website, I think that Microsoft SQL Server is your best bet for these reasons. First of all, it's highly scalable, meaning that it can handle enormous amounts of data and a large number of simultaneous users. This distinguishes it from Microsoft Access, which is really designed for use as a Desktop database by an individual user. While it is possible to build a dynamic website using Microsoft Access and while ASP.NET does include all of the software or drivers that you need to use Access in the web environment, most developers and website administrators find that there is a very quick upper limit to both the amount of data and number of simultaneous users that you can support with the Access model.

ASP.NET includes all of the required drivers not just for Access though, but also for SQL Server and this distinguishes SQL Server from products like MySQL, Oracle and IBM DB2. If your organization has already invested in those databases, that is, if you have enormous amount of data already in MySQL, Oracle or DB2, there are drivers available on the market for integration with the .NET Framework. But if you're getting started for the first time with data that will be used to support a dynamic website, you will find you'll be able to get started more easily with SQL Server.

SQL Server and ASP.NET share a programming model, the .NET Framework. If you're familiar with programming in Visual Basic, .NET, C# or one of the other programming languages that's supported by .NET, you'll find you're able to use the same programming skills in both environments. Finally, SQL Server is highly integrated with Windows and its security model, which makes it easy to create integration and authentication of users when dealing with secured websites.

To get started with SQL Server, the first step is to figure out which version of SQL Server you need. There are many editions of SQL Server available. You can go to this webpage, which is listed on the screen at www.msdn.microsoft.com/en-us/ library/ms144275.aspx. This webpage, at the SQL Server Developer Center, includes a listing of all of the different editions of SQL Server that are available.

When you deploy your ASP.NET website, if you're building an enormous website that needs to serve a lot of users, you might need the Enterprise Edition of SQL Server, but you'll find that there are less expensive versions available as well, including the Web version, which is a much lower cost edition specifically designed for deployment with websites. You'll also find SQL Server Express listed on this page. I'll be using SQL Server Express with Tools during this video series.

This edition of SQL Server includes both the server itself and the tools you need to manage the server allowing you to create new databases, manage the structure of existing databases and configure SQL Server on your system for use with your development environment. I should caution that if you're going to install SQL Server Express on the same machine on which you're running Visual Web Developer, and the .NET Framework, the machine should be equipped with a minimum of 1 Gigabyte of RAM and you'll probably find that 2 Gigabytes of RAM will be much better.

You will find other editions of SQL Server on the same page including the Compact Edition, which is designed for mobile devices and web clients on all Windows platforms. In order to download the appropriate version of SQL Server, go to this page, www.microsoft.com/express/sql. On this page you'll find a simple listing of the SQL Server 2008 Express product and a link to get started.

When you click through to the link, you'll be able to download SQL Server 2008 Express for free. You don't have to register; you can go directly to the download page by clicking on the Download link, but if you do register, it will allow you to receive information from Microsoft about changes to the SQL Server 2008 Express product. As you scroll down on the page, you'll find a number of versions that you can select from. If you're getting started with SQL Server for the first time, choose this download, SQL Server 2008 Express with Tools. You'll receive both the SQL Server Database Engine that allows you to create databases, set up their structure and create initial data and SQL Server Management Studio Basic, an integrated environment for managing your SQL Server installation.

Show transcript

This video is part of

Image for ASP.NET Essential Training
ASP.NET Essential Training

79 video lessons · 48120 viewers

David Gassner
Author

 
Expand all | Collapse all
  1. 18m 44s
    1. Welcome
      1m 42s
    2. Prerequisites
      2m 21s
    3. Using the exercise files
      1m 32s
    4. Upgrading exercise file websites for ASP.NET 4.5 (NEW)
      2m 40s
    5. What's new in ASP.NET 4 (NEW)
      3m 48s
    6. What's new in ASP.NET 4.5 (NEW)
      3m 23s
    7. What's new in this course update (NEW)
      3m 18s
  2. 33m 34s
    1. Understanding how ASP.NET works
      5m 52s
    2. Installing Microsoft Visual Web Developer 2008
      3m 43s
    3. Installing Visual Studio Express 2012 for web (NEW)
      2m 12s
    4. Hello World: Creating your first ASP.NET web site
      4m 28s
    5. Creating pages with dynamic output
      7m 39s
    6. Understanding the development web server
      4m 49s
    7. Exploring the development environment
      4m 51s
  3. 40m 2s
    1. Understanding Microsoft SQL Server
      5m 47s
    2. Installing SQL Server Express
      6m 51s
    3. Exploring SQL Server Management Studio Basic
      4m 23s
    4. Creating a new database
      8m 51s
    5. Connecting to the database in ASP.NET
      5m 35s
    6. Testing SQL queries
      3m 53s
    7. Presenting a dataset in an ASP.NET page
      4m 42s
  4. 25m 31s
    1. Understanding ASP.NET web form pages
      5m 51s
    2. Separating presentation and logic with code files
      4m 17s
    3. Adding web form controls to a page
      5m 25s
    4. Handling postback data in a web form page
      5m 50s
    5. Using data binding expressions
      4m 8s
  5. 48m 37s
    1. Creating a testing environment
      4m 40s
    2. Declaring and using a simple variable
      6m 14s
    3. Declaring and using a complex object
      6m 16s
    4. Using loops
      6m 52s
    5. Using functions
      9m 25s
    6. Using trace statements
      4m 47s
    7. Debugging with breakpoints
      5m 45s
    8. Commenting code
      4m 38s
  6. 17m 43s
    1. Creating web controls
      5m 53s
    2. Registering a user control on a web form page
      3m 25s
    3. Registering controls globally in the web.config file
      3m 53s
    4. Adding public properties to a web control
      4m 32s
  7. 19m 7s
    1. Understanding Cascading Style Sheets (CSS)
      5m 36s
    2. Attaching external CSS files
      3m 12s
    3. Defining a CSS selector
      6m 10s
    4. Using CSS class selectors in server controls
      4m 9s
  8. 30m 34s
    1. Presenting data with the GridView control
      5m 49s
    2. Controlling GridView paging and appearance
      5m 46s
    3. Editing data with the GridView control
      6m 57s
    4. Presenting data with the DataList control
      5m 42s
    5. Formatting data with binding expressions
      6m 20s
  9. 36m 46s
    1. Using the DetailsView control
      7m 33s
    2. Inserting data with the DetailsView control
      6m 36s
    3. Redirecting page requests
      9m 39s
    4. Creating an update page
      6m 20s
    5. Linking to update pages from the list page
      4m 3s
    6. Deleting database records
      2m 35s
  10. 22m 15s
    1. Customizing forms with item editing templates
      6m 7s
    2. Adding validator controls to a form
      6m 40s
    3. Controlling the validation error message display
      6m 24s
    4. Using the ValidationSummary control
      3m 4s
  11. 29m 49s
    1. Creating a query with joined tables
      8m 6s
    2. Replacing control style properties with CSS
      5m 50s
    3. Creating a CSS file for printing
      3m 14s
    4. Suppressing elements in printed web pages
      5m 47s
    5. Selecting data for a report
      6m 52s
  12. 11m 14s
    1. Understanding ViewState and managing postbacks
      4m 36s
    2. Using session variables
      6m 38s
  13. 20m 57s
    1. Turning on forms authentication
      1m 51s
    2. Creating a page to log in users
      4m 18s
    3. Creating a page to set up new users
      4m 6s
    4. Understanding the security database
      3m 27s
    5. Configuring security in the web.config file
      2m 59s
    6. Creating a page to log out users
      4m 16s
  14. 27m 56s
    1. Installing IIS on Windows XP
      6m 32s
    2. Installing ASP.NET 3.5 on Windows XP
      1m 39s
    3. Deploying a site on Windows XP
      5m 9s
    4. Installing Information Internet Services (IIS) on Windows Vista, Windows 7, and Windows 8
      1m 56s
    5. Configuring ASP.NET 3.5 on Windows Vista
      2m 15s
    6. Deploying an application on Windows Vista
      3m 29s
    7. Scripting a database for deployment
      3m 36s
    8. Exporting database scripts in SQL Server Management Studio 2012 (NEW)
      3m 20s
  15. 2m 0s
    1. Where to go from here
      2m 0s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.