| Sumario: | 6+ Hours of Video Instruction Help non-DBAs learn the critical skills they need to manage SQL Servers. Description 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 thebasics 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. Skill Level Beginner Intermediate Topics Covered Fully up-to-date for SQL Server 2016 including: The SQL Server 2016 Management tools Updates to SQL Server 2016 Security Guidance for producing better code for communicating with SQL Server Crucial topics like indexing, query plans, and the execution cache Basic skills and knowledge needed to maintain SQL Server Programmability objects in SQL Server and how the use of each is appropriate Relational databases and how to go about accessing and storing data in a relational database Who Should Take this Course? Any developer or admin who has been given the responsibility of managing SQL Server Also a good study resource for IT professionals pursuing SQL Certification Course Requirements Basic IT Skills Intermediate knowledge of Microsoft Windows Understand Windows Services Familiarity with Installing and Managing Applications About LiveLessons Video Training The LiveLessons Video ...
|
|---|
