К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
SQL Bootcamp - From Zero to Job-Ready · LearnSpace
Назад в каталог
courseraАнализ данных

SQL Bootcamp - From Zero to Job-Ready

Курс от Packt
Средний≈ 16.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

SQLRelational DatabasesDatabase DesignStar SchemaSnowflake SchemaDatabasesQuery LanguagesDatabase ManagementDatabase TheoryData AnalysisData Management

Программа курса

16 модулей · 148 учебных материалов

01Introduction to SQL4 материалов

Introduction to SQL

Introduction to SQL LanguageВидеоUnderstanding the SQL LanguageВидеоWriting our First SQL QueryВидеоFull Course ResourceЧтение
02SQL Foundations7 материалов

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

SQL Bootcamp - From Zero to Job-Ready
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 16.8 ч

16 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета

SQL Foundations

Introduction to DatabasesВидеоTypes of DatabasesВидеоSQL vs MySQL UpdatedВидеоSpreadsheets vs DatabaseВидеоUnderstanding Relational DatabaseВидеоUnderstanding Databases, Types, and SQL vs MySQLDIALOGUESQL Foundations - AssessmentЗадание
03Data Types in SQL19 материалов

Data Types in SQL

Project IntroductionВидеоData Types and INTВидеоBIG INTВидеоTINYINTВидеоDECIMALВидеоFLOAT and DOUBLEВидеоBIT and BOOLEANВидеоCHARВидеоVARCHARВидеоTEXTВидеоENUMВидеоDATE and TIMEВидеоDATETIMEВидеоTIMESTAMPВидеоYEARВидеоBLOBВидеоJSONВидеоChoosing the Right SQL Data Types for a Pizza Store DatabaseDIALOGUEData Types in SQL - AssessmentЗадание
04Understanding Schema and Creating Schema9 материалов

Understanding Schema and Creating Schema

Why we need Database SchemaВидеоTypes of SchemaВидеоSTAR SchemaВидеоInstalling Server and Workbench Installation for MacВидеоCreating our First Database SchemaВидеоIntroduction to Snowflake SchemaВидеоCreating a Snowflake Schema DatabaseВидеоUnderstanding Database Schemas and the Star vs. Snowflake ModelDIALOGUEUnderstanding Schema and Creating Schema - AssessmentЗадание
05Keys and Relationships8 материалов

Keys and Relationships

Primary KeyВидеоForeign KeyВидеоUnique Composite and Candidate KeyВидеоOne to One RelationshipsВидеоOne to Many RelationshipsВидеоMany to Many RelationshipsВидеоUnderstanding Database Keys and RelationshipsDIALOGUEKeys and Relationships - AssessmentЗадание
06CRUD Operations8 материалов

CRUD Operations

Creating a Sample DatabaseВидеоCreate a Sample TableВидеоCreating Data for our TableВидеоSelecting Data CRUD OperationsВидеоAltering and Updating the Table and Table InformationВидеоDeleting in SQLВидеоFundamentals of SQL CRUD Operations with a Pizza Shop ExampleDIALOGUECRUD Operations - AssessmentЗадание
07Project and Select Statements14 материалов

Project and Select Statements

Importing Data to our MySQL WorkbenchВидеоSELECT EverythingВидеоSelecting Multiple ColumnsВидеоSelect Distinct Values from a Column or ColumnsВидеоSelecting Info with WHERE ClauseВидеоShortcomings and Operators of WHERE ClauseВидеоUsing Less Than or Equal to with WHERE ClauseВидеоWHERE with AND Criteria and Multiple CriterionВидеоWHERE and ORВидеоWHERE and INВидеоUnderstanding Wild Cards in MySQLВидеоWild Cards Situation Practice in MySQL WorkbenchВидеоFiltering Data in SQL: WHERE, AND, OR, IN, and LIKE OperatorsDIALOGUEProject and Select Statements - AssessmentЗадание
08Aggregations in MySQL9 материалов

Aggregations in MySQL

