Updated on Jun, 2025
Language - English
Good
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
Development ,Database and Design Development,SQL
Lectures -138
Resources -26
Duration -13.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.
Curriculum
Check out the detailed breakdown of what’s inside the course
SQL Set Up
1 Lectures
-
SQL Set Up
06:49
06:49
Introduction to SQL
5 Lectures
Data Types In SQL
4 Lectures
Working With Database
3 Lectures
Working With Tables
8 Lectures
Fetching Records From A Table
4 Lectures
Comparison Operators In SQL
8 Lectures
Understanding NULL & NOT NULL Values
2 Lectures
Logical Operators In SQL
17 Lectures
Data Sorting In SQL
2 Lectures
Constraints in SQL
6 Lectures
ALIASES In SQL
1 Lectures
Arithmetic Operators In SQL
6 Lectures
Selecting Distinct Items
1 Lectures
Altering Tables In SQL
14 Lectures
MODIFY & DROP
7 Lectures
SHOW Statements
3 Lectures
Updating & Deleting Records From A Table
3 Lectures
Copying Table
2 Lectures
Statistical Functions In SQL
7 Lectures
Miscellaneous Functions In SQL
3 Lectures
GROUP BY & HAVING Clause
2 Lectures
Relationships Between Tables In SQL
2 Lectures
Data Modification Anomalies & SQL Keys
2 Lectures
Normalization In SQL
5 Lectures
FOREIGN Key
6 Lectures
ON DELETE & ON UPDATE Clause
6 Lectures
JOIN & UNION In SQL
8 Lectures
Instructor Details
Ammit Kumar Rai
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Good.
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now