- Learn tips to help you select your ideal database.
- Learn how to manipulate, analyze, and report data using SQL.
- Practice your knowledge of SQL with Code Challenges.
Overview
Advance your data career by elevating your SQL programming skills. With this learning path, you can learn how to use SQL with different databases, how to report and analyze data using SQL, and practice your new SQL skills.
Syllabus
Courses under this program:
Course 1: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud
-Learn pros, cons, and options for different databases: PostgreSQL, MySQL, Mongo (a NoSQL database), and several cloud-based options.
Course 2: SQL: Data Reporting and Analysis (2019)
-Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.
Course 3: Using SQL with Python
-If you already know SQL and Python, learn the power of using these two languages together.
Course 4: SQL Code Challenges
-Test your SQL skills. Follow along with a series of five-minute coding challenges that provide hands-on practice.
Course 1: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud
-Learn pros, cons, and options for different databases: PostgreSQL, MySQL, Mongo (a NoSQL database), and several cloud-based options.
Course 2: SQL: Data Reporting and Analysis (2019)
-Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.
Course 3: Using SQL with Python
-If you already know SQL and Python, learn the power of using these two languages together.
Course 4: SQL Code Challenges
-Test your SQL skills. Follow along with a series of five-minute coding challenges that provide hands-on practice.
Courses
-
Test your SQL skills with these concise challenges.
-
Learn pros, cons, and options for different databases: PostgreSQL, MySQL, Mongo (a NoSQL database), and several cloud-based options.
-
Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.
-
If you already know SQL and Python, learn the power of using these two languages together.
Taught by
Amataverna Lee, Emma Saunders, Bill Weinman and Scott Simpson