Possible Career Investment
SQL Server 2008 Programming training is now available on
7 full-motion video CD-ROMs with narration. Learn SQL Server
2008 programming the fun way! Multimedia training is far
more effective than boring hard-to-follow textbooks. It
simulates the real-world environment for excellent memory
retention. Learn from your own computer at a pace that suits
you. You can replay the video and audio instructional units
as many times as you need to. Save big over expensive classroom
training. Learn the new
programming features of SQL Server 2008 from SQLUSA, The World
Leader in SQL Server Training.
Master Microsoft SQL Server 2008
Design, and Programming are all included in this easy-to-learn
video/audio CD-ROM collection from Silico-Magnetic Intelligence.
Whether you are learning SQL Server 2008 Programming for
the first time or adding to your professional skills set,
you will find that SMI’s Practical Training via full-motion
video CD-ROM™ contains thorough, outstanding, well-prepared
content that is second to none. Like training one-on-one
with an experienced database professional, each unit is
presented in full-motion screen image video allowing you
to see the steps and hear the explanations.
Instructions by a Top SQL Expert
The instructor is Kalman
Toth, MCDBA/MCITP, Senior SQL Server 2000/2005/2008
Architect. By mastering one CD-ROM a day, you can become
a Microsoft SQL Server 2008 developer in 7 days. Naturally,
you can also proceed at your own pace, be it 21 days or 8
weeks. The comprehensive CD-ROM course is focused on practical
solutions to real-world database, client and server design
and programming problems. Full-motion screen video
and rich audio make the subject matter understandable, and
reusable as reference material in the future.
Audience for SQL Server 2008 Programming
C#, VB, .Net, Cold Fusion, Web, Java, C++ and database developers,
systems analysts, and software engineers who need to know
more about database design and programming of SQL Server 2008.
Prerequisites for SQL Server 2008
SQL Server 2008 learners must have a solid working knowledge
of the Windows environment, and any programming experience
is a huge plus. This is the most extensive, practical and
the best Microsoft SQL Server Programming multimedia
training currently available in North America, or anywhere
in the world.
Objective: Excellence in SQL Server
The CD-ROM based course will allow learners to design, create and manage database objects, use the SELECT statement, insert/update/delete data, and program in Transact-SQL. There is strong emphasis on practical applications and real life examples. Familiarize with SQL Server sample databases: pubs, Northwind, AdventureWorks, AdventureWorks2008 and AdventureWorksDW2008. Discover the most important principles of relational database design: logical and physical data modeling, primary keys and foreign keys and 3NF design guidelines. Explore inner join, left join, right join, self join and cross join. Learn about the all important GROUP BY clause and aggregate functions like sum, avg and count. Investigate ways to create sophisticated crosstab (matrix) reports with single or multi-dimension. Learn how to modify data in the database with insert, update and delete statements. Work with the new MERGE statement which does a combination of insert, update and delete in a single statement. Understand data integrity checks: entity, domain and referential integrity enforcement. Learn about business rules enforcement in the enterprise. Explore stored procedure, user-defined function, view and trigger design. Create structure SQL queries with Common Table Expressions (CTEs). Work with T-SQL transactions, locks, isolation levels and deadlocks. Master debugging T-SQL scripts, stored procedures, triggers and functions (UDFs). Explore query optimization using the Database Engine Tuning Advisor and the visual query execution plan tool. (See full
About the Industry Expert Trainer
a designer of over 60 databases worldwide with 17 years
of database/BI administration and development experience on
SQL server 4.2, 6.5, 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008
and Sybase. His clients include: Citibank, Bank of Sweden,
Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers,
Merrill Lynch, Reuters, IBM and major ecommerce website companies.
He holds an M.Phil. degrees in Physics and Computing Science from Columbia
University, where he taught Computer Science courses.
Bonus Book: Beginning SQL Server 2008 for Developers: From Novice to Professional
By author and developer Robin Dewson, 496 pages. Learn to use Transact–SQL, a full–blown procedural language that is built right into the database system. Transact–SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact–SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having to move data back and forth across the network.
What you’ll learn:
Install and manage SQL Server on your system.
Create and secure tables.
Store and query data; use indexes to improve query performance.
Run procedural code inside your database in the form of Transact–SQL procedures and triggers.
Serve up business reports to in–house users and outside business partners via SQL Server 2008 Reporting Services.
7 CD-ROMs Equivalent to 3 Years
of Job Experience
SMI's CD-based SQL Server 2008 training is like training
one-on-one with an international SQL/BI industry expert -- full
motion screen video allows you to see the steps, hear the
explanations, and perform the critical tasks. This is complete
training solution for passing related certification exams,
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.