The practical planning textbook case of special computer-driven project practice: SQLServer(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date :2012-08-01 Pages: 393 Publisher: Tsinghua University Press book edge KC10.29 basic information about the title: Practical planning textbook case of special computer-driven project practice: SQL Server databases and applications (SQL Server 2008 Edition) List Price: 42.00 yuan: Shao Pengming Press: Tsinghua University Press Publication Date: August 1. 2012 ISBN: 9.787.302.285.779 words: Page: 393 Edition: 1st Edition Binding: Paperback: Weight: 621 g Editor's Choice practical planning textbook case of special computer-driven project practice: SQL Server databases and applications (SQL Server 2008 Edition) can be used as a vocational college computer science students and universities of applied computer science students textbooks and teaching reference books. and is also suitable for all readers want to learn database technology and SQL Server 2008. Executive summary the practical planning textbook case of special computer-driven project practice: SQL Server databases and applications (SQL Server 2008) uses three databases. the first database system throughout the book the whole story task. The second database independent practice throughout the book the whole story. The third database through the practice of the projects in the book the whole story. Practical planning textbook case of special computer-driven project practice: SQL Server databases and applications (SQL Server 2008 Edition) These three databases as a framework. as a tool and a development platform with SQL Server 2008. a comprehensive exposition of database technology theory and applications. including the use of SQL Server 2008. The book is divided into six topics: issues first. understanding and use of the database. including the understanding of the database. database functions and definitions. use basic SQL query language and SQL the DLL data definition language; subject design database. including the creation of an entity a contact model the entity contact model to the database design conversion and standardization of the table; subject database. including creating databases and tables. create table relationships and referential integrity. use SQL to query the database; topics for database creation objects and procedures. create views. stored procedures. triggers. and user-defined functions. cursors. control structure and affairs; Topic 5 is running and management of the database. including safety management and database maintenance; six topics operation the SSMS achieve database and maintain databases . Understand the database application directory subject knowledge and use of database tasks introduction of an understanding of the database and its applications 1.1 scene 1.2 1.3 to understand the relationship between 1.4 understanding of the concept of a database management system applications and database management systems 1.5 a real understanding of the database 1.6 understanding 1.7 independent practice of database definition 1.7.1 task 1.7.2 install SQL Server 2008 1.7.3 Open SSMS and connect to the database engine 1.7.4 1.7.6 the registered server 1.7.5 registration local server start Database Engine 1.7. 7 1.7.8 Additional Database Connection Object Explorer 1.7.9 using SSMS writing the code task of understanding of SQL 2.1 scene introduced 2.2 Understanding the role of SQL 2.3 query data in a single table 2.3.1 select specific columns from a single table 2.3. select all columns from a single table 2.3.3 using complex criteria query DISTINCT to eliminate duplicates 2.3.4 TOP and PERCENT limit results set 2.3.5 2.4 simple criteria query 2.4.1 Case Study 2.4.2 independent practice independent practice 2.5 2.5.1 AND and OR logical operators 2.5.2AND and OR priority. 2.5.3 Independent Practice 2.6 created 2.7.2 2.7 2.7.1 create a computed column to create a computed column query query query column alias mathematical operators and Th.