Teach Yourself Microsoft SQL Server 2005 Express In 24 Hours

Many excellent books about SQL Server 2005 Express are available, so how is this one different? In talking to the many people I meet in my travels around the country, I have heard one common complaint. Instead of the host of wonderful books available to expert Database Administrators (DBAs), my students yearn for a book targeted toward the beginning-to-intermediate DBA or developer. They yearn for a book that starts at the beginning, ensures that they have no gaps in their knowledge, and takes them through some of the more advanced aspects of SQL Server 2005 Express. Along the way, they want to acquire volumes of practical knowledge that they can easily port into their own applications. I wrote Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours with those requests in mind.

This book begins by providing you with an introduction to basic relational database design. It is mandatory that you understand database design principals before moving on to the other hours, so this hour is a must. During the hour you'll get a summary of all the components that we will be covering through the remainder of the book.

Hour 2 teaches you the basics of working with SQL Server Express. You learn about the versions of SQL Server 2005 available. You then learn how to set up SQL Server Express and how to get started with SQL Server Management Studio Express.

Hour 3 is one of the most important hours. During hour three you learn the ins and outs of working with SQL Server Management Studio. It is in this tool that you will be spending most of your time. During this hour you will also learn how to create a new SQL Server database.

Hours 4 through 20 cover tables, relationships, views, and stored procedures. These objects are at the heart of every SQL Server database. During hour 4 you learn how to work with tables. Then you move on to hour 5 where you learn how to work with table relationships.

Knowledge of the T-SQL language is an important aspect of SQL Server 2005 Express. Probably the most used keyword used in T-SQL is SELECT. Hour 6 delves into the SELECT statement in quite a bit of detail. Hour 7 expands on hour 6 by showing you how you can build T-SQL statements based on data from multiple tables. Not only can you use T-SQL to retrieve data, you can also use it to modify data. Hour 8 shows you how to modify data with action queries. Hour 9 introduces you to many of the built-in T-SQL functions such as DataAdd, DateDiff, and Upper. These built-in functions prove invaluable for building database applications.

Another important SQL Server 2005 Express object is the view. Hour 10 shows you how to build and work with views. During hour 10 the topics become more and more complex until you move to Hour 11, "More About Views." Hour 11 covers topics such as subqueries, outer joins, and using views to secure data.

Hours 12, 13, and 14 show you how to use T-SQL to design SQL Server stored procedures. You learn topics such as the basics, how to control the flow, the use of built-in functions, updating data, and transaction handling. Hour 15 teaches you about ADO.NET. Armed with the basics of ADO.NET, you are ready to design your stored procedures in Visual Basic .NET or C#. Hours 16 through 19 show you how to build your stored procedures in Visual Basic .NET and C# respectively. During the hour you'll learn why you may decide to take advantage of this new technology.

Without the ability to effectively debug, almost any programmer will be lost. Hour 20 covers the powerful debugger available when building stored procedures in Visual Basic .NET or C#.

The last three hours cover security and administration. You learn about SQL Server authentication and permissions validation and how you can take advantage of both to properly secure your databases. You'll also learn how to configure, maintain, and tune the SQL Servers that you manage. Without proper care, even the fastest hardware could run a database that is abysmally slow!

Finally, several of the chapters in the book use a database called NorthWind. Appendix A includes the steps necessary to attach to the NorthWind database so that you can follow along with those chapters.

SQL Server 2005 Express is powerful and exciting. With the keys to deliver all that it offers, you can produce applications that provide much satisfaction as well as many financial rewards. After poring over this hands-on guide and keeping it nearby for handy reference, you too can become masterful at working with SQL Server 2005 Express. This book is dedicated to demonstrating how you can fulfill the promise of making SQL Server 2005 Express perform up to its lofty capabilities. As you will see, you have the ability to really make SQL Server 2005 Express shine in the everyday world!

Download
http://rapidshare.com/files/121731264/Teach_Yourself_Microsoft_SQL_Server_2005_Express_In_24_Hours__2006_.chm

or
http://tinyurl.com/67tbja