This book takes a developer, and even a DBA, 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. The book focuses on the features within the Express Edition & therefore will not confuse readers with coverage of features found only in the Development Edition.
- 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 & your business.
What you'll learn:
- Learn what features exist within SQL Server 2008 Express Edition and how to install & upgrade the product and set up security;
- Design and create a database;
- Build database objects, such as tables & stored produres, graphically as well as programmatically;
- Work with data_inserting, updating, deleting, and retrieving - using simple & complex queries, programs, and data views;
- Generate reports from data;
- Implement a solid database maintenance strategy that includes backing up & restoring your data when necessary;
- Take advantage of advanced Transact-SQL techniques to get the most out of your data;
- Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner.