email us
 info@pcworkshopslondon.co.uk
contact us
 020-7164-6359

Google BigQuery Course Webinar

Book - FAQ'S - Bespoke Courses
Google BigQuery Course Webinars

BigQuery Conversion:

For SQL Users Only
Data types, Query Basics
Aggregates, Joins
Stored Procedures, Functions
Differences discussed

1-Hour Training Voucher

BigQuey SQL Basics:

Filtering and sorting data
Expression queries
Group by, Aggregates and Having
Inner, left and right joins

1-Hour Training Voucher

BigQuery Built-in Functions:

String functions
Math functions
Date and Time Functions

1-Hour Training Voucher

BigQuery Procedures:

CTE Queries and Subqueries
Views
Stored Procedures
User Defined Functions

1-Hour Training Voucher

BigQuery 1 Hour Webinar:

1-Hour Training

This BigQuery Conversion course is for users of SQL.
We cover the interface and lincencing differences, and additional capabilities. Highlights of BigQuery.
We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are.
You would be able to move to this platform easily.

BigQuery 1 Hour Webinar

Topics Covered
  • Data Types
  • Where clauses
  • Expressions
  • Aggregate, Group by, Having
  • Joins, Combine queries
  • Date Functions
  • CTE Tables, Subqueries, Correlated Subqueries
  • Stored Procedures and User defined Functions
How to book
1 Hour Training Ideas, SQL

SQL Procedures:

CTE Queries
Views and Table Variables
Stored Procedures
Custom Functions

Database design:

Database normalization
Keys, datatypes, etc.
Relationships
UML Models

SQL Built-in Functions:

String functions
Math functions
Date and Time Functions

SQL Query Basics:

Filtering and sorting data
Expression queries
Group by, Aggregates and Having
Inner, left and right joins
1 Hour Training Ideas, Coding

Java OOP:

Functions, Methods
Classes, Objects
Inheritance, Override, Overload
Constructors

Java Data Structures

Generics, Wrapper classes
Arrays vd Array Lists
Collections: Sets, Maps, Tree

Python Dataframes:

Create dataframes
Slice dataframes
Filter, sort and group data
Edit data

Python Numpy:

Numpy examples
Numpy arrays, array manipulation
Numpy string, math functions
Numpy statistical functions

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.
About Us
  • About PCWorkshops
    •
  • Awards
    •
  • Locations
    •
  • Terms and Conditions
    •
  • Contact Us
    •
  • Client Comments
    •
    Quick Links
  • All Courses
    •
  • Python Courses
    •
  • Java Courses
    •
  • SQL Courses
    •
  • Database Courses
    •
  • MS Project Courses
    •
    Contact Us
  • Call: 020-7164-6359
  • Email: training@pcworkshopslondon.co.uk
    • Connect with Us

    Copyright © PCWorkshops 2019. All Rights Reserved.