Custom Search

2/16/09

CBT-Linux RedHat Training complete

CBT-Linux RedHat Training complete 10cds tested working links 100%

CD01 - Linux Basic
CD02 - Client Install
CD03 - Linux RedHat Desktop
CD04 - Linux RedHat Client Admin
CD05 - Linux RedHat Server Install
CD06 - Linux RedHat System Management
CD07 - Linux RedHat Network Admin
CD08 - Linux RedHat Web Services
CD09 - Linux RedHat Messaging
CD10 - Linux RedHat Web Secirity

CD1 - Linux Basics
http://rapidshare.de/files/19971946/CD1.part1.rar.html 100 MB
http://rapidshare.de/files/19972348/CD1.part2.rar.html 56 MB

CD2 - Client Installs
http://rapidshare.de/files/19973113/CD2.part1.rar.html 100 MB
http://rapidshare.de/files/19973800/CD2.part2.rar.html 100 MB
http://rapidshare.de/files/19974384/CD2.part3.rar.html 100 MB
http://rapidshare.de/files/19974986/CD2.part4.rar.html 100 MB
http://rapidshare.de/files/19975229/CD2.part5.rar.html 43 MB

CD3 - Desktop
http://rapidshare.de/files/19975799/CD3.part1.rar.html 100 MB
http://rapidshare.de/files/19976246/CD3.part2.rar.html 100 MB
http://rapidshare.de/files/19976677/CD3.part3.rar.html 100 MB
http://rapidshare.de/files/19976829/CD3.part4.rar.html 30 MB

CD4 - Client Admin
http://rapidshare.de/files/19977378/CD4.part1.rar.html 100 MB
http://rapidshare.de/files/19977863/CD4.part2.rar.html 100 MB
http://rapidshare.de/files/19978180/CD4.part3.rar.html 69 MB

CD5 - Server Install
http://rapidshare.de/files/19978632/CD5.part1.rar.html 100 MB
http://rapidshare.de/files/19979106/CD5.part2.rar.html 100 MB
http://rapidshare.de/files/19979551/CD5.part3.rar.html 100 MB
http://rapidshare.de/files/19979723/CD5.part4.rar.html 34 MB

CD6 - System Management
http://rapidshare.de/files/19980180/CD6.part1.rar.html 100 MB
http://rapidshare.de/files/19980493/CD6.part2.rar.html 64 MB

CD7 - Network Admin
http://rapidshare.de/files/19980898/CD7.part1.rar.html 100 MB
http://rapidshare.de/files/19981339/CD7.part2.rar.html 100 MB
http://rapidshare.de/files/19981568/CD7.part3.rar.html 56 MB

CD8 - Web Services
http://rapidshare.de/files/19981971/CD8.part1.rar.html 100 MB
http://rapidshare.de/files/19982353/CD8.part2.rar.html 100 MB
http://rapidshare.de/files/19982617/CD8.part3.rar.html 66 MB

CD9 - Messaging
http://rapidshare.de/files/19982993/CD9.part1.rar.html 100 MB
http://rapidshare.de/files/19983068/CD9.part2.rar.html 22 MB

CD10 - Security
http://rapidshare.de/files/19983416/CD10.part1.rar.html 100 MB
http://rapidshare.de/files/19983778/CD10.part2.rar.html 100 MB
http://rapidshare.de/files/19984098/CD10.part3.rar.html 100 MB
http://rapidshare.de/files/19984180/CD10.part4.rar.html 21 MB

Testout’s Microsoft Windows Server 2003 MCSE Certification Suite 10cds set

• Installing, Configuring, and Administering Windows XP Pro 70-270 2CDS
• Managing and Maintaining a Windows 2003 Network 70-290
• Implement, Manage, and Maintain a Network Infrastructure 70-291
• Plan and Maintain a Server 2003 Network Infrastructure 70-293 2CDs
• Plan, Implement, & Maintain an Active Directory Infrastructure 70-294

• Design Server 2003 Active Directory and Network Infrastructure 70-297

• Administer SQL Server 2000 70-228
• Exchange 2003 70-284

FULLY DOWNLOADED AND TESTED BY ME

Download Links

1 http://www.megaupload.com/?d=KFZ4CJ13
2 http://www.megaupload.com/?d=4R3VAMFN
3 http://www.megaupload.com/?d=QJXL5XLK
4 http://www.megaupload.com/?d=YO84MNHO
5 http://www.megaupload.com/?d=2LH2LARD
6 http://www.megaupload.com/?d=JWBUAY2R
7 http://www.megaupload.com/?d=1PI6GJSX
8 http://www.megaupload.com/?d=0W1QZ724
9 http://www.megaupload.com/?d=7PE9IG6P
10 http://www.megaupload.com/?d=XQVF81Z8
11 http://www.megaupload.com/?d=YOL3DR40
12 http://www.megaupload.com/?d=LPBTOIGS
13 http://www.megaupload.com/?d=GY3SMXMR
14 http://www.megaupload.com/?d=4DXNMYGD
15 http://www.megaupload.com/?d=0TCK0VMT
16 http://www.megaupload.com/?d=P7UV0KNT
17 http://www.megaupload.com/?d=EMLLAI31
18 http://www.megaupload.com/?d=6M57ES66
19 http://www.megaupload.com/?d=8ZJQDTC6
20 http://www.megaupload.com/?d=IZJ0S5WU
21 http://www.megaupload.com/?d=KDR536VH
22 http://www.megaupload.com/?d=QZYB88TF
23 http://www.megaupload.com/?d=2O826E9M
24 http://www.megaupload.com/?d=02BCH18V
25 http://www.megaupload.com/?d=YNL03PPT
26 http://www.megaupload.com/?d=0HHIR6QL
27 http://www.megaupload.com/?d=VAP7AZT3
28 http://www.megaupload.com/?d=H55JXRNK
29 http://www.megaupload.com/?d=KFGY3ZQ4
30 http://www.megaupload.com/?d=U3H6B2PW
31 http://www.megaupload.com/?d=6M197BJ8
32 http://www.megaupload.com/?d=01ABHMCK
33 http://www.megaupload.com/?d=2ULMKJGS
34 http://www.megaupload.com/?d=Y91FKH60
35 http://www.megaupload.com/?d=BH4V4S65
36 http://www.megaupload.com/?d=YMYHFLTC
37 http://www.megaupload.com/?d=D90YA9PO
38 http://www.megaupload.com/?d=QJ9SOCN0
39 http://www.megaupload.com/?d=7GRZWSB1
40 http://www.megaupload.com/?d=SDXPAWII
41 http://www.megaupload.com/?d=WI6N66GM
42 http://www.megaupload.com/?d=YY73HYMY

Password is www.arabdl.com

Checking ...

Ajax Video

Microsoft ASP.NET AJAX v1.0

ASP.NET AJAX is a free framework for quickly creating a new generation of more efficient, more interactive and highly-personalized Web experiences that work across all the most popular browsers.

With ASP.NET AJAX, you can:

* Create next-generation interfaces with reusable AJAX components.
* Enhance existing Web pages using powerful AJAX controls with support for all modern browsers.
* Continue using Visual Studio 2005 to take your ASP.NET 2.0 sites to the next level.
* Access remote services and data directly from the browser without writing a ton of complicated script.
* Enjoy the benefits of a free framework with technical support provided by Microsoft.

WMV, 1024Ñ…768
Language: English

