Descrizione del corso

Course delivered in English
Lessons: 6
Livello: Foundational
Access: Free Online Course (Audit)

Learn SQL for working with databases, using Google BigQuery.

This course is compsed by 6 Lessons Tutorial, 6 excercises and can be tackled in approx 3 hours.

Prerequisite Skills

We reccommend to take prior to this course: Python

Course Structure

• 1 Getting Started With SQL and BigQuery

Learn the workflow for handling big datasets with BigQuery and SQL

• 2 Select, From & Where

The foundational compontents for all SQL queries

• 3 Group By, Having & Count

Get more interesting insights directly from your SQL queries

• 4 Order By

Order your results to focus on the most important data for your use case.

• 5 As & With

Organize your query for better readability. This becomes especially important for complex queries.

• 6 Joining Data

Combine data sources. Critical for almost all real-world data problems

Obiettivi

Struttura

Completing SQL Course will equip you with the foundation you need to further your working with databases, using Google BigQuery.

• Empowered Learning & Job Preparedness
• Set goals and create a personal action plan to support a Database, coding and Machine Learning journey.
• Preparing for Job-readiness
• Planning for personal and professional growth
• Planning and Producing a portfolio
• Developing professional attitudes

This  course is managed by the external partner Kaggle. In order to take this  course you will need to register on their Academy platform where you  can take advantage of this and many other courses on offer.

Kaggle might not issue a Certificate for completing this course; however we will! Once you have finished the course, go back to the course page in Guilds42 to upload an evidence of completion (screenshot jpg / png / pdf). Your document will be evaluated and if appropriate and verifiable, you will find this certification validated in the dashboard.