|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-70-464-developing-microsoft-sql-server-2012-da/
课程评论：没有评论
课程名称：Microsoft 70-464 开发 Microsoft SQL Server 2012 数据库 课程概述：本课程专为参与者量身定制，旨在测评其在微调 Microsoft SQL Server 2012 数据库方面的知识和技能。课程面向数据库开发人员，帮助他们在组织内部构建和实施数据库，并确保数据的高可用性。参与者将学习创建数据库文件、数据类型、表、规划和优化索引、实施数据完整性、视图、存储过程和函数的管理，以及事务和锁的管理等任务。主要职责包括：优化和调整查询，创建和修改索引及存储过程，维护数据库完整性，优化索引策略，创建和修改表，维护索引，以及创建和修改约束。 本培训课程为参加 Microsoft 考试 70-464 做好准备，涵盖以下领域所需的知识和技能： - 创建和修改表（复杂语句） - 设计、实施和故障排除安全性 - 设计锁粒度级别 - 维护索引 - 实施数据类型 - 创建和修改约束（复杂语句） - 处理 XML 数据 - 编写自动化脚本 - 设计和实施存储过程 - 设计 T-SQL 表值和标量函数 - 创建、使用和修改用户定义的函数（UDFs） - 创建和修改视图（复杂语句） - 表的设计与并发设计 - 创建和修改索引 - 设计数据完整性 - 明确和隐含事务的设计 - 优化和调整查询 - 故障排除和解决性能问题 - 优化索引策略 - 捕获和分析执行计划 - 收集性能和系统信息 我们致力于提供优质的课程大纲，确保您获得成功所需的培训和知识。
This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases. This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks. Primary responsibilities may include: Optimizing and tuning queries.Creating and altering indexes and stored procedures.Maintaining database integrity.Optimizing indexing strategies.Creating and altering tables.Maintaining indexes.Creating and modifying constraints. This training course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.This course will provide all the skills and knowledge for the following areas: 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.
