Presents lessons covering exam objectives, practice exercises, real-world scenarios, and practice exams on the accompanying CD-ROM.
Presents lessons covering exam objectives, practice exercises, real-world scenarios, and practice exams on the accompanying CD-ROM.
Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries You also get an exam discount voucher—making this book an exceptional value and a great career investment.
Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012 DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQL Server 2012 Addresses implementing high availability and data distribution Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.
Ace your preparation for Microsoft® Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options.
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. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Prepare for Microsoft Exam 70-762, Developing SQL Databases —and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Design and implement database objects • Implement programmability objects • Manage database concurrency • Optimize database objects and SQL infrastructure This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases About the Exam Exam 70-762 focuses on skills and knowledge for building and implementing databases across organizations and ensuring high levels of data availability. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of modern database development. Exam 70-761 (Querying Data with Transact-SQL) is also required for MCSA: SQL 2016 Database Development. See full details at: microsoft.com/learning
Gain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator. Discover how to: Work with programming practices unique to T-SQL Create database tables and define data integrity Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Implement insert, update, delete, and merge data modification strategies Tackle advanced techniques such as window functions, pivoting and grouping sets Control data consistency using isolation levels, and mitigate deadlocks and blocking Take T-SQL to the next level with programmable objects
Fully updated for Windows Server 2012 R2! Designed to help enterprise administrators develop real-world, job-role-specific skills - this Training Guide focuses on core infrastructure administration for Windows Server 2012 R2. Build hands-on expertise through a series of lessons, exercises, and suggested practices - and help maximize your performance on the job. This Microsoft Training Guide: Focuses on job-role-specific expertise for core infrastructure administration tasks Fully updated for Windows Server 2012 R2, including new practices Provides in-depth, hands-on training you take at your own pace Creates a foundation of skills which, along with on-the-job experience, can be measured by Microsoft Certification exams such as 70-411 Topics include: Deploying and updating Windows Server 2012 R2 Managing account policies and service accounts Configuring name resolution Administering Active Directory Managing Group Policy application and infrastructure Configuring Group Policy settings and preferences Administering network policies Administering remote access Managing file services Monitoring and auditing Windows Server 2012 R2
Prepare for Microsoft Exam 70-486—and help demonstrate your real-world mastery of developing ASP.NET MVC-based solutions. Designed for experienced developers ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Specialist level. Focus on the expertise measured by these objectives: Design the application architecture Design the user experience Develop the user experience Troubleshoot and debug web applications Design and implement security This Microsoft Exam Ref: Organizes its coverage by exam objectives. Features strategic, what-if scenarios to challenge you.
Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.
Prepare for Microsoft Exam 70-346--and demonstrate your real-world mastery of the skills needed to provision, manage, monitor, and troubleshoot Microsoft Office 365 identities and cloud services. Designed for experienced IT pros ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Provision Office 365 Plan and implement networking and security in Office 365 Manage cloud identities Implement and manage identities by using DirSync Implement and manage federated identities (SSO) Monitor and troubleshoot Office 365 availability and usage This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Provides exam preparation tips written by a top trainer, consultant, and sysadmin Assumes you have experience with the Office 365 Admin Center and an understanding of Microsoft Exchange Online, Skype for Business, SharePoint Online, Office 365 ProPlus, and Azure Active Directory
A perfectly crafted prep guide that prepares you for the MCSD 70-483 The MCSD 70-483 exam is the entry-level Microsoft certification exam for C# developers and this must-have resource offers essential coverage of the exam that will test your competency in C# programming. Each chapter covers one of the core subject domains that comprise the exam. Among the authors are experienced trainers who advised Microsoft on the development of its certification programs, affording them a unique understanding of both the objectives and what it takes to master them. This invaluable knowledge is passed to you so that you will not only be prepared to take the exam, but also become a better C# developer Features a step-by-step lab tutorial for each lesson covered in the book, encouraging you to practice what you've just learned in order to reinforce your learning Includes an accompanying website that includes more than 100 simulated test questions and answers Shares solutions to the hands-on labs presented in the book Contains complete sample code Offers a unique author approach that not only teaches you how to answer a set of exam questions but also provides you with an understanding of the underlying concepts and skills needed to succeed as a professional C# programmer MCSD Certification Toolkit is all you need to fully prepare for exam 70-483!
Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-764 Administering a SQL Database Infrastructure certification exam, the first of two exams required for MCSA: SQL 2016 Database Administration certification. Exam Ref 70-764 Administering a SQL Database Infrastructure offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database administration. Coverage includes: Configuring data access and auditing, including encryption, data access, permissions, and more Managing database backup/restore: developing backup strategies, performing backups/restores, and managing database integrity Managing and monitoring SQL Server instances: monitoring database activity and queries; managing indexes and statistics, and monitoring instances Managing high availability and disaster recovery: implementing log shipping, AlwaysOn Availability Groups, and failover cluster instances Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro's job role For more information on Exam 70-764 and the MCSA: SQL Server 2016 Database Administration certification, visit microsoft.com/learning