编辑推荐
 ; ; ; ; 王振海主编的《实用数据库技术(临沂大学优秀校本教材)》既重视对国内外该课程领域经典的基本理论问题进行透彻的解析,又对当前教育所面临的新现象、新理论、新方法给予必要的回应;既考虑如何有利于教师的课堂教学与辅导,又兼顾如何有助于学生的课后复习和思考;既能反映我校特色和课程体系改革的基本方向,又要展示我校教材建设及学术研究的**成果,适应我校创建精品课程、优质课程和品牌课程的实际需要。
 ;
内容简介
暂无
作者简介
暂无
目录
Introduction to SQL Server 2005
Unit ; ; What Makes Up a SQL Server Database?
 ; 1.1 ; An Overview of Database Obiects
 ; 1.2 ; The Database Object
 ; 1.3 ; SOL Server Identifie ; for Objects
 ; Summary
 ; Exercises
Unit 2 ; How to Use Tools of SQL Server
 ; 2.1 ; Creating a Database in Microsoft SQL Server2005
 ; 2.2 ; The Query Editor
 ; 2.3 ; Entering a SQL Query or Statement
 ; 2.4 ; The Scripts of SQL Server2005 load.sql
 ; Review Questio ;
 ; Exercises
 ; Uint 3 ; The Foundation Statements of T-SQL
 ; 3.1 ; Getting Started with a Basic SELECTStatement
 ; 3.2 ; Adding Data with the INSERT Statement
 ; 3.3 ; Changing What Youve Got with the UPDATEStatement
 ; 3.4 ; The DELETE Statement
 ; Summary
 ; Review Questio ;
 ; Exercise
Unit 4 ; Joi
 ; 4.1 INNER JOIN
 ; 4.2 The OUTER JOIN
 ; 4.3 ; CROSS JOINs
 ; Summary
 ; Review Questio ;
 ; Exercises
Unit 5 ; Subquery
 ; 5.1 ; What Is a Subquery? ;
 ; 5.2 ; Introducing Set Operatio ;
 ; Summary
 ; Review Questio ;
 ; Exereises
Unit 6 ; Creating and Altering Tables
 ; 6.1 ; Object Names in SQL Server
 ; 6.2 ; ; ; CREATE DATABASE ; ;
 ; 6.3 ; Data Types in SQL Server 2005
 ; 6.4 ; Creating a Table
 ; 6.5 ; The ALTER TABLE Command
 ; Summary
 ; Review Questio ;
 ; Exereises
Unit 7 ; Functio
 ; 7.1 ; Aggregate Functio ;
 ; 7.2 ; Row-Level Functio ;
 ; 7.3 ; Other Functio ;
 ; Summary
 ; Review Questio ;
 ; Exercises
Unit 8 ; Indexes and Co traints on Tables
 ; 8.1 ; Indexes
 ; 8.2 ; How Data Is Accessed in SQL Server I
8.3 CREATE INDEX
8.4 Co traints
Summary
Review Questio
Exercises
Unit 9 Views
9.1 Creating views
9.2 Using views
Summary
Review Questio
Exercises
Unit 10 Programming Basics and Stored Procedures
10.1 Declaring Variables
10.2 Control-of Flow Statements
10.3 Stored Procedures
Summary
Exercises
Unit 11 Trigge
11.1 What Is a Trigger?
11.2 Using Trigge
11.3 Dropping Trigge
Summary
Exercises
Unit 12 User Defined Functio
12.1 What a UDF Is
12.2 Using UDF
Summary
Unit 13 Tra actio
13.1 What is a Tra action?
13.2 Tra actio
Summary
Exercises
References
实用数据库技术 pdf下载声明
本pdf资料下载仅供个人学习和研究使用,不能用于商业用途,请在下载后24小时内删除。如果喜欢,请购买正版