曙海教育集团
全国报名免费热线:4008699035 微信:shuhaipeixun
或15921673576(微信同号) QQ:1299983702
首页 课程表 在线聊 报名 讲师 品牌 QQ聊 活动 就业
 
MCSE认证课程

 
  班级规模及环境--热线:4008699035 手机:15921673576( 微信同号)
      每个班级的人数限3到5人,互动授课, 保障效果,小班授课。
  上间和地点
上部份地点:【上海】同济大学(沪西)/新城金郡商务楼(11号线白银路站)【深圳分部】:电影大厦(地铁一号线大剧院站)/深圳大学成教院【北京分部】:北京中山/福鑫大楼【南京分部】:金港大厦(和燕路)【武汉分部】:佳源大厦(高新二路)【成都分部】:领馆区1号(中和大道)【沈阳分部】:沈阳理工大学/六宅臻品【郑州分部】:郑州大学/锦华大厦【石家庄分部】:河北科技大学/瑞景大厦
近开间(周末班/连续班/晚班):2019年1月26日
  实验设备
    ◆小班教学,教学效果好
       
       ☆注重质量☆边讲边练

       ☆合格学员免费推荐工作
       ★实验设备请点击这儿查看★
  质量保障

       1、培训过程中,如有部分内容理解不透或消化不好,可免费在以后培训班中重听;
       2、课程完成后,授课老师留给学员手机和Email,保障培训效果,免费提供半年的技术支持。
       3、培训合格学员可享受免费推荐就业机会。☆合格学员免费颁发相关工程师等资格证书,提升职业资质。专注高端技术培训15年,曙海学员的能力得到大家的认同,受到用人单位的广泛赞誉,曙海的证书受到广泛认可。

部份程大纲
 
  • 一、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

 

-

 

  备案号:沪ICP备08026168号 .(2014年7月11)..............