
Product Description
In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.
Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.
Step-by-step instructions carefully walk you through the most common SQL tasks.
Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.
Notes and Tips point out shortcuts and solutions.
New terms are clearly defined and explained.
Learn how to…
Use SQL-2003, the latest standard for the Structured Query Language
Design and deploy efficient, secure databases
Build advanced queries for information retrieval
Sort, group, and summarize information for best presentation
Tune databases and queries for maximum performance
Understand database administration and security techniques
For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems.
Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University—Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems.
Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles.
http://rapidshare.com/files/168278178/Sams.Teach.Yourself.SQL.in.24.Hours.4th.Edition.Jun.2008.pdf
Network Warrior provides a thorough and practical introduction to the entire network infrastructure, from cabling to the routers. What you need to learn to pass a Cisco certification exam such as CCNA and what you need to know to survive in the real world are two very different things. The strategies that this book offers weren ‘t on the exam, but they ‘re exactly what you need to do your job well.
Written by networking veteran with 20 years of experience, Network Warrior provides a thorough and practical introduction to the entire network infrastructure, from cabling to the routers. What you need to learn to pass a Cisco certification exam such as CCNA and what you need to know to survive in the real world are two very different things. The strategies that this book offers weren ‘t on the exam, but they ‘re exactly what you need to do your job well.
Network Warrior takes you step by step through the world of hubs, switches, firewalls, and more, including ways to troubleshoot a congested network, and when to upgrade and why. Along the way, you ‘ll gain an historical perspective of various networking features, such as the way Ethernet evolved. Based on the author ’s own experience as well as those he worked for and with, Network Warrior is a Cisco-centric book, focused primarily on the TCP/IP protocol and Ethernet networks — the realm that Cisco Systems now dominates.
TABLE OF CONTENT:
Part 1 - Hubs, Switches, and Switching
Part 2 - Routers and Routing
Part 3 - Multilayer Switches
Part 4 - Telecom
Part 5 - Security and Firewalls
Part 6 - Server Load Balancing
Part 7 - Quality of Service
Part 8 - Designing Networks
Download here
password:knowfree.net