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

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

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

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

The Ultimate SQL Bootcamp: Zero to Hero in 9 Hours

Курс от 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. Get hands-on with SQL and master one of the most in-demand skills in data and software development. In this intensive bootcamp, you'll learn how to create, query, and manage databases using SQL Server, going from complete beginner to confident practitioner in just a few hours. The course begins with foundational concepts, including database architecture, installation setup, and sample data import. You'll then dive into the essential SQL commands—DDL and DML—for building and manipulating databases. Topics like data integrity, filtering, joins, and built-in functions are explained clearly, with frequent practice opportunities. As your skills grow, you'll explore more advanced techniques like subqueries, CTEs, stored procedures, and window functions. The course wraps up with a real-world capstone project analyzing EuroMart sales data—bringing all your new skills together in one cohesive challenge. Perfect for aspiring data analysts, developers, and business professionals, this course assumes no prior experience. If you’re looking to quickly build SQL skills from scratch or solidify your knowledge with real projects, this beginner-friendly course is the ideal place to start.

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

Data AnalysisData Import/ExportMicrosoft SQL ServersDatabase DevelopmentTransact-SQLDatabase Architecture and AdministrationScriptingDatabase Management SystemsRelational DatabasesAnalytics

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

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

01Introduction6 материалов

Introduction

What All Will Be Covered?ВидеоFull Course ResourcesЧтениеWhat Is a Database?ВидеоUnderstand SQLВидео

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

Packt - Course Instructors

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

The Ultimate SQL Bootcamp: Zero to Hero in 9 Hours
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.8 ч

14 модулей

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

Субтитры: Венгерский, Казахский

Часть программы вашего университета
Installation of SQL ServerВидео
Download and Restore DatabaseВидео
02DDL and DML Statements16 материалов

DDL and DML Statements

DDL: Create Database GraphicallyВидеоDDL: Create Database Using QueryВидеоAdd CommentsВидеоDDL: Alter Database CommandВидеоDDL: Delete a DatabaseВидеоData TypesВидеоDDL: Create TableВидеоDML: Insert Data in TableВидеоDDL: Create Table with Identity ColumnВидеоDDL: Alter Table CommandВидеоDDL: Drop the TableВидеоDML: Delete the TableВидеоDDL: Truncate the TableВидеоWhat Is Schema?ВидеоCreating Databases in SQL ServerDIALOGUEDDL and DML Statements - AssessmentЗадание
03Data Integrity9 материалов

Data Integrity

What Is Data Integrity?ВидеоNot Null ConstraintВидеоPrimary Key ConstraintВидеоUnique ConstraintВидеоForeign Key ConstraintВидеоCheck ConstraintВидеоDefault ConstraintВидеоUnderstanding Data Integrity and Constraints in SQLDIALOGUEData Integrity - AssessmentЗадание
04Querying the Database12 материалов

Querying the Database

Import Data from ExcelВидеоSELECT StatementВидеоSELECT with DISTINCT and TOP ClauseВидеоWHERE Clause with Comparison OperatorsВидеоWHERE Clause with Logical OperatorsВидеоWHERE Clause with Range OperatorsВидеоWHERE Clause with List OperatorsВидеоWHERE Clause with Wildcard OperatorsВидеоWHERE Clause with IS NULL / IS NOT NULL OperatorsВидеоWHERE Clause with Update CommandВидеоImporting Excel Data to SQL ServerDIALOGUEQuerying the Database - AssessmentЗадание
05Sort, Aggregate, Group, and Filter the Data7 материалов

Sort, Aggregate, Group, and Filter the Data

Sort the DataВидеоAggregate Functions 1ВидеоAggregate Functions 2ВидеоGroup By ClauseВидеоHaving ClauseВидеоSorting with SQL ORDER BY ClausDIALOGUESort, Aggregate, Group, and Filter the Data - AssessementЗадание
06Functions8 материалов

Functions

String FunctionsВидеоDate FunctionsВидеоMathematical FunctionsВидеоData Conversion FunctionsВидеоCOALESCE and ISNULLВидеоString Aggregation FunctionВидеоUsing SQL Server String FunctionsDIALOGUEFunctions - AssessmentЗадание
07Joins8 материалов

Joins

Inner JoinВидеоLeft JoinВидеоRight JoinВидеоFull Outer JoinВидеоSelf JoinВидеоCross JoinВидеоSQL Joins: Exploring Data RelationshipsDIALOGUEJoins - AssessmentЗадание
08SQL Query Order of Execution4 материалов

SQL Query Order of Execution

Order of Execution 1ВидеоOrder of Execution 2ВидеоUnderstanding SQL Query Execution OrderDIALOGUESQL Query Order of Execution - AssessmentЗадание
09CASE, IF ELSE Statement, and Set Operators8 материалов

CASE, IF ELSE Statement, and Set Operators

Simple CASE ExpressionВидеоSearched CASE ExpressionВидеоVariable and Print StatementВидеоIF ELSE StatementВидеоSet Operators: Union and Union AllВидеоSet Operators: Intersect and Except (Minus)ВидеоUsing CASE Statements in SQL ServerDIALOGUECASE, IF ELSE Statement, and Set Operators - AssessmentЗадание
10Views4 материалов

Views

Create a ViewВидеоAlter, Join, and Drop the ViewsВидеоCreating and Managing SQL ViewsDIALOGUEViews - AssessmentЗадание
11Writing Subqueries and Common Table Expressions (CTE)11 материалов

Writing Subqueries and Common Table Expressions (CTE)

Subqueries 1ВидеоSubqueries 2ВидеоSubqueries 3ВидеоSubqueries 4ВидеоSubqueries 5ВидеоCommon Table Expression 1ВидеоCommon Table Expression 2ВидеоSQL Problem 1ВидеоSQL Problem 2ВидеоExploring SQL SubqueriesDIALOGUEWriting Subqueries and Common Table Expressions (CTE) - AssessmentЗадание
12Stored Procedures6 материалов

Stored Procedures

Create, Alter, Execute, Drop a Stored ProcedureВидеоStored Procedure with Input ParametersВидеоStored Procedure with Output ParametersВидеоCalling One Stored Procedure from Another Stored ProcedureВидеоUnderstanding Stored Procedures in SQLDIALOGUEStored Procedures - AssessmentЗадание
13Window Functions for Advanced Querying7 материалов

Window Functions for Advanced Querying

Aggregate Window FunctionВидеоRanking Window FunctionВидеоROWS BETWEEN ClauseВидеоLAG and LEADВидеоFIRST_VALUE and LAST_VALUEВидеоWorking with SQL Server Window FunctionsDIALOGUEWindow Functions for Advanced Querying - AssessmentЗадание
14SQL Portfolio Project (EuroMart Data Analysis)9 материалов

SQL Portfolio Project (EuroMart Data Analysis)

Project Introduction and Import Data to SQL ServerВидеоData CleaningВидеоData Exploration - BeginnerВидеоData Exploration - IntermediateВидеоData Exploration - AdvancedВидеоCreate GitHub Account and Upload the Project FilesВидеоSQL Portfolio Project (EuroMart Data Analysis) - AssessmentЗаданиеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание