SQL Server Express Editions - Installation and Management - Video Series Video Category: Getting Started with SQL Server 2005 Express Editions Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 SQL Server 2005 Express Edition is a free, easy-to-use and easy to learn edition of SQL Server 2005. Did I say it's free? Because it is - free to download, free to redistribute, free to integrate into your applications, and easy for new developers to use immediately. SQL Server Express is a full-fledged version of SQL Server 2005 and, with SQL Server Express, you can create databases, add tables, add data, and even use Express as your database for a website! This series of videos focuses on installation and basic management of SQL Express - perfect for beginners!

Videos in this Series:

Title Skill Length Download Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server   100 10 mins. Download Pt. 2 - Installing SQL Server 2005 Express Editions   200 14 mins. Download Pt. 3 - Post-Install: Examining an Installation of SQL Server 2005 Express Editi...   200 11 mins. Download Pt. 4 - Using the SQL Server Configuration Manager   300 14 mins. Download Pt. 5 - Using SQL Server Management Studio (SSMS) Express   200 15 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "CTRL" + "F4" closes the active pane/worksheet/tab within an application but does not close the application Helpful Keyboard Shortcuts: "ALT" + "TAB" allows you to cycle through the Taskbar items Performance Tip: "WHERE LastName LIKE 'Sm%'" is a fast query but "WHERE column LIKE '%Sm%' is a performance killer. Imagine searching in a phone book for anyone whose last name starts with 'Sm' - easy right? Now try to find anyone whose last name contains the two letters 'sm'. There's a huge difference in the number of pages required to satisfy the two queries