|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learning-path-sql-up-and-running-with-sql-server-2016/
课程评论：没有评论
课程总结：学习路径：SQL：快速掌握 SQL Server 2016 本课程围绕 Microsoft SQL Server 2016 进行深入学习，作为微软数据平台历史上重大的一步，SQL Server 2016 在大数据和数据科学时代为开发人员提供了独特的机会。课程适合管理员、开发者及 DBA，旨在帮助学生掌握 SQL 及 DBMS 的维护和自动化。 课程的亮点包括： - 学习 SQL Server 2016 的最新功能 - 内容丰富、实例详尽的教程，帮助您熟练掌握 SQL 2016 学习之旅将帮助您高效处理、管理和监控 SQL Server 2016，包括： - 设置和配置 SQL Server 2016 虚拟机 - 改善查询性能、创建索引及进行活动监控 - 实施多种认证技术以保护 SQL Server 解决方案 - 制定备份策略，进行完整和差异备份 - 探索系统日志恢复选项以及如何将数据库状态恢复至特定时间点 - 自动化服务器，创建任务和作业，设置操作和通知 - 配置警报和数据库邮件，向用户发送消息 - 深入学习高可用性和灾难恢复，包括数据库镜像、日志传送及可用性组 - 探索服务器和数据复制的不同类型及其应用 完成本课程后，您将成为 SQL Server 2016 的专家。 课程讲师Steve Jones，拥有超过25年的SQL Server开发和管理经验，被广泛认可为SQL Server社区的领军人物。他曾获得微软数据平台MVP称号，定期在技术会议上进行讲演并与社区互动。
Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. If you're an administrator, developer or a DBA and want to learn SOL along with maintaining and automating your DBMS, then go for this Learning Path. Packt's Video Learning Paths are a series of individual video products put together in a logical and stepwise manner such that each video builds on the skills learned in the video before it. The highlights of this Learning Path are: Work with the latest features of the SQL Server 2016 release A comprehensive, example-filled tutorial that helps you to master in SQL 2016 Let's take a quick look at your learning journey. This Learning Path will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. Learn how to secure your SQL Server solution by implementing various authentication techniques. Develop a backup strategy and carry out full database backups as well as differential database backups. Next, you will explore the different options for restoring your system logs, and how to restore your database's state to a specified point in time. From there, you will move on to automating your server. You will learn to create tasks and jobs for your system, and also set up operations and notifications. You will also learn to configure alerts and database emails for sending messages to users. After that, you will dive right into high availability and disaster recovery, where you will database mirroring, log shipping, and availability groups. Finally, you will explore the different types of server and data replication and how they are used. By the end of this Learning Path, you will become an expert in SQL Server 2016. Meet Your Expert: We have combined the best works of the following esteemed author to ensure that your learning journey is smooth: Steve Jones has been working with SQL Server since 1991. He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies. Over the last 25 years, he been very pleased with the enhancements and growth of the platform. He feels that SQL Server is an outstanding database platform well-suited to a wide variety of needs and situations. Steve is a graduate of the University of Virginia. He has been awarded the title of Microsoft Data Platform MVP from 2008 - 2017 for his many contributions to the SQL Server community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server. Steve regularly presents at SQL Saturday conferences and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. He has been a presenter at //build/, the PASS Summit, Dev/IT Connections, VSLive, SQL Bits, SQL Intersection, and many user groups in the U.S.
