Software Details
Media: CD-ROM	Operating System: Windows 9x, 2000, NT, XP & Vista

Check All Offers

Add to Wish List

Customer Reviews

Description

Microsoft SQL Server 2005 self-study training course will teach you how to implement, manage and maintain the SQL Server in 24 hours. The user-friendly interface is easy to navigate. You'll spend your time studying and learning the material, not tinkering with software. In addition, your schedule is your own. You can study as quickly or as slowly as you need to. By the time you are ready to launch a project, take the exam or attend a formal class, you will have all the tools, experience, and knowledge needed for success.

Lessons Include the following and many more:

3. SQL Server Management Studio

* Basic function of Server Management Studio
* Change Window layout
* Writing Transact-SQL code
* Using template, programs and projects
* Enhance efficiency by using HELP

4. Database management

* Design users database
* Create user database
* Set up user database
* Detach and Attach user databases
* Online and offline user database
* Compress user database and file
* Delete an unused database
* Export SQL script directly from SQL Server 2005 (new feature)

5. Management of Data Tables

* Design user tables
* Create user tables
* Edit user tables
* Delete user Table
* INSERT statements
* UPDATE statements
* DELETE statements

6. Transact-SQL Data Queries

* Understanding Common Query Language
* Using a WHERE conditions Query
* Using ORDER BY command in a query
* GROUP BY queries
* HAVING command in a query
* INTO Command
* JOIN query
* Nested query

Platforms

Windows

Product Features

• Self-study Training course for Microsoft SQL Server 2005
• Interactive training with narration and caption in English – easy to follow
• Must-have tutorial for every system users and system administrators
• Learn how to implement, manage and maintain the SQL Server in 24 hours.
• 16 hours of Total Training Time

More Details
Publisher: Amazing eLearning,..	Category: Business Training	Binding: CD-ROM

Similar Products

Beginning SQL Server 2005 Administration

Comments