Google BigQuery & PostgreSQL Course : 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 Apr, 2024
Language - English
Business,Business Analytics & Intelligence,Google BigQuery
Lectures -127
Resources -1
Duration -10.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ 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
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Welcome to the Course
03:13
03:13
-
Course Flow
06:41
06:41
-
Course Resources
Installation and getting started
3 Lectures
Fundamental SQL statements
26 Lectures
Restore and Back-up
3 Lectures
Selection commands: Filtering
7 Lectures
Selection commands: Ordering
5 Lectures
Alias
2 Lectures
Aggregate Commands
9 Lectures
Group By Commands
5 Lectures
Conditional Statement
2 Lectures
Joins
17 Lectures
Subqueries
3 Lectures
Views and Indexes
5 Lectures
String Functions
15 Lectures
Mathematical Functions
10 Lectures
Date-Time Functions
7 Lectures
Pattern (String) Matching
4 Lectures
Instructor Details
Abhishek and Pukhraj
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now