北美职通卡重磅暑期SQL集训课程
北美职通卡重磅暑期SQL集训课程
$400.00 – $660.00
65 Students |
Duration: 9 Classes |
秋招在即!还在紧张地找工作?投了无数简历没有回应?暑假闲得有些烦了?小伙伴们都回国了没有人一起浪了?你还在等什么,赶紧利用起暑期时间,赶紧给简历上添一个必不可少的技能吧,提升你的行业竞争力!
马云说:“人类正在从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在金融和市场营销领域中的应用
课程目标:
在精心打造的九课时的学习后,你将会熟练掌握:
- 核心SQL语句(statement)及关键词(keyword)
- 组合子句及操作符(operators)
- 数据的检索(select),筛选(filter),与排序(order)的方法
- 聚集函数(aggregate function)的使用,分组数据(group by)的技巧
- SQL基本的联结(join)
- 数据和表的插入,更新,删除
- SQL在金融,市场,科技(advanced课程)等实际项目中的使用思路
- SQL面试基本题型的应对技巧
- 视图(view), 存储过程(stored procedure),索引(index)的基本知识 (advanced课程)
- 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.
Level | Class | Topic | Details Covered (keywords are BOLD) |
Basic | 1 | Getting Started:
Understanding SQL Understanding Database
SELECT-FROM-WHERE: Retrieving Data Filtering Data
|
l What is SQL? What is RDBMS?
l Download SQL platform and open sample database l Get familiar with the tables l Identify Primary/Foreign Key l The SELECT statement (SELECT *) l Case sensitivity l Retrieving column(s) l Liming Results (TOP) l The WHERE statement l Ordering data (ORDER BY, ASC, DESC) l Making comment # |
Basic | 2
|
Manipulating Data:
Operators Calculated Fields Summarizing Data Grouping Data Subqueries
|
l Logic Operators: BETWEEN, IN
l Comparison Operators: =, <, > l Conjunctive Operators: AND, OR l Arithmetic Operators: +,-, *, / l Mathematical Calculations: ABS, ROUND, SQRT l Aggregate Functions: COUNT, SUM, MAX, MIN AVG l The GROUP BY clause l Creating Subqueries l Creating combined queries (UNION)
|
Basic | 3 | Play with the Tables:
Join Tables Insert/Update/Delete Data Create/Update/Delete Tables
Q&A Prepared with your questions |
Understand different types of Join (JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN)
Creating Alias CREATE/DROP table INSERT/UPDATE/DELETE data |
Basic/Advanced | 4 | How to manipulate equity/stock data in SQL? | Working SQL example in Finance |
Basic/Advanced | 5 | How SQL helps in:
1) User/customer activity analysis 2) Sales data analysis |
Working SQL example in Marketing and Manufacturing |
Basic/Advanced | 6 | Common Interview Questions
& Advice from Big 4 Manager
|
Xi will give Andy a list of questions covered later. |
Advanced | 7 | Advanced SQL
Stored Procedures and more |
Stored procedures
Enhancing performance: INDEX Database security Cursors Normalization Process Oracle |
Advanced | 8
|
How to use SQL queries to generating complex reports based on different requirements? | Working SQL example in IT service |
Advanced | 9 | Common Interview Questions
& Advice from Big 4 Manager
|
Xi will give Andy a list of questions covered later. |
课程报名:
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

Reviews
Average Rating
Detailed Rating
Stars 5 |
|
0 |
Stars 4 |
|
0 |
Stars 3 |
|
0 |
Stars 2 |
|
0 |
Stars 1 |
|
0 |
Add a review Cancel reply
You must be logged in to post a comment.
$400.00 – $660.00
65 Students |
Duration: 9 Classes |
Allen
很好,安迪老师的课一直都很不错,支持支持!
Glover
哇塞,这个是美女导师哎!!!求联系方式~👀
职牛牛
您好,很抱歉我们不提供邂逅,如您对课程有兴趣可以报名学习。感谢您的支持。
Jennifer
SQL 不是很懂,但是周围会SQL 的职位都会Sponsor 工作签证的。安迪老师很有人格很有人格魅力!
Stella Artois
被喊来帮顶一下,SQL超有用的,正需要!反正我报名了
Allen Li
您好,请问之前没有相关基础,现在还能报名吗?谢谢
职牛牛
您好Allen,可以的,我们之前两节基础课的录像回放和课件都提供给我们报名的学员。我们将有专人邮件联系您,请留意您的邮件。感谢您的支持!