专家授课, 视频重播, 论坛互助, 班会分享, 只需数月, 斩获好工作！USA LaoTu

八月三日世界日报引华儿街日报文：软件工程师和数据库很缺人

SQL Server 2012 DBA Friday 6:00pm-9:00pm


SQL Server 2012 DBA  硅谷专家  多年 经验传授

Introduction to SQL 2012  DBA

6:00pm-9:00pm Friday  08/30 to 10/4   6 weeks

This class will use SQL 2012 as platform and will focus on new features of SQL 2012, although the first half of the lecture will review concept of SQL server DBA in general.

Week1 – SQL 2012 New features overview, SQL editions and licensing, Installation, Upgrade, and Migration Strategies. Main responsibility of SQL DBA – backup/restore, HA/DR, performance tuning, architecture design, new instance deployment.
 
Week2 – SQL Agent – setup and automate SQL Agent jobs, backup and restore databases. SSIS – Transfer data from different data source, linked server, querying remote data source. PerfMon, SQL Profiler.  Optional* SSAS – Business Intelligence.
 
Week3 – High-Availability and Disaster-Recovery.  Database Mirroring, Log Shipping
 
Week4 - Traditional Windows and SQL clustering. Installation and setup. 
Case study - Monitor SQL instance balance in a stacked SQL cluster environment using PowerShell.
 
Week5 - SQL server AlwaysOn Availability Group – architecture, setup, configuration, listener, primary & secondary replica. Combine different HA technologies such as clustering and AlwaysOn. Demo of AG failover.
 
Week6 – SQL server AlwaysOn Availability Group continued - Backup and restore of AlwaysOn AG.

SQL Server 2008/2012 DBA Package $1398 (include 2008/2012 both DBA courses)
SQL Server 2012 DBA          $998  
SQL Server 2008 DBA          $899
Click here: Register course  use Credit Card.

Database Real Project Workshop

Real World Project Workshop:  Saturday  8:00 to 11:00   California Time

8/10  (3 Hours)    Rongrong                -- PL/SQL   
         Clinical Patient Data Processing using cursor and database link. 
8/17  No class
8/24  (3 hours)     Xiaowen / Lily       -- SQL -T-SQL/ Cursor
         Project 1: Use BCP extract data from database with column header 
         Project 2: T-SQL Procedure
         Project 3: How to load more than 1000 excel files into database, VBA Micro, DOS Scripts, SQL, T-SQL Scripts
         Project 4: Real World Order Validation Project T-SQL Procedure
8/31  (3 Hours)    Joe                          --  Crystal Report
9/07  (4 Hours)    Wei / Lisa               --  ETL
9/14  (4 Hours)    Catherine  / Renee   -- SSRS

Registration Price:
General Public: $ 1100
Core Package Student: $799