SQL Server 2005 Express Tutorial: (13 Videos) Database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instance


Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instanceExcellent SQL Server 2005 Express series of 13 free videos from Bob Tabor at LearnVisualStudio.Net. Here are just a few of the topics in this series: , , sql server 2005 replication, , download sql server 2005, compare sql server, sql server instance

Gitex 2005 - database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instanceThe 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.
 

 
Creative Commons License photo credit: @@:@@
 

 

SQL Server 2005 Express Tutorial

 

1. What is a Database?
Key Concepts:

A. SQL Server terminology for creating and managing databases;
B. SQL Server database;
C. Compare SQL Server to Excel;
D. Relation between SQL Server Database and Desktop application or website;
E. Relationship between SQL Server Express and Visual Studio Express; ADO.NET

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
B. Execution of SQL statement from ADO.NET
C. Insert, update, and delete SQL statements.

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
B. Stored procedures and their counterparts in C# and VB methods.

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.
B. Various scenarios for connecting to SQL Server Express databases
C. Enabling and disabling user instances
D. login permissions
E. other security precautions

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 application
B. 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 Express
B. 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 Studio
B. 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 scratch
B. 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 Procedures
B. 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

 

Related posts:

  1. SQL Server 2005 Video Tutorial – 1 – Installing This programming video tutorial series will show will show you...
  2. Visual Studio Express 2005 Video Tutorial – Part 1 Quick 2-minute tutorial shows how to install Visual Studio Visual...
  3. Visual C# 2005 Express Video Tutorial -1- Installing Shows you how to install C# for free in under...
  4. Visual Studio Express 2005 Video Tutorial – Part 2 This is the second of a series of asp net...
  5. Visual Studio Express 2005 Video Tutorial – Part 4 – Adding Text-To-Speech (TTS) In this tutorial, we learn how to add speech to...

Related posts brought to you by Yet Another Related Posts Plugin.

Comments

13 Responses to “SQL Server 2005 Express Tutorial: (13 Videos) Database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instance”
  1. chetan says:

    realy very applicable video

  2. Chris says:

    How exactly did Bob Tabor create SQLLesson02 in the second .wmv? Please email me with your answer.

  3. Chris says:

    How exactly did Bob Tabor create SQLLesson02 in the second .wmv? Please email me with your answer.

    chris@therucker.com

  4. krishna kompally says:

    its really very very very…..usefull for learners…

  5. krishna kompally says:

    thank you…………..

  6. Zo says:

    Do you have a french version pls ?

  7. Well you can try to ask in forums . I think we can translate the articles but i dont think we can translate the videos

  8. anuragsharma says:

    ultimate videos, and the way u taught is excellent. thanks for the good work……….

  9. rammpr says:

    thank you very much for the web site people ….

    great thanks to Idealprogrammer people .

    Great work ..

    cheers ,

    Ram …

  10. ruavila says:

    Than you very much. Excelent videos. And For Free!!!!

  11. chikile says:

    Can you please quickly show how to do a bulk insert from a comma delimited text file

  12. seriana says:

    thank you. :)

  13. cepwahyu says:

    thanks for video, it is very useful for me and it is Excellent…..i am waiting for the tutorial about collaboration between MS Access as FE and SQL server as BE.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net