Aggregation Section IntroductionВидеоBasic SUMВидеоAggregations with Previous Learnings and Complex SituationsВидеоBasic CountВидеоComplex CountingВидеоAverageВидеоMAX and MINВидеоMastering SQL Basic Aggregations (SUM, COUNT, AVG, MIN, MAX, and Aliases)DIALOGUEAggregations in MySQL - AssessmentЗадание
09Level 1 - Assignment4 материалов

Level 1 - Assignment

What is Expected in This AssignmentВидеоAssignment Solution WalkthroughВидеоApplying SQL Aggregate Functions and FilteringDIALOGUELevel 1 - Assignment - AssessmentЗадание
10GroupBy, OrderBy, and Having in MySQL6 материалов

GroupBy, OrderBy, and Having in MySQL

Group By StatementВидеоGROUP BY in MySQL WorkbenchВидеоORDER BY StatementВидеоHAVINGВидеоMastering GROUP BY, ORDER BY, and HAVING in SQLDIALOGUEGroupBy, OrderBy, and Having in MySQL - AssessmentЗадание
11Joins13 материалов

Joins

What are Joins and Why We Need ThemВидеоExploring the Dataset and CROSS JoinsВидеоUnderstanding Left JoinВидеоPracticing Left Join with AggregationsВидеоRIGHT JoinВидеоRIGHT Join ExampleВидеоPracticing Right Join - Multi Join and AggregationsВидеоInner JoinВидеоPracticing INNER JOINВидеоUnionВидеоUnion AllВидеоUnderstanding SQL Joins: UNION, UNION ALL, CROSS JOIN, LEFT/RIGHT/INNER JOINSDIALOGUEJoins - AssessmentЗадание
12More Operators and NULL Management7 материалов

More Operators and NULL Management

Between and ANDВидеоNOT BETWEENВидеоIS NOT NULLВидеоIS NULLВидеоLIMITВидеоUsing SQL BETWEEN, NOT BETWEEN, NULL Checks, and LIMITDIALOGUEMore Operators and NULL Management - AssessmentЗадание
13CASE Statements6 материалов

CASE Statements

Understanding CASE Statements UpdatedВидеоPracticing Case Statement 1ВидеоCase Statement 2ВидеоCase Statement 3ВидеоMastering CASE Statements in SQLDIALOGUECASE Statements - AssessmentЗадание
14Subqueries7 материалов

Subqueries

Introduction to Subquery MySQLВидеоScalar Subquery - MySQLВидеоPracticing Scalar Subquery - Q1 - MySQLВидеоScalar Subquery Q2 - MySQLВидеоComplex Sub-Query Using Joins and Multiple Tables - MySQLВидеоMastering SQL Subqueries with Real-World ScenariosDIALOGUESubqueries - AssessmentЗадание
15SQL Window Function3 материалов

SQL Window Function

Introduction to Window Functions - UpdatedВидеоUnderstanding SQL Window Functions for Aggregation and RankingDIALOGUESQL Window Function - AssessmentЗадание
16Capstone Project24 материалов

Capstone Project

Find the Active Branches ListВидеоFetching the Basic Product Details from the TableВидеоRecent Customer SignupsВидеоOrders OverviewВидеоUnresolved Customer Support TicketsВидеоFetching Customers Orders Info Using JoinsВидеоTotal Revenue MadeВидеоAverage Response Time to CustomersВидеоActive Employee Count for DepartmentsВидеоExpired Products from InventoryВидеоCampaigns by ChannelВидеоActive Assets Deployed in BranchesВидеоTop 5 Products by Their RevenueВидеоAsset Depreciation CalculationВидеоHigh-Cost Employees by DepartmentВидеоReturn on Investment on BranchesВидеоDelivery Type PerformanceВидеоCustomer Order FrequencyВидеоTop 3 Products per CategoryВидеоInventory Expiry TrackerВидеоCampaign Spend EfficiencyВидеоCapstone Project - AssessmentЗаданиеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание