9787113124830 (textbook) SQL Server application technology(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date :2011-05-01 Pages: 250 Publisher: China Railway Press Title: (textbook) SQL Server Applied Technology List Price: 26.00 yuan Author: Wei Pengcheng Wang Lu. Wu Haixia editor Press: China Railway Publishing Society Publication Date :2011-5-1ISBN: 9787113124830 Words: 392.000 yards: 250 Edition: 1 Binding: Paperback: 16 Weight: Editor's Summary book throughout a large database project - OnlineCS. and then the The project is broken down into a number of sub-projects. each sub-project is divided into different tasks to illustrate the concept and operation of the database. The book is divided into 11 projects: Project 1 SQLServer2005 database management system installation. project 2 database creation and management. the creation and management of the table in item 3. item 4 of the table data operation. item 5 data query implementation project view index and cursor operations. Item 7 of the stored procedures and triggers operation. item 8. system security management. item 9 database maintenance. item 10 of the transaction. lock. the project 110nlineCS database management system to achieve. Book keep up with the curriculum reform teaching model. focusing on the combination of theory and practice. the use of project-driven teaching mode. by project and task decomposition. to illustrate the concepts and knowledge of the database; Deep and all knowledge. and with the expansion of training can be enhance the reader's understanding of the knowledge and operation. This book is suitable as the various types of vocational colleges course materials or teaching reference books. are also available for students to use self-study and database enthusiasts. Directory Project SQL Server 2005 database management system installation tasks: installing SQL Server 2005 project database creation and management tasks: of online elective system OnlineCS database created task: OnlineCS database modify and delete items table creation and Management Task 1 Create Table task: for 0nlineCS database creation and management tasks: Constraint 3: OnlineCS database table modify and delete items 4 table data manipulation tasks: the interface operation Student table data tasks: T-SQL statements to manipulate Student table Item 5 of the realization of the task of data query: single-table queries OnlineCS database Task 2: OnlineCS database connection Query Task 3: OnlineCS database the nested query tasks: OnlineCS database combined query task : realize T-SQL OnlineCS database visualization operation projects view. index and cursor manipulation tasks: established in OnlineCS database query students elective courses information view tasks: indexing OnlineCS database tasks: OnlineCS to create cursors project database 7 stored procedures and triggers operation Task 1: stored procedures to create and perform tasks: create trigger project system security management tasks: create the server login account task 2: for 0nlineCS database to add the role item 9 database maintenance tasks: the backup OnlineCS database task: 10 affairs export OnlineCS database project. locks Task 1: Create a task into the student information records Affairs: roll back the transaction tasks: manufactured for 0nlineCS database tasks the deadlock Project 11 OnlineCS database management realization Task 1: database design tasks: database application systems design references of introduction Digest preambleFour Satisfaction guaranteed,or money back.…