Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Structured Query Language (SQL) Online Course

person icon Ammit Kumar Rai

4.7

Structured Query Language (SQL) Online Course

To understand the concepts of SQL, covered different types of operators in SQL and their usage with practical sessions

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Ammit Kumar Rai

English [CC]

category icon Development ,Database and Design Development,SQL

Lectures -138

Resources -26

Duration -13.5 hours

Lifetime Access

4.7

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

SQL is the most in-demand language for professionals working in data science or data analysis field. SQL helps to communicate with the database and organize raw data in a structured form. SQL also helps to run queries through the data to bring meaningful insights that contribute to decision-making.

This course will start with basic concepts of SQL. After the basics, and concepts of SQL, we have covered different types of operators in SQL and their usage with practical sessions.

Then the course will move to constraints in SQL. Every constraint and SQL key is covered with a practical example. Then the learners will get to learn the concept of relationships and normalization in SQL.

In this course, you will get:

  • 137 videos to master SQL for data science.
  • 13+ hours of recorded lectures.
  • Study materials cover the theory, syntax, and practical examples.
  • Every session covers the theory and practice of each theory.

In this course, you will learn:

  • To create, update and modify the database.
  • To create, update and modify tables.
  • To write data retrieval queries and evaluate the result set.
  • To write data updation and modification queries.
  • Normalization in SQL.
  • Creating joins in SQL.
  • Creating relationships in tables using the foreign key and primary key.
  • AND a lot more concepts.

Goals

  • To create, update and modify the database.
  • To create, update and modify tables.
  • To write data retrieval queries and evaluate the result set.
  • To write data updation and modification queries.
  • To convert data to the best form using normalization techniques.
  • To establish relations and get desired output with multiple tables by using SQL JOINS & UNION.
  • Creating relationships in tables using foreign key and primary key.
  • AND lots of more concepts with practical sessions.

Prerequisites

  • No prior coding knowledge is required.
  • The course is suitable for both experienced professionals and freshers.
  • The course is suitable for anyone who wants to launch a career in data science.
Structured Query Language (SQL) Online Course

Curriculum

Check out the detailed breakdown of what’s inside the course

SQL Set Up

1 Lectures
  • play icon SQL Set Up 06:49 06:49

Introduction to SQL

5 Lectures
Tutorialspoint

Data Types In SQL

4 Lectures
Tutorialspoint

Working With Database

3 Lectures
Tutorialspoint

Working With Tables

8 Lectures
Tutorialspoint

Fetching Records From A Table

4 Lectures
Tutorialspoint

Comparison Operators In SQL

8 Lectures
Tutorialspoint

Understanding NULL & NOT NULL Values

2 Lectures
Tutorialspoint

Logical Operators In SQL

17 Lectures
Tutorialspoint

Data Sorting In SQL

2 Lectures
Tutorialspoint

Constraints in SQL

6 Lectures
Tutorialspoint

ALIASES In SQL

1 Lectures
Tutorialspoint

Arithmetic Operators In SQL

6 Lectures
Tutorialspoint

Selecting Distinct Items

1 Lectures
Tutorialspoint

Altering Tables In SQL

14 Lectures
Tutorialspoint

MODIFY & DROP

7 Lectures
Tutorialspoint

SHOW Statements

3 Lectures
Tutorialspoint

Updating & Deleting Records From A Table

3 Lectures
Tutorialspoint

Copying Table

2 Lectures
Tutorialspoint

Statistical Functions In SQL

7 Lectures
Tutorialspoint

Miscellaneous Functions In SQL

3 Lectures
Tutorialspoint

GROUP BY & HAVING Clause

2 Lectures
Tutorialspoint

Relationships Between Tables In SQL

2 Lectures
Tutorialspoint

Data Modification Anomalies & SQL Keys

2 Lectures
Tutorialspoint

Normalization In SQL

5 Lectures
Tutorialspoint

FOREIGN Key

6 Lectures
Tutorialspoint

ON DELETE & ON UPDATE Clause

6 Lectures
Tutorialspoint

JOIN & UNION In SQL

8 Lectures
Tutorialspoint

Instructor Details

user profile image

Ammit Kumar Rai

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

V

Vaibhav kashyap

Good

P

Phil Toa

Good.

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515