實(shí)用數(shù)據(jù)庫(kù)技術(shù)

內(nèi)容概要

　　《臨沂大學(xué)優(yōu)秀校本教材：實(shí)用數(shù)據(jù)庫(kù)技術(shù)》內(nèi)容的組織以關(guān)系數(shù)據(jù)庫(kù)理論知識(shí)為基礎(chǔ)，注重操作技能的培養(yǎng)和實(shí)際問(wèn)題的解決，旨在使學(xué)生掌握Microsoft SQL Server 2008的使用和管理。

書籍目錄

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 Server
2005
 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 SELECT
Statement
 3.2 Adding Data with the INSERT Statement
 3.3 Changing What You've Got with the UPDATE
Statement
 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

圖書封面

評(píng)論、評(píng)分、閱讀與下載

---

    實(shí)用數(shù)據(jù)庫(kù)技術(shù) PDF格式下載

---