File: ajax.part01.rar
DownloadLink: http://rapidshare.com/files/29853197/ajax.part01.rar
———————————————————————————————-
File: ajax.part02.rar
DownloadLink: http://rapidshare.com/files/29856188/ajax.part02.rar
———————————————————————————————-
File: ajax.part03.rar
DownloadLink: http://rapidshare.com/files/29858279/ajax.part03.rar
———————————————————————————————-
File: ajax.part04.rar
DownloadLink: http://rapidshare.com/files/29860180/ajax.part04.rar
———————————————————————————————-
File: ajax.part05.rar
DownloadLink: http://rapidshare.com/files/29861898/ajax.part05.rar
———————————————————————————————-
File: ajax.part06.rar
DownloadLink: http://rapidshare.com/files/29863271/ajax.part06.rar
———————————————————————————————-
File: ajax.part07.rar
DownloadLink: http://rapidshare.com/files/29864574/ajax.part07.rar
———————————————————————————————-
File: ajax.part08.rar
DownloadLink: http://rapidshare.com/files/29865749/ajax.part08.rar
———————————————————————————————-
File: ajax.part09.rar
DownloadLink: http://rapidshare.com/files/29867064/ajax.part09.rar
———————————————————————————————-
File: ajax.part10.rar
DownloadLink: http://rapidshare.com/files/29868011/ajax.part10.rar
———————————————————————————————-

Lynda.com - Flash CS3 Professional Essential Training (FULL ISO)

 In Flash CS3 Professional Essential Training, instructor Rich Shupe delves into the key aspects of working with Flash CS3 to create professional animations, design interactive websites, and incorporate audio and video into self-contained presentations. The training covers using the drawing and color tools, mastering the essentials of animation, and working with type, graphics, sound, and video. Rich also introduces the essentials of working with ActionScript 3.0. Exercise files accompany the tutorials.

More Information: http://movielibrary.lynda.com/html/modPage.asp?ID=353


Download Part 1
Download Part 2
Download Part 3
Download Part 4
Download Part 5
Download Part 6
Download Part 7
Download Part 8

Download SFV

Password: knowfree.net

Checking ...

Lynda - Learning Blogger

 Learning Blogger with Molly E. Holzschlag is a movie-based workshop for audiences new to blogging and to the newly revamped Blogger weblog service, a free service from Google. Begin by learning what blogs are and the various ways they can be used.

You'll quickly get into setting up your weblog, adding specialty features such as comment systems and news-feeds, working with and customizing templates, and even creating team blogs and audio blogs. The included exercise files, articles, and
resources enhance the title, allowing you to follow along with the movies and learn at your own pace.


Download Links
http://rapidshare.com/files/10722475/LB.part01.rar.html
http://rapidshare.com/files/10724341/LB.part02.rar.html
http://rapidshare.com/files/10728688/LB.part03.rar.html
http://rapidshare.com/files/10763508/LB.part04.rar.html
http://rapidshare.com/files/10765184/LB.part05.rar.html
http://rapidshare.com/files/10855697/LB.part06.rar.html
http://rapidshare.com/files/10862119/LB.part07.rar.html
http://rapidshare.com/files/11140001/LB.part08.rar.html
http://rapidshare.com/files/11171891/LB.part09.rar.html

Learnkey : (MCSE 70-290) Windows 2003 Managing A Network Environment

The Windows Server 2003 Managing a Network Environment course from LearnKey prepares you with the knowledge and skills needed to install, configure, and administer Microsoft Windows Server 2003. Aaron Spurlock shows you techniques for monitoring and optimizing physical and logical devices. He will guide you through managing users, computers and groups, configuring access to resources and disaster recovery contingency planning. At the conclusion of the course, you will understand how to manage and maintain a Windows Server 2003 environment.

Benefits:

• This course meets MCP exam 70-290 objectives.

• Develop your abilities and IT credibility.

• Increase your career opportunities and earning potential.

5 CDs

Download Here

Password = devilkings1@knowfree.net



Learnkey : (MCSE 70-292) Windows 2003 MCSA Skills Update

The Microsoft Certified Systems Administrator (MCSA) on Windows Server 2003 upgrade exam is available only to current MCSAs or MCSEs on Windows 2000. In the Windows Server 2003 MCSA Skills Update course from LearnKey, you'll build on current abilities to develop skills needed to manage and maintain a Windows Server 2003 network. Expert instructor Aaron Spurlock shows you how to manage users and groups, active directory, servers, web services, security, DNS configuration, and disaster recovery.

Benefits

• Be prepared to pass MCP exam 70-292.
• Update your certification and increase your valuable IT mastery.
• Increase your career opportunities and earning potential.

3 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : (MCSE 70-296)Windows 2003 MCSE Skills Update

The Windows 2000 Skills Update from LearnKey is a comprehensive course for experienced network administrators who need to incorporate Windows 2000 into existing Windows NT 4.0 networks. Expert Michael Storm provides critical information and practical insights based on experience to show network managers how to prepare for, implement and manage mixed-environment networks.

Benefits

• Gain technical mastery of network environments.

• Integrate Windows 2000 into existing Windows NT 4.0 networks.

• Enhance your career opportunities increased IT knowledge.

4 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : (MCSE 70-294) Windows 2003 Active Directory Infrastructure

The Windows Server 2003 Active Directory Infrastructure course from LearnKey prepares you with the knowledge and skills needed to plan, implement, and maintain a Windows Server 2003 Active Directory Infrastructure. Expert instructor Dale Brice-Nash demonstrates how to set up and maintain Active Directory structure and topology, and how to plan and implement user, computer, and group security. At the conclusion of the course, you will understand the skills required to manage and maintain an Active Directory infrastructure within a Windows Server 2003 environment.

Benefits

• Develop your IT abilities and credibility.
• Increase your career opportunities and earning potential.
• Be prepared to pass MCP exam 70-297.

5 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : (MCSE 70-297) Windows 2003 Active Directory and Network Infrastructure Design

The Windows Server 2003 Active Directory and Network Infrastructure Design course from LearnKey prepares you with the knowledge and skills needed to design a Windows Server 2003 Active Directory and Network Infrastructure. Expert instructor Michael Storm demonstrates how to create conceptual, logical, and physical designs for Active Directory and network services. At the conclusion of the course, you will be prepared to pass the MCP exam 70-297 - Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure.

Benefits

• LearnKey courses meet or exceed all exam objectives.
• Increase your career opportunities and earning potential.
• Be prepared to pass the MCP exam 70-297.


5 CDs

Learnkey : (MCSE 70-298) Windows 2003 Security Design

The Windows Server 2003 Security Design course from LearnKey prepares you with the knowledge and skills needed to analyze business requirements for a secure network infrastructure and design a security solution that meets those requirements. Expert instructor Tom Carpenter demonstrates how to create conceptual, logical, and physical designs for network infrastructure security. At the conclusion of the course, you will be prepared to pass the MCP exam 70-298, Designing Security for a Microsoft Windows Server 2003 Network.

Benefits

• This course meets all Microsoft exam 70-298 objectives.
• Build on current abilities and increase your IT credibility.
• Information security skills are in demand throughout the world.

4 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : MCSE 70-272) Windows XP Troubleshooting Desktop Appliocaitons

The Windows XP Troubleshooting Desktop Applications course from LearnKey prepares candidates for one of two core exams required to achieve Microsoft Certified Desktop Support Technician (MCDST) certification. Expert instructor Tom Carpenter shows candidates how to configure and troubleshoot problems with Microsoft applications including Office, Internet Explorer and Outlook. Candidates also learn to configure application connectivity and security, and to resolve problems with application usability and customization.

2 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : (MCSE 70-285) Exchange Server 2003 Design

The Exchange Server 2003 Design course from LearnKey prepares IT professionals to analyze business messaging requirements and design an appropriate Exchange Server 2003 messaging infrastructure. Expert instructor Aaron Spurlock takes you through analysis and design of Active Directory integration, Exchange Server 2003 infrastructure, routing topology and security. Your working knowledge of networking principles and Internet protocols or experience with Windows Server 2003 will put you on the path to a successful experience and prepare you for MCP exam 70-285. Exchange Server 2003 Design Aaron Spurlock.

