Play Video
Preview this course

Google Big Query

Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query

0 / 5
Rating
0 +
Students
0 Hrs
Duration

499 375

Price

Google Big Query

What you'll learn

Introduction to BigQuery

Understand the core principles behind Google Big Query and how to leverage them for big data analysis

Introduction to SQL

Get started with PostgreSQL and PgAdmin, two of the world's most popular SQL tools. Learn the basic SQL syntax.

Useful BigQuery functions

Master BigQuery's most popular string, mathematical and date-time functions for data analytics.

Data Manipulation

Become competent in using sorting, filtering and grouping commands in BigQuery Learn how to use sub queries.​

Joining data in BigQuery

Join two or three tables together into one, combine tables using set theory, and work with subqueries in BigQuery .

Our Happy Students!

It’s a great learning experience so far, you guys both the database like PgAdmin and Cloud database which is Big Query. I really loved SQL this journey. Thanks!

5/5

Vinit Guru

It was a great journey and from my experience on this course, i am now ready to face a real world challenge. it was a classroom feeling all along.

5/5

Frank Moses

Was Awesome learning SQL with you, everything i needed was expalained. Thank you very much. I joined your Facebook Group and also the Youtube Chanel.

5/5

Ahmed Essaih

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate​

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

Google Big Query - Desc

Course Content

Course Content

Introduction
Installation and getting started
Fundamental SQL statements
Restore and Back-up
Selection commands: Filtering
Selection commands: Ordering
Alias
Aggregate Commands
Group By Commands
Conditional Statement
JOINS
Subqueries
Views and Indexes
String Functions
Mathematical Functions
Date-Time Functions
PATTERN (STRING) MATCHING
Conclusion

Leave a Reply