August 2, 2008
SQL Server 2005 Express Tutorial - 13 Free Videos
Excellent SQL Server 2005 Express series of 13 free videos from Bob Tabor at LearnVisualStudio.Net.
The best hosting company that I have found for .NET applications is Discountasp.net. Discountasp.net provides many SQL tools that make it easy to remotely manage your sql database directly from your computer that other hosting companies like GoDaddy do not.
Need a Quick Way to See These .NET Videos and Monitor Your Progress?Click Here to Use Progress Monitor For FREE Now |
| May I Also Recommend for Further Study? Bob Tabor also has an excellent 20-part series on LINQ that is entitled: LINQ to SQL 101. Check it out in the video library section of LearnVisualStudio. It is one of the best sites for learning Visual Studio that I have found, and they allow you to download many videos for free to try it out. I have a Lifetime Subscription to Learn Visual Studio and have spent hundreds of hours watching their videos. I am very satisfied with the amount of information that they provide, and I think it is an extremely good value. Most video tutorials and live training classes for Visual Studio cost around $25 per hour (see AppDev.com, Learnkey.com, etc.), but Learn Visual Studio only costs about 70 cents per hour of video. You can save 30% off of the retail price for Learn Visual Studio by clicking on the link at the beginning of this paragraph. |
| 1. What is a Database? |
| Key Concepts:
A. SQL Server terminology for creating and managing databases; Duration: 28 minutes, 15 seconds |
| 2. Understanding Database Tables and Records |
| Key Concepts: A. Tables and definitions of data types; B. Properties; C. Keys D. Table rows, columns, and fields. Duration: 24 minutes, 56 seconds Date: 29 March 2006 |
| 3. More about Column Data Types and Other Properties |
| Key Concepts: A. Data integrity; B. Data types C. Avoid common data type pitfalls. Duration: 21 minutes, 37 seconds Date: 22 February 2006 |
| 4. Designing Relational Database Tables |
| Key Concepts: A. Relational databases B. Primary and foreign keys C. Designing relational database tables D. Normalization rules and de-normalization. Duration: 34 minutes, 10 seconds Date: 29 March 2006 |
| 5. Manipulating Database Data |
| Key Concepts:
A. ADO.NET objects Duration: 40 minutes, 20 seconds Date: 29 March 2006 This lesson requires Management Studio Express and MSXML |
| 6. More Structured Query Language |
| Key Concepts:
A. Sub-select Duration: 23 minutes, 13 seconds Date: 29 March 2006 |
| 7. Understanding Security and Network Connectivity |
| Key Concepts:
A. Differentiate between SQL Server database files and SQL Server processes. Duration: 40 minutes, 59 seconds Date: 20 March 2006 |
| 8. Connecting your Web Application to SQL Server 2005 Express Edition |
| Key Concepts:
A. Workflow of creating a database driven Web applicationB. Visual tools to quickly create an administration application. Duration: 1 hour, 5 minutes Date: 20 March 2006 |
| 9. Using SQL Server Management Studio |
| Key Concepts:
A. SQL Server Management Studio ExpressB. Connect to database instances C. Navigate the query window D. Scripting database objects E. Attaching, detaching and backing up databases Duration: 40 minutes, 26 seconds Date: 23 October 2006 |
| 10. Getting Started with Reporting Services |
| Key Concepts:
A. Set up Reporting Services and the Business Intelligence Development StudioB. Build reports using the wizards and designers C. Deploy reports to Report Server. Duration: 32 minutes, 51 seconds Date: 21 October 2006 |
| 11. Building and Customizing Reports in Business Intelligence Development Studio |
| Key Concepts:
A. Building reports from scratchB. Modifying the reports that were created using the wizards and designers C. Embedding reports into ASP.NET Web Form applications Duration: 44 minutes, 50 seconds Date: 22 October 2006 |
| 12. Creating and Using Stored Procedures |
| Key Concepts:
A. Stored ProceduresB. Basic syntax to create and update stored procedures C. Using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures D. Executing stored procedures from the query window E. Visual Basic and C# syntax required to utilize stored procedures in applications Duration: 42 minutes, 34 seconds Date: 14 November 2006 |
| 13. Enabling Full-Text Search in your Text Data |
| Key Concepts:
A. Setting up Full-Text search within SQL Server Express.B. Creating full-text indexes C. Configuring the index population settings D. CONTAINS predicate Duration: 38 minutes, 25 seconds Date: 14 November 2006 |
Comments