SQL Server 2017 Administration Inside Out

8+ Hours of Video Instruction A comprehensive guide to provisioning, managing, and securing SQL Server 2017 databases Overview In this video, database analyst and trainer Eric Johnson gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Serve...

Descripción completa

Detalles Bibliográficos
Otros Autores: Johnson, Eric, author (author)
Formato: Video
Idioma:Inglés
Publicado: Microsoft Press 2018.
Edición:1st edition
Colección:Inside out
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631276306719
Descripción
Sumario:8+ Hours of Video Instruction A comprehensive guide to provisioning, managing, and securing SQL Server 2017 databases Overview In this video, database analyst and trainer Eric Johnson gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Server 2017, including running SQL Server on Linux. You also learn how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL. The video wraps up by showing you how to manage data recovery and implement high-availability databases. Throughout the video, Eric explains the concepts and methodologies of managing SQL Server databases and then puts techniques into practice with visual demonstrations. With Eric as your guide, follow his detailed steps and get hands-on practice to become a more experienced--and more efficient-- database adminstrator. About the Instructor Eric Johnson has been working with SQL Server since 1998 when he started doing administration on version 6.5. For over 20 years, Eric has done everything with the product from administrator to development to database design. He has recorded several video tutorials about SQL Server, including Introduction to SQL Server 2016 Integration Services (SSIS) LiveLessons and SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons published by Pearson. Eric has worked with Microsoft on developing their certification exams on SQL Server and was a SQL Server MVP for 5 years. Skill Level All levels Learn How To Install SQL Server administration and development tools Configure server memory and network settings Provision SQL Server databases, including Azure databases Manage user security and permissions Secure servers and data Design SQL Server tables Configure clustered and non-clustered indexes Create and verify backups and restore a database Implement high availability and disaster recovery Who Should Watch This Video These video lessons are for database administrators, architects, and developers, and performance tuning experts Requirements Understanding of the Windows operating system An IT background Previous experience with SQL Server not required
Notas:Title from title screen (viewed March 6, 2018).
Descripción Física:1 online resource (1 video file, approximately 9 hr., 33 min.)