View the Course
Outline
Our Microsoft SQL Server 2000 training is designed for developers who want to use SQL Server to build robust, scalable database applications
Course includes 60+ hours of total training time...
- 14 modules of training
- Over 20 hours of media run time
- Over 1000 pages of printable courseware
- Step-by-step hands-on-labs
- Sample code
|
| Microsoft SQL Server 2000 |
| Format |
Modules |
Retail Price |
|
CD-ROM
|
14 CD-ROMs
|
$295
|
|
CD-ROM & Books
|
14 CD-ROMs + Printed Books
|
$435
|
|
DVD-ROM
|
2 DVD-ROMs
|
$295
|
|
DVD-ROM & Books
|
2 DVD-ROMs + Printed Books |
$435
|
|
Order
online
|
|
Read
about Mary Chipman & Andy Baron
|
|
|
| Course
Outline(Outlines
are subject to change.) |
|
|
Microsoft SQL Server 2000
|
| Modules |
Run Time |
Pages |
| 14
|
20 hours |
1000 |
|
This course 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. You'll 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. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll also learn how to take advantage of SQL Server's tools for maintaining your databases.
SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. You'll learn how to take advantage of SQL Server's tools for securing and tuning your databases. You'll also learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.
In this course, you will...
- Learn to install and configure Microsoft SQL Server 2000.
- Understand basic database design principles and how to implement them in
SQL Server.
- Learn the fundamentals of writing Transact-SQL queries that retrieve or
modify data.
- Use the programming environment in the Query Analyzer.
- Understand the differences between view, stored procedures, triggers, and
user-defined functions, and know the advantages and drawbacks of each.
- Design and implement reliable backup and maintenance plans.
- Understand the SQL Server security model; and create logins, users and
permissions to protect your data.
- Configure and tune SQL Server, and monitor database activity.
- Use Data Transformation Services (DTS) to import and export data, or to
move it between external data sources, handling data mapping and conversion
when necessary.
- Support distributed users by implementing SQL Server Replication, and
understand which replication options are appropriate for which requirements.
- Publish data to the Web, and take advantage of SQL Server 2000’s rich
support for Extensible Markup Language (XML).
- Use Analysis Services to create online analytical processing (OLAP)
solutions and to mine your data for hidden patterns.
Prerequisites : To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.
|
MODULE 1
SQL Server Tour
- SQL Server Editions
- Graphical Tools
- Exploring the Enterprise Manager
- Working with SQL Server Books Online
Installing SQL Server
- Multiple Instances
- Installing an Instance of SQL Server
- Configuring the Server
Designing and Creating a Database
- Relational Database Design Principles
MODULE 2
Designing and Creating a Database (continued)
Basic Querying
- Introduction to the Query Analyzer
- Retrieving Data
`
MODULE 3
Basic Querying (continued)
Action Queries
- Modifying Data
- Inserting Data
- Updating Data
- Deleting Data
MODULE 4
Using the Query Analyzer
- Query Analyzer Features
- The File Menu Items
- The Edit Menu
- Query Menu Items
- Tools Menu Items
- Window Menu Items
- Help Menu Items
Programming With Transact-SQL
- Overview of Transact-SQL
- Using Built-In Functions
MODULE 5
Programming With Transact-SQL (continued)
- Control of Flow
- Error Handling
Transaction Processing
- Transactions
- Working with Locks
- Monitoring Processes and Locks
- Transaction Isolation
- Blocking and Deadlocks
Creating Views
MODULE 6
Creating Views (continued)
- Creating Views
- Updating Views
Backups and Maintenance
- Creating a Backup Strategy
- Implementing Backups
- Restoring from a Backup
- The Database Maintenance Plan Wizard
Stored Procedures and Triggers
- Building Stored Procedures
MODULE 7
Stored Procedures and Triggers (continued)
- Building Stored Procedures (continued)
- Building Triggers
- Using INSTEAD OF Triggers
User-Defined Functions
- User-Defined Functions in SQL Server 2000
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Functions, Views, and Stored Procedures
MODULE 8
Advanced Queries and Linked Servers
- Dynamic SQL
- Transact-SQL Cursors
- Handling Large Data Sets
- Distributed Queries
Security
- Security Overview
- Authentication
- Understanding Roles
- Assigning Permissions
MODULE 9
Security (continued)
Monitoring, Tuning, and Configuration
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries
- Working with Indexes
- Indexed Views
- Using the Index Tuning Wizard
- Data Caching
- The System Monitor
MODULE 10
Using System Objects
- Exploring System Objects
- DBCC
Automating Administration with SQL Agent
- Configuring SQL Server Agent
- Operators
- Jobs
- Alerts
- Create an Alert
Data Transformation Services (DTS)
- Introduction
- The DTS Import/Export Wizard
MODULE 11
Data Transformation Services (DTS) (continued)
- DTS Packages
- Controlling DTS Workflow
Replication
- Introduction to Replication
- Implementing Replication
Publish SQL Server Data to the Web
- Publishing Data to the Web
- The Web Assistant Wizard
- The SQL Server Web Stored Procedures
- Scheduling Web Jobs
XML Features, Part I
MODULE 12
XML Features, Part I (continued)
- Generating XML from SQL Queries with FOR XML
- Using FOR XML Explicit
- Setting Up IIS for SQL Server
- Accessing SQL Server Using a URL
XML Features, Part II
- Creating XML Views with Annotated Schemas
- Using Xpath to Retrieve SQL Server Data Directly
- Using OpenXML to Work with XML Documents in Transact-SQL
MODULE 13
XML Features, Part II (continued)
Full Text Search
- What is Full-Text Search?
- Configuring Full-Text Search
- Writing Full-Text Queries
- Using Full-Text Search with Documents Stored in SQL Server
MODULE 14
Analysis Services
- Understanding Analysis Services
- Building a Simple Cube
- Browsing Data from a Cube
- Exploring MDX
- Data Mining
English Query
- Overview of English Query
- Before You Start – Preparing Your Database
- Creating and English Query Application
- Deploying an English Query Application
|
|
back to top
|
|
Your
Instructor
|
| Andy Baron and Mary Chipman are co-authors and your instructors. They are both Senior Consultants with MCW Technologies, a Microsoft Certified Solution Provider. Mary and Andy specialize in database application development, training, and writing about SQL Server, Visual Basic, the .NET framework and related technologies. They are Contributing Editors at Advisor Media and at Pinnacle Publishing, contributing writers for SQL Magazine, and frequent speakers at industry conferences. Mary and Andy have both received Microsoft's Most Valuable Professional (MVP) award every year since 1995, based on their contributions to Microsoft's online support newsgroups. They are co-authors of The Access Developer's Guide to SQL Server, published by Sams, and Mary co-authored SQL Server 7.0 in Record Time, published by Sybex.
|
|
back to top
|
|
|
