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

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

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

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

SQL for Data Science with R

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

О курсе

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL and R languages. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning. As such, you will work with real databases, real data science tools, and real-world datasets. Through a series of hands-on labs, you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and R. No prior knowledge of databases, SQL, R, or programming is required. Anyone can audit this course at no charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.

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

SQLRelational DatabasesData ManipulationR ProgrammingDatabasesDatabase DesignData ScienceQuery LanguagesData AnalysisData AccessR (Software)Database Development

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

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

01Getting Started with SQL14 материалов

Basic SQL

Course Overview ЧтениеWelcome to SQL for Data ScienceВидеоSELECT StatementВидеоSELECT statement examplesPLUGIN

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

Rav Ahuja

CCO & Global Program Director

SQL for Data Science with R
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 28.6 ч

6 модулей

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

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

Часть программы вашего университета
Hands-on Lab: Simple SELECT StatementsВнешний инструмент
COUNT, DISTINCT, LIMITВидео
Hands-on Lab: COUNT, DISTINCT, LIMITВнешний инструмент
INSERT StatementВидео
UPDATE and DELETE StatementsВидео
Hands-on Lab: INSERT, UPDATE, and DELETEВнешний инструмент
Module Summary: Getting Started with SQLЧтение
Practice Quiz: Getting Started with SQL Задание
SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMITPLUGIN
Graded Quiz: Getting Started with SQLЗадание
02Introduction to Relational Databases and Tables16 материалов

Introduction to Relational Databases and Tables

Introduction to DatabasesВидеоRelational Database ConceptsВидеоTypes of SQL statements (DDL vs. DML)ВидеоCREATE TABLE StatementВидеоALTER, DROP, and Truncate tablesВидеоExamples to CREATE and DROP tablesPLUGINHands-on Lab: CREATE, ALTER, TRUNCATE, DROP into Tables in MySQL using phpMyAdminВнешний инструментHands-on Lab: Create and Load Tables using SQL ScriptsВнешний инструментModule Summary: Introduction to Relational Databases and TablesЧтениеPractice Quiz: Introduction to Relational Databases and TablesЗаданиеSQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATEPLUGINGraded Quiz: Introduction to Relational Databases and TablesЗадание

[Optional] Using IBM Db2

About this Optional LessonЧтениеHow to create a Database instance on CloudВидеоObtain IBM Cloud Feature Code and Activate Trial AccountВнешний инструмент[Optional] Hands-on Lab Using IBM Db2Чтение
03Intermediate SQL24 материалов

Refining your Results

Using String Patterns and RangesВидеоSorting Result SetsВидеоGrouping Result SetsВидеоReading: Examples for String Patterns, Sorting, and GroupingPLUGINHands-on Lab: String Patterns, Sorting and GroupingВнешний инструментSummary: Refining Your ResultsЧтениеPractice Quiz: Refining Your ResultsЗаданиеGraded Quiz: Refining Your ResultsЗадание

Functions, Multiple Tables, and Sub-queries

Built-in Database FunctionsВидеоDate and Time Built-in FunctionsВидеоReading: Examples for Built-in FunctionsPLUGINHands-on Lab: Built-in functionsВнешний инструментSub-Queries and Nested SelectsВидеоReading: Examples for Sub Queries and Nested QueriesPLUGIN

[Optional] Using IBM Db2

About this Optional LessonЧтение[Optional] Hands-on Lab Using IBM Db2Чтение
04Getting Started with Databases using R27 материалов

R and Relational Databases

Why use R with Relational Databases ВидеоR Persistence OptionsВидеоTerminology ComparisonВидеоMapping Data between R and RDBMSВидеоDatabase Design ConsiderationsВидеоHands-on Lab: Review using Jupyter and R DataframesВнешний инструментSummary & Highlights: R and Relational DatabasesЧтениеPractice Quiz: R and Relational DatabasesЗаданиеCheat Sheet - R basicsPLUGINGraded Quiz: R and Relational DatabasesЗадание

Connecting to Databases from R

Connectivity OptionsВидеоConnecting with RJDBC ВидеоConnectivity using ODBCВидеоRODBC in Detail ВидеоMetadata Discovery ВидеоReading: Example for Connecting with RJDBC using SQLitePLUGIN

[Optional] Using IBM Db2

About this Optional LessonЧтение[Optional] Hands-on Lab: Create Db2 Service CredentialsPLUGIN[Optional] Hands-on Lab: Accessing Your Database using RJDBC with DB2Внешний инструмент[Optional] Hands-on Lab: Accessing your Database using RODBC with DB2Внешний инструмент
05Working with Database Objects using R14 материалов

Creating Database Objects and Querying Data from R

Working with Data ВидеоDatabase Design and Data PreparationВидеоCreating Physical Database ObjectsВидеоLoading the DataВидеоQuerying Data (SQL SELECT)ВидеоAnalyzing the DataВидеоReading: Example for Creating and querying databases with SQLite using RPLUGINHands-on Lab: Creating and Querying Database Objects from R using RSQLite with SQLiteВнешний инструментSummary and Highlights: Working with Database Objects using R ЧтениеPractice Quiz: Working with Database Objects using RЗаданиеCheatSheet- Creating Database Objects & Querying Data from RPLUGINGraded Quiz: Working with Database Objects using RЗадание

[Optional] Using IBM Db2

About this Optional LessonЧтение[Optional] Hands-on Lab: Creating and Querying Database Objects from R using RODBC with DB2Внешний инструмент
06Course Project10 материалов

Assignment Preparation

Hands-on Lab: Practice Querying Real World Datasets using RSQLite with SQLiteВнешний инструмент[Optional] Hands-on Lab: Practice Querying Real World Datasets using RODBC with DB2Внешний инструмент

Final Project

Final Project OverviewPLUGINReading: Final Project Submission Guidelines and DeliverablesPLUGINLab for Final Project - Data Analytics for Canadian Crop Production Data SetВнешний инструмент[Optional] Jupyter Notebook with Problems for Peer Reviewed Assignment using RODBC with DB2Внешний инструментOption 1: AI Graded - Final Project: Submission and EvaluationВнешний инструмент Option 2: Peer Graded - Final Project Submission and EvaluationВзаимная проверка

Final Exam

Final ExamЗадание

Course Wrap-up

Congratulations & Next StepsЧтение
Hands-on Lab: Sub-queries and Nested SELECTsВнешний инструмент
Working with Multiple TablesВидео
Reading: Examples for Multiple TablesPLUGIN
Hands-on Lab: Working with Multiple TablesВнешний инструмент
Summary: Functions, Multiple Tables, and Sub-queriesЧтение
Practice Quiz: Functions, Multiple Tables, and Sub-queriesЗадание
SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BYPLUGIN
Graded Quiz: Functions, Multiple Tables, and Sub-QueriesЗадание
Hands-on Lab: Accessing Your Database using RJDBCВнешний инструмент
Reading: A Comprehensive Review of RSQLitePLUGIN
Hands-on Lab: Accessing Your Database with RSQLiteВнешний инструмент
Summary & Highlights : Connecting to Databases from RЧтение
Practice Quiz: Connecting to Databases from RЗадание
CheatSheet - Connecting to Databases using RPLUGIN
Graded Quiz: Connecting to Databases from RЗадание