书籍详情
DOS实用大全:.0-V6.0
作者:郑甫京,张军编著
出版社:清华大学出版社
出版时间:1994-01-01
ISBN:9787302014805
定价:¥180.00
内容简介
内容简介DOS磁盘操作系统在我国广泛地应用,其最新版本DOS6.0也正在逐步推广。为使用户较快地了解和应用最新版本,作者对原“DOS实用大全”进行了修订,增加了DOS6.0的全部内容。全书共分十八章,系统地介绍了DOS的文件和目录操作、磁盘和内存的管理、数据输入、输出和保护技术以及系统配置和外部设备管理等内容,并详细叙述了行编辑EDLIN、调试程序DEBUG、全屏幕编辑EDIT以及汉字操作系统的各种命令和操作方法。最后两章按字母顺序给出了各版本的所有命令和设备驱动程序的详细解释。全书内容由浅入深,循序渐进,实例丰富。本书可作为操作系统课程的参考教材及各类培训班的DOS教材,也可作为广大计算机用户的参考手册。
作者简介
暂缺《DOS实用大全:.0-V6.0》作者简介
目录
Introduction
Course Materials
Prerequisites
Course Outline
Setup
Microsoft Official Curriculum
Microsoft Certified Professional Program
Facilities
Module 1: SQL Server Overview
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab A: SQL Server Overview
Review
Module 2: Overview of Programming SQL Server
Designing Enterprise Application Architecture
SQL Server Programming Tools
The Transact-SQL Programming Language
Elements of Transact-SQL
Additional Language Elements
Ways to Execute Transact-SQL Statements
Recommended Practices
Lab A: Overview of Transact-SQL
Review
Module 3: Creating and Managing Databases
Creating Databases
Creating Filegroups
Managing Databases
Introduction to Data Structures
Recommended Practices
Lab A: Creating and Managing Databases
Review
Module 4: Creating Data Types and Tables
Creating Data Types
Creating Tables
Generating Column Values
Generating Scripts
Recommended Practices
Lab A: Creating Data Types and Tables
Review
Module 5: Implementing Data Integrity
Types of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use
Recommended Practices
Lab A: Implementing Data Integrity
Review
Module 6: Planning Indexes
Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index
Recommended Practices
Lab A: Determining the Indexes of a Table
Review
Module 7: Creating and Maintaining Indexes
Creating Indexes
Creating Index Options
Maintaining Indexes
Lab A: Creating and Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting UP Indexes Using the Index Tuning Wizard
Performance Considerations
Recommended Practices
Lab B: Viewing Index Statistics
Review
Module 8: Implementing Views
Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views,
Optimizing Performance by Using Views
Recommended Practices
Lab A: Implementing Views
Review
Module 9: Implementing Stored Procedures
Introduction to Stored Procedures
Creating, Executing, Modifying, and Dropping Stored Procedures
Lab A: Creating Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
Performance Considerations
Recommended Practices
Lab B' Creating Stored Procedures Using Parameters
Review
Module 10: Implementing User-defined Functions
What Is a User-defined Function?
Defining User-defined Functions
Examples of User-defined Functions
Recommended Practices
Lab A: Creating User-defined Functions
Review
Module 11: Implementing Triggers
Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations
Recommended Practices
Lab A: Creating Triggers
Review
Module 12: Programming Across Multiple Servers
Introduction to Distributed Queries
Executing an Ad Hoc Query on a Remote Data Source
Setting Up a Linked Server Environment
Executing a Query on a Linked Server
Executing a Stored Procedure on a Linked Server
Managing Distributed Transactions
Modifying Data on a Linked Server
Using Partitioned Views
Recommended Practices
Lab A: Using Distributed Data
Review
Module 13: Optimizing Query Performance
Introduction to the Query Optimizer
Obtaining Execution Plan Information
Using an Index to Cover a Query
Indexing Strategies
Overriding the Query Optimizer
Recommended Practices
Lab A: Optimizing Query Performance
Review
Module 14: Analyzing Queries
Queries That Use the AND Operator
Queries That Use the OR Operator
Lab A: Analyzing Queries That Use the AND and OR Operators
Queries That Use Join Operations
Lab B: Analyzing Queries That Use Different Join Strategies
Recommended Practices
Review
Module 15: Managing Transactions and Locks
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
Recommended Practices
Lab A: Managing Transactions and Locks
Review
Classroom Setup Guide
Classroom Requirements
Classroom Configuration
Setup Instructions
Automated Classroom Setup
Classroom Setup Checklist
Customization Information
Course Materials
Prerequisites
Course Outline
Setup
Microsoft Official Curriculum
Microsoft Certified Professional Program
Facilities
Module 1: SQL Server Overview
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab A: SQL Server Overview
Review
Module 2: Overview of Programming SQL Server
Designing Enterprise Application Architecture
SQL Server Programming Tools
The Transact-SQL Programming Language
Elements of Transact-SQL
Additional Language Elements
Ways to Execute Transact-SQL Statements
Recommended Practices
Lab A: Overview of Transact-SQL
Review
Module 3: Creating and Managing Databases
Creating Databases
Creating Filegroups
Managing Databases
Introduction to Data Structures
Recommended Practices
Lab A: Creating and Managing Databases
Review
Module 4: Creating Data Types and Tables
Creating Data Types
Creating Tables
Generating Column Values
Generating Scripts
Recommended Practices
Lab A: Creating Data Types and Tables
Review
Module 5: Implementing Data Integrity
Types of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use
Recommended Practices
Lab A: Implementing Data Integrity
Review
Module 6: Planning Indexes
Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index
Recommended Practices
Lab A: Determining the Indexes of a Table
Review
Module 7: Creating and Maintaining Indexes
Creating Indexes
Creating Index Options
Maintaining Indexes
Lab A: Creating and Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting UP Indexes Using the Index Tuning Wizard
Performance Considerations
Recommended Practices
Lab B: Viewing Index Statistics
Review
Module 8: Implementing Views
Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views,
Optimizing Performance by Using Views
Recommended Practices
Lab A: Implementing Views
Review
Module 9: Implementing Stored Procedures
Introduction to Stored Procedures
Creating, Executing, Modifying, and Dropping Stored Procedures
Lab A: Creating Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
Performance Considerations
Recommended Practices
Lab B' Creating Stored Procedures Using Parameters
Review
Module 10: Implementing User-defined Functions
What Is a User-defined Function?
Defining User-defined Functions
Examples of User-defined Functions
Recommended Practices
Lab A: Creating User-defined Functions
Review
Module 11: Implementing Triggers
Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations
Recommended Practices
Lab A: Creating Triggers
Review
Module 12: Programming Across Multiple Servers
Introduction to Distributed Queries
Executing an Ad Hoc Query on a Remote Data Source
Setting Up a Linked Server Environment
Executing a Query on a Linked Server
Executing a Stored Procedure on a Linked Server
Managing Distributed Transactions
Modifying Data on a Linked Server
Using Partitioned Views
Recommended Practices
Lab A: Using Distributed Data
Review
Module 13: Optimizing Query Performance
Introduction to the Query Optimizer
Obtaining Execution Plan Information
Using an Index to Cover a Query
Indexing Strategies
Overriding the Query Optimizer
Recommended Practices
Lab A: Optimizing Query Performance
Review
Module 14: Analyzing Queries
Queries That Use the AND Operator
Queries That Use the OR Operator
Lab A: Analyzing Queries That Use the AND and OR Operators
Queries That Use Join Operations
Lab B: Analyzing Queries That Use Different Join Strategies
Recommended Practices
Review
Module 15: Managing Transactions and Locks
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
Recommended Practices
Lab A: Managing Transactions and Locks
Review
Classroom Setup Guide
Classroom Requirements
Classroom Configuration
Setup Instructions
Automated Classroom Setup
Classroom Setup Checklist
Customization Information
猜您喜欢