Benefits

• Enhance your career with the messaging specialist credential.
• Increase your earning potential with your IT skills.
• Meets the requirements to pass MCP exam 70-285.

2 CDs

Download Here

Password = devilkings1@knowfree.net



Learnkey Cisco ® CCNA Series (Exam640-801)

The CCNA® credential represents a basic knowledge of networking and Cisco® technology. With the CCNA® Series from LearnKey, candidates pursuing the two-exam option for certification prepare for both required tests, the Introduction to Cisco® Networking Technologies exam (INTRO) and the Interconnecting Cisco® Networking Devices exam (ICND). Expert instructor Michael Storm covers all Cisco® exam topics for both tests. At the conclusion of this series, you will be prepared to pass the INTRO and ICND exams required to complete the two-exam option for CCNA® certification. Cisco ® CCNA Series(Exam640-801) Michael Storm

Benefits

• Enhance career opportunities with CCNA® Certification.
• Demonstrate confidence in your abilities to employers and clients.
• LearnKey courses have a proven first time exam pass rate.

9 CDs

Download Here

Password = devilkings1@knowfree.net

Teracom Training : Teracom VoIP 3 CDs

Teracom's Understanding Voice over IP VoIP training course is geared for non-technical professionals needing to understand VoIP: jargon and buzzwords, concepts and components, protocols, technologies and architecture choices, why and how an organization would implement VoIP. Totally up to date - the course has been updated again with updated vendor information and applications enabled by SIP and VoIP including presence and group communications.

Taking this course, you will build the solid foundation necessary to intelligently discuss, compare, evaluate and understand VoIP technologies, products and implementation choices. You 'll learn concrete ways VoIP saves money and improves service, and how to apply it in your organization. Here's what you'll get:

A clear, structured understanding of VoIP systems, components, standards, jargon and buzzwords, from codecs to softswitches to SIP and IP call flow and everything in between

An unbiased view, not tied to any vendor's products or mindset: the pros and cons of all of the mainstream choices for implementing VoIP contrasted and compared

Understanding what SIP is, and what it can do

Details of more than 15 concrete ways VoIP can save money. Examples of new VoIP and IP applications using convergence and presence to improve service and enhance productivity

Numerous case studies illustrating appropriate VoIP solutions for small, medium, large organizations

The rundown on VoIP services from carriers.

Seven areas that must be addressed when selecting a VoIP carrier

Readiness Assessment, covering more than eight major potential problem areas and solutions, with a detailed Readiness Assessment Checklist that you can put to immediate use

An unbiased survey of major vendors and product/service categories in the marketplace

A comprehensive template for VoIP project management: how to do it the "right" way, analyzing requirements, running trials, evaluating and selecting a vendor, rollout, acceptance and more.

For Complete course Details go to

hxxp://teracomtraining.com/courses/301/voip-training.htm

3 CDs

Download Here

Password = devilkings1@knowfree.net

Testout : (MCSE 70-290) Managing and Maintaining a Windows 2003 Network

Testout : (MCSE 70-290) Managing and Maintaining a Windows 2003 Network

Videos: 58
Demonstrations: 64
Simulations: 99
Fact Sheets: 63
Exam Questions: 191
Exams: 39

Download Here

Password = devilkings1@knowfree.net

Lynda.com - Photoshop Lightroom Essential Training

 Photoshop Lightroom is a powerful new photographic workflow application designed to help photographers expand their creative potential. Photoshop Lightroom Essential Training is all about using this revolutionary new tool to its full potential. One of the main challenges of photography is dealing with the sheer volume of images that result from each shoot. In Photoshop Lightroom Essential Training , instructor and professional photographer Chris Orwig explains how browsing, organizing, and adjusting images in Photoshop Lightroom dynamically improves photo management, processing, and presentation. The training empowers photographers to establish a more effective and creative workflow so they can focus on what it's all about–the photo! Exercise files (full resolution raw files) accompany the tutorials.

Testout : (MCSE 70-291) Implement, Manage, and Maintain a Network Infrastructure

1 CD

More info: hxxp://www.testout.com/docs/70-291.htm

DOWNLOAD HERE

Password = devilkings1@knowfree.net

Testout : (MCSE 70-293) Planning a Server 2003 Network Infrastructure

1 CD

More info here: hxxp://www.testout.com/docs/70-293.htm

DOWNLOAD HERE

Password = devilkings1@knowfree.net

Testout : (MCSE 70-294) Implementing an Active Directory Infrastructure

1 CD

More info here: hxxp://www.testout.com/docs/70-294.htm

DOWNLOAD HERE

Password = devilkings1@knowfree.net



Testout : (MCSE 70-297) Design Server 2003 Active Directory and Network Infrastructure

1 CD

More info here: hxxp://www.testout.com/docs/70-297.htm

Download Here

Learnkey : (MCSE 70-291) Windows 2003 Implementing A Network Infrastructure

The Windows Server 2003 Implementing Network Infrastructure course from LearnKey prepares you with the knowledge and skills needed to implement, manage, and maintain a Windows Server 2003 network. Expert instructor Aaron Spurlock covers critical topics like how to implement server IP addressing, name resolution, network security, routing and remote access. At the conclusion of the course, you will understand the skills required to implement a Windows Server 2003 network, and be prepared to pass MCP exam 70-291. Windows 2003 Implementing A Network Infrastructure Aaron Spurlock

Benefits

• Develop your abilities and IT credibility.
• Increase your career opportunities and earning potential.
• This course meets MCP exam 70-291 objectives.

5 CDs
Download Here

Password = devilkings1@knowfree.net

Learnkey MCSE 70-293 : Windows 2003 Planning A Network Infrastructure

The Windows Server 2003 Planning Network Infrastructure course from LearnKey prepares you with the knowledge and skills needed to plan and maintain a Windows Server 2003 network. Expert instructor Michael Storm demonstrates critical skills like how to plan for server and network security, routing and remote access, and server availability. At the conclusion of the course, you will understand the skills required to plan a Windows Server 2003 network, and be prepared to pass MCP exam 70-293.

Benefits

• This course meets MCP exam 70-293 objectives.
• Develop your abilities and IT credibility.
• Increase your career opportunities and earning potential. 5 CDs

Download Here

Password = devilkings1@knowfree.net

Learnkey : Visual Basic 6.0 to VB.NET Migration For Developers

In the Visual Basic 6.0 to VB.NET Migration for Developers course from LearnKey, Visual Basic developers will learn how to migrate to the latest version of this favored application building tool. Expert instructor Shannon Horn begins by explaining .NET, Microsoft�s web services and applications platform, and then moves logically and progressively through the migration issues VB developers will face. At the conclusion of this course, you’ll feel confident in your ability to move your development efforts to VB.NET.

Benefits

• Increase earning potential with technical mastery.
• Enhance employment opportunities with IT development knowledge.
• Gain new skills in a useful, productive manner

2 CDs

Download Link

Password = devilkings1@knowfree.net

Testout MCSE 70-299 : Implement and Administer Security in a Server 2003 Network

Course Details : hxxp://www.testout.com/docs/70-299.htm

Download Here

Password = devilkings1@knowfree.net

Learnkey MCSE 70-284 : Exchange Server 2003 Implementation

The Exchange Server 2003 Implementation course from LearnKey provides in-depth training on implementation, managing, and troubleshooting an Exchange Server 2003. Expert instructor Aaron Spurlock takes you through installation, configuration and upgrading from earlier versions. He also covers exchange security, managing address lists, and more. If you have a working knowledge of networking principles and Internet protocols or experience with Windows Server 2003, this is the course for you. This courses meet the requirements to pass MCP exam 70-284

