Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

SQL Bootcamp - From Zero to Job-Ready

Packt via Coursera

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. In this SQL Bootcamp, you will embark on a comprehensive journey, starting from the basics and advancing to real-world job-ready skills. You'll learn to write SQL queries, understand database concepts, and master key techniques such as CRUD operations, joins, and subqueries. By the end, you will be well-equipped to manage and manipulate data using SQL, preparing you for a career in database management or data analysis. The course begins with foundational concepts such as the structure and syntax of SQL, followed by an introduction to databases and their types. You will quickly get hands-on experience writing your first SQL queries, progressively building your skills. As you move through the course, you will tackle real-world projects and apply what you’ve learned by working with different data types, creating schemas, and implementing keys and relationships in SQL. As you progress, you will dive deeper into advanced topics such as aggregation, window functions, and complex queries using joins and subqueries. These skills will culminate in the capstone project, where you will apply your knowledge to real datasets, solving problems ranging from inventory management to customer analysis. This course is ideal for beginners with no prior SQL experience. It will also benefit individuals looking to sharpen their SQL skills for job readiness. No prior knowledge of databases is required, but basic computer literacy is helpful. The difficulty level is beginner to intermediate. By the end of the course, you will be able to write complex SQL queries, understand relational database design, perform data aggregation, and work with real-world datasets to solve business problems.

Syllabus

  • Introduction to SQL
    • In this section, we will introduce the SQL language, its structure, and its significance in database management. You will learn how SQL queries are constructed, and you'll get hands-on experience by writing your first SQL query to retrieve data from a database.
  • SQL Foundations
    • In this section, we will dive deeper into the fundamentals of databases, exploring their structure, types, and uses. We will also distinguish between SQL and MySQL, and understand when and how each is applied in database management.
  • Data Types in SQL
    • In this section, we will explore various SQL data types and their application in database design. You'll learn how to choose the right data type for each field in your database and practice creating tables using a variety of data types, from integers to complex JSON objects.
  • Understanding Schema and Creating Schema
    • In this section, we will discuss the significance of database schema in organizing and maintaining data integrity. You will learn how to create different types of schemas, including the STAR and Snowflake schemas, which are key in data warehousing.
  • Keys and Relationships
    • In this section, we will explore the importance of keys in relational database management. You will learn how to create primary, foreign, and composite keys and understand their role in defining relationships between tables.
  • CRUD Operations
    • In this section, we will guide you through the essential CRUD operations, teaching you how to create tables, insert data, and retrieve information using SQL. You will also learn how to update and delete records to maintain accurate and up-to-date data.
  • Project and Select Statements
    • In this section, we will focus on SELECT statements, helping you retrieve and filter data from databases. You will learn to apply filtering criteria using the WHERE clause and practice selecting specific columns from a table or multiple tables.
  • Aggregations in MySQL
    • In this section, we will teach you how to apply aggregation functions to summarize and analyze large sets of data. You will explore various aggregation techniques and learn how to use them in complex data analysis tasks.
  • Level 1 - Assignment
    • In this section, we will outline the expectations for your first assignment and guide you through a solution walkthrough. You will apply the SQL skills you've learned to complete real-world tasks and gain practical experience.
  • GroupBy, OrderBy, and Having in MySQL
    • In this section, we will teach you how to group and sort data using GROUP BY and ORDER BY. You will also learn to filter grouped data using the HAVING clause to perform more advanced queries.
  • Joins
    • In this section, we will introduce you to SQL joins and their importance in relational database management. You'll learn how to combine data from different tables and practice using various types of joins to retrieve and analyze related data.
  • More Operators and NULL Management
    • In this section, we will explore advanced SQL operators for filtering data, including BETWEEN, AND, and NOT BETWEEN. You'll also learn how to manage NULL values and limit query results to improve your data retrieval efficiency.
  • CASE Statements
    • In this section, we will explore the CASE statement, a powerful tool for implementing conditional logic in SQL queries. You will practice using CASE statements to handle different conditions and apply them in practical data analysis scenarios.
  • Subqueries
    • In this section, we will cover the use of subqueries to perform more complex queries in SQL. You will learn how to use scalar subqueries and integrate them with other queries, including joins and multiple tables.
  • SQL Window Function
    • In this section, we will introduce window functions, explaining how they enable you to perform calculations across a set of table rows related to the current row. This module will enhance your ability to analyze data in more advanced ways.
  • Capstone Project
    • In this section, we will walk you through a series of practical SQL tasks, including retrieving product details, analyzing sales performance, and calculating revenue. This hands-on project will help solidify your SQL skills in real-world contexts.

Taught by

Packt - Course Instructors

Reviews

Start your review of SQL Bootcamp - From Zero to Job-Ready

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.