SQL Server 2008 for Developers
This course is the ideal course for developers who need to work with a SQL Server database. It will show you how code the SQL statements that developers need for their applications. It shows how to code the SQL statements that developers need for their applications. It shows how to code these statements so they run efficiently. And it shows how to take advantage of the most useful advanced features that SQL Server has to offer.
This course is also a good choice for anyone who wants to learn standard SQL. Since SQL is a standard language for accessing database data, 90% or more of the SQL in the course will work with any database management system. As a result, once you learn to how to use SQL to work with a SQL Server database, you can transfer 90% of what you have learned to another database management system such as Oracle or DB2.
This course is also right you anyone who wants to become a database administrator, although it doesn't present all of the advanced skills that are needed by a top DBA.
Although you will progress through the course more quickly if you have some development experience, everything you need to know about databases and SQL is presented in the course. As a result, you don't need to have any programming background to take the course.
However, if you want to use C# or Visual Basic to write database objects as described in Chapters 20 through 22 of the textbook, you need to have some experience using C# or Visual Basic to write ADO.NET code.
For chapters 1 through 19 of the textbook, you can download all the software you need from Microsoft's web site for free. That includes
Murach's SQL Server 2008 for Developers
Bryan Syverson and Joel Murach
Buy the book from Amazon
Buy the book from Murach