Murach's SQL for SQL Server - Softcover

Bryan Syverson

Softcover

ISBN 10: 1890774162 ISBN 13: 9781890774165

Publisher: Mike Murach & Associates Inc, 2002

Synopsis

Provides an introduction to SQL and relational databases, explains how to write SQL queries, discusses database design and implementation using SQL DDL statements or the Enterprise Manager, and covers advanced SQL skills.

About this title

From the Publisher

To be an effective database programmer, you need to master SQL for the database you’re going to be using. So this is first a book for programmers who use Microsoft SQL Server. However, but it is also a great book for anyone who wants to learn standard SQL, because its CD includes everything you need for running SQL on your own PC.

In section 1, you’ll learn the concepts and terms you need for working with any database. You’ll also learn how to use the Microsoft SQL Server 2000 Desktop Engine (MSDE) and the client tools for SQL Server 2000 that come on the CD. Then, you’ll be able to run SQL statements on your own PC. At that point, you’ll be prepared for rapid progress as you learn SQL.

In section 2, you’ll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won’t have any trouble if you’re a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you do have SQL experience.

In section 3, you’ll learn how to design a database and how to implement that design by using either SQL DDL (Data Definition Language) statements or the Enterprise Manager that comes with SQL Server. When you’re done, you’ll be able to design and implement your own databases. But even if you’re never called upon to do that, this section will give you perspective that will make you a better SQL programmer.

To complete your SQL skills, section 4 presents the skills for working with database features like views, stored procedures, functions, triggers, cursors, and transactions. These are the features that give a database management system much of its power. So once you master them, you’ll have a powerful set of SQL skills.

From the Author

Like most other programmers, I first learned SQL almost by accident, not realizing all that I was missing. That's why I think of this as the SQL book that you didn't know you needed. And my goal has been to make it the perfect book for three different types of SQL users.

First, if you're an application programmer, this book helps you improve your queries and teaches you the advanced SQL skills that you won't learn on your own. Second, if you're a SQL programmer (or want to be one), this book lets you quickly learn the basics, then move on to the SQL Server and database design skills that turn you into a top professional. Third, if you're developing a complete database application on your own, this book gives you all the information you need to design, implement, and maintain it.

In my career, I've worked with SQL at all three levels. And I've found Murach's "paired pages" format to be the perfect way to deliver the concise explanations, realistic examples, and quick reference material that I know you'll use on the job.

Edition details

• Publisher: Mike Murach & Associates Inc
• Publication date: 2002
• ISBN 10: 1890774162
• ISBN 13: 9781890774165
• Binding: Paperback
• Language: English
• Number of pages: 570