SQL Full Course for Beginners 2025 | SQL Tutorial For Beginners | SQL for Beginners to Advanced
✅SQL Tutorials: Complete Learning Guide: https://www.upgrad.com/tutorials/soft...
✅FREE Certificate on Advanced SQL: Functions and Formulas: https://www.upgrad.com/free-courses/d...
✅AI-Powered Full Stack Development Course by IIITB: https://www.upgrad.com/ai-full-stack-...
✅Executive PG Certificate Programme in Data Science & AI: https://www.upgrad.com/data-science-p...
SQL is a fundamental skill for anyone working with data, it's widely used in various industries, including business, finance, healthcare, and more. It can help you analyze and visualize data, make informed decisions & Build data-driven applications. In simple words, SQL (Structured Query Language) is a programming language designed for managing and manipulating data stored in relational databases. It allows you to create, modify, and query databases to extract specific information.
Hello and welcome to SQL full course 2025 powered by upGrad. In this SQL tutorial for beginners we will be covering the following topics which is make a best SQL tutorial for beginners.
Key Topic Highlights
SQL Basics and how to structure your first queries.
Understand different SQL datatypes
Learn how to filter and refine your queries using the WHERE clause.
Apply aggregate functions like COUNT, AVG, SUM, and GROUP BY to analyze data.
Master the use of different types of joins to combine data from multiple tables.
Data Definition Language and Data Manipulation Language operations.
Topics with Time Stamps
Chapter 1 - SQL Basics
00:01:10 - What is Relational Database?
00:01:40 - What Is A Non-Relational Database?
00:02:55 - What is ER Diagram?
00:03:29 - What is Primary Key?
00:04:34 - What is Foreign Key?
00:05:10 - SQL Commands
00:07:23 - How to Create a Database?
00:12:44 - Example on Database
Chapter 2 - SQL Working with Datatypes
00:39:15 - What is Numeric Data Type?
00:41:05 - What is String Data Type?
00:42:30 - Data and Time Data Types
00:44:40 - Boolean Data Type
00:45:37 - Explicit Data Type Conversions
00:46:17 - CAST()
00:48:10 - CONVERT()
00:50:10 - Implicit Data Type Conversions
00:52:48 - Handling Null Values
00:57:20 - Why Handling Null is Important?
Chapter 3 - How to Filter Data In SQL?
01:00:00 - Concat()
01:01:55 - Example on Concat()
01:11:00 - Substr()
01:12:17 - Example on Substr()
01:16:12 - INITCAP()
01:17:10 - What is Distinct?
01:18:29 - Example on Distinct
01:22:29 - Define Where Clause
01:23:50 - Example on Where Clause
01:30:13 - Order of Execution
01:35:10 - Example on Order of Execution
Chapter 4 – Wildcards
01:46:44 - What is BETWEEN Operator?
01:47:55 - Example on BETWEEN Operator
02:02:22 - Define IN Operator
02:04:18 - Example on IN Operator
02:12:20 - What is LIKE Operator?
02:14:15 - What is WILDCARDS?
Chapter 5 - Aggregate Function and Grouping
02:32:02 - What is Aggregate Function?
02:33:48 - Example on Aggregate Function
02:46:56 - Define Group by
02:49:45 - Example on Group by
03:05:30 - What is Having Clause?
03:07:30 - Example on Having Clause
Chapter 6 - Joins in SQL
03:24:52 - What is Inner Joins?
03:26:36 - Example on Inner Joins
03:45:11 - What is Left Join?
03:46:50 - Example on Left Joins
03:57:56 - What is Right Join?
03:58:47 - Example on Right Join
04:03:07 - What is Full Join?
04:03:48 - Example on Full Join
Chapter 7 - Subqueries in SQL
04:22:37 - What is Subquery?
04:26:00 - Example on Subquery
Chapter 8 - SQL, DDL and DML
04:54:20 – What is DDL (Data Definition Language)
05:11:21 – What is DML (Data Manipulation Language)
Chapter 9 - SQL CTE and Views
05:33:30 - What is CET?
05:36:34 - Example on CET
05:54:19 - What are Views?
05:58:15 - Example on View Statement
06:11:30 - Topics Covered
#sqlfullcourse #sqltutorialforbeginners #sqltraining #sql #sqltutorial
Thank you for joining us in this SQL tutorial series. We hope you now feel more confident in your ability to write efficient SQL queries and work with databases effectively.
コメント