【课程简介】

认证介绍：

MCSE是指被证明能够在用MicrosoftWindowsNTServer和MicrosoftBackoffice服务器产品家庭构建的广泛的计算环境中进行有效地规划、实现、维护和支持信息系统的合格人员。

成为MCSE需要掌握：

1、网络基本架构的实现和管理---以WindowsServer2003为例;

2、网络基本架构的规划和维护---以WindowsServer2003为例;

3、活动目录的规划,实现和管理---以WindowsServer2003为例;

4、网络安全的实现和管理---以WindowsServer2003为例;

5、网络安全设计；

6、网络操作系统管理---以WindowsServer2003为例；

7、操作系统的安装,配置和管理---WindowsXP专业版的安装,配置和管理.

MCSE认证课程内容：

一、QueryingMicrosoftSQLServer2012

1）IntroductiontoMicrosoftSQLServer2012

2）GettingStartedwithSQLAzure

3）IntroductiontoT-SQLQuerying

4）WritingSELECTQueries

5）QueryingMultipleTables

6）SortingandFilteringData

7）WorkingwithSQLServer2012DataTypes

8）UsingBuilt-InFunctions

9）GroupingandAggregatingData

10）UsingSubqueries

11）UsingTables

12）UsingSet0perators

13）UsingWindowRanking,0ffsetandAggregateFunctions

14）PivotingandGroupingSets

15）QueryingSQLServerMetadata

16）ExecutingStoredProcedures

17）ProgrammingwithT-SQL

18）ImplementingErrorHandling

19）ImplementingTransactions

20）ImprovingQueryPerformance

二、AdministeringMicrosoftSQLServer2012Databases

1）IntroductiontoSQLServer2012anditsToolset

2）PreparingSystemsforSQLServer2012

3）InstallingandConfiguringSQLServer2012

4）WorkingwithDatabases

5）UnderstandingSQLServer2012RecoveryModels

6）BackupofSQLServer2012Databases

7）RestoringSQLServer2012Databases

8）ImportingandExportingData

9）AuthenticatingandAuthorizingUsers

10）AssigningServerandDatabaseRoles

11）AuthorizingUserstoAccessResources

12）AuditingSQLServerEnvironments

13）AutomatingSQLServer2012Management

14）ConfiguringSecurityforSQLServerAgent

15）MonitoringSQLServer2012withAlertsandNotifications

16）Performing0ngoingDatabaseMaintenance

17）TracingAccesstoSQLServer2012

18）MonitoringSQLServer2012

19）ManagingMultipleServers

20）TroubleshootingCommonSQLServer2012AdministrativeIssues

三、ImplementingaDataWarehousewithMicrosoftSQLServer2012

1）IntroductiontoDataWarehousing

2）DataWarehouseHardware

3）DesigningandImplementingaDataWarehouse

4）CreatinganETLSolutionwithSSIS

5）ImplementingControlFlowinanSSISPackage

6）ImplementingControlFlowinanSSISPackage

7）ImplementinganIncrementalETLProcess

8）IncorporatingDatafromtheCloudintoaDataWarehouse

9）EnforcingDataQuality

10）UsingMasterDataServices

11）ExtendingSQLServerIntegrationServices

12）DeployingandConfiguringSSISPackages

13）ConsumingDatainaDataWarehouse

四、DevelopingMicrosoftSQLServer2012Databases

1）IntroductiontoSQLServer2012anditsToolset

2）WorkingwithDataTypes

3）DesigningandImplementingTables

4）EnsuringDataIntegritythroughConstraints

5）PlanningforSQLServer2012Indexing

6）ImplementingTableStructuresinSQLServer2012

7）ReadingSQLServer2012ExecutionPlans

8）ImprovingPerformancethroughNonclusteredIndexes

9）DesigningandImplementingViews

10）DesigningandImplementingStoredProcedures

11）MergingDataandPassingTables

12）DesigningandImplementingUser-DefinedFunctions

13）CreatingHighlyConcurrentSQLServer2012Applications

14）HandlingErrorsinT-SQLCode

15）RespondingtoDataManipulationviaTriggers

16）ImplementingManagedCodeinSQLServer2012

17）StoringXMLDatainSQLServer2012

18）QueryingXMLDatainSQLServer

19）WorkingwithSQLServer2012SpatialData

20）WorkingwithFull-TextIndexesandQueries

五、DesigningDatabaseSolutionsforMicrosoftSQLServer2012

1）DesigningaDatabaseServerInfrastructure

2）DesigningaLogicalDatabaseSchema

3）DesigningaPhysicalDatabaseImplementation

4）IncorporatingDataFilesintoDatabases

5）TuningDatabasePerformance

6）DesigningDatabaseSecurity

7）PolicyBasedManagement

8）MonitoringServerHealth

9）DesigningaDatabaseBackupSolution

10）AutomatingMulti-ServerMaintenance

11）ManagingSQLServerwithPowerShell

12）ReplicatingData

13）PlanningHighAvailability

考试费：

3000

G-LAB培训优势：

教学团队之最：3CCIE讲师

考试通过之最：CCNA考试、CCNP考试、CCIE考试平均通过率高达96%

就业之最：我们提供培训后免费推荐工作

培训环境之最：免费的自习教室和健全的补课制度