Data Science

SQL for Data Science

4.36 (100 Ratings)

Intermediate

Skill level

Free

Course cost

About this course

Data Science is an emerging field with a huge amount of job opportunities. Now-a-days most of the companies are going towards being data driven. This data is stored in a Database and is managed through Database Management system. DBMS makes our work so easy and organized. Hence, it becomes important to link the most popular programming language with the most amazing DBMS tool. SQL is the most widely-implemented database language and supported by the popular relational database systems, like MySQL, SQL Server, and Oracle. However, some features of the SQL standard are implemented differently in different database systems. Thus this makes SQL one of the most important concept to be learnt in the field of Data Science. So we have come up with this course which walks you through the important concepts and their Hands-on.

Skills covered

  • Group By
  • Having Clause
  • Joins
  • Subquery
  • SQL with Python

Course Syllabus

SQL for Data Science

  • Course Overview
  • Intro to Clauses
  • Group By Statement
  • Demo for Group By Statement
  • Having Clause Statement
  • Demo For having Clause
  • Alias in SQL
  • Joins in SQL
  • Types of Joins in SQL
  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join
  • SELF Join
  • Intro to Subquery
  • Problem Statement
  • What is a Subquery?
  • How Subquery Executes?
  • Type of Subquery
  • Demo for Subqueries
  • Introduction to SQL with Python
  • History of Python
  • Why Should You Learn Python?
  • Why is Python So Popular?
  • Installing Python
  • MySQL with Python Demo

Course Certificate

Get SQL for Data Science course completion certificate from Great learning which you can share in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

GL Academy Sample Certificate

Great Learning Academy - Free Online Certification Courses

Great Learning Academy, an initiative taken by Great Learning to provide free online courses in various domains, enables professionals and students to learn the most in-demand skills to help them achieve career success.

Great Learning Academy offers free certificate courses with 1000+ hours of content across 100+ courses in various domains such as Data Science, Machine Learning, Artificial Intelligence, IT & Software, Cloud Computing, Marketing & Finance, Big Data, and more. It has offered free online courses with certificates to 1 Million+ learners from 140 countries. The Great Learning Academy platform allows you to achieve your career aspirations by working on real-world projects, learning in-demand skills, and gaining knowledge from the best free online courses with certificates. Apart from the free courses, it provides video content and live sessions with industry experts as well.

X
popup asset

Welcome to Great Learning Academy