This programming video tutorial series will show will show you how to install SQL Server 2005 Express and SQL Server Management Studio. SQL Server provides you with a "window" to connect to your databases. You use the "SQL (Structured Query Language) Language" to reach through the window to "touch" and "manipulate" the databases.

The express version of SQL Server is totally free. It allows you create and update tables on your own computer or update tables on a remote web server. The standard Edition (not the Express) allows you to directly create and administer your tables on a remote web server, but the Express version only allows updating on remote web servers.

In this first video, we will look at how to install SQL ServerExpress Edition 2005. Please click on the heading for the tutorial if you want to view it in full-screen mode.

If you want to learn more about SQL Server and dotNET technologies, I recommend the video series from Learn Visual Studio. It is a fantastic resource for learning about using Microsoft's products and you can try out a number of videos for free - no strings attached. I have spent many hours viewing their videos as I have a Lifetime Subscription to Learn Visual Studio.

You can find a summary of over 700 video tutorials on programming by clicking this link: Summary of 700 Programming Tutorials.

Part 1 - Installing SQL Server 2005 Express

Oct 16, 2007

By: Wade Harvey (Ideal Programmer)

10 minutes

Quick 10-minute tutorial shows how to install SQL Server Express 2005.

Other Tutorials in This Series

This is a work in progress - More to episodes will be coming…Please bookmark this post and check back often.

Further Study

Microsoft has an excellent series of 13 video tutorials on SQL Server 2005 Express that lasts about 9 hours. The series is for beginners, but everyone can learn a good deal from it. You can view the series by clicking on this link: SQL Server 2005 Express Video Tutorials

Tags:database training Learn db microsoft SQL Server SQL Server 2005 Express Video tutorial

Popularity: 55% [?]

Share This

By: John L

What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases.

SQL began life as an IBM creation but was standardized by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) as ANSI/ISO SQL in 1988. Since then ANSI/ISO SQL standard continued to evolve. The ANSI-SQL group has since published three standards over the years:
1. SQL89 (SQL1)
2. SQL92 (SQL2)
3. SQL99 (SQL3)

SQL is a query language. It is English-like and easy to use. However, although there are more than 90 SQL reserved words, most programmers seldom use more than the following handful of commands - SELECT, INSERT, UPDATE, DELETE, FROM, WHERE, HAVING, BETWEEN, LIKE, OR, AND, NOT, IN, ORDER, GROUP and BY.

For example, if you had a database table named "employees" and you wanted to retrieve all records where the employee has the last name "goodman", you would use the following SQL statement:
SELECT * FROM employees WHERE lastname = 'goodman';

There are many different categories of SQL statements but the basic ones which all programmers should be familiar with are the SQL statements that:
1. Create tables and manipulate their definitions
2. Query the table data
3. Manipulate the table data
SQL is predominantly used by 2 types of users - programs and humans (keying in the commands through a database client) - to pass instructions to databases. SQL commands can be keyed into a database client like the MySQL Query Browser or the SQL
Server Enterprise Manager and executed to either return a result or modify records in the database. SQL can also be used in conjunction with programming language or scripting language like Microsoft Visual Basic or PHP to communicate with the database.

Although SQL is a world standard, it is unfortunate that most database vendors have come up with different dialects and variations. This is because every database vendor wants to differentiate their database products from the crowd. One good example is Microsoft SQL Server's TRANSACT-SQL. TRANSACT-SQL is a superset of SQL and is designed for use only with Microsoft SQL Server. Although it does make programming much easier for software developers, it is not compliant with other databases like Oracle or MySQL - making TRANSACT-SQL programs non database-portable. As such, although many of these features are powerful and robust, it is good practice to exercise caution and limit your SQL use to be compliant with the ANSI/ISO SQL standards and ODBC-Compliant.

Courtesty of SQLPrimer.com. For more information, please contact the Webmaster of
SQLPrimer.com - http://www.sqlprimer.com.

About the Author

John L is the Webmaster of SQLPrimer.com - http://www.sqlprimer.com.

Tags:Oracle Primer SQL SQL Server

Popularity: 31% [?]

Share This