时间：2月1日(周六)2:30pm；2月8日(周六)4:00pm

 
【讲座内容】很多从事数据分析，金融分析，IT的朋友，比如Financial Analysis、SAS、SPSS、Crystal Report 、Access、QA 或Excel 。学完之后发现现在越来越多的高薪数据分析工作不仅需要具备以上分析软件技能还需具备SQL技能。这使很多拥有SAS或其他分析软件知识的朋友对很多好工作望而却步，总是觉得“瘸了一条腿”。QA 以及BA人员经常需要能够在SQL SERVER数据库中进行数据处理，模拟测试数据，对测试的CASE进行验证，等等。
 
为了帮助大家解决这个问题，让大家快速掌握SQL Server的基础知识，学习现实工作中解决问题的方法，维多利亚本周特邀SQL名师Mr.Liu为大家带来大型免费讲座：SQL Foundation-金融分析以及数据分析师求职人士必备技能！希望可以为正在找工作的朋友增加信心，自如的应答面试中的SQL Server相关问题，使觉得自己“瘸腿”的朋友重拾信心，步履矫健的快速找到心仪的工作。不论您是Developer，还是QA，不论您是金融人员，还是数据分析人员，都是不可不听的好讲座，有点有面，有理论有实践，一定能带给你惊喜！
 
 
【主讲人】Mr.Liu；计算机软件专业毕业，MCITP-DBA证书，拥有10多年北美大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统，AT&T全美联机系统的Senior Consultant，加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计，复杂数据结构的应用，企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解，所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。

SQL Foundamental证书经验班
(Introduction to SQL Foundamental)
公开课：2月1日(周六)2:30pm；2月8日(周六)4:00pm
第一次课：2月14日(周五)7:00pm，以后固定在每周五7pm-10pm 

 
【课程内容】
IT,数据分析，金融分析师求职和工作中常用的SQL知识讲解。适合正在找SAS，Data Analysis，Data warehouse，.NET，QA方面工作的人士
-Create database objects
-Work with data
-Modify data
-Troubleshoot and optimize
 
【授课老师】Mr.Liu；

SQL Databse 2008/2012实战班
(SQL Database 2008/2013 Hands-On)
公开课：

第一次课：Coming Soon
 

【课程内容】
1.安装和升级数据库服务器，以及应用程序工具；
2.数据库设计系统存储方案，并制定未来的存储需求计划；
3.根据开发人员的反馈信息，必要的时候，修改数据库的结构；
4.登记数据库的用户，维护数据库的安全性；
5.控制和监控用户对数据库的存取访问；
6.监控和优化数据库的性能；
7.制定数据库备份计划，灾难出现时对数据库信息进行恢复；
8.维护适当介质上的存档或者备份数据；备份和恢复数据库等。
 
【授课老师】Mr.Liu；

Microsoft released SQL Server 2012 on April 2012, and soon it has become the most favorite product for IT professionals in the world. People have been exciting the revolutions the new generation of Microsoft data solution product has brought, and the improvements and enhancements on the existing features from its older version as well.

SQL Server 2012 is Microsoft’s latest cloud-ready information platform. Organizations can use SQL Server 2012 to efficiently protect, unlock, and scale the power of their data across the desktop, mobile device, datacenter, and either a private or public cloud.

SQL Server 2012 brings in a lot of new features, which make management and maintenance of High Availability, High Performance and High Security much easier, more flexible, more secured and much more powerful.

 SQL Server 2012 has made a strong impact on organizations worldwide with its significant capabilities. It provides organizations with mission-critical performance and availability, as well as the potential to unlock breakthrough insights with pervasive data discovery across the organization. By all means, SQL Server 2012 delivers a variety of hybrid solutions you can choose from.

By implementing their Big Data solution built on SQL Server 2012, organizations now can develop and deploy applications and database solutions on traditional non-virtualized environments, on appliances, and in on-premises private clouds or off-premises public clouds. Moreover, these solutions can easily integrate with one another, offering a fully integrated hybrid solution.

The AlwaysOn is introduced in SQL Server 2012 which allows organizations to design and implement their Disaster Recovery solutions with clustered auto-failover and data synchronization with all the existing High Availability requirements merged each other, as a universal solution platform, the new generation of High Availability has been renovated.

ColumnStore Indexes and Enhanced Resource Governor can help DBAs and developers to easily improve the database performance and maintain the most efficient workload on SQL Server 2012 platform. Data-Tier Application and Contained Databases make database installation, transition and migration a lot easier than ever. User-defined Server Role and Enhanced Security Management such as Auditing Enhancement ensure the better and more secured solution provided in SQL Server 2012.

While lots of people are still looking at the new features by studying, analyzing, planning and evaluating the new generation of data solution platform that SQL Server 2012 provides, it is now the time for us to think of practicing, implementing and using the grand product from Microsoft. Let us get started with SQL Server 2012!

【2月1日(周六)Free Seminar安排早知道】
 
上周银行求职讲座反响热烈
本周精彩继续！10年银行HR Manager 亲自告诉您：北美银行招聘原则
1:00pm免费讲座：Scotiabank HR揭秘银行录用标准!

【主讲人】Sherry；2005年Schulich商学院MBA毕业，13年HR工作经验，9年Scotiabank HR Manager，她拥有注册人力资源师（CHRP)证书，作为HR Manager，对于银行的招聘流程非常熟悉，愿意毫无保留分享。
 
【讲座内容】
1.介绍银行各部门职能及各类职位
2.极具针对性的银行找工简历面试剖析(什么样的简历是备受HR Manager青睐的简历)
3.揭秘银行HR MANAGER录用的标准

维多利亚培训中心(Victoria Training Center (Toronto))
订座电话：416-665-1888，Website：www.victoronto.com
地址：200 Consumers Road，Suite 108，M2J 4R4  (位于Consumers夹Sheppard东南角第三座楼，近地铁站，免费停车)
如果您是住在密市附近的朋友，请参考维多利亚密市培训中心网站：www.vicmiss.com；联系电话：905-361-8881