北美职通卡重磅暑期SQL集训课程

秋招在即！还在紧张地找工作？投了无数简历没有回应？暑假闲得有些烦了？小伙伴们都回国了没有人一起浪了？你还在等什么，赶紧利用起暑期时间，赶紧给简历上添一个必不可少的技能吧，提升你的行业竞争力！

马云说：“人类正在从IT时代进入DT（Data Technology）时代，21世纪必将是DT的世纪！” 作为21世纪的主人，如果再不懂得如何处理数据做数据分析，那你就Out了！

SQL，这三个字母，对于许多人来说或许并不陌生，无论你申请金融、咨询、市场营销、数据分析等职位，无一例外总会出现SQL Required or SQL Preferred的要求。

What is SQL？

SQL（Structured Query Languages）它是一种标准化、结构化的数据库查询和操纵语言。

What can SQL do？

SQL可以用于存取数据以及查询、更新和管理关系数据库系统，同时还可以制作精美统计图表。

SQL不仅在数据分析领域，在金融，市场营销，咨询，销售等众多领域也都有广泛的应用，是当今找工作的必备技能之一。可以说有数据的地方，就需要SQL。

Is SQL difficult?

The answer is absolutely no. 许多同学听到编程二字就忘而却步，实际上SQL是所有编程语言里相对最简单的。它可以在短时间内入门，再加以实践，基本上就没有什么问题了。比如Andy导师在对冲基金公司面试前，仅仅用了2周就初步掌握了SQL。

继暑期四大集训课程收获满满的好评后，应广大小伙伴们的要求，北美职通卡特邀Finance（对冲基金量化数据分析师），IT（四大信息服务主管，项目经理）和Marketing（四大创新团队信息工程师）领域三位行业大牛联合授课，只为让大家全方位无死角地掌握SQL在各个领域的应用。无论你对SQL一无所知，还是略知一二，甚至有了基础，你都可以在我们为你精心打造的9次SQL集训课程里学你想学，取你所需。

课程特色：

• 课程从Basic到Advanced，层次分明，学生选择多元，适合初学者和有基础者
• 三位行业经验丰富的导师联合授课，全方位覆盖金融、市场营销和咨询等行业
• 课程不仅涉及理论，更从实践出发，学练结合，应用性强，运用第三方平台和SQLite进行演练
• 用实例剖析SQL在金融和市场营销领域中的应用

课程目标：

在精心打造的九课时的学习后，你将会熟练掌握：

1. 核心SQL语句(statement)及关键词(keyword)
2. 组合子句及操作符(operators)
3. 数据的检索(select)，筛选(filter)，与排序(order)的方法
4. 聚集函数(aggregate function)的使用，分组数据(group by)的技巧
5. SQL基本的联结（join）
6. 数据和表的插入，更新，删除
7. SQL在金融，市场，科技（advanced课程）等实际项目中的使用思路
8. SQL面试基本题型的应对技巧
9. 视图(view), 存储过程(stored procedure)，索引(index)的基本知识 (advanced课程)
10. SQL面试题高难度题型的应对技巧 （advanced课程）

课程形式：

网络授课，全程录制，每节课后答疑，布置作业，行业案例分析，附导师精美PPT。

导师介绍：

Education： MBA at Johns Hopkins Carey Business School

Experience: Quantitative Data Analyst at Man Group

Andy got an MBA degree from Johns Hopkins Carey Business School. During school, he worked as a Sales Data analyst for 180s, the biggest ear warmer company in the U.S. After graduation, Andy worked as a Risk Analyst for PRA Group, the world biggest non-performing debt company for 6 months. Then, he joined Man Group, the biggest public hedge fund in the world in 2014, where he worked as a Quantitative Data Analyst. His daily role include dealing with big financial data, creating financial models and assisting portfolio managers and researcher with models enhancement by using SQL and SAS. Andy has a strong passion for sharing his experience and helping others to gain their career success.

Education: Information Technology at Cornell

Experience: Quality Assurance Associate, KPMG

Description：Xi is graduated from Cornell University majored in Operations Research and Information Technology, with a minor in business. She is currently working as a quality assurance (QA) associate at KPMG focusing on client-facing tax applications. She is extensively using SQL, R, and many other data analytic tools at her work to manipulate customer data, create specific interactive dashboard/report, conduct market research and evaluate applications. She also worked as a peer-adviser for two years at Cornell Career Service Center, and provided mock interviews, resume critiques, and cover letter critiques to assist over 150 students.

Experience: Senior Project Manager, KPMG

Description：Kevin has over ten years of IT professional experience which expose technical, management and customer service skills, including nine years of experience as a software quality assurance analyst and Scrum Master in tax-application software development. He also has deep experience in working and managing multiple fast-paced projects using scrum and waterfall methodology. Kevin is highly proficient in SQL queries to support root cause analysis and generating complex reports for very complex enterprise-class tax calculation/compliance related projects. He also has been the KPMG interviewer for many years.

课程报名：

Basic Only（Class 1 – Class 6）

Early Bird Package （Ended on July 7, 2016 ）：$360 包含软件安装包，超过30万条数据库，详细的SQL Cheat Sheet, SQL经典教程。

Regular Price：$400 含软件安装包，超过30万条数据库。

Advanced Only：(Class 4 – Class 9)

Early Bird Package （Ended on July 7, 2016 ）：$380 包含软件安装包，超过30万条数据库，详细的SQL Cheat Sheet, SQL经典教程。

Regular Price：$420含软件安装包，超过30万条数据库。

Full Package:

Early Bird Package （Ended on July 7, 2016 ）：$580 包含软件安装包，超过30万条数据库，详细的SQL Cheat Sheet, SQL经典教程。

Regular Price：$660 含软件安装包，超过30万条数据库。

特别优惠：带上一个小伙伴每人立减$20，带上两个小伙伴每人立减30美金。

(BOA直接转账至北美职通卡官方账户andyfan@uscareerpass.com，将有8美金优惠）

如有关于课程方面的疑问，请加微信号GoDears1

About Instructor

Andy Fan

Man Group

Andy got an MBA degree from Johns Hopkins Carey Business School. During school, he worked as a Sales Data analyst for 180s, the biggest ear warmer company in the U.S. After graduation, Andy worked as a Risk Analyst for PRA Group, the world biggest non-performing debt company for 6 months. Then, he joined Man Group, the biggest public hedge fund in the world in 2014, where he worked as a Quantitative Data Analyst.

Reviews