Higher Education

MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462), 1st Edition

  • Faisal Akkawi Northwestern University School of Continuing Studies
  • Kayed Akkawi Robert Morris University
  • Gabriel J. Schofield Northwestern University / Financial Services Industry
  • ISBN-10: 1133131077  |  ISBN-13: 9781133131076
  • 464 Pages
  • Previous Editions: 2005, 2002
  • © 2014 | Published
  • College Bookstore Wholesale Price = $144.00
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.

About

Overview

MCSA GUIDE TO MICROSOFT® SQL SERVER® 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career success. Ideal for formal courses, self-study, or professional reference, this detailed text employs a lab-based approach to help users develop the core knowledge and practical skills they need to master Microsoft SQL Server administration in an enterprise environment and pass Microsoft Certified Solutions Associate Exam 70-462. The text opens with information on the latest version of Microsoft SQL Server, offering step-by-step guidance on selecting an edition and completing initial installation and configuration. Several chapters then explore key topics such as database programming, security, performance tuning, backup and recovery, data integration, and system monitoring. Within each chapter, numerous resources and features reinforce teaching and learning, including learning objectives, summaries of key ideas, hands-on activities, discusssion questions, definitions of important terms, and case studies to provide real-world context.

Features and Benefits

  • This detailed, highly practical text helps prepare users to pass Microsoft Certified Solutions Associate (MCSA) Exam 70-462 and apply their knowledge and skills as Microsoft Networking professionals in an enterprise environment.
  • Abundant resources and features are included in every chapter to facilitate teaching and learning, including learning objectives, summaries of key ideas, hands-on activities, discusssion questions, definitions of important terms, and case studies to provide real-world context.
  • Ideal for formal courses, self-study, or professional reference, this detailed text provides thorough coverage of essential database administration principles and practices, from installation and configuration to programming, security, performance tuning, backup and recovery, data integration, and system monitoring.
  • The authors' clear, concise, and engaging style makes even complex concepts easier to understand, while step-by-step instructions, abundant illustrations, and application activities help users develop their skills quickly and confidently.

Table of Contents

1. Introduction to SQL Server 2012.
2. Deploying SQL Server 2012.
3. Architecture and Configuration.
4. Creating SQL Server 2012 Databases.
5. Transact-SQL Primer.
6. SQL Server Security.
7. Performance Monitoring and Optimization.
8. Backup and Recovery.
9. Extracting, Transforming, and Loading Data.
10. Monitoring SQL Server 2012.
Appendix.
Glossary.
Index.

Meet the Author

Author Bio

Faisal Akkawi

Faisal Akkawi, Ph.D., is Executive Director of Information Systems Programs at Northwestern University School of Continuing Studies. He holds a doctorate in computer science and a master's degree in electrical engineering from Illinois Institute of Technology. Dr. Akkawi is an accomplished educator with experience in classroom instruction, curriculum development, faculty and course scheduling, faculty and student recruitment, and budgetary development. An active researcher, his work focuses on knowledge management, concurrent object-oriented software systems, aspect-oriented technology, and the evolution of technological education. Dr. Akkawi has been honored with two NASA Faculty Fellowships, completing projects within the Avionic Offices of both Johnson Space Center and the Ames Research Center. His fellowship work included designing and implementing a framework used in the Advanced Diagnostic and Advanced Caution and Warning System for the International Space Station (ISS), as well as the Integrated System Health Management (ISHM) Testbed project to develop next-generation technologies for the Crew Exploration Vehicle (CEV), lunar habitats and human missions to Mars.

Kayed Akkawi

Kayed Akkawi. Ph.D., is dean of the Morris Graduate School of Management at Robert Morris University. He holds a doctorate in computer science and a master's degree in electrical engineering from Illinois Institute of Technology (IIT). Dr. Akkawi has extensive teaching experience at the graduate level. His professional projects have included developing a natural language interface for information retrieval and a search engine for accessing large-scale databases, as well as designing a toolkit to measure retrieval accuracy for bilingual information. Dr. Akkawi serves as chair of the educational committee for the Chicago-Amman International Sister Cities Program.

Gabriel J. Schofield

Gabriel J. Schofield, MBA, CFA, has over 20 years of experience as a financial services technology professional. Schofield enjoys applying technology to solve complex business problems and has led teams that have delivered industry-leading solutions for a variety of front and back-office financial applications. Schofield has been a proactive member of several industry groups that define financial data and messaging standards. He has also served as an adjunct faculty member at Northwestern University where he designed and taught graduate-level courses in information systems.