Much of the world's data resides in databases, making SQL a vital programming language for interacting with and manipulating data. This course, offered by IBM, provides a practical introduction to SQL, covering fundamental and intermediate SQL concepts essential for a career in data-related fields.
Through hands-on labs and real-world datasets, learners will gain practical experience in creating and manipulating databases, writing SQL statements, and employing advanced techniques like views, transactions, stored procedures, and joins. No prior knowledge of databases, SQL, or programming is required, making this course accessible to beginners with a basic understanding of data.
Certificate Available ✔
Get Started / More Info
This comprehensive course is structured into five modules, covering SQL fundamentals, relational database concepts, intermediate SQL techniques, working with real-world datasets, and advanced SQL skills for data engineers.
This module provides a foundational understanding of SQL, including an introduction to databases, basic SQL statements (SELECT, INSERT, UPDATE, DELETE), and practical exercises to reinforce learning.
Learners delve into relational database concepts, understanding the types of SQL statements, creating and managing tables, and working with databases on the cloud. The module also includes optional labs for hands-on practice.
This module focuses on intermediate SQL techniques, covering string patterns, sorting, grouping, built-in functions, date and time functions, sub-queries, nested selects, and working with multiple tables. Practical labs and optional Db2 labs provide a comprehensive learning experience.
Learners gain hands-on experience working with real-world datasets, understanding table and column details, and culminate their learning with a final project and exam. Optional labs further enhance the practical application of SQL skills.
This honors module covers advanced SQL topics such as views, stored procedures, ACID transactions, and various join operations. Learners engage in extensive hands-on labs and a final project focusing on advanced SQL techniques for data engineers, with optional Db2 labs available for further practice.
Big Data course offers hands-on experience with tools and systems used by big data scientists and engineers, providing insights into real-world problems and questions....
Sports Performance Analytics provides an in-depth exploration of sports analytics, using real data sets from various sports leagues to construct predictive models...
Data Manipulation at Scale: Systems and Algorithms is a comprehensive course covering scalable data analytics platforms, programming models, database technology,...
This course provides a comprehensive introduction to data science and scikit-learn in Python, enabling learners to apply artificial intelligence techniques to test...