姑苏区计算机网络管理员课程(1)

课程简介：课程详情认证介绍：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 20121）Introduction to Microsoft SQL Server 20122）Getting Started with SQL Azure3） Introduction to T-SQL Querying4）Writing SELECT Queries5）Querying Multiple Tables6）Sorting and Filtering Data7）Working with SQL Server 2012 Data Types8）Using Built-In Functions9）Grouping and Aggregating Data10）Using Subqueries11）Using Table Expressions12）Using Set Operators13）Using Window Ranking, Offset and Aggregate Functions14）Pivoting and Grouping Sets15）Querying SQL Server Metadata16）Executing Stored Procedures17）Programming with T-SQL18）Implementing Error Handling19）Implementing Transactions20）Improving Query Performance二、Administering Microsoft SQL Server 2012 Databases1） Introduction to SQL Server 2012 and its Toolset2）Preparing Systems for SQL Server 20123）Installing and Configuring SQL Server 20124）Working with Databases5）Understanding SQL Server 2012 Recovery Models6）Backup of SQL Server 2012 Databases7）Restoring SQL Server 2012 Databases8）Importing and Exporting Data9）Authenticating and Authorizing Users10）Assigning Server and Database Roles11）Authorizing Users to Access Resources12）Auditing SQL Server Environments13）Automating SQL Server 2012 Management14）Configuring Security for SQL Server Agent15）Monitoring SQL Server 2012 with Alerts and Notifications16）Performing Ongoing Database Maintenance17）Tracing Access to SQL Server 201218）Monitoring SQL Server 201219）Managing Multiple Servers20）Troubleshooting Common SQL Server 2012 Administrative Issues三、Implementing a Data Warehouse with Microsoft SQL Server 20121）Introduction to Data Warehousing2）Data Warehouse Hardware3）Designing and Implementing a Data Warehouse4）Creating an ETL Solution with SSIS5）Implementing Control Flow in an SSIS Package6）Implementing Control Flow in an SSIS Package7）Implementing an Incremental ETL Process8）Incorporating Data from the Cloud into a Data Warehouse9）Enforcing Data Quality10）Using Master Data Services11）Extending SQL Server Integration Services12）Deploying and Configuring SSIS Packages13）Consuming Data in a Data Warehouse四、Developing Microsoft SQL Server 2012 Databases1）Introduction to SQL Server 2012 and its Toolset2）Working with Data Types3） Designing and Implementing Tables4）Ensuring Data Integrity through Constraints5）Planning for SQL Server 2012 Indexing6）Implementing Table Structures in SQL Server 20127）Reading SQL Server 2012 Execution Plans8）Improving Performance through Nonclustered Indexes9）Designing and Implementing Views10）Designing and Implementing Stored Procedures11）Merging Data and Passing Tables12）Designing and Implementing User-Defined Functions13）Creating Highly Concurrent SQL Server 2012 Applications14）Handling Errors in T-SQL Code15）Responding to Data Manipulation via Triggers16） Implementing Managed Code in SQL Server 201217）Storing XML Data in SQL Server 201218）Querying XML Data in SQL Server19）Working with SQL Server 2012 Spatial Data20）Working with Full-Text Indexes and Queries五、Designing Database Solutions for Microsoft SQL Server 20121） Designing a Database Server Infrastructure2）Designing a Logical Database Schema3）Designing a Physical Database Implementation4）Incorporating Data Files into Databases5）Tuning Database Performance6）Designing Database Security7）Policy Based Management8）Monitoring Server Health9）Designing a Database Backup Solution10）Automating Multi-Server Maintenance11）Managing SQL Server with PowerShell12）Replicating Data13）Planning High Availability考试费：3000G-LAB培训优势：教学团队之：3CCIE讲师考试通过之：CCNA考试、CCNP考试、CCIE考试平均通过率高：我们提供培训后免费推荐工作培训环境之：免费的自习教室和健全的补课制度