Sumario: | More than 19 hours of video instruction to help you learn and master the skills necessary to pass Exam 70-762: Developing SQL Databases, required for the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development certification. Overview Through detailed presentations and hand-on demos, this complete video course guides you through all the concepts and skills you’ll need to manage data effectively with SQL Server 2016 and prepare for Microsoft Exam 70-762 toward your MCSA certification. SQL Server expert and Microsoft Certified Trainer Marilyn White presents nearly 20 hours of video lessons fully aligned with Microsoft’s official exam topics, including 69 video lab walk-through demos with downloadable .sql files based on the WideWorldImporters and AdventureWorks2016CTP3 Databases‚ÄìMicrosoft’s sample databases for SQL Server 2016 for extensive realistic practice. Topics include Design and Implement a Relational Database Schema Design and Implement Indexes Design and Implement Views Implement Columnstore Indexes Ensure Data Integrity with Constraints Create Stored Procedures Create Triggers and User-Defined Functions Implement Transactions Manage Isolation Levels Optimize Concurrency and Locking Behavior Implement Memory-Optimized Tables and Native Stored Procedures Optimize Statistics and Indexes Analyze and Troubleshoot Query Plans Manage Performance for Database Instances Monitor and Trace SQL Server Baseline Performance Metrics About the Instructor Marilyn White has more than 20 years of experience in Information Technology and has worked with Microsoft Server products as a Microsoft Certified Trainer (MCT) for more than 18 years, spending most of that time specializing in SQL Server and SharePoint products. Besides working in the industry she holds Microsoft certifications in server and database development and administration. She is the owner of White & White Consulting, a New Jersey-based consultancy specializing in systems training and solutions. With a master's degree in education and a passion for learning, Marilyn began teaching computer science in New Jersey's schools and colleges. While teaching, she decided to branch out to both the government and private sectors, specializing in designing database, programming, and systems solutions to support the growing needs of her customers. She has been training and implementing Microsoft technologies for customers throughout North America. An early achiever on b...
|