filmov
tv
SQL for Beginners: 1+ Hour of Database Tutorial
Показать описание
✅Download the free demo file and follow along here
In this SQL for Beginners tutorial, we're diving headfirst into the world of SQL (Structured Query Language) and mastering the SELECT statement. 🚀
SQL is the backbone of managing and manipulating relational databases, and in this lesson, we're using PostgreSQL v11 as our database playground. Get ready to explore SQL commands through the user-friendly pgAdmin interface.
We'll start by understanding the essential components of a SELECT statement, like specifying columns to retrieve and the table to fetch data from. But that's just the tip of the iceberg! 🗻
You'll learn how to filter data with the WHERE clause, group data with GROUP BY, set conditions with HAVING, and sort results using ORDER BY. Plus, we'll cover useful functions, string manipulations, and working with date and time.
Whether you're a beginner or looking to level up your SQL skills, this video has something for everyone. Join us on this SQL adventure, and let's unlock the power of data together!💡📊
We've even included downloadable course files from our paid-for courses so you can follow along with this course. This will help you put what you are learning into practice and master SQL.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:21 - Course Overview
00:02:34 - Introduction to SQL
00:14:06 - Predicates, Operators, and Case Expression
00:24:58 - String Functions Part 1
00:34:00 - String Functions Part 2
00:43:45 - String Functions Part 3
00:53:18 - Working With Date & Time Part 1
01:01:45 - Working With Date & Time Part 2
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
💬Stay in touch!
🔔 Subscribe to our channel:
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
In this SQL for Beginners tutorial, we're diving headfirst into the world of SQL (Structured Query Language) and mastering the SELECT statement. 🚀
SQL is the backbone of managing and manipulating relational databases, and in this lesson, we're using PostgreSQL v11 as our database playground. Get ready to explore SQL commands through the user-friendly pgAdmin interface.
We'll start by understanding the essential components of a SELECT statement, like specifying columns to retrieve and the table to fetch data from. But that's just the tip of the iceberg! 🗻
You'll learn how to filter data with the WHERE clause, group data with GROUP BY, set conditions with HAVING, and sort results using ORDER BY. Plus, we'll cover useful functions, string manipulations, and working with date and time.
Whether you're a beginner or looking to level up your SQL skills, this video has something for everyone. Join us on this SQL adventure, and let's unlock the power of data together!💡📊
We've even included downloadable course files from our paid-for courses so you can follow along with this course. This will help you put what you are learning into practice and master SQL.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:21 - Course Overview
00:02:34 - Introduction to SQL
00:14:06 - Predicates, Operators, and Case Expression
00:24:58 - String Functions Part 1
00:34:00 - String Functions Part 2
00:43:45 - String Functions Part 3
00:53:18 - Working With Date & Time Part 1
01:01:45 - Working With Date & Time Part 2
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
💬Stay in touch!
🔔 Subscribe to our channel:
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Комментарии