Beginning SQL Server 2008 Express for Developers

From Novice to Professional
1. Auflage 2008
ISBN: 978-1-4302-1090-0
Verlag: Apress

Buch, Englisch, 536 Seiten, Format (B × H): 191 mm x 234 mm, Gewicht: 907 g

takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to as well as other books within the Apress SQL Server lineup such as .

• Covers using the free Express Edition of SQL Server
• Describes creating a database from scratch and builds on this
• Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business

Zielgruppe

Popular/general

Autoren/Hrsg.

Dewson, Robin

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

1. SQL Server 2008 Express Overview and Installation
2. SQL Server Management Studio Express
3. Database Design and Creation
4. Security
5. Defining Tables
6. Creating Indexes and Database Diagramming
7. Database Backup, Recovery,

8. Database Maintenance
9. Working with the Data – Inserting data
10. Working with the Data – Selecting, updating and deleting

11 Building a View
12. Stored Procedures
13. T-SQL Essentials
14. Advanced T-SQL
15. Triggers
16. Reporting Services

Über Autor(innen)

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.