Benefits

• Enhance your career with the messaging specialist credential.
• Increase your earning potential with IT certification.
• Meet the requirements to pass MCP exam 70-284.

5 CDs


Download Here

Password = devilkings1@knowfree.net

Testout MCSE 70-270 : Installing, Configuring, and Administering Windows XP Pro

Course Details = http://www.testout.com/docs/70-270.htm


Download Here

Password = devilkings1@knowfree.net

VTC Unix Shell Fundamentals Tutorials

 VTC Unix Shell Fundamentals Tutorials

* Never has it been so easy to learn Unix Shell Fundamentals.
* No expensive classroom training courses.
* No boring hard to follow books to read.
* Learn from your own desk at a pace that suits you.
* High quality affordable training that is easy to use and follow.
* Use our unique training method, it makes learning easy no matter what your learning style.


Download Here




Lynda.com - ActionScript 3.0 in Flash CS3 Professional Essential Training

Lynda.com - ActionScript 3.0 in Flash CS3 Professional Essential TrainingTo fully take advantage of Flash CS3, it's necessary to have a comprehensive understanding of ActionScript 3.0. From manipulating movie clips and responding to user actions with variables to writing functions and conditional operators, ActionScript 3.0 in Flash CS3 Professional Essential Training covers the vital skills necessary to master ActionScript 3.0. Instructor Todd Perkins uses numerous hands-on examples–including two game-building exercises–to explore ActionScript's powerful features. Exercise files accompany the tutorials.

Appdev Microsoft SQL Server 2000| 20 hours Runtime | 14 (CDs Set) | 2.6 GB

Appdev Microsoft SQL Server 2000

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…

* 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.

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

http://www.ftp2share.com/file/19206/Appdev-Microsoft-SQL-Server-2000.part01.rar.html http://www.ftp2share.com/file/19210/Appdev-Microsoft-SQL-Server-2000.part02.rar.html
http://www.ftp2share.com/file/19211/Appdev-Microsoft-SQL-Server-2000.part03.rar.html
http://www.ftp2share.com/file/19213/Appdev-Microsoft-SQL-Server-2000.part04.rar.html
http://www.ftp2share.com/file/19221/Appdev-Microsoft-SQL-Server-2000.part05.rar.html
http://www.ftp2share.com/file/19234/Appdev-Microsoft-SQL-Server-2000.part06.rar.html
http://www.ftp2share.com/file/19248/Appdev-Microsoft-SQL-Server-2000.part07.rar.html
http://www.ftp2share.com/file/19290/Appdev-Microsoft-SQL-Server-2000.part08.rar.html
http://www.ftp2share.com/file/19372/Appdev-Microsoft-SQL-Server-2000.part09.rar.html
http://www.ftp2share.com/file/19400/Appdev-Microsoft-SQL-Server-2000.part10.rar.html
http://www.ftp2share.com/file/19428/Appdev-Microsoft-SQL-Server-2000.part11.rar.html
http://www.ftp2share.com/file/19440/Appdev-Microsoft-SQL-Server-2000.part12.rar.html
http://www.ftp2share.com/file/20213/Appdev-Microsoft-SQL-Server-2000.part13.rar.html
http://www.ftp2share.com/file/20234/Appdev-Microsoft-SQL-Server-2000.part14.rar.html
http://www.ftp2share.com/file/20275/Appdev-Microsoft-SQL-Server-2000.part15.rar.html
http://www.ftp2share.com/file/20466/Appdev-Microsoft-SQL-Server-2000.part16.rar.html
http://www.ftp2share.com/file/20493/Appdev-Microsoft-SQL-Server-2000.part17.rar.html
http://www.ftp2share.com/file/20610/Appdev-Microsoft-SQL-Server-2000.part18.rar.html
http://www.ftp2share.com/file/20632/Appdev-Microsoft-SQL-Server-2000.part19.rar.html
http://www.ftp2share.com/file/20653/Appdev-Microsoft-SQL-Server-2000.part20.rar.html
http://www.ftp2share.com/file/20663/Appdev-Microsoft-SQL-Server-2000.part21.rar.html
http://www.ftp2share.com/file/20676/Appdev-Microsoft-SQL-Server-2000.part22.rar.html
http://www.ftp2share.com/file/20690/Appdev-Microsoft-SQL-Server-2000.part23.rar.html
http://www.ftp2share.com/file/20709/Appdev-Microsoft-SQL-Server-2000.part24.rar.html
http://www.ftp2share.com/file/20808/Appdev-Microsoft-SQL-Server-2000.part25.rar.html
http://www.ftp2share.com/file/20811/Appdev-Microsoft-SQL-Server-2000.part26.rar.html

Wicked Cool Shell Scripts

 Wicked Cool Shell Scripts101 useful, customizable, and fun Linux, Mac OS X and UNIX shell scripts that you can use to solve common problems and personalize your computing environment. Includes an interactive calculator, a spell checker, a disk backup utility, a weather tracker, a web logfile analysis tool, and much more. The cookbook style examples are all written in Bourne Shell (sh) syntax.Download Here

How to wow with Flash

How to wow with Flash Finally, my first Flash training title is ready for download! This is 9 hours of the hottest Flash training. in 59 lessons, learn the basics and then take-off with Video, creating interactive content, animation, sound, creating special effects like you see on entertainment sites, creating CD and DVD content, galleries, websites and much more! Download Links

http://rapidshare.com/files/43936861/Photoshop_cafe_-_How_to_wow_with_flash.part01.rar
http://rapidshare.com/files/43940529/Photoshop_cafe_-_How_to_wow_with_flash.part02.rar
http://rapidshare.com/files/43945094/Photoshop_cafe_-_How_to_wow_with_flash.part03.rar
http://rapidshare.com/files/43948529/Photoshop_cafe_-_How_to_wow_with_flash.part04.rar
http://rapidshare.com/files/44028614/Photoshop_cafe_-_How_to_wow_with_flash.part05.rar
http://rapidshare.com/files/44122822/Photoshop_cafe_-_How_to_wow_with_flash.part06.rar
http://rapidshare.com/files/44125521/Photoshop_cafe_-_How_to_wow_with_flash.part07.rar
http://rapidshare.com/files/44129290/Photoshop_cafe_-_How_to_wow_with_flash.part08.rar
http://rapidshare.com/files/44134163/Photoshop_cafe_-_How_to_wow_with_flash.part09.rar
http://rapidshare.com/files/44138983/Photoshop_cafe_-_How_to_wow_with_flash.part10.rar
http://rapidshare.com/files/44143069/Photoshop_cafe_-_How_to_wow_with_flash.part11.rar
http://rapidshare.com/files/44294835/Photoshop_cafe_-_How_to_wow_with_flash.part12.rar
http://rapidshare.com/files/44296713/Photoshop_cafe_-_How_to_wow_with_flash.part13.rar

Photoshop for Video 3rd Edition

Photoshop for Video 3rd EditionMaster the graphic design and production skills required of today's video editors and motion graphic professionals with this comprehensive guide to the video tools in Adobe Photoshop CS3. Every page is filled with techniques to help the video professional make graphics for use in television, video, the Internet, and DVD. Lively discourse, full-color presentations, and hands-on tutorials demonstrate everything you need to know about how to combine still and moving images. Fundamental concepts such as transparency, pixel aspect ratio, and alpha channels are made precisely clear, and advanced techniques show how to use Photoshop as a character generator, color corrector, and animation tool.

This edition features expanded coverage of DVD and motion graphics design, as well as addressing recent developments in High Definition video and 32-bit imaging. This indispensable reference includes:

* real-world solutions for making graphics for video

* introduction to third party plug-ins

* automation and shortcut methods that cut production time

* profiles of notable editors and motion graphic artists that include their favorite tips and tricks

