Google Cloud Platform And Bigquery Sql

Simple BigQuery Python SQL queries

What you'll learn
SQL Introduction
Build a SQLite database with Python
Simple BigQuery Ethereum queries
Simple BigQuery Python SQL queries
Requirements
No experience necessary
Description
Buff your skills to keep your job and get a raise in ANY economic climate. This course BUNDLE keeps your skills sharp and your paycheque up!Google Cloud Platform and BigQuery IntroductionSQL IntroductionSimple BigQuery Python SQL queriesSimple BigQuery Ethereum queriesThis masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.Frequently Asked QuestionsHow do I obtain a certificate?Each certificate in this bundle is only awarded after you have completed every lecture of the course.Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.Is this an eBook or videos?The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code.Can't I just learn via Google or YouTube?This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5-course curriculum to take you from absolute beginner to starting a high-paying career.How will I practice to ensure I'm learning?With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you. Try a course today.

Overview

Section 1: Introduction

Lecture 1 00 Course Overview - Ethereum SQL

Section 2: 01 Google Cloud Platform and BigQuery

Lecture 2 01 What Are Google Cloud Platform And Bigquery

Lecture 3 02 Build A Project On Google Cloud Platform

Section 3: 02 Introduction to Blockchain (Prerequisite)

Lecture 4 00 Blockchain Introduction

Lecture 5 01 What Are Blockchains And Distributed Ledgers

Lecture 6 02 What Are Bitcoin And Ethereum

Section 4: 03 Introduction to Python (Prerequisite)

Lecture 7 00. Introduction

Section 5: 03 - 01 Code Python on the Web

Lecture 8 02.02 What If I Get Errors

Lecture 9 02.03 How Do I Terminate a Session

Section 6: 03 - 02 Python Language Fundamentals

Lecture 10 02. Variables

Lecture 11 03. Type Conversion Examples

Lecture 12 04. Operators

Lecture 13 05. Operators Examples

Lecture 14 06. Collections

Lecture 15 07. Lists

Lecture 16 08. Multidimensional List Examples

Lecture 17 09. Tuples Examples

Lecture 18 10. Dictionaries Examples

Lecture 19 11. Ranges Examples

Lecture 20 12. Conditionals

Lecture 21 13. If Statement Examples

Lecture 22 14. If Statement Variants Examples

Lecture 23 15. Loops

Lecture 24 16. While Loops Examples

Lecture 25 17. For Loops Examples

Lecture 26 18. Functions

Lecture 27 19. Functions Examples

Lecture 28 20. Parameters And Return Values Examples

Lecture 29 21. Classes And Objects

Lecture 30 22. Classes Example

Lecture 31 23. Objects Examples

Lecture 32 24. Inheritance Examples

Lecture 33 25. Static Members Example

Lecture 34 26. Summary And Outro

Section 7: 04 SQL Introduction (Prerequisite)

Lecture 35 01 Why You Must Know How To Work With Data

Section 8: 04 - 02 Entity Relationship Modeling (ERM)

Lecture 36 01 How To Read An Er Model

Section 9: 04 - 03 Introduction to databases and relational databases

Lecture 37 01 What Is A Database

Lecture 38 02 What Is A Relational Database

Section 10: 04 - 04 How to build an organized database

Lecture 39 01 How To Design Columns And Data Types

Lecture 40 02 Use Normal Forms To Check Your Design

Section 11: 04 - 05 Build a SQLite database with Python

Lecture 41 01 Build A SQLite Database With Python

Lecture 42 02 Add An Entry To The Table With SQL

Lecture 43 03 Add More Records To The Table

Lecture 44 04 Build A Second Table For Cross-Referencing

Lecture 45 05 Select Rows That Meet Conditions

Section 12: 05 Simple BigQuery Python SQL queries

Lecture 46 01 Find Entries In Big Query Public Dataset

Lecture 47 02 Filter Entries By State Column

Section 13: 06 Simple BigQuery Ethereum queries

Lecture 48 01 Query Tables In Crypto Ethereum Big Query Public Dataset

Lecture 49 02 Select Ethereum Traces By Date

Lecture 50 03 Get Total Ether Supply Each Day

Lecture 51 04 Select Transactions By Address And Timestamp

Section 14: 07 Calculate transaction ratios

Lecture 52 01 Get Zero Transaction Ratio For Blockchain

Lecture 53 02 Get Zero Transaction Ratio For Smart Contracts

Anyone interested in GCP with an Ethereum emphasis