SQL for Data Science with R
Register to start the conversation
Next Start
September 21, 2026
(Offered monthly)Duration
5 Days
ClassroomProgram Fee
$1,250
Exclusive 16% VATOther Dates
October 19, 2026
November 16, 2026
November 16, 2026
Course Description
This professional course provides a practical foundation in SQL for data science and analytics using R. Participants will learn how to work with relational databases, retrieve and manipulate data using SQL, and integrate SQL workflows with R and the tidyverse. The course focuses on the essential SQL skills required to efficiently work with structured data in professional data environments.
The curriculum progresses from SQL fundamentals to data aggregation, advanced queries, joins, and database operations, before introducing R integration. Participants will learn how to connect R to databases, execute SQL queries from R, retrieve query results, and work with database data using dplyr and dbplyr. Through hands-on exercises, learners will develop practical skills for combining SQL and R in data-focused workflows.
Prerequisite note: This course requires basic R programming knowledge. No prior SQL experience is required — all SQL concepts will be taught from the ground up.
Course Outline
This course is structured into 5 core modules, each carefully designed to build progressively on the previous one.
Learning Outcomes
Technical Skills
- Write SQL queries to retrieve data from relational databases.
- Filter, sort, and organize data using SQL.
- Use SQL aggregate functions for data summarization.
- Group and summarize data using GROUP BY and HAVING.
- Use conditional logic with CASE expressions.
- Write subqueries and common table expressions (CTEs).
- Combine data from multiple tables using SQL joins.
- Use UNION and other set operations.
- Use window functions for advanced data operations.
- Connect R applications to relational databases using DBI and odbc.
- Execute SQL queries from R.
- Retrieve SQL query results into R and dplyr tibbles.
- Combine SQL and dplyr for data manipulation workflows using dbplyr.
Career Benefits
- Build practical SQL skills for data-focused professional roles.
- Develop the ability to retrieve and manipulate data directly from databases.
- Learn to work efficiently with relational databases.
- Gain practical experience combining SQL with R.
- Develop skills applicable to data analysis, reporting, research, and business intelligence.
- Strengthen your technical foundation for further learning in data science.
- Improve your ability to work with large and structured datasets.
Who Should Attend
- Aspiring Data Analysts — Individuals seeking practical SQL and R skills.
- Data Professionals — Professionals who work with structured data and databases.
- Business Analysts — Professionals who need to retrieve and summarize business data.
- Researchers & Academics — Individuals working with data stored in relational databases.
- R Developers — Programmers looking to integrate databases with R applications.
- Students — Learners building practical SQL and R skills.
- Career Changers — Individuals preparing for data-focused technical roles.
- Data Professionals — Anyone who needs to query and work with relational data.
Prerequisites & Requirements
Prerequisites
- Basic computer literacy and familiarity with file management.
- Basic R programming knowledge is strongly recommended.
- No prior SQL experience is required — all concepts will be taught from first principles.
- Basic understanding of data and tables is helpful but not required.
- A willingness to work with databases and structured data.
Requirements
- Laptop with at least 2GB RAM (GB recommended for smoother performance).
- All learning facilities are provided on-site, including high-speed internet, projectors, writing materials, and refreshments.
- Administrative rights on your laptop to install R, RStudio, and necessary packages.
- Sufficient free disk space (at least 2GB) for software installation and project files.
Register to start the conversation