|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Implementation - Level 1 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 What is a Database?
1.2 Goals of a Database
1.3 Relational Databases
1.4 Relational Algebra
1.5 Operators
1.6 Relational Database Management System
1.7 Terms
1.8 Codd's Twelve Rules
2.0 Database Normalization (12 min)
2.1 The Process of Normalization
3.0 Overview of Features in SQL (21 min)
3.1 What is SQL Server?
3.2 Why Use SQL Server
3.3 Transact-SQL
3.4 Stored Procedures
3.5 Triggers
3.6 Security
3.7 Capacities
3.8 Connectivity
3.9 Additional Tools in SQL Server
3.10 SQL Versions & Requirements
4.0 Creating an SQL Server Database (39 min)
4.1 Creating databases
4.2 Transaction logs
4.3 Using file groups
4.4 Database Growth
4.5 Capacity planning
5.0 Creating Tables (44 min)
5.1 SQL Server field types
5.2 Creating tables
5.3 Creating defaults
5.4 Adding data to tables
Implementing SQL 7 Level 1 (2 Hours 20 Minutes)
1.0 Relational Database Design (23 min)1.1 What is a Database?
1.2 Goals of a Database
1.3 Relational Databases
1.4 Relational Algebra
1.5 Operators
1.6 Relational Database Management System
1.7 Terms
1.8 Codd's Twelve Rules
2.0 Database Normalization (12 min)
2.1 The Process of Normalization
3.0 Overview of Features in SQL (21 min)
3.1 What is SQL Server?
3.2 Why Use SQL Server
3.3 Transact-SQL
3.4 Stored Procedures
3.5 Triggers
3.6 Security
3.7 Capacities
3.8 Connectivity
3.9 Additional Tools in SQL Server
3.10 SQL Versions & Requirements
4.0 Creating an SQL Server Database (39 min)
4.1 Creating databases
4.2 Transaction logs
4.3 Using file groups
4.4 Database Growth
4.5 Capacity planning
5.0 Creating Tables (44 min)
5.1 SQL Server field types
5.2 Creating tables
5.3 Creating defaults
5.4 Adding data to tables
|
|
SQL Server 7 0 Implementation - Level 1
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
