- 課程詳情
- 上課校區(qū)(1)
課程詳情
認證介紹：
MCSE是指被證明能夠在用Microsoft Windows NT Server 和Microsoft Backoffice服務器產(chǎn)品家庭構(gòu)建的廣泛的計算環(huán)境中進行有效地規(guī)劃、實現(xiàn)、維護和支持信息系統(tǒng)的合格人員。
成為MCSE需要掌握：
1、 網(wǎng)絡基本架構(gòu)的實現(xiàn)和管理--以Windows Server2003為例;
2、 網(wǎng)絡基本架構(gòu)的規(guī)劃和維護--以Windows Server2003為例;
3、活動目錄的規(guī)劃,實現(xiàn)和管理--以Windows Server2003為例;
4、 網(wǎng)絡安全的實現(xiàn)和管理--以Windows Server2003為例;
5、 網(wǎng)絡安全設計；
6、 網(wǎng)絡操作系統(tǒng)管理--以Windows Server2003為例；
7、操作系統(tǒng)的安裝,配置和管理--Windows XP專業(yè)版的安裝,配置和管理.
MCSE認證課程內(nèi)容：
一、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
考試費：3000
G-LAB培訓優(yōu)勢：
教學團隊之：3CCIE講師
考試通過之：CCNA考試、CCNP考試、CCIE考試平均通過率高
：我們提供培訓后免費推薦工作
培訓環(huán)境之：免費的自習教室和健全的補課制度
-
干將東路校區(qū)
地址：蘇州干將東路666號
電話：400-029-0976 轉(zhuǎn) **** 查看號碼
G-LAB資深顧問G-LAB周老師
蘇州G-LAB網(wǎng)絡實驗室 官方咨詢微信 微信號：epp******e_
關于我們 詳情
G-LAB核心優(yōu)勢G-LAB 高端網(wǎng)絡實驗室，涵蓋路由交換、運營商、網(wǎng)絡安全、語音協(xié)作、無線通信、虛擬化、存儲、數(shù)據(jù)中心及微軟等眾多專業(yè)技術(shù)領域。G-LAB機構(gòu)簡介? ? 蘇州競予信息科技有限公司 (以下簡稱：G-Lab)，創(chuàng)立于2015年4月，依靠優(yōu)秀的并極富經(jīng)驗的講師隊伍、強大的教材開發(fā)實力，G-Lab已經(jīng)成為了蘇州市乃至蘇南地區(qū)IT專業(yè)培訓領域，特別是高端網(wǎng)絡培訓的領頭羊。? ? G-Lab擁有電信級的網(wǎng)絡實驗環(huán)境，有多個實驗室，涵蓋路由交換、運營商、網(wǎng)絡安全、語音協(xié)作、視頻會議、無線通信、虛擬化、存儲、數(shù)據(jù)中心、及紅帽系統(tǒng)等眾多專業(yè)技術(shù)領域。? ? G-Lab的專職講師隊伍全部擁有廠商*高級別認證，超過一半講師具備多個CCIE證書。同時，G-Lab的講師也是IT行業(yè)內(nèi)的技術(shù)服務專業(yè)，相關領域?qū)嵺`工作經(jīng)驗平均超過6年。每一門課程都是精心研發(fā)，每為學員都將接受階段性技術(shù)測試，以保障學習進度的合理性機有效性。? ? G-Lab也是一家專業(yè)的信息網(wǎng)絡基礎設施服務和解決方案提供商，專注于幫助客戶規(guī)劃、構(gòu)建、維護和管理網(wǎng)絡基礎設施。為客戶定制提供網(wǎng)絡架構(gòu)、信息安全、融合通信、聯(lián)絡中心、數(shù)據(jù)中心、云計算、應用交付、服務管理等解決方案，能夠為金融、電信、能源、媒體、醫(yī)療等各個領域提供專業(yè)服務。
