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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Managing Relational Databases · LearnSpace
Назад в каталог
courseraIT и технологии

Managing Relational Databases

Курс от Akamai Technologies, Inc.
Начальный≈ 17.7 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

In Managing Relational Databases, you’ll learn about their structure, design, and use of primary and foreign key fields equipping you with foundational knowledge. Upon completing this course, you’ll be able to: ● Master the use of Structured Query Language (SQL) and use it to analyze database structures ● Create and manage databases, tables, and records ● Conduct data analysis using basic SQL queries, conditional statements, and logical comparison ● Control output data using SQL ● Create complex queries using joins, and subqueries Throughout this course, hands-on labs will provide practical experience in working with SQL and manipulating databases. At the end of this course, you’ll complete a capstone project, allowing you to showcase the knowledge and skills you learned throughout the course.

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

SQLRelational DatabasesQuery LanguagesData ManipulationData AnalysisDatabase ManagementDatabase SystemsDatabase TheoryData ManagementDatabase DevelopmentDatabase DesignDatabasesDatabase Administration

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

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

01Database Fundamentals22 материалов

Overview of networking

Introduction to the ATA TrackВидеоOverview of ATA TrackВидеоAdvice for Completing the ATAВидеоREADMEЧтение

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

Shadow Farrell

Instructor

Managing Relational Databases
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 17.7 ч

7 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Databases Course SyllabusВидео

Relational Database Concepts

DatabasesВидеоFlat DatabasesОбсуждениеTables and KeysВидеоRelationshipsВидеоRelational Database Concepts AssessmentЗадание

Understand SQL

Structured Query Language (SQL)ВидеоFinding the Database StructureВидеоQueriesВидеоConditional QueriesВидеоUnderstand SQL Practice AssessmentЗадание

Database Fundamentals Labs

Installing VirtualBoxЧтениеInstalling UbuntuЧтениеConfiguring the Virtual Machine to Interact with the Host Operating SystemЧтениеSetting Up the Lab EnvironmentЧтениеQuerying a DatabaseЧтение

Database Fundamentals Review and Graded Assessment

Database Fundamentals ReviewВидеоDatabase Fundamentals Graded AssessmentЗадание
02Multiple Conditions and Complex Criteria14 материалов

Queries with Multiple Conditions

AND and OR QueriesВидеоComparison OperatorsВидеоArithmetic OperatorsВидеоQueries with Multiple Conditions Practice AssessmentЗадание

Queries with Complex Criteria

Searching for a Range of ValuesВидеоThe IN OperatorВидеоNULL ValuesВидеоPattern MatchingВидеоRegular ExpressionsВидеоQueries with Complex Criteria Practice AssessmentЗадание

Multiple Conditions and Complex Criteria Labs

Using Multiple ConditionsЧтениеUsing PatternsЧтение

Multiple Conditions and Complex Criteria Review and Graded Assessment

Multiple Conditions and Complex Criteria ReviewВидеоMultiple Conditions and Complex Criteria Graded AssessmentЗадание
03Working with Functions18 материалов

Perform Date Calculations

FunctionsЧтениеDate and Time Data TypesЧтениеDate FunctionsВидеоDate Functions ReferenceЧтениеPerform Date Calculations Practice AssessmentЗадание

Calculate Data Using Aggregate Functions

The DISTINCT Key WordВидеоAggregate FunctionsВидеоCalculate Data Using Aggregate Functions Practice AssessmentЗадание

Manipulate String Values

StringsЧтениеFormatting Text and NumbersВидеоTRIM and SUBSTR FunctionsВидеоConcatenationВидеоManipulate String Values Practice AssessmentЗадание

Working with Functions Labs

Performing Date CalculationsЧтениеUsing Aggregate FunctionsЧтениеManipulating String FunctionsЧтение

Working with Functions Review and Graded Assessment

Working with Functions Review ВидеоWorking with Functions Graded AssessmentЗадание
04Retrieving and Organizing Data from Multiple Tables17 материалов

Combine the Results of Two Queries

UNION OperatorВидеоINTERSECT and EXCEPT OperatorsВидеоCombine the Results of Two Queries Practice AssessmentЗадание

Retrieve Data by Joining Tables

JoinsВидеоMultiple Table JoinsВидеоSelf JoinsВидеоRetrieve Data by Joining Tables Practice AssessmentЗадание

Organizing Data

Data SortingВидеоLimit ResultsВидеоGROUP BY and HAVING ClausesВидеоROLLUP OperatorВидеоRetrieve Data by Joining Tables Practice AssessmentЗадание

Retrieving and Organizing Data from Multiple Tables Labs

Combining and Comparing the Results of Two QueriesЧтениеRetrieving Data by Joining TablesЧтениеOrganizing DataЧтение

Retrieving and Organizing Data from Multiple Tables Review and Graded Assessment

Retrieving and Organizing Data from Multiple Tables ReviewВидеоRetrieving and Organizing Data from Multiple Tables Graded AssessmentЗадание
05Using Subqueries11 материалов

Basic Subqueries

SubqueriesВидеоSubqueries in WHERE ClausesВидеоSubqueries in FROM ClausesВидеоAdvanced CSS Selectors Practice AssessmentЗадание

Advanced Subqueries

Correlated SubqueriesВидеоExisting RecordsВидеоNested SubqueriesВидеоProvide Alternate Layouts Practice AssessmentЗадание

Subqueries Lab

Using SubqueriesЧтение

Using Subqueries Review and Graded Assessment

Using Subqueries ReviewВидеоUsing Subqueries Graded AssessmentЗадание
06Manipulating Table Data12 материалов

Insert Data

Data TypesЧтениеCreating Databases and TablesВидеоINSERT StatementВидеоInserting Multiple RowsВидеоInsert Data Practice AssessmentЗадание

Modify and Delete Data

UPDATE StatementВидеоDELETE StatementВидеоTRUNCATE TABLE StatementВидеоModify and Delete Data Practice AssessmentЗадание

Manipulating Table Data Lab

Inserting Data into a TableЧтение

Manipulating Table Data Review and Graded Assessment

Manipulating Table Data ReviewВидеоManipulating Table Data Graded AssessmentЗадание
07Database Fundamentals Capstone3 материалов

Capstone

Capstone IntroductionВидеоCapstone InstructionsВидеоNew Peer ReviewВзаимная проверка