General Higher Education Eleventh Five-Year national planning materials: practical database technology (2)(Chinese Edition) by LUO YONG SHENG . ZHANG ZHI QIANG . LI JUN

paperback. New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: 2013 02 of Pages: 209 in Publisher: People's Posts and Telecommunications Press regular higher education Eleventh Five-Year national planning materials: the practical database technology (2) mainly to explain the basic concepts of database. SQL. the core content of the database design. database technology. and two practical case teaching management . Books Invoicing main line. these throughout. Book on database design. the more difficult to understand and very practical content. tailor user-friendly case analysis instead of the arcane mathematical expression. exercises directly in the text. easy readers completion of a knowledge point immediately after exercise . Regular higher education Eleventh Five-Year national planning materials: practical database technology (2) can be used as the vocational colleges computer applications. software technology. e-commerce professional textbooks. but also can be used as computer enthusiasts learn database technical reference books. Contents: Chapter 0 Introduction 0.1 What is a Database 0.2 How to learn to Chapter 1 of this course 0.3 learn the meaning of the database relations 1.1.1 entities and attributes in the database infrastructure 1.1 1.1.2 tables. rows. columns Contact 1.2 key 1.3 Table 1.4 relationship the type and size of the field of database management system 1.5 1.6 data specification 1.7 Sort index 1.8 data integrity constraints 1.8.1 Data Integrity 1.8.2 Constraints 1.9 using SQL Server 20081.9.1 install 1.9.2 Books Online 1.9. 3 common operating methods 1.9.5 registered server database Introduction 1.9.7 1.9.6. 1.9.4 tools and services to create a database 1.9.8 the create table 1.9.9 library Separation and additional 1.9.10 create indexes 1.9.11 implementation constraints 1.10 Summary Chapter 2 Structured Query Language (SQL) 2.1 SQL Overview the View the database 2.2.4 Separation database 2.2.5 Additional database 2.3 Definitions and Use Table 2.2 2.2.1 Definition of the definition and use of database database delete database 2.2.3 2.2.2 2.3 .1 definition to modify Table 2.3.2 Table 2.3.3 delete Table 2.3.4 Table 2.4 data initialization Query 2.4.1 single-table queries 2.4.2 nested queries 2.4.3 join queries 2.4.4 2.5 Data Collection Query update 2.5.1 to insert data the 2.5.2 2.5.3 delete. modify data data 2.6 definition. delete and modify the view 2.6.1 custom view 2.6.2 the query view 2.6.3 update view 2.6.4 delete view 2.7 Application 2.8 data controls 2.8 .1 2.9 knowledge to expand 2.10 Summary Chapter 3. stored procedures and triggers 3.1 stored procedure 3.1.1 stored procedure concept 3.1.2 classification of the stored procedure in 3.1.3 to create and execute stored procedures 3.1.4 View 2.8.2 recover permissions authorized 3.1.5 modify the stored procedure stored procedure stored procedure 3.1.6 Rename 3.1.7 delete stored procedure trigger 3.2 Triggers 3.2.1 the concept 3.2.2 create trigger 3.2.4 3.2.3 using triggers to view flip-flop 3.2 .5 modify the trigger 3.2.6 Rename triggers 3.2.7 delete trigger 3.3 Summary Chapter 4 concurrent transaction 4.1 Affairs 4.1.1 affairs of the basic concepts and characteristics 4.1.2 SQL Server transaction execution mode 4.1.3 4.1.5 Transaction Recovery Affairs works 4.1.4 Troubleshooting database system implementation techniques 4.2 concurrency control 4.2.1 Concurrency Control Overview 4.2.2 blockade principle 4.2.3 blockade technology 4.3 Summary Chapter 5 Database Design 5.1 data dependence 5.2 paradigm paradigm 5.2.1 5.2.2 Second Normal Form 5.2.3 Third Normal Form 5.3 Summary 5.4 design process demand analysis of the 5.5 logic design 5.5.1 object named 5.5.2 identify themes 5.5.3 identify fields 5.5.4 key 5.5.5 enumeration list 5.5.6 subset Table 5.5.7 Contact 5.5.8 the identifying Contact 5.5.9 integrity and constraints 5.5.10 5.7 to optimize weight document 5.5.11 Liang configuration standards and process 5.6 physical implementation structure 5.8 6.2 BOM preliminary 6.3 DVD Rental Management 6.4 Book Lending Management the 6.5 online bookselling Management Appendix A Access 2007 Getting Started - Material Requirements Appendix B to deal with complexity 5.9 Summary Chapter 6 curriculum design topics 6.1 gas station liquefied sales of statistics SQL Server to MySQL \ Oracle \ DB2 and other large database Satisfaction guaranteed,or money back.