临沂大学优秀校本教材:实用数据库技术
目 录内容简介
君子务本,本立而道生——《临沂大学优秀校本教材》总序 韩延明
Introduction to SQL Server
Unit 1 What Makes Up a SQL Server Database?
1.1 An Overview of Database Obiects
1.2 The Database Object
1.3 SQL Server Identifiers for Objects
Summary
Exercises
Unit 2 How to Use Tools of SQL Serv…
查看完整
Introduction to SQL Server
Unit 1 What Makes Up a SQL Server Database?
1.1 An Overview of Database Obiects
1.2 The Database Object
1.3 SQL Server Identifiers for Objects
Summary
Exercises
Unit 2 How to Use Tools of SQL Serv…
查看完整
目 录内容简介
《临沂大学优秀校本教材:实用数据库技术》内容的组织以关系数据库理论知识为基础,注重操作技能的培养和实际问题的解决,旨在使学生掌握Microsoft SQL Server 2008的使用和管理。
目 录内容简介
君子务本,本立而道生——《临沂大学优秀校本教材》总序 韩延明
Introduction to SQL Server
Unit 1 What Makes Up a SQL Server Database?
1.1 An Overview of Database Obiects
1.2 The Database Object
1.3 SQL Server Identifiers for Objects
Summary
Exercises
Unit 2 How to Use Tools of SQL Server
2.1 Creating a Database in Microsoft SQL Server
2.2 The Query Editor
2.3 Entering a SQL Query or Statement
2.4 The Scripts of SQL Server2005_load. sql
Review Questions
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 Questions
Exercise
Unit 4 Joins
4.1 INNER JOIN
4.2 The OUTER JOIN
4.3 CROSS JOINs
Summary
Review Questions
Exercises
Unit 5 Subquery
5.1 What Is a Subquery?
5.2 Introducing Set Operations
Summary
Review Questions
Exercises
Unit 6 Creating and Altering Tables
6.1 Object Names in SQL Server
6.2 CREATE DATABASE
6.3 Data Types in SQL Server
6.4 Creating a Table
6.5 The ALTER TABLE Command
Summary
Review Questions
Exercises
Unit 7 Functions
Unit 8 Indexes and Constraints on Tables
Unit 9 Views
Unit 10 Programming Basics and Stored Procedures
Unit 11 Triggers
Unit 12 User Defined Functions
Unit 13 Transactions
Summary
Exercises
References
^ 收 起
Introduction to SQL Server
Unit 1 What Makes Up a SQL Server Database?
1.1 An Overview of Database Obiects
1.2 The Database Object
1.3 SQL Server Identifiers for Objects
Summary
Exercises
Unit 2 How to Use Tools of SQL Server
2.1 Creating a Database in Microsoft SQL Server
2.2 The Query Editor
2.3 Entering a SQL Query or Statement
2.4 The Scripts of SQL Server2005_load. sql
Review Questions
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 Questions
Exercise
Unit 4 Joins
4.1 INNER JOIN
4.2 The OUTER JOIN
4.3 CROSS JOINs
Summary
Review Questions
Exercises
Unit 5 Subquery
5.1 What Is a Subquery?
5.2 Introducing Set Operations
Summary
Review Questions
Exercises
Unit 6 Creating and Altering Tables
6.1 Object Names in SQL Server
6.2 CREATE DATABASE
6.3 Data Types in SQL Server
6.4 Creating a Table
6.5 The ALTER TABLE Command
Summary
Review Questions
Exercises
Unit 7 Functions
Unit 8 Indexes and Constraints on Tables
Unit 9 Views
Unit 10 Programming Basics and Stored Procedures
Unit 11 Triggers
Unit 12 User Defined Functions
Unit 13 Transactions
Summary
Exercises
References
^ 收 起
目 录内容简介
《临沂大学优秀校本教材:实用数据库技术》内容的组织以关系数据库理论知识为基础,注重操作技能的培养和实际问题的解决,旨在使学生掌握Microsoft SQL Server 2008的使用和管理。
比价列表价格走势