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.
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
DB2 is a relational database management system produced by IBM that IBM refers to as a "data server." What is a relational database? A relational database is a set of files that has been analyzed for all of the relationships between fields. The related fields are pulled out of the original files in order to minimize redundancy in the data being stored. For example, instead of storing the information that TN is the state Tennessee in every record, that information is pulled out of the original file and stored only once in a state code file.
The idea of a relational database first arose in 1970 when Dr. E.F. Codd formally stated a number of algebraic rules that could be applied to data manipulation. IBM left the application of Codd's principles to a group of programmers that created a language that was eventually called SQL (Structured Query Language). DB2 was the name given to the Database Management System in 1982, and it is the first database to use SQL.
At first, DB2 was only available on IBM mainframes, but during the 1990's DB2 spread to many other platforms, LUW (Linux, Unix, Windows), mid-range computers i5/OS (formerly AS/400) and even on PDAs. During the 90s, IBM also introduced it's Universal Server. The Universal Server shifted the technology to an object-related SQL DBMS that allows developers to define their own data types from more primitive data types.
In 2001, IBM bought Informix and incorporated many of it's database features into the DB2 product suite.
In 2006, IBM announced "Viper," the codename for DB2 9 on distributed platforms and DB2 9 on z/OS. DB2 9 offers the ability to store XML "natively," and it also allows storage compression to save on disk space. IBM refers to the ability to store XML as pureXML(tm).
IBM's biggest competitors are Teradata for Data Warehousing and Oracle. Microsoft's SQL Server and MySQL are serious competitors in the smaller environments.
Editions
IBM's Product Summary page for DB2 allows one to download the various editions after registering. The DB2 Express-c edition is free, and the other editions allow you to have a 90-day free trial.
IBM will send you a free Discovery DVD that contains:
DB2 Express-C 9 (Linux and Windows),
DB2 Developer Workbench (Linux and Windows),
a comparison of all Editions from Express to Enterprise,
webcasts, tutorials, and much more!
Here is a list of some of the major features of several of the DB2 Editions:
1. DB2 9 Express for Linux, Sun Solaris x86, Windows is the ideal entry level data server. Suitable for transaction processing or complex query workloads on servers with up to two processors. (2 processors & 4 Gig RAM) Starting at $4,874 per processor of $165 per user (minimum of 5 users).
1.a. DB2 Express-C is a free version of DB2 Express Edition (DB2 Express) for the community. DB2 Express-C is a no-charge data server for use in development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more. DB2 Express-C can be run on up to 2 dual-core CPU servers, with up to 4 GB of memory, any storage system setup and with no restrictions on database size or any other artificial restrictions. (Linux and Windows)
2. DB2 9 Workgroup for LUW (Linux, Unix, and Windows Includes all of the features of DB2 Express with scalability to larger servers. (4 processors & 16 Gig RAM)
3. DB2 9 Enterprise for LUW - Includes all of the features of DB2 Workgroup plus features required to provide the scalability to handle high user loads and provide 24×7x365 availability. (No restrictions on number of processors or ram). Pricing is by users on CPU (25 minimum) or by number of CPUs.
4. DB2 Data Warehouse Enterprise Edition (DB2 DWE) - can run on LUW (Linux, Unix, and Windows) platforms, and it can be used with a mixed workload (OLTP and datawarehousing) or business intelligence implementations. Pricing starts at $4,874 per processor.
5. DB2 for z/OS - allows for storing of XML and also has improved dynamic warehousing and OLTP capabilities. Pricing starts at $4,450 per month.
6. DB2 Everyplace - features a small footprint relational database and high performance data synchronization solution that enables enterprise applications and data to be securely extended to mobile devices such as personal digital assistants (PDAs), smart phones and other embedded mobile devices.
Related Videos
IBM What Makes You Special DB2 Viper ..
5 min - Aug 30, 2006
IBM video ad highlighting Information On Demand (IOD) value in DB2 v9 Viper release as described by several customers and partners. Includes What Makes You Special ad
IBM DB2 Viper Test Drive - StradaSoft In…
2 min - Nov 17, 2006
IBM DB2 Viper Test Drive Partner Video StradaSoft Inc.
DB2 Viper 2 Overview - Part I
8 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW currently in beta. Part I gives an overview and covers workload management enhancements.
DB2 Viper 2 Overview - Part II
10 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW.
The Key to Optimal Performance of Your DB2 Applications
57 min - Mar 27, 2007
Jim Wankowski, DB2 technology specialist for Quest Software, discusses the performance gains you can achieve in IBM DB2 LUW using Toad for DB2. You will learn a 3-step, best practices approach to workflow: develop, optimize, and validate.
In 1977, Larry Ellison and two of his friends, Bob Miner and Ed Oates, began a company named Software Development Laboratories, and they developed the original Oracle DBMS (Database Management System). They named the product Oracle after a code name project that they had worked on at a company called Ampex. In 1979, Software Development Laboratories was renamed to Relational Software Inc (RSI), and the RSI company was later renamed to Oracle Corporation in 1984.
Major Components of Oracle DBMS
An Oracle consists of a database and an instance.
A database includes all of the physical data files, control files, and redo log files that hold Oracles metadata and your data. Data files hold your actual data and indexes. Redo logs contain records of all changes that have been made. Control files hold important Oracle metadata. Control files contain all the information that instance needs to access a database.
An instance is a combination of the pool of physical memory (RAM) allocated to Oracle and the background processes that Oracle creates to use this memory pool. The RAM is called the SGA (System Global Area). RAM is used to cache data because RAM is about one thousand times faster that disk I/O. Here are the major processes that run in the background:
1. DBWR process that copies data in the RAM to the disk files
2. LGWR records changes applied to data in the redo log for recovery purposes in the event of a problem.
3. PMON Performance Monitor performs cleanup of failed user and server processes.
4. SMON System Monitor performs instance recovery in case server shuts down improperly.
5. CKPT Takes account whenever DBWR writes information from memory to disk.
Versions
The "i" in the version name emphasizes the internet functionality and the "g" emphasizes that the version is "grid-computing" ready.
Date
Version
Features
1979
Oracle V2
SQL queries and joins
1983
Oracle V3
Commit, Rollback, Unix, Rewritten in C
1984
Oracle V4
Read Consistency
1985
Oracle V5
Distributed Queries
1989
Oracle V6
ERP Financials, PL/SQL , row-level locking, hot backups
SQL*Plus - for creating and testing command-line SQL Queries and executing PL/SQL procedural programs. Oracle Developer Suite - for developing database applications including the following developer tools:
Forms Builder - for creating custom user applications
Reports Builder - for creating reports for displaying, printing, and distributing summary data.
Enterprise Manager - for performing database administration tasks such as creating new user accounts and configuring how the DBMS stores and manages data.
Further Study
There is an excellent set of study guide workbooks from Oracle University that you can get by clicking on this link: Oracle University Workbooks
MySQL (pronounced "My Ess Que Ell") is an RDBMS (relational database) that is used in many web applications today. MySQL was originally developed in 1994 by a Swedish consulting firm named TeX. The principal developer was Michael Widenius. He was seeking a database that could be fast, even at the expense of omitting many features that are included in other relational databases. The name of the company is now called MySQL AB, and their website is www.mysql.com
The MySQL software consists of:
MySQL Server (MySQLd) - this is the component that does the work of executing commands against MySQL databases
Administration Utility Programs
Supporting Software
MySQL Server carries out the instructions that you write. For example, if you say CREATE DATABASE, MySQL Server is what carries out those commands. You can send instructions to MySQL Server in many ways, but PHP language is primary way used on most web sites. You talk to the relational database thru Structured Query Language (SQL). MySQL server understands SQL, but PHP does not. PHP is used to create a connection to MySQL server and to send the SQL statements to the server so that they can be executed.
Advantages of MySQL:
It is fast
It is inexpensive (free in most cases)
Easy to use
Tech support is widely available - for example, see www.mysql.com
It can run on a wide variety of operating systems - Windows, Linux, Mac OS, most varieties of Unix(including AIX, DEC Unix, and Solaris), FreeBSD, Irix, OS/2 and more.
It supports large databases (up to a theoretical limit of 8 million terabytes).
It has it's own security system for users and groups of users.
MySQL AB licenses the software in two ways:
Open Source Software - MySQL is available thru the GNU General Public License (GPL) for no charge. If you are using MySQL as a database for a website, it is okay even if you are making money on the web site.
Commercial License - If a developer wants to create a product that uses MySQL and desires to sell that product rather than release it under GPL, the developer needs a commercial license.
You can learn more about MySQL by viewing the following introductory videos:
Meet the MySQL Database - (27 min) - This talk was given at the Hampshire Linux User Group (HantsLUG) meeting on 1st April 2006 at Southampton University.
MySQL Basics -(1 hr.) - California Central Valley Developer and Database Professional Chad Godfirnon gives a demonstration on the basic usage of the popular open source Database application MySQL.
Make the most of MySQL with phpMyAdmin - (Feb. 3/2006 - 70 min) - PhpMyAdmin, the leading web interface to the MySQL database system, is covered in detail by one of its key developers, Marc Delisle.
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.
