Rough Cuts / Sneak Peek:
The Rough Cuts/Sneak Peek program provides early access to Pearson video products and is exclusively available to Safari subscribers. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing.
Help non-DBAs learn the critical skills they need to manage SQL Servers.
SQL Server is installed behind many third-party applications and behind Microsoft development tools such as Visual Studio. System administrators and developers alike are increasingly responsible for working with and managing SQL Server with no prior exposure or background. Further, they need to understand the basics of relational databases and technologies, such as indexing and stored procedures, to effectively develop applications. This video covers SQL Server from their perspectives and gives them what they need to manage these instances.
SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons is for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Eric Johnson shows you how to perform the essential DBA tasks with SQL Server 2016, even if you‚Äôve never had any DBA training. In these lessons, you learn at your own pace through realistic hands-on examples that walk you through every step. While these lessons are taught on SQL Server 2016 and use the latest tools and features, most of what you learn can be applied to earlier versions as well. If you are an accidental DBA‚Äìexpected to run Microsoft SQL Server efficiently, reliably, and securely, when nobody ever taught you how--then this is the video for you. From backup/restore to indexing to scheduling to memory management, you get all the personal, practical DBA training you‚Äôll ever need.
About the Instructor
Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is co-founder of Consortio Services, and the company‚Äôs primary Database Technologies Consultant. His background in information technology is diverse‚Äîranging from operating systems and hardware, specialized applications and development, to a fair amount of work on networks. Since IT is really just a way to support business processes, he also acquired an MBA. Eric has almost 20 years of IT experience, with a good number of those dedicated to working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes, and has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. He also does a good deal of writing, including the four-part series "Tour de SQL" published in Redmond magazine, and the book A Developer‚Äôs Guide to Data Modeling for SQL Server (Addison-Wesley, 2008).
Topics CoveredFully up-to-date for SQL Server 2016 including:
Who Should Take this Course?
About LiveLessons Video Training
The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons.