SQL for SQL Server, Murach
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
|
Contents |
C# Online.NET Book Review
SQL DDL and DML are required skills for most computer programmers. Yet, sadly, most programmers are not proficient with SQL. Many cannot normalize a a set of tables or even perform a join. This book could remedy that situation.
Before getting into the review, I would like to comment on the Murach paired-page format. I have heard people call it "redundant"; because, the information on the right hand page is a recapitulation of the left-hand side. The fact is that the information on the left-hand page is a written description of the feature, how-to, or topic at hand. The right-hand page normally contains supporting detail, expanded coverage, examples, guidelines, and a bulletized version of the written description. The bulletized version is very handy when you need to refer back to a section you have already read.
Like most Murach books, the majority of paired pages are how-tos, e.g., How to normalize a data structure, How to create an updatable view. The result is that you have the entire topic on view on the two pages facing you where the book is opened. This virtually eliminates the need to flip a page back and forth to correlate two things on different pages. Furthermore, the table of contents becomes a list of categorized how-tos making it very easy to locate the section of interest.
Now, on with the review of Murach's SQL for SQL Server. The book is is a comprehensive reference and professional training manual divided into four sections:
- Introduction to SQL - including Microsoft SQL Server Desktop Engine and SQL Server client tools.
- Essential SQL skills - including joins, queries, subqueries, and updates.
- Database design and implementation - using either SQL DDL or Enterprise Manager.
- Advanced SQL skills - including cursors, stored procedures, and transactions.
The book comprises both basic and advanced tutorials for accomplishing specific hands-on tasks like working with user-defined database roles, managing security, and creating stored procedures. The examples are lucid and easily followed. And, the author succeeds in beginning with simple examples which are further developed and expanded to illustrate more advanced features and practices.
The book includes a CD-ROM containing:
- Microsoft SQL Server 2000 Books Online
- Microsoft SQL Server Desktop Engine (MSDE)
- Microsoft SQL Server Enterprise Evaluation Edition
- Examples from the book including 5 databases
As are most Murach books, this book is a great method of developing your skills from basic through advanced either in a classroom or on your own in front of your computer. Unfortunately, the book covers only up to SQL Server 2000.
Bottom line
Murach's SQL for SQL Server is a pedagogically well-designed set of tutorials designed to take you quickly from the SQL basics through full proficiency.
Other books in this series
- ASP.NET 2.0 Web Programming with CSharp 2005, Murach
- C# 2005, Murach
- SQL for SQL Server, Murach
Publisher's description
If you want to learn SQL, you’ve picked the right book. Unlike most SQL books, this one starts by showing how to use SQL queries to extract and update the data in a database, because that's what every programmer needs to know. Then, the book shows how to design and implement a database, and how to use the server-side features like views, procedures, and transactions. Because its CD includes everything you need for running SQL on your own PC, this book works great whether you want to learn SQL or the specifics of SQL for Microsoft SQL Server.
From the publisher's Web site
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, this 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.
Why learn SQL? First, because most database programmers would be better programmers if they knew more about SQL. Second, because SQL programming is a valuable specialty in itself. And third, because knowing SQL is the first step toward becoming a database administrator. In short, knowing SQL makes you more valuable on the job.
What you’ll learn in this book
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. At that point, you’ll be able to run SQL statements on your own PC, and 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 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. Once you master these features, you’ll have all the SQL skills you’ll ever need for database programming.
3 reasons why you’ll learn faster with this book
First, unlike most SQL books, this one starts by showing you how to query an existing database. Why? Because that’s what you’re most likely to do first on the job. Once you master those skills, the book teaches you how to design and implement a database...whenever you need to do that. Or, you can learn how to work with other database features like views and stored procedures...whenever you need to do that.
Second, like all our books, this one includes hundreds of examples that range from the simple to the complex. That way, you can quickly get the idea of how a feature works from the simple examples, but you’ll also see how the feature is used in real-world examples.
Third, like all the books in the Murach series, all of the information is presented in "paired pages," with the essential syntax, guidelines, and examples on the right page and the perspective and extra explanation on the left page. This helps you learn faster by reading less...and this is the ideal reference format when you need to refresh your memory about how to do something later on.
With features like those, this is the book you’ll want on your desk whenever you’re using SQL. And if you’re a programmer, this book is the ideal companion for our Visual Basic and Java books.
