Introducing a programming learning service created by Kinocode / Kinoquest is the best way to learn Python, where you can immediately output the knowledge you've learned and feel your skills have solidified! ・There are over 350 questions ・No need to set up an environment! ・There is a curriculum so you won't get lost in how to study ▼ Register here ▼ https://kino-code.com/kq_service_a/?u... ーーーThis video is a compilation of videos about SQL. This video is a little long at 2 and a half hours, but it explains things carefully so that beginners can learn SQL. Please watch until the end to master SQL! ▼Table of contents00:01:30 [SQL Beginner's Course] 01. Course introduction ~ What is SQL? ~ Setting up the environment For beginners00:10:04 [SQL Beginner's Course] 02. What is a database table? 00:14:19 [SQL Beginner's Course] 03. SELECT statement The most basic of SQL basics00:17:01 [SQL Beginner's Course] 04. WHERE How to extract data based on specific conditions00:21:23 [SQL Beginner's Course] 05. ORDER BY Sorting data00:26:48 [SQL Beginner's Course] 06. GROUP BY Grouping, grouping00:32:23 [SQL Beginner's Course] 07. HAVING Extracting data from grouped data00:38:14 [SQL Beginner's Course] 08. JOIN Joining tables (INNER JOIN/LEFT JOIN)00:46:38 [SQL Beginner's Course] 09. Setting up a PostgreSQL environment Explanations for Mac and Windows! 01:04:27 [SQL Beginner's Course] 10. Connecting Python and PostgreSQL01:12:05 [SQL Beginner's Course] 11. Backing up and restoring a database01:16:06 [SQL Beginner's Course] 12. Joining tables (RIGHT JOIN/OUTER JOIN)01:23:05 [SQL Beginner's Course] 13. AND, OR How to extract with multiple conditions01:29:30 [SQL Beginner's Course] 14. LIKE How to extract records that match partially, front, or back01:40:07 [SQL Beginner's Course] 15. BETWEEN How to extract by specifying an interval01:43:28 [SQL Beginner's Course] 16. LENGTH function How to extract data based on the number of characters01:47:39 [SQL Beginner's Course] 17. DISTINCT How to extract by eliminating duplicate values01:53:52 [SQL Beginner's Course] 18. SUBSTRING How to extract part of a string01:59:40 [SQL Beginner's Course] 19. Regular Expressions How to extract complex pattern matching conditions02:08:51 [SQL Beginner's Course] 20. ROUND Can you round numbers as you like?02:13:21 [SQL Beginner's Course] 21. CASE How to separate processing according to conditions02:22:01 [SQL Beginner's Course] 23. IN How to clearly write and extract multiple OR conditions02:27:57 [SQL Beginner's Course] 24. LIMIT How to display only the required number of records▼Related videos[SQL Beginner's Course] 01. Course introduction ~ What is SQL? ~ Setting up the environment For beginners • [SQL Beginner's Course] 01. Course introduction ~ What is SQL? ~ Setting up the environmen... [SQL Beginner's Course] 02. What is a database table? • [SQL Beginner's Course] 02. What is a database table? [SQL Beginner Course] 03. SELECT Statement SQL Basics • [SQL Beginner Course] 03. SELECT Statement How to extract data from a database [SQL Beginner Course] 04. WHERE How to extract data under specific conditions • [SQL Beginner Course] 04. WHERE How to extract data under specific conditions [SQL Beginner Course] 05. ORDER BY Sorting data • [SQL Beginner Course] 05. ORDER BY How to sort data [SQL Beginner Course] 06. GROUP BY Grouping, grouping • [SQL Beginner Course] 06. GROUP BY Sorting data based on the values ​​of a specified column... [SQL Beginner Course] 07. HAVING Extracting data from grouped data • [SQL Beginner Course] 07. HAVING Extracting data from grouped data [SQL Beginner Course] 08. JOIN Joining tables (INNER JOIN / LEFT JOIN) • [SQL Beginner Course] 08. INNER JOIN/LEFT JOIN Table... [SQL Beginner's Course] 09. Setting up a PostgreSQL environment Explained on Mac and Windows! • [SQL Beginner Course] 09. Setting up a PostgreSQL environment Mac and Windows... [SQL Beginner Course] 10. Connecting Python to PostgreSQL • [SQL Beginner Course] 10. How to connect to PostgreSQL from Python [SQL Beginner Course] 11. Backing up and restoring a database • [SQL Beginner Course] 11. How to back up and restore a database [SQL Beginner Course] 12. Joining tables (RIGHT JOIN/OUTER JOIN) • [SQL Beginner Course] 12. RIGHT JOIN/OUTER JOIN Joining tables... [SQL Beginner Course] 13. AND, OR How to extract with multiple conditions • [SQL Beginner Course] 13. AND, OR How to extract with multiple conditions [SQL Beginner Course] 14. LIKE How to extract records that match partially, start with, or end with a match • [SQL Beginner Course] 14. LIKE How to extract records that match partially, start with, or end with a match... [SQL Beginner Course] 15. BETWEEN How to extract by specifying a range • [SQL Beginner's Course] 15. BETWEEN How to extract by specifying an interval [SQL Beginner's Course] 16. LENGTH function How to extract data using the number of characters as a condition • [SQL Beginner's Course] 16. LENGTH function How to extract data using the number of characters as a condition... [SQL Beginner's Course] 17. DISTINCT How to extract and eliminate duplicate values ​​• [SQL Beginner's Course] 17. DISTINCT How to extract and eliminate duplicate values ​​[SQL Beginner's Course] 18. SUBSTRING How to extract part of a string • [SQL Beginner's Course] 18. SUBSTRING How to extract part of a string [SQL Beginner's Course] 19. Regular Expressions How to extract using complex pattern matching as a condition • [SQL Beginner's Course] 19. Regular Expressions How to extract using complex pattern matching as a condition [SQL Beginner's Course] 20. ROUND Can you round numbers as you like? • [SQL Beginner's Course] 20. ROUND Can you round numbers as you like? [SQL Beginner's Course] 21. CASE How to separate processing according to conditions • [SQL Beginner's Course] 21. CASE How to separate processing according to conditions [SQL Beginner's Course] 22. Subquery How to write SQL within SQL for two-stage extraction • [SQL Beginner's Course] 22. Subquery How to write SQL within SQL for two-stage extraction... [SQL Beginner's Course] 23. IN How to clearly write multiple OR conditions for extraction • [SQL Beginner's Course] 23. IN How to clearly write multiple OR conditions for extraction [SQL Beginner's Course] 24. LIMIT How to display only the number of records you need • [SQL Beginner's Course] 24. LIMIT How to display only the number of records you need ▼Transcription blog [SQL Beginner's Course] 01. Course introduction ~ What is SQL? ~ Environment setup For beginnershttps://kino-code.com/sql01/ [SQL Beginner's Course] 02. What is a database table? https://kino-code.com/sql02/ [SQL Beginner's Course] 03. SELECT statement The most basic of SQL basics https://kino-code.com/sql03/ [SQL Beginner's Course] 04. WHERE How to extract data based on specific conditions https://kino-code.com/sql04/ [SQL Beginner's Course] 05. ORDER BY Sorting data https://kino-code.com/sql05/ [SQL Beginner's Course] 06. GROUP BY Grouping, grouping https://kino-code.com/sql06/ [SQL Beginner's Course] 07. HAVING Extracting data from grouped data https://kino-code.com/sql07/ [SQL Beginner's Course] 08. JOIN Joining tables (INNER JOIN/LEFT JOIN) https://kino-code.com/sql08/ [SQL Beginner's Course] 09. Setting up a PostgreSQL environment Explained for Mac and Windows! https://kino-code.com/sql09/ [SQL Beginner's Course] 10. Connecting Python and PostgreSQL https://kino-code.com/sql10/ [SQL Beginner's Course] 11. Backing up and restoring a database https://kino-code.com/sql11/ [SQL Beginner's Course] 12. Joining tables (RIGHT JOIN/OUTER JOIN) https://kino-code.com/sql12/ [SQL Beginner's Course] 13. AND, OR How to extract with multiple conditions https://kino-code.com/sql13/ [SQL Beginner's Course] 14. LIKE How to extract records that match partially, start with, or end with https://kino-code.com/sql14/ [SQL Beginner's Course] 15. BETWEEN How to extract by specifying an interval https://kino-code.com/sql15/ [SQL Beginner's Course] 16. LENGTH function How to extract data based on the number of characters https://kino-code.com/sql16/ [SQL Beginner's Course] 17. DISTINCT How to extract and eliminate duplicate values ​​https://kino-code.com/sql17/ [SQL Beginner's Course] 18. SUBSTRING How to extract part of a string https://kino-code.com/sql18/ [SQL Beginner's Course] 19. Regular Expressions How to extract using complex pattern matching conditions https://kino-code.com/sql19/ [SQL Beginner's Course] 20. ROUND Can you round numbers as you wish? https://kino-code.com/sql20/ [SQL Beginner's Course] 21. CASE How to separate processing according to conditions https://kino-code.com/sql21/ [SQL Beginner's Course] 22. Subquery How to write SQL inside SQL for two-stage extraction https://kino-code.com/sql22/ [SQL Beginner's Course] 23. IN How to neatly write and extract multiple OR conditions https://kino-code.com/sql23/ [SQL Beginner's Course] 24. LIMIT How to display only the number of records you need https://kino-code.com/sql24/ ▼I've written my self-introduction on my blog. https://kino-code.com/profile/​ ▼SNS Twitter : / likes Facebook : / Kinokod -105693727500005/ Website : https://kino-code.com/ #SQL #Beginner's Course #SELECT #Extraction #JOIN #GROUPBY