Beginning Microsoft SQL Server 2012 Programming
Samenvatting
Get the tools to change the way you develop database applications
This step-by-step tutorial will show you how to create more productivemanagement applications and gain business intelligence from your SQLServer database environment.
You'll learn the foundation objects of SQL and basic queries and joins. You'll then add objects to your database and use items that are important to the physical design. Next, you'll explore SQL Server scripting. By the end, you'll have gained the necessary skills to build a world-class database for your world-class application, using the full capabilities of SQL Server 2012.
'Beginning Microsoft SQL Server 2012 Programming':
- Explores the key concepts for developing SQL Server applications, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and the development of Business Intelligence applications
- Walks you through client-connectivity enhancements, security and compliance, and data warehouse performance improvements
- Addresses essential topics including managing keys, writing scripts, and working with stored procedures
- Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services
wrox.com
- Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
- Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
- Read More
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that guides you through all the techniques involved.
Specificaties
Inhoudsopgave
1. RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE?
2. LEARNING THE TOOLS OF THE TRADE
3. THE FOUNDATION STATEMENTS OF T-SQL
4. JOINS
5. CREATING AND ALTERING TABLES
6. KEYS AND CONSTRAINTS
7. ADDING MORE TO YOUR QUERIES
8. BEING NORMAL: NORMALIZATION AND OTHER BASIC DESIGN ISSUES
9. SQL SERVER STORAGE AND INDEX STRUCTURES
10. VIEWS
11. WRITING SCRIPTS AND BATCHES
12. STORED PROCEDURES
13. USER-DEFINED FUNCTIONS
14. TRANSACTIONS AND LOCKS
15. TRIGGERS
16. A BRIEF XML PRIMER
17. BUSINESS INTELLIGENCE FUNDAMENTALS
18. BI STORAGE AND REPORTING RESOURCES
19. REPORTING FOR DUTY, SIR! A LOOK AT REPORTING SERVICES
20. GETTING INTEGRATED WITH INTEGRATION SERVICES
21. PLAYING ADMINISTRATOR
APPENDIX: ANSWERS TO EXERCISES
INDEX
ONLINE APPENDICES
BONUS APPENDIX 1: SYSTEM FUNCTIONS
BONUS APPENDIX 2: VERY SIMPLE CONNECTIVITY EXAMPLES
Anderen die dit boek kochten, kochten ook
Net verschenen
Rubrieken
- aanbestedingsrecht
- aansprakelijkheids- en verzekeringsrecht
- accountancy
- algemeen juridisch
- arbeidsrecht
- bank- en effectenrecht
- bestuursrecht
- bouwrecht
- burgerlijk recht en procesrecht
- europees-internationaal recht
- fiscaal recht
- gezondheidsrecht
- insolventierecht
- intellectuele eigendom en ict-recht
- management
- mens en maatschappij
- milieu- en omgevingsrecht
- notarieel recht
- ondernemingsrecht
- pensioenrecht
- personen- en familierecht
- sociale zekerheidsrecht
- staatsrecht
- strafrecht en criminologie
- vastgoed- en huurrecht
- vreemdelingenrecht