|
Supercharge
Your Career Today
Crash Course in SQL Server 2000 is now available on full-motion
CD-ROMs with narration. Learn the fun way! Multimedia training
is far more effective than textbooks. It simulates the real-world
environment for excellent retention. You can replay the
video and audio instructional units as many times as you
need to.
Learn Microsoft SQL Server 2000 with this easy-to-follow
CD-ROM collection from Silico-Magnetic Intelligence. Whether
you are learning Microsoft SQL Server 2000 for the first
time or adding to your professional skills set, you will
find that SMI’s Practical Training via CD-ROM™ contains
thorough, outstanding, well-prepared content that
is second to none:
3 CD-ROMs with Over 7 Hours of Instruction
The instructor is Kalman
Toth, MCDBA, Senior SQL Server Architect. By mastering
one CD-ROM a day, you can become a Microsoft SQL Server
2000 programmer in 3 days. You can also proceed at your
own pace. The introductory CD-ROM course is focused on practical
solutions to real-world database, client and server SQL
programming and administration problems. Full-motion screen
video and rich audio make the subject matter understandable,
and reusable as reference material.
Audience
Software engineers, IT managers and technical project managers
who design, develop, implement and manage Microsoft SQL
Server 2000 (or 7.0 which is very similar) based applications.
MCSE & MCDBA candidates, VB, Java, C++, ASP.NET and
database developers who need to know more about applying
SQL Server 2000 in business environment.
Prerequisites
SQL Server 2000 students must have a solid working knowledge
of the Windows environment, and programming experience in
any computer language. This is the best Microsoft
SQL Server 2000 multimedia crash training currently available
in North America, or anywhere in the World.
Objectives
The CD-ROM based crash course will teach students to setup
tables, populate them with data, change data in tables,
delete rows from tables. Write SQL queries, use transact-SQL
built-in function. Create indexes, stored procedures, views
and triggers. The CD course shows and tells applying live
screen image video and audio, how to install and configure
an SQL Server, create and manage databases and database
devices both in Enterpriser Manager and with scripts in
Query Analyzer, backup and restore SQL databases, import
and export data, understand olap datawarehouse basics and
implement automated tasks. (See full list below.)
About the Trainer
Kalman Toth,
MCDBA, is
an IT professional with over 14 years of database administration
and development experience with SQL server 4.2, 6.5, 7.0
and 2000. In addition Kalman Toth has substantial Sybase
and Oracle experience. His clients include: Citibank, Bank
of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers,
Salomon Brothers, Merrill Lynch, and IBM. He holds an M.Phil.
degree in Computing Science from Columbia University, where
he taught computer science.
Free Bonus: SQL Server 2000 Bible
The book is divided into 6 parts: Preparing to Develop with
SQL Server; Building and Managing Databases with SQL Server;
Managing Data with SQL Server; Implementing Business Rules
with SQL Server; Monitoring and Performance Tuning with
SQL Server; and Advanced Data Transfer and Analysis with
SQL Server. Comprehensive coverage: This Bible covers both
beginning and advanced topics. Topics covered include: installing
and configuring SQL Server; using SQL server's development
tools; securing databases; retrieving data; SQL Server transactions;
working with XML; understanding transact SQL language extensions;
developing stored procedures; tuning queries and indexes;
and developing for English query. Sample database applications:
The book builds on sample database applications to demonstrate
topics/concepts. Sidebars: So as readers can focus on practical
information, the author is using sidebars throughout to
explain the best practices associated with the product and
highlight material. The CD-ROM contains the sample database
applications and code examples in the book; and SQL Server
utilities.
CD-ROM Features
SMI's CD-based training is like training one-on-one with
an expert -- full motion video allows you to see the steps,
hear the explanations, and perform the critical tasks. This
is complete training solution for passing a certification
exam, excelling on an interview and performing well in the
workplace. It is convenient, giving you the freedom to learn
at your own pace, wherever and whenever it suits your schedule.
CD-ROM is easy to use, with streamlined interface featuring
one-click navigation. 100% guaranteed.
|
