|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-70-465-designing-database-solutions-for-micros/
课程评论：没有评论
课程名称：Microsoft 70-465: 设计数据库解决方案 课程概述： 本课程旨在帮助参与者评估他们在为Microsoft SQL Server 2012设计数据库解决方案时的知识和技能。课程特别针对数据库专业人士，这些专业人士负责设计和构建数据库解决方案，涉及数据库结构、存储、对象和服务器的创建计划及设计，以及数据库解决方案运行环境的规划。 参与者的主要责任包括但不限于： - 设计数据压缩策略 - 创建数据库模型 - 实现全文搜索策略 - 开发高可用性解决方案 - 制定数据库服务器的维护策略 - 管理自动化策略 - 制定迁移、合并和升级策略 - 设定数据库、模式及对象的安全参数 该培训课程为参与者准备了Microsoft考试70-465，内容包括： - 创建和修改表（复杂语句） - 设计、实施和排除安全问题 - 设计锁定粒度级别 - 维护索引 - 实施数据类型 - 创建和修改约束（复杂语句） - 处理XML数据 - 编写自动化脚本 - 设计和实施存储过程 - 设计T-SQL表值和标量函数 - 创建、使用及修改用户定义函数（UDF） - 创建和修改视图（复杂语句） - 设计表结构 - 针对并发情况进行设计 - 创建和修改索引 - 设计数据完整性 - 针对隐式和显式事务进行设计 - 优化和调优查询 - 排除和解决性能问题 - 优化索引策略 - 捕获和分析执行计划 - 收集性能和系统信息 我们的目标是创建最高质量的课程大纲，确保参与者能够获得成功所需的培训和知识。
This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012. This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing: Data compression strategiesDatabase modelsFull-Text Search strategiesHigh-availability solutionsMaintenance strategy for database serversManagement automation strategiesMigration, consolidation, and upgrade strategiesDatabase, schema, and object security parameters This training course on designing database solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-465: Creating and altering tables (complex statements)Designing, implementing, and troubleshooting securityDesigning the locking granularity levelMaintaining indexesImplementing data typesCreating and modifying constraints (complex statements)Working with XML DataWriting automation scriptsDesigning and implementing stored proceduresDesigning T-SQL table-valued and scalar functionsCreating, using, and altering user-defined functions (UDFs)Creating and altering views (complex statements)Designing tablesDesigning for concurrencyCreating and altering indexesDesigning data integrityDesigning for implicit and explicit transactionsOptimizing and tuning queriesTroubleshooting and resolving performance problemsOptimizing indexing strategiesCapturing and analyzing execution plansCollecting performance and system information We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
