This series is designed for absolute beginners who may want to integrate a database into their development efforts. Areas of focus include anSQL Server 2005 Express Edition introduction, where databases fit into the typical application's design, relational database theory, review of major database objects like tables, columns, etc. Writing Transact SQL statements, connectivity and security issues and a full development lifecycle of a small database driven application.
The following videos are available for this series:
Lesson 1: What is a database? |
|
This introduction covers the questions and terminology necessary to create and manage databases, such as: What is a database? How is a database different from an Excel spreadsheet? What do databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express? What do terms like “ADO.NET” mean? |
Lesson 2: Understanding Database Tables and Records |
|
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 can be empty. |
Lesson 3: More about Column Data Types and Other Properties |
|
Explore data integrity, know which data types to use for what, and avoid common data type pitfalls. |
Lesson 4: Designing Relational Database Tables |
|
Why are relational databases the most popular? Differentiate between primary and foreign keys. Design relational database tables and learn about normalization rules and de-normalization. |
Lesson 5: Manipulating Database Data |
|
Learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. |
Lesson 6: More Structured Query Language |
|
Discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods. |
Lesson 7: Understanding Security and Network Connectivity |
|
Differentiate between 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. |
Lesson 8: Connecting your Web Application to SQL Server 2005 Express Edition |
|
Walkthrough the entire workflow of creating a database driven web application and use visual tools to quickly create an administration application. |
Lesson 10: Getting Started with Reporting Services |
|
Reporting Services allows you to design and deploy reports – nicely formatted, interactive and representations of your data suitable for printing or online distribution … 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 designers, and deploy them to your Report Server. |
Lesson 11: Building and Customizing Reports in Business Intelligence Development Studio |
|
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. |
Lesson 12: Creating and Using Stored Procedures |
|
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 the Visual Basic and C# syntax required to utilize stored procedures in your own applications. |
Lesson 13: Enabling Full-Text Search in your Text Data |
|
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 expecting great performance. This lesson demonstrates how to set up Full-Text search paying particular attention to the nuances of setting it up within SQL Server 2005 Express Edition. Then we move to creating full-text indexes, configuring the index population settings, and performing queries that demonstrate the power of the CONTAINS predicate and its many, many variations. |
Lesson 9: Using SQL Server Management Studio |
|
SQL Server Management Studio Express will typically be your main interface into SQL Server 2005 Express Edition. 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. |
Home: http://www.learnvisualstudio.net/content/series/getting_started_with_sql_server_2005_express_edition.aspxLink download :
getting_started_with_sql_server_2005_express_edition.rar.030http://rapidshare.com/files/219507311/getting_started_with_sql_server_2005_express_edition.rar.030
getting_started_with_sql_server_2005_express_edition.rar.001
http://rapidshare.com/files/219508313/getting_started_with_sql_server_2005_express_edition.rar.001
getting_started_with_sql_server_2005_express_edition.rar.002
http://rapidshare.com/files/219509188/getting_started_with_sql_server_2005_express_edition.rar.002
getting_started_with_sql_server_2005_express_edition.rar.003
http://rapidshare.com/files/219510020/getting_started_with_sql_server_2005_express_edition.rar.003
getting_started_with_sql_server_2005_express_edition.rar.004
http://rapidshare.com/files/219510930/getting_started_with_sql_server_2005_express_edition.rar.004
getting_started_with_sql_server_2005_express_edition.rar.005
http://rapidshare.com/files/219511944/getting_started_with_sql_server_2005_express_edition.rar.005
getting_started_with_sql_server_2005_express_edition.rar.006
http://rapidshare.com/files/219512934/getting_started_with_sql_server_2005_express_edition.rar.006
getting_started_with_sql_server_2005_express_edition.rar.007
http://rapidshare.com/files/219513813/getting_started_with_sql_server_2005_express_edition.rar.007
getting_started_with_sql_server_2005_express_edition.rar.008
http://rapidshare.com/files/219514702/getting_started_with_sql_server_2005_express_edition.rar.008
getting_started_with_sql_server_2005_express_edition.rar.009
http://rapidshare.com/files/219515611/getting_started_with_sql_server_2005_express_edition.rar.009
getting_started_with_sql_server_2005_express_edition.rar.010
http://rapidshare.com/files/219516580/getting_started_with_sql_server_2005_express_edition.rar.010
getting_started_with_sql_server_2005_express_edition.rar.011
http://rapidshare.com/files/219517426/getting_started_with_sql_server_2005_express_edition.rar.011
etting_started_with_sql_server_2005_express_edition.rar.012
http://rapidshare.com/files/219518343/getting_started_with_sql_server_2005_express_edition.rar.012
getting_started_with_sql_server_2005_express_edition.rar.013
http://rapidshare.com/files/219519266/getting_started_with_sql_server_2005_express_edition.rar.013
getting_started_with_sql_server_2005_express_edition.rar.014
http://rapidshare.com/files/219520261/getting_started_with_sql_server_2005_express_edition.rar.014
getting_started_with_sql_server_2005_express_edition.rar.015
http://rapidshare.com/files/219521261/getting_started_with_sql_server_2005_express_edition.rar.015
getting_started_with_sql_server_2005_express_edition.rar.016
http://rapidshare.com/files/219522217/getting_started_with_sql_server_2005_express_edition.rar.016
getting_started_with_sql_server_2005_express_edition.rar.017
http://rapidshare.com/files/219523159/getting_started_with_sql_server_2005_express_edition.rar.017
getting_started_with_sql_server_2005_express_edition.rar.018
http://rapidshare.com/files/219524090/getting_started_with_sql_server_2005_express_edition.rar.018
getting_started_with_sql_server_2005_express_edition.rar.019
http://rapidshare.com/files/219525043/getting_started_with_sql_server_2005_express_edition.rar.019
getting_started_with_sql_server_2005_express_edition.rar.020
http://rapidshare.com/files/219525963/getting_started_with_sql_server_2005_express_edition.rar.020
getting_started_with_sql_server_2005_express_edition.rar.021
http://rapidshare.com/files/219526947/getting_started_with_sql_server_2005_express_edition.rar.021
getting_started_with_sql_server_2005_express_edition.rar.022
http://rapidshare.com/files/219527982/getting_started_with_sql_server_2005_express_edition.rar.022
getting_started_with_sql_server_2005_express_edition.rar.023
http://rapidshare.com/files/219529022/getting_started_with_sql_server_2005_express_edition.rar.023
getting_started_with_sql_server_2005_express_edition.rar.024
http://rapidshare.com/files/219530110/getting_started_with_sql_server_2005_express_edition.rar.024
getting_started_with_sql_server_2005_express_edition.rar.025
http://rapidshare.com/files/219531106/getting_started_with_sql_server_2005_express_edition.rar.025
getting_started_with_sql_server_2005_express_edition.rar.026
http://rapidshare.com/files/219532116/getting_started_with_sql_server_2005_express_edition.rar.026
getting_started_with_sql_server_2005_express_edition.rar.027
http://rapidshare.com/files/219533101/getting_started_with_sql_server_2005_express_edition.rar.027
getting_started_with_sql_server_2005_express_edition.rar.028
http://rapidshare.com/files/219534192/getting_started_with_sql_server_2005_express_edition.rar.028
getting_started_with_sql_server_2005_express_edition.rar.029
http://rapidshare.com/files/219535244/getting_started_with_sql_server_2005_express_edition.rar.029
Join files with hjsplit
Password default :
booktraining.net