Introduction to SQL

Self-paced, online training

See the full course description at Innovation Enterprise Academy

Course Overview:

SQL is the standard language to query and analyze Big Data in very large and parallel data centers. In this course, we will use the free trial of Google BigQuery as it is (in my opinion) the fastest Data Warehouse in the world with a very competitive and cheap price per query. BigQuery is a close cousin of Dremel, the internal tool at Google that power most of its data, including Google Searches.

In this training, we will have a quick introductory tour of BigQuery, before learning the key elements of SQL: its syntax (e.g. SELECT, FROM, WHERE, HAVING, GROUP BY), its aggregated functions (e.g. AVG, MIN, MAX), and early glimpse of slightly more advanced topics (e.g. upload data, sub-queries).

We will play with training datasets, as well as public datasets from Google BigQuery, for example the list of all Wikipedia changes or the list of all the words used by Shakespeare.

Learning Objectives:

As a non-technical business, project, or team leader, you will get your hands on the basics of SQL - the language to query and analyze data. In the end, our aim is not that you are able to create SQL from scratch, but that you are able to understand what a simple SQL does and how to adjust it for your needs. You will find that SQL is actually not very complicated and that you can run basic SQL queries by yourself to pull data without being dependent on your team of analysts.

Indeed, the course will provide you with documentation containing a large set of examples from which you can pick for your own use cases. Moreover, by enabling all non-technical business, project, and team leaders to run their own simple analysis, you free up the analytics teams to execute more complex analysis and deliver more value-added insights.

About the Course Leader

Partick Deglon

Advanced Analytics | Big Data Executive | Particle Physicist

Partick  Deglon's LinkedIn pagePartick  Deglon's Twitter page

Patrick Deglon is recognized as one of the leading minds at successfully applying advanced technologies to businesses. With 18 years experience driving operation optimization and market share growth for corporations, he has helped lead a number of companies in their transition to the New Economy, and raised the bar in Analytics at some of the biggest names in tech, such as eBay and Motorola Mobility. Having been educated as a Particle Physicist at the University of Geneva, Patrick initially started his career at CERN studying the creation of the universe, authoring 138 scientific publications. As a business leader, Patrick’s first role was with eBay International in Switzerland, where he spent eight years in a number of different roles, most notably as leader of the EU Investment Analytics team and Director of the Global Internet Marketing Analytics organization. In 2003, he was recruited by Google to guide the adoption of Google technologies by Motorola Mobility. Patrick was also tasked with the challenge of leading a major technology area. He is recognized as having raised the bar in Analytics within the company, reaching the level of Senior Director of Engineering. Patrick now works as a consultant, founding Deglon Consulting to help businesses apply his internet vision and advanced analytical tools. Patrick is Governance Fellow accredited with The National Association of Corporate Directors(NACD), and active at both the national level and with the Florida Chapter. His leadership Board roles included Science Faculty Council Chairman at the University of Geneva, and several academic and community Board engagements. He is also an Advisory Board Member at the internet based Bottles Waiting. Patrick is acknowledged for his sound mentoring of talented individuals, many of whom have gone on to become successful start‐up CEO’s.

About the Sponsor

Innovation Enterprise Academy

The Innovation Enterprise Academy is a leadership and management training provider. We offer a range of workshops, immersive onsite programs, online educational programming and OnDemand presentations - all of which are delivered by leading industry experts. They provide tried and tested insights that can be applied to your organisation, delivering immediate, measurable results and giving you the knowledge and skills to confront real world challenges.

University lecture small

Read next:

How Are Higher Education Institutions Using Analytics?