The DVD offers a hands-on multimedia experience with hundreds of images to work on, tutorials to complete and 2 hours of video training to watch.

Features:

* Real-world solutions for making graphics for video, motion graphics, and DVD authoring

* Expanded coverage of High Def video

* 16-bit and 32-bit image processing techniques for greater color fidelity

* Integration guides for top selling Editing, Motion Graphics, and DVD software

* Automation and shortcut methods that cut production time and improve final product

Download here

Password: knowfree.net

Total Training - Microsoft Expression Media DVD

Total Training - Microsoft Expression Media DVDGet your digital assets in order with Microsoft Expression Media. Hosted by Nick Wilcox-Brown, this video series teaches you how to organize and catalog your entire library of digital files for easy retrieval and presentation. In addition, you'll learn how to rank and rate your files, add metadata and copyright information, and output your digital assets to an HTML gallery. Sorting out your files just got easier.

Managing and Maintaining a Windows 2003 Network (70-290)

Another latest version of Testout 70-290.

More info: hxxp://www.testout.com/docs/70-290.htm


http://rapidshare.com/files/40938442/CD_70-290.part01.rar
http://rapidshare.com/files/40971503/CD_70-290.part02.rar
http://rapidshare.com/files/41096785/CD_70-290.part03.rar
http://rapidshare.com/files/41099676/CD_70-290.part04.rar
http://rapidshare.com/files/41107250/CD_70-290.part05.rar
http://rapidshare.com/files/41111017/CD_70-290.part06.rar
http://rapidshare.com/files/41113604/CD_70-290.part07.rar
http://rapidshare.com/files/41126371/CD_70-290.part08.rar
http://rapidshare.com/files/41139577/CD_70-290.part09.rar
http://rapidshare.com/files/41140964/CD_70-290.part10.rar

RAR Password: Microsoft
Checking ...

VTC Design Patterns Training

Design patterns let programmers avoid re-inventing the wheel. The original book (Design Patterns by the "Gang of Four": Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides) was phenomenally successful. When the programmer faces a particular problem, all they have to do is to look up the correct matching design pattern and use it to implement the solution. In this tutorial VTC author Steve Holzner guides you through the most popular and useful design patterns, so you can begin incorporating them into your own code.

Download Links

http://rapidshare.com/files/47345466/VTCDP.part1.rar
http://rapidshare.com/files/47345497/VTCDP.part2.rar
http://rapidshare.com/files/47345706/VTCDP.part3.rar
http://rapidshare.com/files/47345715/VTCDP.part4.rar
http://rapidshare.com/files/47345672/VTCDP.part5.rar
http://rapidshare.com/files/47345691/VTCDP.part6.rar
http://rapidshare.com/files/47342848/VTCDP.part7.rar

Photoshop Top Secret

Just released by Mark Monciardini, Photoshop® Top Secret™ is an Extreme Training Course that teaches you, step by step, how to create cutting-edge graphics and special effects with Adobe® Photoshop®. This student-friendly home study course includes four DVD-ROMs with over 16 gigabytes of video tutorials and project files. It also comes with a full-color gallery book (printed, not pdf) that shows the end result of each project in the course. You can look, learn, practice, and master these advanced techniques wherever you may be, without the need for expensive classes or tutors.

Photoshop Top Secret DVD1

How to Become a Photoshop "Black Belt"-Fast!

Just released by Mark Monciardini, Photoshop® Top Secret™ is an Extreme Training Course that teaches you, step by step, how to create cutting-edge graphics and special effects with Adobe® Photoshop®. This student-friendly home study course includes four DVD-ROMs with over 16 gigabytes of video tutorials and project files. It also comes with a full-color gallery book (printed, not pdf) that shows the end result of each project in the course You can look, learn, practice, and master these advanced techniques wherever you may be, without the need for expensive classes or tutors. Create Posters, Movie Covers, Surreal Graphics and More! The course will teach you how to become the ultimate Photoshop® "black belt" for fun and/or profit. You'll learn how to create top-level special effects
for eye-catching movie posters, album covers, book jackets, brochures, mailing pieces, magazine covers, article illustrations, and a tremendously wide range of print ads and Web site graphics.


http://www.megaupload.com/?d=129B3WPN
http://www.megaupload.com/?d=1B54GV02
http://www.megaupload.com/?d=1E5PL6EL
http://www.megaupload.com/?d=1SUTVPY1
http://www.megaupload.com/?d=1VEFI59E
http://www.megaupload.com/?d=24KCVRCZ
http://www.megaupload.com/?d=2CNBK42M
http://www.megaupload.com/?d=2HA962PL
http://www.megaupload.com/?d=2KMNOLUH
http://www.megaupload.com/?d=2XFUZAY9
http://www.megaupload.com/?d=3JG5Z8PB
http://www.megaupload.com/?d=3K2WWSPX
http://www.megaupload.com/?d=49K02290
http://www.megaupload.com/?d=4AYC8IUS
http://www.megaupload.com/?d=4CO3XVEP
http://www.megaupload.com/?d=4R3ZT7IA
http://www.megaupload.com/?d=5QFGX43A
http://www.megaupload.com/?d=652FHOHP
http://www.megaupload.com/?d=7HK4BGEZ
http://www.megaupload.com/?d=8J9N80I0
http://www.megaupload.com/?d=8KV3B10X
http://www.megaupload.com/?d=8N2R4O5X
http://www.megaupload.com/?d=8Y42BZ8W
http://www.megaupload.com/?d=9HSWOPY1
http://www.megaupload.com/?d=9J83R1BS
http://www.megaupload.com/?d=9ODAX3RY
http://www.megaupload.com/?d=A1YKHJDH
http://www.megaupload.com/?d=AG2YHM3Q
http://www.megaupload.com/?d=AY6C6T0Q
http://www.megaupload.com/?d=B817GJ4E
http://www.megaupload.com/?d=BP85V6E8
http://www.megaupload.com/?d=BQKQ0O7P
http://www.megaupload.com/?d=BSTAX330
http://www.megaupload.com/?d=C9EVCH1W
http://www.megaupload.com/?d=CECZ4Q5O
http://www.megaupload.com/?d=CTZMVQ97
http://www.megaupload.com/?d=DRQYAP2U
http://www.megaupload.com/?d=DV75PNJG
http://www.megaupload.com/?d=DWMY3K5H
http://www.megaupload.com/?d=G6B46MSK
http://www.megaupload.com/?d=GNETJ7CJ
http://www.megaupload.com/?d=H8BQX5BB
http://www.megaupload.com/?d=HVFO2V8J
http://www.megaupload.com/?d=HXAJ1MVC
http://www.megaupload.com/?d=JHGZG6ZR
http://www.megaupload.com/?d=JHSHYO54
http://www.megaupload.com/?d=LQMF7IEF
http://www.megaupload.com/?d=LSL2CZ2W
http://www.megaupload.com/?d=M8MNE6BZ
http://www.megaupload.com/?d=MIQLN16L
http://www.megaupload.com/?d=MTFPPAPY
http://www.megaupload.com/?d=N8VNQCPK
http://www.megaupload.com/?d=NDT9UJVF
http://www.megaupload.com/?d=NLLF37SH
http://www.megaupload.com/?d=O4H5EX0F
http://www.megaupload.com/?d=OYSY85KD
http://www.megaupload.com/?d=P7KDLQ55
http://www.megaupload.com/?d=Q4GCID5H
http://www.megaupload.com/?d=QI7QKHPE
http://www.megaupload.com/?d=R50ZA6CE
http://www.megaupload.com/?d=RE0OKM0M
http://www.megaupload.com/?d=RQW67BY0
http://www.megaupload.com/?d=SG1CT0E7
http://www.megaupload.com/?d=SH1WVLKI
http://www.megaupload.com/?d=TC1BOGCP
http://www.megaupload.com/?d=TL8RKZSS
http://www.megaupload.com/?d=U3CANUQV
http://www.megaupload.com/?d=VH0S6EDE
http://www.megaupload.com/?d=VMJY890Y
http://www.megaupload.com/?d=W42YST76
http://www.megaupload.com/?d=WJ0V20QB
http://www.megaupload.com/?d=WJ6F2NTB
http://www.megaupload.com/?d=X7WZSG11
http://www.megaupload.com/?d=XPI1EA3H
http://www.megaupload.com/?d=YGDKUX8A
http://www.megaupload.com/?d=YH49A9Y6
http://www.megaupload.com/?d=YQZMB9O0
http://www.megaupload.com/?d=YRY4VBQN
http://www.megaupload.com/?d=YVGGMR7R
http://www.megaupload.com/?d=YXNMYF1O
http://www.megaupload.com/?d=ZHW0P3BD
http://www.megaupload.com/?d=ZLLQ4KWB

