Corso Intro to SQL
Course delivered in English
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.
We reccommend to take prior to this course: Python
- 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
Standard SQL is the preferred SQL dialect for querying data stored in BigQuery
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.