Tutorialspoint

Leap Year Sale! Use code FEB10 to get an extra 10% off

Google BigQuery & PostgreSQL : Big Query for Data Analysis

person icon Abhishek And Pukhraj

4

Google BigQuery & PostgreSQL : Big Query for Data Analysis

Master Google BigQuery for data analysis and Become a BigQuery expert. Learn all SQL queries in PostgreSQL & Big Query

updated on icon Updated on Feb, 2024

language icon Language - English

person icon Abhishek And Pukhraj

category icon Business,Business Analytics & Intelligence,Google BigQuery

Lectures -127

Resources -1

Duration -10.5 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

Google BigQuery and PostgreSQL: Big Query For Data Analysis is a carefully designed course with a curriculum that teaches you everything in SQL that you will need for Data analysis in businesses.

The course covers the basic and advanced SQL statements in both PostgreSQL and BigQuery. You are set to understand the concepts practically with business-related examples and case studies.

The course also provides you with ample practice exercises because SQL requires practice. You can use the downloadable resources provided and get your queries answered by the instructor himself.

A Verifiable Certificate of Completion is presented to all students who undertake this online SQL course.

Google BigQuery and PostgreSQL: Big Query For Data Analysis Overview

SQL is the most sought-after skill for Data analysis roles in all companies. So whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need. This complete online SQL course can be completed within a weekend.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade.

Who this course is for:

  • Working Professionals beginning their Data journey
  • Anyone curious to master SQL from beginner to Advanced in a short span of time

Goals

What will you learn in this course:

  • Knowledge of all the essential SQL commands in BigQuery and PostgreSQL
  • Become proficient in SQL tools like GROUP BY, JOINS, and Subqueries
  • Become competent in using sorting and filtering commands in SQL

Prerequisites

What are the prerequisites for this course?

  • Just a PC with any web browser


Google BigQuery & PostgreSQL : Big Query for Data Analysis

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
3 Lectures
  • play icon Welcome to the Course 03:13 03:13
  • play icon Course Flow 06:41 06:41
  • play icon Course Resources
Installation and getting started
3 Lectures
Tutorialspoint
Fundamental SQL statements
26 Lectures
Tutorialspoint
Restore and Back-up
3 Lectures
Tutorialspoint
Selection commands: Filtering
7 Lectures
Tutorialspoint
Selection commands: Ordering
5 Lectures
Tutorialspoint
Alias
2 Lectures
Tutorialspoint
Aggregate Commands
9 Lectures
Tutorialspoint
Group By Commands
5 Lectures
Tutorialspoint
Conditional Statement
2 Lectures
Tutorialspoint
Joins
17 Lectures
Tutorialspoint
Subqueries
3 Lectures
Tutorialspoint
Views and Indexes
5 Lectures
Tutorialspoint
String Functions
15 Lectures
Tutorialspoint
Mathematical Functions
10 Lectures
Tutorialspoint
Date-Time Functions
7 Lectures
Tutorialspoint
Pattern (String) Matching
4 Lectures
Tutorialspoint

Instructor Details

Abhishek and Pukhraj

Abhishek and Pukhraj

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners.
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey.

Founded by Abhishek Bansal and Pukhraj Parikh.

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in  MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek 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.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515