Book description
Beginning SQL Server 2008 Express for Developers: From Novice to Professional 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 Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.
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
Table of contents
- Copyright
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- 1. SQL Server 2008 Express Overview and Installation
- 2. SQL Server Management Studio Express
-
3. Database Design and Creation
- 3.1. Defining a Database
- 3.2. Prebuilt Databases Within SSE
- 3.3. Choosing the Database System Type
- 3.4. Gathering the Data
- 3.5. Determining the Information to Store in the Database
- 3.6. External and Ignored Information
- 3.7. Building Relationships
- 3.8. Normalization
- 3.9. Creating the Sample Database
- 3.10. Summary
- 4. Security and Compliance
-
5. Defining Tables
- 5.1. What Is a Table?
-
5.2. SQL Server Data Types
-
5.2.1. Table Data Types
- 5.2.1.1. char
- 5.2.1.2. nchar
- 5.2.1.3. varchar
- 5.2.1.4. nvarchar
- 5.2.1.5. text
- 5.2.1.6. ntext
- 5.2.1.7. image
- 5.2.1.8. int
- 5.2.1.9. bigint
- 5.2.1.10. smallint
- 5.2.1.11. tinyint
- 5.2.1.12. decimal/numeric
- 5.2.1.13. float
- 5.2.1.14. real
- 5.2.1.15. money
- 5.2.1.16. smallmoney
- 5.2.1.17. date
- 5.2.1.18. datetime
- 5.2.1.19. datetime2
- 5.2.1.20. smalldatetime
- 5.2.1.21. datetimeoffset
- 5.2.1.22. time
- 5.2.1.23. hierarchyid
- 5.2.1.24. Geometry
- 5.2.1.25. Geography
- 5.2.1.26. rowversion
- 5.2.1.27. uniqueidentifier
- 5.2.1.28. binary
- 5.2.1.29. varbinary
- 5.2.1.30. bit
- 5.2.1.31. xml
- 5.2.2. Program Data Types
-
5.2.1. Table Data Types
- 5.3. Columns As More Than Simple Data Repositories
- 5.4. Creating a Table in SQL Server Management Studio Express
- 5.5. Creating a Table Through Query Editor
- 5.6. Creating a Table Using a Template
- 5.7. Creating and Altering a Template
- 5.8. Altering a Table
- 5.9. Creating the Remaining Tables
- 5.10. Setting a Primary Key
- 5.11. Creating a Relationship
- 5.12. Building a Relationship via T-SQL
- 5.13. Summary
-
6. Creating Indexes and Database Diagramming
- 6.1. What Is an Index?
- 6.2. Determining What Makes a Good Index
- 6.3. Determining What Makes a Bad Index
- 6.4. Reviewing Your Indexes for Performance
- 6.5. Creating an Index
- 6.6. The CREATE INDEX Syntax
- 6.7. Dropping an Index
- 6.8. Altering an Index in Query Editor
- 6.9. When an Index Does Not Exist
- 6.10. Diagramming the Database
- 6.11. The SQL Server Express Database Diagram Tool
- 6.12. Summary
- 7. Database Backup and Recovery
- 8. Inserting Data and Transactions
-
9. Selecting, Updating, and Deleting Data
- 9.1. Retrieving Data
- 9.2. Using SSMSE to Retrieve Data
- 9.3. The SELECT Statement
- 9.4. Naming the Columns
- 9.5. First Searches
- 9.6. Varying the Output Display
- 9.7. Limiting a Search: The Use of WHERE
- 9.8. String Functions
- 9.9. Order! Order!
- 9.10. The LIKE Operator
- 9.11. Creating Data: SELECT INTO
- 9.12. Who Can Add, Delete, and Select Data?
- 9.13. Updating Data
- 9.14. Using Transactions
- 9.15. Deleting Data
- 9.16. Truncating a Table
- 9.17. Dropping a Table
- 9.18. Summary
-
10. Building a View
- 10.1. Why a View?
- 10.2. Using Views for Security
- 10.3. Encrypting View Definitions
- 10.4. Creating a View Using SSMSE
- 10.5. Creating a View Using a View
- 10.6. Creating a View Using CREATE VIEW Syntax
- 10.7. Creating a View Using a Query Editor Pane
- 10.8. Creating a View Using SCHEMABINDING
- 10.9. Indexing a View
- 10.10. Summary
- 11. Stored Procedures and Functions
-
12. T-SQL Essentials
- 12.1. Using More Than One Table
- 12.2. Variables
- 12.3. Temporary Tables
- 12.4. Aggregations
- 12.5. Grouping Data
- 12.6. HAVING
- 12.7. Distinct Values
- 12.8. Functions
- 12.9. RAISERROR
- 12.10. Error Handling
- 12.11. @@ERROR
- 12.12. TRY...CATCH
- 12.13. Summary
- 13. Advanced T-SQL
-
14. Triggers
- 14.1. What Is a Trigger?
- 14.2. The DML Trigger
- 14.3. CREATE TRIGGER Syntax for DML Triggers
- 14.4. Why Not Use a Constraint?
- 14.5. Deleted and Inserted Logical Tables
- 14.6. Creating a DML Trigger
- 14.7. Checking Specific Columns
- 14.8. DDL Triggers
- 14.9. Dropping a DDL Trigger
- 14.10. EVENTDATA()
- 14.11. Summary
- 15. SQL Server 2008 Reporting Services
Product information
- Title: Beginning SQL Server 2008 Express for Developers: From Novice to Professional
- Author(s):
- Release date: November 2008
- Publisher(s): Apress
- ISBN: 9781430210900
You might also like
book
Microsoft® SQL Server™ 2005 Administrator's Companion
Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of …
book
Programming Microsoft® SQL Server® 2012
Your essential guide to key programming features in Microsoft SQL Server 2012 Take your database programming …
book
Beginning Microsoft® SQL Server® 2012 Programming
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server …
book
Accelerated C# 2010
C# 2010 offers powerful new features, and this book is the fastest path to mastering them—and …