MS SQL SERVER: Getting Started With Sql Server 2008

MS SQL SERVER: Getting Started With Sql Server 2008

• 1.
  2SQL SERVER: GETTINGSTARTED WITH MICROSFT SQL SERVER 2008
• 2.
  SQL Server 2008 SQL Server (pronounced as ‘Sequel Server’) is a Relational Database Management System (RDBMS) developed by the Microsoft Corporation
• 3.
  TheSQL Server 2008 (Version.No:10), code-named ‘Katmai’ was released on August 2008
• 4.
  The Firstedition of SQL Server (Version.No:1.0) was released in 1989. SQL Server 08 echoes Microsoft’s 19-year long work on the database industryEditions of SQL ServerThe SQL Server is available in many editions, with unique feature sets – targeting different user bases. They are as follows:
• 5.
  What is SQL? SQL Stands for Structured Query Language
• 6.
  SQLis a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra
• 7.
  See http://en.wikipedia.org/wiki/Relational_algebrafor detailson Relational Algebra. For now, remember that Relational Algebra paves a way to represent database query statements mathematicallyAdvantages of SQL Server 2008The SQL Server 2008 has numerous advantages over its predecessors and competitors. The Prominent Turn-ons of SQL Server 08 are as follows:
• 8.
  How to Start?Getstarted with the SQL Server in 15 minutes! Just follow the steps given below:DOWNLOAD AND INSTALLATION: Download the Express edition of the SQL from the link: http://www.microsoft.com/express/sql/download/. Click on ‘Install it now’ to perform installation
• 9.
  How to start?2.When the Installer appears, select the first option: ‘New SQL Server stand-alone installation or add features to an existing instlllation’Proceed with the Installation
• 10.
  How to start?3.Finishthe Server Configuration Window
• 11.
  How to start?4.Finishthe Database engine Configuration WindowClick on ‘Add Current User’ and Click ‘Next’The Rest of the installation should proceed smoothly. Restart the machine after installation (if required)
• 12.
  The SQL RoadmapTheRoad of SQL evolution
• 13.
  Summary2. GETTING STARTEDWITH MICROSFT SQL SERVER 2008An Introduction to SQL
• 14.
  An Introduction toSQL Server 2008
• 15.
  History of SQLServer
• 16.
  Download/Installation
• 17.
  Initial Configurations forSQL Server 2008 : Express
• 18.
  SQL RoadmapEnd
• 19.
  Visit more selfhelp tutorialsPick a tutorial of your choice and browse through it at your own pace.The tutorials section is free, self-guiding and will not involve any additional support.Visit us at www.dataminingtools.net