Updated on May, 2024
Language - English
Good.
Learn SQL- Structured Query Language
SQL FOR DATA SCIENCE
MySQL,Data & Analytics,Data Analysis,Database Management,Database Administration,
Lectures -138
Resources -26
Duration -13.5 hours
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 help 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 which 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 covering 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
What will you learn in this course:
- To create, update and modify 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
What are the prerequisites for this course?
- No prior coding knowledge required
- Course is suitable for both experienced professionals and freshers
- Course is suitable for anyone who want to launch their 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
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
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