CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / Data Science and Machine Learning / SQL for Data Science, Data Analytics and Data Vi...
CPD course All Levels

SQL for Data Science, Data Analytics and Data Visualization

5 enrolled 7h 15m of learning Updated Nov 2026
CertificateOn completion
7h 15mSelf-paced
80 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 80 lessons 7h 15m total
01 SQL for Data Science, Data Analytics and Data Visualization 80 lessons
  1. Introduction
  2. How to get course requirements
  3. Getting started on Windows, Linux or Docker
  4. How to ask great questions
  5. FAQ’s
  6. Section Introduction
  7. Microsoft SQL Server Installation
  8. SQL Server Management Studio (SSMS) Installation
  9. How to connect MS SQL (Windows Authentication)
  10. How to connect MS SQL (SQL Server Authentication)
  11. Download and Restore Sample Database
  12. What is Azure Data Studio
  13. Azure Data Studio Installation steps
  14. Azure Data Studio to Connect SQL Server
  15. Create a Database
  16. Create a Table
  17. Insert Data rows
  18. View the Data returned by Query
  19. Overview of Databases
  20. Creating Database
  21. SQL Data Types
  22. Column Data Types on SSMS
  23. Creating Table
  24. Overview of Primary Key and Foreign Key
  25. Primary Key
  26. Foreign Key
  27. Creating Temporary tables
  28. Insert statement
  29. Update statement
  30. Delete statement
  31. CREATE table statement
  32. DROP statement
  33. ALTER statement
  34. TRUNCATE statement
  35. COMMENT in query
  36. RENAME
  37. Create Database user
  38. GRANT permissions
  39. REVOKE permissions
  40. SQL Statement basic
  41. SELECT Statement
  42. SELECT DISTINCT
  43. SELECT with column headings
  44. Column AS statement
  45. SELECT WHERE Clause – theory
  46. SELECT WHERE Clause – practical
  47. Sum()
  48. Min()-Max()
  49. Order By statement
  50. SELECT TOP clause in SQL
  51. BETWEEN command
  52. IN operator
  53. Wildcard Characters and LIKE
  54. Group by – theory
  55. Group by – practical
  56. HAVING statement
  57. Overview of Joins
  58. What are Joins
  59. Inner join
  60. Left outer join
  61. Right outer join
  62. Full outer join
  63. Union
  64. Cartesian Product with the Cross Join
  65. Query Exercise
  66. Solution for Query Exercise
  67. Section introduction
  68. Check constraint
  69. NOT NULL constraint
  70. UNIQUE constraint
  71. Creating Views
  72. Reporting with multiple tables
  73. Timestamp
  74. Extract from timestamp
  75. Mathematical scalar functions
  76. String functions
  77. Sub Query
  78. SELECT with calculations
  79. Create stored procedure
  80. Stored procedure with parameter

About this course

Overview:

Welcome to "SQL for Data Science, Data Analytics, and Data Visualization!" This course is designed to provide a comprehensive understanding of SQL (Structured Query Language) and its applications in data science, data analytics, and data visualization. SQL is a powerful tool for managing and querying relational databases, making it essential for anyone working with data. In this course, you'll learn SQL from the ground up and explore its role in analyzing and visualizing data effectively.

  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Detailed explanation of SQL syntax and commands for data manipulation and querying
  • Hands-on exercises and projects for practical application of SQL concepts
  • Exploration of advanced SQL techniques for data analysis and visualization
  • Integration of SQL with popular data visualization tools such as Tableau or Power BI
  • Real-world case studies and examples showcasing SQL's applications in data science and analytics
  • Access to datasets and resources for practicing SQL queries and analysis
  • Supportive online community for collaboration and assistance throughout the course
  • Regular updates to keep pace with the latest advancements in SQL and data visualization technologies

Who Should Take This Course:

  • Data scientists, analysts, and professionals working with relational databases
  • Business analysts and decision-makers seeking to leverage SQL for data-driven insights
  • Students and professionals aiming to enhance their skills in data manipulation and analysis
  • Anyone interested in learning SQL for data science, analytics, and visualization applications

Learning Outcomes:

  • Master SQL fundamentals for data manipulation, querying, and analysis
  • Perform complex data analysis tasks using SQL queries and functions
  • Create interactive and visually appealing data visualizations with SQL and visualization tools
  • Develop advanced SQL skills for data exploration and visualization
  • Gain practical experience through hands-on exercises and projects
  • Build a portfolio of SQL-based data analysis and visualization projects
  • Communicate insights effectively through data visualization techniques
  • Stay updated with the latest trends and best practices in SQL and data visualization.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in Data Science and Machine Learning
Machine Learning Basics
Save 86%
47 lessons
Data Science and Machine Learning 11h 17m

Machine Learning Basics

16 others bought this course in the last 24 hours! Machine Learning Basics teaches you everything on the topic thoroughly from scratch so you can achieve a prof...

4.9 (8) 5 enrolled
£39.00 £279.00
Enrol now
£39.00 7h 15m · All Levels
Enrol now