Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
BigQuery for Data Analysts online training

BigQuery for Data Analysts



overview


BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you have no infrastructure to manage and don't need a database administrator, use familiar SQL and can take advantage of pay-as-you-go model.

prerequisties

  • Google Cloud Platform Fundamentals
  • Experience with data analysis using SQL
  • Experience with business intelligence, reporting, and data visualization
  • Familiarity with extract, transform, and load (ETL) activities
  • Familiarity with data modeling

Duration

Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • Introduction to BigQuery
    • Examine the current state big data landscape
    • Exploit the cloud for big data
    • Define what is BigQuery
    • Explore BigQuery use cases
  • BigQuery Functional Overview
    • Organize BigQuery projects
    • Store data in BigQuery
    • Leverage BigQuery architecture
    • Interact with BigQuery from the web console and command API
  • BigQuery Fundamentals
    • Define BigQuery table schemas
    • De-normalize relational data structures for efficient processing
    • Execute BigQuery jobs
    • Maximize performance and reduce cost with destination tables and caching
  • Transform, Stage, and Load Data
    • Prepare and transform data for upload into BigQuery
    • Stage and ingest data
    • Load data
  • Pricing and Quotas
    • Understand the BigQuery pricing model
    • Calculate the cost of queries
    • Avoid quota limitations
  • Clauses and Functions
    • Leverage user-defined functions
  • Nested and Repeated Fields
    • Model big data schemas to optimize performance and cost
    • Define nested, repeated, and nested repeated fields using JSON
    • Query nested and repeated fields in BigQuery
  • Tuning Query Performance
    • Explore how the BigQuery architecture impacts query processing
    • Analyze the effects of Join and Group By statements on performance
    • Optimize reads with table decorators and table ranges
    • Diagnose and resolve query performance issues
  • Troubleshooting Errors
    • Recognize common BigQuery SQL errors
    • Prevent resource errors
    • Diagnose HTTP errors
  • Access Control
    • Define access control lists (ACLs) to protect data
    • Understand project and dataset access controls
    • Apply views for row-level security
  • Exporting Data
    • Export data for backups and for use with third-party tools
    • Run export jobs
  • Interfacing with External Tools
    • Integrate BigQuery with Google Sheets
    • Analyze BigQuery data with R
  • Working with Google Analytics Premium Data
    • Mine Google Analytics and Google AdSense data with BigQuery
  • Data Visualization
    • Visualize data using Google Cloud Datalab

Videos

BigQuery for Data Analysts Videos will be updated Soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings