|
Level
1
Microsoft SQL Server 2000 CD-ROMs
Cost Level
1:
$299 + GST
 Set
of 3 CD's
Cost All 3 Levels: $1,350.00 + GST
Set
of 14 CD's
Level 1 is for
developers coming from Microsoft Access, Visual
Basic, Active Server Pages or other development
backgrounds who want to learn to build successful
databases solutions with SQL Server. Even developers
who've already used Oracle, Sybase, DB2 or other
relational database management systems will find
this course useful for getting up to speed on SQL
Server 2000. Learn about the features that are
available in SQL Server; how to design and create a
database; and how to build basic queries using
Transact-SQL, the language of SQL Server. This
introductory course teaches you the fundamentals and
gives you a taste of the potential of Microsoft SQL
Server 2000.
|
|
|
Level 1
SQL Server Tour
- Enterprise Manager, Analysis
Services, Query Analyzer, English Query
- Profiler, XML Support
- Management Tools
- SQL Server Security
- Meta Data Services
- Import and Export
- Data Transformation Services
- Replication
Installation and Configuration
- Versions
- Pre-Requirements
- Multiple Instances
- Install SQL Server
- Setting Up the System Accounts
- Configure the Server
- Memory, Processor, Connections
- Server Settings
- Database Settings
Designing and Implementing a
Database
- Database Design, Normalization
- Beyond Normalization
- Setting Up a Database
- Creating Databases
- Creating, Dropping, and Altering
Tables
- Modifying Tables
- Creating Indexes
- Triggers, Stored Procedures
- Database Diagrams
- Tools for Enforcing Data Integrity
Basic Querying
Understanding SQL
The SELECT Statement
The WHERE Clause
The ORDER BY Clause
The GROUP BY Clause
TOP
Search Conditions
Aggregate Functions
Joining
- Principals of Joining
- Inner Joins
- Outer Joins
- Self Joins
- Subqueries
- Unions
Action Queries
Inserting Data
Updating Data
Deleting Data
The Use of Temporary Tables
Bulk Inserts
|
|
