Page 43 - DCAP508_DATABASE_ADMINISTRATION

Unit 2: Installing SQL Server

SQL Server 2008 graphical tools require VGA or higher resolution: at least 1,024×768 pixel Notes
resolution.

Security is important for every product and every business. By following simple best
practices, you can avoid many security vulnerabilities.

2.7 Keywords

Default Database: The database the user is connected to immediately after logging in to SQL Server.

SQL Server: Microsoft SQL Server is a database management and analysis system for e-commerce,
line-of-business, and data warehousing solutions.
SQL Server Installation Wizard: The SQL Server Installation Wizard is Windows Installer-
based that provides a single feature tree to install all SQL Server components.

2.8 Review Questions

1. Describe the procedure of installing SQL server.
2. State the hardware and software requirements for installing SQL server 2008.

3. Explain the process of installing the Client Tools of Microsoft SQL Server.
4. Discuss the various security concerns associated with sql server installation.

Answers: Self Assessment

1. Windows 2. Various
3. 4.5 4. 6 SP1
5. VGA 6. False
7. True 8. False

9. True 10. True

2.9 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, Tata
McGraw Hill, 3rd Edition.

Silberschatz, Korth, Database System Concepts, McGraw Hill, 5th Edition.

Online links www.sql-tutorial.net/
www.w3schools.com/sql/

www.sqlservertutorials.com/

LOVELY PROFESSIONAL UNIVERSITY 37