8840. SQL Server 2012 for Developers
It is fair to say that most developers don't know enough about SQL and the database management system they're using. As one customer put it, "I know just enough about SQL Server to be a little bit dangerous!"
That's why developers often code SQL statements that don't perform as efficiently as they ought to. That's why they aren't able to code some of the queries that they need for their applications. That's why they don't take advantage of all the features that SQL Server has to offer.
And that's why this book should be required reading for every application programmer who uses SQL Server. Beyond that, this is the right first book for anyone who wants to become a database administrator. Of course, if you want to become a DBA, you'll need to continue your study of SQL Server's advanced features after you finish this book...but you'll be well-prepared to go on.
Prerequisites: Everything you need to know about databases and SQL is presented in this book. However, you'll get more out of chapter 20 (BLOBs) and section 5 (on CLR integration) if you have some programming experience with a .NET language like C# or Visual Basic..
SECTION 1 An introduction to SQL
1. An introduction to relational databases and SQL
2. How to use the Management Studio
SECTION 2 The essential SQL skills
3. How to retrieve data from a single table
4. How to retrieve data from two or more tables
5. How to code summary queries
6. How to code subqueries
7. How to insert, update, and delete data
8. How to work with data types
9. How to use functions
SECTION 3 Database design and implementation
10. How to design a database
11. How to create and maintain databases, tables, and sequences with SQL statements
12. How to use the Management Studio for database design
SECTION 4 Advanced SQL skills
13. How to work with views
14. How to code scripts
15. How to code stored procedures, functions, and triggers
16. How to work with cursors
17. How to manage transactions and locking
18. How to manage database security
19. How to work with XML
20. How to work with BLOBs
SECTION 5 CLR integration
21. An introduction to CLR integration
22. How to code CLR stored procedures, functions, and triggers
23. How to code aggregate functions and user-defined types
Appendix A: How to install the required software for this book
Appendix B: How to install the files and databases used in this book
Appendix C: Coding and syntax conventions
System requirements: For chapters 1 through 19, you can download all the software you need from Microsoft's website for free.
That includes :
In appendix A in the book, you'll find complete instructions for installing these items on your PC. And in chapter 2, you'll learn how to use them.
For chapter 20, on BLOBs, you can use an Express Edition of Visual C# or Visual Basic. These products are also available from Microsoft’s web site for free.
However, for chapters 21 through 23, on CLR integration, you’ll need to install:
Like the Express Editions, SSDT is available for free. Unfortunately, the full editions of Visual Studio are not. However, you can download and install a 90-day trial version of these editions from the Microsoft website.
Schedule & Price
Quote for onsite classes