SQL Fundamentals (training)

Colleagues, in the “SQL Fundamentals” program you will master the SQL fundamentals needed for business, learn how to write SQL queries, and start analyzing your data using this powerful language. Gain the fundamental SQL skills you need to interact with and query your data. SQL is a powerful language used by data-driven businesses, large and small, to explore and manipulate their data to extract meaningful insights. In this track, you'll learn the SQL fundamentals you need to level up your data skills. Through hands-on exercises, you’ll discover SQL basics, such as how to structure and query relational databases. As you progress, you’ll use these foundations to quickly summarize and join tables and use window functions and built-in PostgreSQL functions to analyze your data.By the time you finish this track, you’ll have a firm understanding of the SQL essentials and have the confidence to apply them to your own data sets. You’ll be able to start working on a variety of SQL projects and develop your data science portfolio. Skill-oriented training modules include: 1) Introduction to SQL - create and query relational databases using SQL, 2) Intermediate SQL - everything you need to know to analyze data using your own SQL code, 3) Project - Analyzing Students' Mental Health: use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health, 4) Joining Data in SQL - apply relational set theory, and work with subqueries, 5) Data Manipulation in SQL - master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL, 6) PostgreSQL Summary Stats and Window Functions - create queries for analytics and data engineering with window functions, the SQL secret weapon, 7) Functions for Manipulating Data in PostgreSQL - learn the most important PostgreSQL functions for manipulating, processing, and transforming data, 8) Database Design - design databases in SQL to process, store, and organize data in a more efficient way, and 9) Project - Impact Analysis of GoodThought NGO Initiatives: use SQL to explore and analyze GoodThought NGO's database, uncovering key insights from over 13 years of transformative projects.

Enroll today (teams & executives are welcome): https://datacamp.pxf.io/JKVZJe 

Download your free Data Science  - Career Transformation Guide.

Explore our “Data-Driven Organizations” Audible and Kindle book series on Amazon:

1 - Data-Driven Decision-Making  (Audible) (Kindle)

2 - Implementing Data Science Methodology: From Data Wrangling to Data Viz (Audible) (Kindle)

3 - The Upskill Gambit - Discover the 5 Keys to Your Career and Income Security in the Digital Age (Audible) (Kindle) 

Much career success, Lawrence E. Wilson - Data Science Academy (share with your team)