Category Archives: Downloads
If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to:
Build and maintain tables
Design a database and communicate with it
Retrieve, analyze, and report data
Build solid, robust database applications
Use the SQL Server Optimizer and Query Designer
Navigate SQL Server with Visual Studio
Develop useful reports with the Report Builder and Report Designer
Create Business Intelligence solutions with Business Intelligence Development Studio
Configure your server and perform major administrative tasks
To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks:
Designing and Using Databases
Interacting With Your Data
Performance Tips and Tricks
Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!
Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.
Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:
Program views, stored applications, triggers, and functions using T-SQL
Work with the new data types, LINQ, and the ADO.NET Entity Framework
Automate common administration and maintenance tasks
Debug databases, reports, and objects using Microsoft Visual Studio® 2008
Write transactional code and implement local and distributed transactions
Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services
Many of the books examples, exercises, and code samples are available for download from the companion Web site.
This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself
Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server.
Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more.
Features updated and new material, including new examples using Microsoft’s AdventureWorks sample database.
SQL Fundamentals, Third Edition, teaches you how to
* Build simple statements to retrieve, store, or modify data
* Craft complex queries that draw information from multiple tables
* Sort and summarize your data just the way you want it
* Create and edit your own tables
* Protect the integrity of your data
* Create more efficient, high-performance queries
* Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
* Use Oracle SQL*Plus and the Oracle Data Dictionary