Multiple LinuxCBTs : Classic, Debian, DBMS, Mail, Scripting

jpgLinuxCBT | UnixCBT are the most comprehensive and cost-effective GNU/Linux, Unix, and Open Source training solutions available!

More information at product homepage
hxxp://www.linuxcbt.com

Classic Edition
http://rapidshare.com/users/J1SI50

Debian Edition
http://rapidshare.com/users/EF90JK

DBMS Edition
http://rapidshare.com/users/NIBNT9

Mail Edition
http://rapidshare.com/users/4VO3EZ

Scripting Edition
http://rapidshare.com/users/61RIIJ

UnRAR password (if required) : pokipoki

Lynda.com Contribute CS3 Essential Training

 Lynda.com Contribute CS3 Essential Training

Contribute CS3 is the tool of choice for non-web designers who need to make changes and updates to an existing website without fear of accidentally damaging the site. In Contribute CS3 Essential Training , instructor Garrick Chow explains the process of setting up the Contribute CS3 workflow. He also covers how to collaborate with others to create and maintain a site and how to write and update blog entries.


http://rapidshare.com/files/54800005/Lynda.com_-_contribute_CS3.part1.rar
http://rapidshare.com/files/54800002/Lynda.com_-_contribute_CS3.part2.rar
http://rapidshare.com/files/54800048/Lynda.com_-_contribute_CS3.part3.rar
http://rapidshare.com/files/54797554/Lynda.com_-_contribute_CS3.part4.rar

Total Training Microsoft SQL Server Development

Total Training Microsoft SQL Server DevelopmentTotal Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!

PART 1: Introduction to SQL Server 2005

Lesson 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases

Lesson 2: USING MANAGEMENT STUDIO (23 min)
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor

Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments

Part 2: Selecting Data

Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates

Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions

Lesson 3: WORKING WITH SUBQUERIES (19 min)
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division

Lesson 4: AGGREGATING DATA (35 min)
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums

Lesson 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases

Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views

Lesson 7: DISTRIBUTED QUERIES (18 min)
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions

Lesson 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits

PART 3: Developing Solutions

Lesson 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions

Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using "Instead of" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes

Lesson 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic

