史蒂芬·弗伊尔斯坦、比尔·普里比尔著、方鑫译的《Oracle PL\SQL程序设计(上下第6版)》基于Oracle数据库12C,从用PL/SQL编程、PL/SQL程序结构、PL/SQL程序数据、PL/SQL中的SQL、构造PL/SQL应用程序、 PL/SQL主题这6个方面详细而系统地讨论了PL/SQL以及如何有效地使用它。本书能够帮助你充分利用PL/SQL来解决数据库开发中遇到的各种问题,引导你掌握各种构建应用的技巧和技术,以便使你编写出高效、可维护的代码。本书不但介绍了大量Oracle数据库12C的PL/SQL新性能,还提供了许多优化PL/SQL性能的新方法。 本书结构清晰,示例丰富,实践性强,适用于Oracle数据库开发人员、Oracle数据库管理员等相关数据库从业人员,也可以作为各大、中专院校相关专业师生的参考用书和相关培训机构的培训教材。
The book readers can easily self-SQL Server 2005 based technology, from database design, build, to test configuration, each one of the steps the reader with practical guidance and help. Through the book, readers can fully experience learning-by-doing the fun the successful creation of a truly personal first SQL Server 2005 database.
Ace your preparation for the skills measured by MCTS Exam 70-431--and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: Install and configure SQL Server 2005 Create tables and indexes, define columns, and implement constraints Implement functions, stored procedures, and triggers by using Transact-SQL Work with relational and XML data Monitor, troubleshoot, and tune queries Maintain database availability with log shipping, database mirroring, and replication Prepare a backup strategy and restore a database PRACTICE TESTS Assess your skills with practice tests with website. You can work through hundreds of questions using multiple testing modes to meet