IT易学网-IT在线教育交易平台

IT易学网 > 面授 > MCSE

  • 课程简介
  • 讲师介绍
  • 累积评价(0)
  • 该老师还开设以下课程
  • 现在报名更多优惠哦~

    mcse

    微软公司提供的对于网络专业人员的微软系统工程师认证。MCSE是指被证明能够在用Microsoft Windows NT Server 和Microsoft Backoffice服务器产品家庭构建的广泛的计算环境中进行有效地规划、实现、维护和支持信息系统的合格人员。
    成为MCSE需要掌握
    1、 网络基本架构的实现和管理---以Windows Server2003为例;
    2、 网络基本架构的规划和维护---以Windows Server2003为例;
    3、活动目录的规划,实现和管理---以Windows Server2003为例;
    4、 网络安全的实现和管理---以Windows Server2003为例;
    5、 网络安全设计;
    6、 网络操作系统管理---以Windows Server2003为例;
    7、操作系统的安装,配置和管理---Windows XP专业版的安装,配置和管理.


    MCSE认证课程内容:一、Querying MicrosoftSQL Server 2012
    1)Introduction to Microsoft SQL Server 2012
    2)Getting Started with SQL Azure
    3) Introduction to T-SQL Querying
    4)Writing SELECT Queries
    5)Querying Multiple Tables
    6)Sorting and Filtering Data
    7)Working with SQL Server 2012 Data Types
    8)Using Built-In Functions
    9)Grouping and Aggregating Data
    10)Using Subqueries
    11)Using Table Expressions
    12)Using Set Operators
    13)Using Window Ranking, Offset and Aggregate Functions
    14)Pivoting and Grouping Sets
    15)Querying SQL Server Metadata
    16)Executing Stored Procedures
    17)Programming with T-SQL
    18)Implementing Error Handling
    19)Implementing Transactions
    20)Improving Query Performance
    二、Administering Microsoft SQL Server 2012 Databases
    1) Introduction to SQL Server 2012 and its Toolset
    2)Preparing Systems for SQL Server 2012
    3)Installing and Configuring SQL Server 2012
    4)Working with Databases
    5)Understanding SQL Server 2012 Recovery Models
    6)Backup of SQL Server 2012 Databases
    7)Restoring SQL Server 2012 Databases
    8)Importing and Exporting Data
    9)Authenticating and Authorizing Users
    10)Assigning Server and Database Roles
    11)Authorizing Users to Access Resources
    12)Auditing SQL Server Environments
    13)Automating SQL Server 2012 Management
    14)Configuring Security for SQL Server Agent
    15)Monitoring SQL Server 2012 with Alerts and Notifications
    16)Performing Ongoing Database Maintenance
    17)Tracing Access to SQL Server 2012
    18)Monitoring SQL Server 2012
    19)Managing Multiple Servers
    20)Troubleshooting Common SQL Server 2012 Administrative Issues
    三、Implementing a Data Warehouse with Microsoft SQL Server 2012
    1)Introduction to Data Warehousing
    2)Data Warehouse Hardware
    3)Designing and Implementing a Data Warehouse
    4)Creating an ETL Solution with SSIS
    5)Implementing Control Flow in an SSIS Package
    6)Implementing Control Flow in an SSIS Package
    7)Implementing an Incremental ETL Process
    8)Incorporating Data from the Cloud into a Data Warehouse
    9)Enforcing Data Quality
    10)Using Master Data Services
    11)Extending SQL Server Integration Services
    12)Deploying and Configuring SSIS Packages
    13)Consuming Data in a Data Warehouse
    四、Developing Microsoft SQL Server 2012 Databases
    1)Introduction to SQL Server 2012 and its Toolset
    2)Working with Data Types
    3) Designing and Implementing Tables
    4)Ensuring Data Integrity through Constraints
    5)Planning for SQL Server 2012 Indexing
    6)Implementing Table Structures in SQL Server 2012
    7)Reading SQL Server 2012 Execution Plans
    8)Improving Performance through Nonclustered Indexes
    9)Designing and Implementing Views
    10)Designing and Implementing Stored Procedures
    11)Merging Data and Passing Tables
    12)Designing and Implementing User-Defined Functions
    13)Creating Highly Concurrent SQL Server 2012 Applications
    14)Handling Errors in T-SQL Code
    15)Responding to Data Manipulation via Triggers
    16) Implementing Managed Code in SQL Server 2012
    17)Storing XML Data in SQL Server 2012
    18)Querying XML Data in SQL Server
    19)Working with SQL Server 2012 Spatial Data
    20)Working with Full-Text Indexes and Queries
    五、Designing Database Solutions for Microsoft SQL Server 2012
    1) Designing a Database Server Infrastructure
    2)Designing a Logical Database Schema
    3)Designing a Physical Database Implementation
    4)Incorporating Data Files into Databases
    5)Tuning Database Performance
    6)Designing Database Security
    7)Policy Based Management
    8)Monitoring Server Health
    9)Designing a Database Backup Solution
    10)Automating Multi-Server Maintenance
    11)Managing SQL Server with PowerShell
    12)Replicating Data
    13)Planning High Availability
  • Orange

    微软Windows技术专家,MCSE,MCT,Linux系统技术专家,RHCE。网络安全专家,思科认证网络工程师CCNA。专注于x86服务器系统,包括Microsoft Server System、RedHat Linux,网络架构等方面的技术培训与顾问咨询服务。现为专职培训讲师和企业服务咨询顾问。
    5年IT专业服务工作经历, 2年IT培训教学经验。极其丰富的运维及项目经验,使其对理论及技术的理解极为深入、精准。同时,极富条理的思维与激情洋溢的讲授,将繁杂的技术知识与实践技能娓娓道来,清晰连贯,感染了一批又一批的学员。

     

  • 累积评价:0条

    与描述相符 0.0
    0.0
  • < > 共0页

———— 相关面授课程 ————

MCSE 最新课程培训¥5000.00

更多>>
立即注册 认证讲师 在线咨询 ×