| Get the guidance you need to start designing databases——one step at a time. with this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server Discover how to: Install and configure SQL Server 2005 Design database conponents with SQL Server Management Studio Apply a three-step modeling approach to design databases that meet business requirements Create, modiry, and manage views Write user-defined functions and stored procedures using T-SQL Add, delete, and update information in your databases Work with data from custom applications and legacy systems Troubleshoot error messages and bandle exceptions |
| The mentors at Solid Quality Learning combine deep technical expertise and realworld implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform. ... .. << 查看详细 |
| introduction acknowledgments part i introduction to database development with microsoft sql server 2005 1 introducing database development with microsoft sql server 2005 the process of storing and managing data intronducing database systems understanding the requirements of a database system defining the architecture of a database application using a monolithic application with data embedded in the application code using a monolithic application with data stored in an external file using a database application with data managed by a batabase server using an application with a generic data access layer using an application with separated presentation,business,and data access layers using a complex application with multiple options for each layer conclusion 2 installing and setting up your microsoft sql server 2005 development environment using a virtual pc operating system rquirements for development of sql server database applications recommended productivity tools using performance monitor using network monitor . using upgrade advisor recommended development tools microsoft sql server 2005 editions microsoft sql server express edition microsoft sql server workgroup edition microsoft sql server standard edition microsoft sql server enterprise edition installing sql server 2005 using the surface area configuration tool conclusion chapter2 quick reference 3 reviewing microsoft sql server 2005 management tools part ii how to create a microsoft sql server 2005 database 4 gathering and understanding business requirements before creating database objects 5 designing a database to solve business needs part iii how to query data from microsoft sql server 2005 6 reading microsoft sql server 2005 data from client applications 7 selecting the data you need 8 creating views to encapsulate queries 9 retrieving data using programmable objects part iv how to modify data in microsoft sql server 2005 10 inserting data in microsoft sql server 2005 11 deleting data from microsoft sql server 2005 12 updating data from microsoft sql server 2005 index |
内容加载中，请稍后...
商品评论（0条）