Ebook for free

Physical Metallurgy Fourth Edition (Three Volume Set)

R.W. Cahn, "Physical Metallurgy, Fourth Edition (Three Volume Set)"
North Holland | 1996-02-01 | ISBN 0444898751 | 2888 pages | PDF | 88.4 MB

Download:
| VOL_1 | VOL_2 | VOL_3

Handbook of Natural Gas Transmission and Processing

Chemical Micro Process Engineering: Processing and Plants

Volker Hessel, Holger Lowe, Andreas Muller, Gunther Kolb, "Chemical Micro Process Engineering: Processing and Plants"
Wiley-VCH | 2005-05-06 | ISBN: 3527309985 | 681 pages | PDF | 16,2 MB

Micro process engineering is approaching both academia and industry. With the provision of micro devices, systems and whole plants by commercial suppliers, one main barrier for using these units has been eliminated.
This book focuses on processes and their plants rather than on devices: what is 'before', 'behind' and 'around' micro device fabrication - and gives a comprehensive and detailed overview on the micro-reactor plants and three topic-class applications which are mixing, fuel processing, and catalyst screening. Thus, the book reflects the current level of development from 'micro-reactor design' to 'micro-reactor process design'.

Download:
Link_1
Or
Link_2

Handbook of Chemical Technology and Pollution Control, 3rd Edition, Third Edition by: Martin B. B. Hocking

Handbook of Chemical Technology and Pollution Control, 3rd Edition, Third Edition by: Martin B. B. Hocking
Publisher: Academic Press | 3 edition (18 Jan 2006) | ISBN: 0120887967 | Pages: 830 | PDF | 32.7 MB

The Handbook of Chemical Technology and Pollution Control (3rd Edition) provides a detailed review of the chemistry and operating conditions of many of the present large-scale chemical processes important to our economy and high standards of living. The processes that could lead to emissions affecting our air, soil, and water are considered, together with ways in which it may be possible to reduce or eliminate these pollutants. Focusing on cleaner production concepts without neglecting 'end of pipe' measures. With an increase in the awareness of corporate and social responsibility among business and industry leaders, the pressure to reduce harmful emissions and the desire to increase efficiencies and energy utilization, this book provides an essential resource. Suitable for researchers, practitioners and postgraduate students in the fields of chemical and biochemical engineering and environmental science, as well as government monitoring and regulatory agencies and industry leaders who want to stay one step ahead, this book will be a valuable addition to any library.

* Integrated treatment of chemical technology with emission control chemistry
* Introductory outline of the causes and effects of air and water pollution chemistry
* Outline of the operating features and efficiency of basic emission control devices
* Historical background of developments in industrial chemistry to 2004 in a single volume
* Organized for easy access to chemical technology, new developments, or emission control details
* Referenced to current additional sources of information in each area covered
* Review questions provide working experience with the material provided

Download:
Link_1

Professor Teaches Office 2007

Professor Teaches Office 2007
1.71 GB

Microsoft SQL Server 2005 Administration Tutorials

Microsoft SQL Server 2005 Administration Tutorials SQL Server 2005 is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for a relational database format or XML. By supporting both a relational database format and XML, the SQL Server 2005 database engine provides the flexibility necessary to support the way you work. It also enables you to build and manage highly available, well-performing database software applications that you and your people can use to take your business to the next level.

The SQL Server 2005 data engine lies at the core of this enterprise data management solution. In addition to providing support for relational databases or XML, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your team to build and deploy cost-effective BI solutions with which they can drive data into every corner of your business through scorecards, dashboards, Web services, and mobile devices.

Close integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data—whether stored in a relational database or XML data format.

Download Links

http://rapidshare.com/files/24983389/VTC_SQL_2005.part01.rar
http://rapidshare.com/files/24985577/VTC_SQL_2005.part02.rar
http://rapidshare.com/files/24987576/VTC_SQL_2005.part03.rar
http://rapidshare.com/files/24989714/VTC_SQL_2005.part04.rar
http://rapidshare.com/files/24991684/VTC_SQL_2005.part05.rar
http://rapidshare.com/files/24994063/VTC_SQL_2005.part06.rar
http://rapidshare.com/files/24995105/VTC_SQL_2005.part07.rar
http://rapidshare.com/files/24995423/VTC_SQL_2005.part08.rar

Total Training Microsoft SQL Server Development

Total Training Microsoft SQL Server Development Total 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