Master SQL for Data Science

Go to class
Write Review

Free Online Course: Master SQL for Data Science provided by LinkedIn Learning is a comprehensive online course, which lasts for 12 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Master SQL for Data Science is taught by Bill Weinman, Scott Simpson, Emma Saunders, Dan Sullivan, Ben Sullins and Ben Sullins.

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.