Master SQL for Data Science
Offered By: LinkedIn Learning
Course Description
Overview
SQL database skills are consistently among the most sought after in the world of data science. Master the skills needed for data science project specialists, and develop a solid foundation of knowledge for working with SQL engineers.
- Discover how your SQL knowledge applies to data science projects.
- Construct an expanded skill set optimized for data science work.
- Expand your knowledge into related tool sets and platforms.
Syllabus
- Course 1: SQL Essential Training
- Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.
- Course 2: Learning SQL Programming
- Learn the basics of SQL, the programming language for retrieving and editing data from databases such as SQL Server, MySQL, MariaDB, and PostgreSQL.
- Course 3: SQL: Data Reporting and Analysis
- 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 4: Advanced SQL for Data Scientists
- Learn advanced techniques for analyzing large data sets with SQL. Find out how to build sophisticated data models, optimize queries, extend SQL with user-defined functions, and more.
- Course 5: SQL Tips and Tricks for Data Science
- Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists.
- Course 6: Presto Essentials: Data Science
- Get up to speed with Presto, the open-source SQL query engine developed by Facebook. Learn the key concepts and how to use them to take advantage of your modern big data system.
Taught by
Bill Weinman, Scott Simpson, Emma Saunders, Dan Sullivan, Ben Sullins and Ben Sullins
Related Courses
80043368 - Strategies to Improve Human Papillomavirus (HPV) Vaccination Rates Among College StudentsJohns Hopkins University via Independent MBA Core Curriculum
University System of Maryland via edX A Beginner’s Guide to Data Analytics
Boxplay via FutureLearn A Beginner’s Guide to Data Handling and Management in Excel
Packt via FutureLearn A Day in the Life of a Data Engineer (Korean)
Amazon Web Services via AWS Skill Builder