Lesson 4: INDEXING FOR PERFORMANCE (31 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2

Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation

Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits

Part1
http://rapidshare.com/files/56345531/TSQL05_P01_C01_L00.wmv
http://rapidshare.com/files/56345603/TSQL05_P01_C01_L01.wmv
http://rapidshare.com/files/56346080/TSQL05_P01_C01_L02.wmv
http://rapidshare.com/files/56346112/TSQL05_P01_C01_L03.wmv
http://rapidshare.com/files/56346160/TSQL05_P01_C01_L04.wmv

http://rapidshare.com/files/56344418/TSQL05_P01_C02_L00.wmv
http://rapidshare.com/files/56344615/TSQL05_P01_C02_L01.wmv
http://rapidshare.com/files/56345282/TSQL05_P01_C02_L02.wmv
http://rapidshare.com/files/56345757/TSQL05_P01_C02_L03.wmv
http://rapidshare.com/files/56345695/TSQL05_P01_C02_L04.wmv
http://rapidshare.com/files/56345307/TSQL05_P01_C02_L05.wmv
http://rapidshare.com/files/56345350/TSQL05_P01_C02_L06.wmv
http://rapidshare.com/files/56345797/TSQL05_P01_C02_L07.wmv

http://rapidshare.com/files/56344297/TSQL05_P01_C03_L00.wmv
http://rapidshare.com/files/56344645/TSQL05_P01_C03_L01.wmv
http://rapidshare.com/files/56346094/TSQL05_P01_C03_L02.wmv
http://rapidshare.com/files/56345708/TSQL05_P01_C03_L03.wmv
http://rapidshare.com/files/56345299/TSQL05_P01_C03_L04.wmv
http://rapidshare.com/files/56345116/TSQL05_P01_C03_L05.wmv
http://rapidshare.com/files/56345871/TSQL05_P01_C03_L06.wmv
http://rapidshare.com/files/56344226/TSQL05_P01_C03_L07.wmv

Part2
http://rapidshare.com/files/56347494/TSQL05_P02_C01_L00.wmv
http://rapidshare.com/files/56350511/TSQL05_P02_C01_L01.wmv
http://rapidshare.com/files/56350997/TSQL05_P02_C01_L02.wmv
http://rapidshare.com/files/56348537/TSQL05_P02_C01_L03.wmv
http://rapidshare.com/files/56350392/TSQL05_P02_C01_L04.wmv
http://rapidshare.com/files/56349477/TSQL05_P02_C01_L05.wmv
http://rapidshare.com/files/56347748/TSQL05_P02_C01_L06.wmv
http://rapidshare.com/files/56350510/TSQL05_P02_C01_L07.wmv
http://rapidshare.com/files/56349263/TSQL05_P02_C01_L08.wmv
http://rapidshare.com/files/56349448/TSQL05_P02_C01_L09.wmv
http://rapidshare.com/files/56348668/TSQL05_P02_C01_L10.wmv
http://rapidshare.com/files/56349540/TSQL05_P02_C01_L11.wmv

http://rapidshare.com/files/56347205/TSQL05_P02_C02_L00.wmv
http://rapidshare.com/files/56351012/TSQL05_P02_C02_L01.wmv
http://rapidshare.com/files/56349147/TSQL05_P02_C02_L02.wmv
http://rapidshare.com/files/56348591/TSQL05_P02_C02_L03.wmv
http://rapidshare.com/files/56350381/TSQL05_P02_C02_L04.wmv
http://rapidshare.com/files/56348847/TSQL05_P02_C02_L05.wmv
http://rapidshare.com/files/56347745/TSQL05_P02_C02_L06.wmv
http://rapidshare.com/files/56350474/TSQL05_P02_C02_L07.wmv

http://rapidshare.com/files/56347117/TSQL05_P02_C03_L00.wmv
http://rapidshare.com/files/56350193/TSQL05_P02_C03_L01.wmv
http://rapidshare.com/files/56348132/TSQL05_P02_C03_L02.wmv
http://rapidshare.com/files/56347704/TSQL05_P02_C03_L03.wmv
http://rapidshare.com/files/56349284/TSQL05_P02_C03_L04.wmv
http://rapidshare.com/files/56350272/TSQL05_P02_C03_L05.wmv

http://rapidshare.com/files/56346792/TSQL05_P02_C04_L00.wmv
http://rapidshare.com/files/56350866/TSQL05_P02_C04_L01.wmv
http://rapidshare.com/files/56349244/TSQL05_P02_C04_L02.wmv
http://rapidshare.com/files/56350855/TSQL05_P02_C04_L03.wmv
http://rapidshare.com/files/56349609/TSQL05_P02_C04_L04.wmv
http://rapidshare.com/files/56350914/TSQL05_P02_C04_L05.wmv
http://rapidshare.com/files/56351212/TSQL05_P02_C04_L06.wmv
http://rapidshare.com/files/56350646/TSQL05_P02_C04_L07.wmv

http://rapidshare.com/files/56347512/TSQL05_P02_C05_L00.wmv
http://rapidshare.com/files/56351020/TSQL05_P02_C05_L01.wmv
http://rapidshare.com/files/56351174/TSQL05_P02_C05_L02.wmv
http://rapidshare.com/files/56348435/TSQL05_P02_C05_L03.wmv

http://rapidshare.com/files/56347686/TSQL05_P02_C06_L00.wmv
http://rapidshare.com/files/56350880/TSQL05_P02_C06_L01.wmv
http://rapidshare.com/files/56349267/TSQL05_P02_C06_L02.wmv
http://rapidshare.com/files/56348695/TSQL05_P02_C06_L03.wmv
http://rapidshare.com/files/56349269/TSQL05_P02_C06_L04.wmv

http://rapidshare.com/files/56348452/TSQL05_P02_C07_L00.wmv
http://rapidshare.com/files/56350807/TSQL05_P02_C07_L01.wmv
http://rapidshare.com/files/56350833/TSQL05_P02_C07_L02.wmv
http://rapidshare.com/files/56349805/TSQL05_P02_C07_L03.wmv
http://rapidshare.com/files/56350286/TSQL05_P02_C07_L04.wmv
http://rapidshare.com/files/56350044/TSQL05_P02_C07_L05.wmv

http://rapidshare.com/files/56348605/TSQL05_P02_C08_L00.wmv
http://rapidshare.com/files/56351312/TSQL05_P02_C08_L01.wmv
http://rapidshare.com/files/56351007/TSQL05_P02_C08_L02.wmv
http://rapidshare.com/files/56350426/TSQL05_P02_C08_L03.wmv
http://rapidshare.com/files/56350132/TSQL05_P02_C08_L04.wmv
http://rapidshare.com/files/56350987/TSQL05_P02_C08_L05.wmv

Part3

http://rapidshare.com/files/56352619/TSQL05_P03_C01_L00.wmv
http://rapidshare.com/files/56354359/TSQL05_P03_C01_L02.wmv
http://rapidshare.com/files/56354110/TSQL05_P03_C01_L03.wmv
http://rapidshare.com/files/56353319/TSQL05_P03_C01_L04.wmv
http://rapidshare.com/files/56354555/TSQL05_P03_C01_L05.wmv
http://rapidshare.com/files/56354232/TSQL05_P03_C01_L06.wmv
http://rapidshare.com/files/56354106/TSQL05_P03_C01_L07.wmv
http://rapidshare.com/files/56354127/TSQL05_P03_C01_L08.wmv
http://rapidshare.com/files/56354582/TSQL05_P03_C01_L09.wmv
http://rapidshare.com/files/56354132/TSQL05_P03_C01_L10.wmv
http://rapidshare.com/files/56354583/TSQL05_P03_C01_L11.wmv
http://rapidshare.com/files/56354124/TSQL05_P03_C01_L12.wmv
http://rapidshare.com/files/56354077/TSQL05_P03_C01_L13.wmv

http://rapidshare.com/files/56353102/TSQL05_P03_C02_L00.wmv
http://rapidshare.com/files/56352910/TSQL05_P03_C02_L01.wmv
http://rapidshare.com/files/56353952/TSQL05_P03_C02_L02.wmv
http://rapidshare.com/files/56352842/TSQL05_P03_C02_L03.wmv
http://rapidshare.com/files/56352233/TSQL05_P03_C02_L04.wmv
http://rapidshare.com/files/56352925/TSQL05_P03_C02_L05.wmv
http://rapidshare.com/files/56354045/TSQL05_P03_C02_L06.wmv
http://rapidshare.com/files/56353245/TSQL05_P03_C02_L07.wmv

http://rapidshare.com/files/56352185/TSQL05_P03_C03_L00.wmv
http://rapidshare.com/files/56353647/TSQL05_P03_C03_L01.wmv
http://rapidshare.com/files/56353444/TSQL05_P03_C03_L02.wmv
http://rapidshare.com/files/56352616/TSQL05_P03_C03_L03.wmv
http://rapidshare.com/files/56354781/TSQL05_P03_C03_L04.wmv
http://rapidshare.com/files/56352812/TSQL05_P03_C03_L05.wmv
http://rapidshare.com/files/56353743/TSQL05_P03_C03_L06.wmv

http://rapidshare.com/files/56352734/TSQL05_P03_C04_L01.wmv
http://rapidshare.com/files/56354622/TSQL05_P03_C04_L02.wmv
http://rapidshare.com/files/56354426/TSQL05_P03_C04_L03.wmv
http://rapidshare.com/files/56354457/TSQL05_P03_C04_L04.wmv

http://rapidshare.com/files/56352838/TSQL05_P03_C05_L01.wmv
http://rapidshare.com/files/56353179/TSQL05_P03_C05_L03.wmv

Total Training for Microsoft® Excel® 2007: Advanced

Total Training for Microsoft® Excel® 2007: AdvancedNow that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.


Lesson 1: SUMMARIZING DATA (58 min)
1. Advanced Subtotals
2. Formatting the Subtotal Rows
3. Adding and Copying with Subtotals
4. Consolidating Data
5. Introducing the SUMIF Command
6. Working with the SUMIF Command
7. Using Array Formulas
8. Looking at AutoSum Tricks
9. Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES (52 min)
1. Creating a Pivot Table
2. Rearranging Fields in a Pivot Table
3. Explaining the Report Layout Options
4. Using the Report Filters Feature
5. Using Top 10 & Date Filters
6. Handling Blank Cells
7. Drilling Down in the Pivot Table
8. Sorting a Pivot Table
9. Formatting a Pivot Table
10. Creating Custom Formats
11. Explaining the Grouping Options
12. Adding Formulas to a Pivot Table
13. Changing a Calculation in a Pivot Table
14. Replicating a Pivot Table
15. Counting with a Pivot Table
16. Using Pivot Charts

Lesson 3: CHARTING IN EXCEL (75 min)
1. Charts Refresher
2. Moving, Sizing & Copying Charts
3. Formatting Charts
4. Formatting a Series
5. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
7. Show a Time Series with Column or Line Charts
8. Using Combination Charts
9. Using Line Chart Accessories
10. Using Bar Charts to Show Comparisons
11. Using Component Charts
12. Using Correlation Charts
13. Exploring Other Charts
14. Chart Lies Revealed & Advanced Chart Types
15. Creating a Custom Layout

Lesson 4: GETTING VISUAL (28 min)
1. Using Conditional Formatting
2. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
4. Using SmartArt Functions
5. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS (85 min)
1. Using Goal Seek to Find an Answer
2. Auditing Formulas
3. Shrinking the Formula Bar
4. Understanding Errors
5. Joining Text Columns
6. Using Custom Formatting Codes
7. Pasting Values
8. Using Paste Special
9. Breaking Apart Text
10. Converting Text to Numbers
11. Using Date Functions
12. Using Bizarre Date Functions
13. Using Exponents
14. Using the VLOOKUP Function
15. Using Index Match
16. Using the Offset Function
17. Using the Convert Function
18. Looking at Interesting but Obscure Functions
19. Using the Rand Function
20. Working with Regression
21. Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS (18 min)
1. Displaying the Developer Tab
2. Recording a Simple Macro
3. Simplifying the Macro
4. Recording Using Relative References

Lesson 7: TIPS & TRICKS (28 min)
1. Showing Off New Tips in Excel 2007
2. Tips for Handling Worksheets
3. Using Excel as a Word Processor
4. Miscellaneous Tips
5. Validating Data
6. Changing Text Entry Direction
7. Using Speak Cells
8. Final Comments & Credits

http://rapidshare.com/files/57708195/_M1XL07_P01_C01_L00.mov
http://rapidshare.com/files/57711904/_M1XL07_P01_C01_L01.mov
http://rapidshare.com/files/57711925/_M1XL07_P01_C01_L02.mov
http://rapidshare.com/files/57711636/_M1XL07_P01_C01_L03.mov
http://rapidshare.com/files/57710370/_M1XL07_P01_C01_L04.mov
http://rapidshare.com/files/57711434/_M1XL07_P01_C01_L05.mov
http://rapidshare.com/files/57711772/_M1XL07_P01_C01_L06.mov
http://rapidshare.com/files/57711263/_M1XL07_P01_C01_L07.mov
http://rapidshare.com/files/57711759/_M1XL07_P01_C01_L08.mov
http://rapidshare.com/files/57711482/_M1XL07_P01_C01_L09.mov
http://rapidshare.com/files/57706513/_M1XL07_P01_C02_L00.mov
http://rapidshare.com/files/57709323/_M1XL07_P01_C02_L01.mov
http://rapidshare.com/files/57708563/_M1XL07_P01_C02_L02.mov
http://rapidshare.com/files/57710467/_M1XL07_P01_C02_L03.mov
http://rapidshare.com/files/57711673/_M1XL07_P01_C02_L04.mov
http://rapidshare.com/files/57710307/_M1XL07_P01_C02_L05.mov
http://rapidshare.com/files/57710303/_M1XL07_P01_C02_L06.mov
http://rapidshare.com/files/57708818/_M1XL07_P01_C02_L07.mov
http://rapidshare.com/files/57709391/_M1XL07_P01_C02_L08.mov
http://rapidshare.com/files/57710239/_M1XL07_P01_C02_L09.mov
http://rapidshare.com/files/57708951/_M1XL07_P01_C02_L10.mov
http://rapidshare.com/files/57711580/_M1XL07_P01_C02_L11.mov
http://rapidshare.com/files/57711181/_M1XL07_P01_C02_L12.mov
http://rapidshare.com/files/57708371/_M1XL07_P01_C02_L13.mov
http://rapidshare.com/files/57707895/_M1XL07_P01_C02_L14.mov
http://rapidshare.com/files/57708347/_M1XL07_P01_C02_L15.mov
http://rapidshare.com/files/57708825/_M1XL07_P01_C02_L16.mov
http://rapidshare.com/files/57705936/_M1XL07_P01_C03_L00.mov
http://rapidshare.com/files/57711013/_M1XL07_P01_C03_L01.mov
http://rapidshare.com/files/57708346/_M1XL07_P01_C03_L02.mov
http://rapidshare.com/files/57711721/_M1XL07_P01_C03_L03.mov
http://rapidshare.com/files/57709112/_M1XL07_P01_C03_L04.mov
http://rapidshare.com/files/57711184/_M1XL07_P01_C03_L05.mov
http://rapidshare.com/files/57709304/_M1XL07_P01_C03_L06.mov
http://rapidshare.com/files/57712206/_M1XL07_P01_C03_L07.mov
http://rapidshare.com/files/57711871/_M1XL07_P01_C03_L08.mov
http://rapidshare.com/files/57709388/_M1XL07_P01_C03_L09.mov
http://rapidshare.com/files/57710296/_M1XL07_P01_C03_L10.mov
http://rapidshare.com/files/57712067/_M1XL07_P01_C03_L11.mov
http://rapidshare.com/files/57711917/_M1XL07_P01_C03_L12.mov
http://rapidshare.com/files/57712003/_M1XL07_P01_C03_L13.mov
http://rapidshare.com/files/57711675/_M1XL07_P01_C03_L14.mov
http://rapidshare.com/files/57708627/_M1XL07_P01_C03_L15.mov
http://rapidshare.com/files/57713221/_M1XL07_P01_C04_L00.mov
http://rapidshare.com/files/57717198/_M1XL07_P01_C04_L01.mov
http://rapidshare.com/files/57716913/_M1XL07_P01_C04_L02.mov
http://rapidshare.com/files/57717568/_M1XL07_P01_C04_L03.mov
http://rapidshare.com/files/57717392/_M1XL07_P01_C04_L04.mov
http://rapidshare.com/files/57717784/_M1XL07_P01_C04_L05.mov
http://rapidshare.com/files/57715892/_M1XL07_P01_C04_L06.mov
http://rapidshare.com/files/57713218/_M1XL07_P01_C05_L00.mov
http://rapidshare.com/files/57717596/_M1XL07_P01_C05_L01.mov
http://rapidshare.com/files/57717902/_M1XL07_P01_C05_L02.mov
http://rapidshare.com/files/57714247/_M1XL07_P01_C05_L03.mov
http://rapidshare.com/files/57717344/_M1XL07_P01_C05_L04.mov
http://rapidshare.com/files/57716785/_M1XL07_P01_C05_L05.mov
http://rapidshare.com/files/57714362/_M1XL07_P01_C05_L06.mov
http://rapidshare.com/files/57716382/_M1XL07_P01_C05_L07.mov
http://rapidshare.com/files/57714543/_M1XL07_P01_C05_L08.mov
http://rapidshare.com/files/57716839/_M1XL07_P01_C05_L09.mov
http://rapidshare.com/files/57716311/_M1XL07_P01_C05_L10.mov
http://rapidshare.com/files/57717411/_M1XL07_P01_C05_L11.mov
http://rapidshare.com/files/57717634/_M1XL07_P01_C05_L12.mov
http://rapidshare.com/files/57714889/_M1XL07_P01_C05_L13.mov
http://rapidshare.com/files/57717801/_M1XL07_P01_C05_L14.mov
http://rapidshare.com/files/57715769/_M1XL07_P01_C05_L15.mov
http://rapidshare.com/files/57715678/_M1XL07_P01_C05_L16.mov
http://rapidshare.com/files/57715912/_M1XL07_P01_C05_L17.mov
http://rapidshare.com/files/57717397/_M1XL07_P01_C05_L18.mov
http://rapidshare.com/files/57716998/_M1XL07_P01_C05_L19.mov
http://rapidshare.com/files/57717679/_M1XL07_P01_C05_L20.mov
http://rapidshare.com/files/57716372/_M1XL07_P01_C05_L21.mov
http://rapidshare.com/files/57713789/_M1XL07_P01_C06_L00.mov
http://rapidshare.com/files/57716424/_M1XL07_P01_C06_L01.mov
http://rapidshare.com/files/57717307/_M1XL07_P01_C06_L02.mov
http://rapidshare.com/files/57716204/_M1XL07_P01_C06_L03.mov
http://rapidshare.com/files/57717956/_M1XL07_P01_C06_L04.mov
http://rapidshare.com/files/57713691/_M1XL07_P01_C07_L00.mov
http://rapidshare.com/files/57716403/_M1XL07_P01_C07_L01.mov
http://rapidshare.com/files/57715904/_M1XL07_P01_C07_L02.mov
http://rapidshare.com/files/57715782/_M1XL07_P01_C07_L03.mov
http://rapidshare.com/files/57717110/_M1XL07_P01_C07_L04.mov
http://rapidshare.com/files/57717442/_M1XL07_P01_C07_L05.mov
http://rapidshare.com/files/57716678/_M1XL07_P01_C07_L06.mov
http://rapidshare.com/files/57717489/_M1XL07_P01_C07_L07.mov
http://rapidshare.com/files/57717302/_M1XL07_P01_C07_L08.mov