❗The content presented here is sourced directly from LinkedIn Learning platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [August 31st, 2023]
Skills and Knowledge:
- Understanding of SQL database structure and syntax
- Ability to write and execute SQL queries
- Knowledge of data manipulation and data analysis techniques
- Understanding of database optimization and performance tuning
- Knowledge of database security and data privacy
- Understanding of data warehousing and data modeling
- Knowledge of data visualization and reporting tools
- Ability to integrate SQL with other programming languages
- Understanding of cloud-based data storage and management
- Knowledge of data engineering and ETL processes.
Professional Growth:
This course contributes to professional growth by providing a comprehensive overview of SQL and its applications in data science. Students will gain a deeper understanding of how to use SQL to create and manage databases, as well as how to apply their knowledge to data science projects. Additionally, students will learn how to use related tools and platforms to further their data science skills. With this course, students will be able to develop a solid foundation of knowledge for working with SQL engineers and data science project specialists.
Further Education:
This course is suitable for preparing for further education in data science. It focuses on mastering SQL database skills, which are highly sought after in the field of data science. By taking this course, you will develop a solid foundation of knowledge for working with SQL engineers and data science project specialists. Additionally, the course aims to help you understand how your SQL knowledge applies to data science projects, expand your skill set for data science work, and increase your knowledge of related tool sets and platforms.
Course 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.
