ThankYou for these amazing tutorials BARAA.Just Loved them. I would like to kindly inform you that the playlist ' SQL Course I For Beginners ' misses out ALTER & DROP videos at the last. Whereas we can find them in this 'SQL Tutorial for Beginners [Ultimate Full Course] ' Please do add them so as to make the playlist a complete guide. Hope this comment grabs your attention and does the needful.
I have been looking for an A to Z SQL course and this the most comprehensive beginner course one can find on TH-cam. You have put so much effort to create the content and any person can easily follow the course. Thank you so much .
This is the best intro to SQL. Very organized and instructional, great examples and visuals. This is awsome and thank you sooooooooo much for doing this. Your a great teacher!!!
🎯 Key Takeaways for quick navigation: 00:00 *🎓 This SQL course covers everything from basics to advanced topics, designed to take beginners from zero to hero, applicable across different databases.* 02:07 *🗺️ The course is structured into nine chapters covering SQL basics, setting up the environment, querying data, filtering, joining tables, using functions, advanced topics, modifying data, and defining data.* 04:03 *📚 Data, information, and databases are explained, emphasizing SQL's role in managing structured and related data easily accessible and managed.* 08:42 *🤔 SQL, pronounced as "sequel" or "SQL", is the standard language for managing, manipulating, and retrieving data in databases, offering simplicity, readability, and widespread usage.* 21:29 *📝 SQL commands are grouped into categories such as Data Definition Language (DDL), Data Query Language (DQL), and Data Manipulation Language (DML), each serving specific purposes in managing and querying databases.* 23:13 *🔧 SQL commands like INSERT, DELETE, and UPDATE are used for data manipulation within databases.* 23:43 *🛡️ Data Control Language (DCL) includes SQL commands for granting or revoking access to databases, tables, or schemas.* 24:11 *💼 Transaction Control Language (TCL) commands like COMMIT, ROLLBACK, and SAVEPOINT manage database transactions for data integrity.* 26:20 *🧩 SQL statements consist of SQL commands, comments, clauses, keywords, identifiers, and operators.* 46:17 *💻 It's essential in programming to write code that is not only functional but also concise, high-performing, and visually organized.* 50:50 *📊 SQL querying forms a significant part of SQL usage, constituting about eighty percent of SQL tutorials.* 51:19 *🧩 SQL statements consist of various clauses such as select, from, join, where, group by, having, order by, and limit, each serving specific functions.* 52:44 *🛠️ The order of clauses in SQL statements is crucial, and violating this order leads to errors. Following the correct order is necessary for successful execution.* 53:11 *📊 The basic SQL statement for data retrieval is the SELECT statement, which retrieves data from tables. It can be tailored to specific needs using clauses like WHERE and ORDER BY.* 58:28 *🔄 To remove duplicates from SQL query results, the DISTINCT keyword is used, ensuring unique values are returned.* 01:01:42 *🎯 The ORDER BY clause in SQL sorts query results based on specified columns, allowing sorting in ascending or descending order.* 01:05:26 *🔄 ORDER BY can be used with multiple columns to sort query results further, providing flexibility in sorting criteria.* 01:08:07 *📝 While ORDER BY can use column names for sorting, using column positions is possible but not recommended due to potential issues when altering database structures.* 01:08:34 *📊 When using SQL queries, it's recommended to write the full name of columns instead of using numbers, as it ensures consistency and adaptability to schema changes.* 01:11:01 *🎯 Filtering data using the `WHERE` clause: SQL queries can filter data based on specific conditions, enabling the retrieval of relevant information.* 01:14:32 *🎚️ SQL's `WHERE` clause allows filtering data based on comparison operators like greater than, less than, and equal to, facilitating precise data retrieval.* 01:17:03 *🛠️ Comparison operators like less than, greater than, and equal to enable fine-grained data filtering in SQL queries.* 01:23:33 *📊 Understanding how SQL databases process `WHERE` clause conditions helps in comprehending query execution and result filtering.* 01:30:10 *🔍 When using the "AND" logical operator, all conditions must be true for a row to be included in the result.* 01:31:38 *🛠️ The "OR" logical operator returns true if at least one condition is true.* 01:33:41 *🔀 The "NOT" logical operator negates the condition, returning false if the condition is true and true if it's false.* 01:35:45 *🎯 "BETWEEN" is used to select rows within a specified range, including the boundary values.* 01:42:04 *📋 The "IN" operator allows defining a list of values to filter rows based on matching values.* 01:46:34 *🎭 The "LIKE" operator is used to match patterns in data, with "%" representing any sequence of characters and "_" representing any single character.* 01:51:29 *🧩 SQL's LIKE operator helps filter data based on patterns.* 01:52:39 *🎯 Use `%` in patterns to match any sequence of characters in SQL queries.* 01:53:51 *📝 To specify a character position in a pattern, use `_` in SQL.* 01:59:56 *🔄 SQL joins are crucial for querying data from multiple tables effectively.* 02:02:52 *🤝 SQL offers four types of joins: inner, left, right, and full join.* 02:04:00 *💡 SQL aliases help simplify queries and distinguish columns from different tables.* 02:12:40 *🔑 When using SQL joins, the order of tables matters, with the first table specified being considered the left table and the subsequent tables as the right tables.* 02:13:21 *🧩 Inner joins only present records that have matching values in both tables based on the specified key column.* 02:19:40 *📊 Right joins show all records from the right table and matching records from the left table, with nulls for non-matching records on the left.* 02:22:24 *💡 Full joins combine left and right joins, showing all records from both tables, but they might have performance issues with large datasets.* 02:29:13 *🚫 Using "UNION" removes duplicate rows from the result set, while "UNION ALL" retains all rows, including duplicates.* 02:34:27 *💡 Understanding data types in SQL is crucial to avoid errors, especially when combining strings and integers in queries.* 02:35:40 *🛠️ Aggregation functions like COUNT, SUM, AVG, MAX, and MIN are essential for analyzing and summarizing data in SQL projects.* 02:37:33 *📊 COUNT function is used to count the number of rows in a table, considering NULL values differently depending on the specified column.* 02:41:18 *🔄 SUM function works only on columns containing numbers, treating NULL values as zero.* 02:44:44 *📏 MIN and MAX functions are useful for identifying the minimum and maximum values in a column, respectively, while ignoring NULLs.* 02:49:11 *✂️ String functions in SQL like CONCAT, LOWER, UPPER, TRIM, LENGTH, and SUBSTRING are essential for manipulating text data.* 02:51:02 *📝 CONCAT function combines strings, while LOWER and UPPER functions convert text to lowercase or uppercase, respectively.* 02:53:34 *🕵️♂️ TRIM function removes leading and trailing white spaces from strings, essential for cleaning up text data.* 02:56:34 *💡 The `LENGTH` function in SQL calculates the number of characters in a string, useful for tasks like determining the length of a last name.* 02:57:43 *🧹 Combining SQL functions like `TRIM` and `LENGTH` can clean data by removing white spaces and then calculating the length of the resulting string.* 03:00:55 *📊 `GROUP BY` clause in SQL is used to group rows that have the same values into summary rows, typically used with aggregate functions like `COUNT`, `MAX`, etc.* 03:02:42 *🎯 In SQL, the `HAVING` clause filters groups created by the `GROUP BY` clause based on specified conditions, similar to `WHERE` but for aggregated data.* 03:13:44 *🔍 While `WHERE` clause filters data based on columns existing in the database, `HAVING` clause filters aggregated data based on conditions applied to those aggregates.* 03:17:24 *📊 Using SQL to filter data from multiple tables can be inefficient and static, requiring manual updates as data changes.* 03:19:28 *🔄 Subqueries offer a dynamic solution to filtering data, allowing for easier maintenance and adaptability as tables change.* 03:21:31 *🚀 Utilizing nested queries and subqueries enables solving complex tasks efficiently in SQL.* 03:22:15 *🛠️ Exist and in operators provide similar results in SQL, but "exist" may offer better performance for large tables.* 03:25:41 *📝 Data Manipulation Language (DML) commands like INSERT, DELETE, and UPDATE enable modifying data within SQL tables.* 03:27:32 *💡 Understanding table structure and column definitions is crucial before inserting data into SQL tables to avoid errors.* 03:32:42 *🧰 Utilizing default values and proper column mapping simplifies data insertion in SQL, improving efficiency and accuracy.* 03:39:03 *📝 In SQL, when inserting data into tables, you can omit columns with null values, allowing the database to handle them, making queries more concise.* 03:39:58 *🛠️ The `UPDATE` statement in SQL is used to modify existing rows in a table by changing their values based on specified conditions.* 03:54:16 *🛠️ When creating SQL tables, specify column names, data types, and constraints like primary keys and not null values to define the structure of the table effectively.* 04:00:41 *🔄 The `ALTER TABLE` command in SQL allows for modifying existing table structures, such as adding new columns, altering column definitions, or dropping columns.* Made with HARPA AI
This is the first video of 2+ hours that I have watched from the start till the end while keeping all my attention, OUTSTANDING work! YOU are the BEST! thank you!
This is the BEST SQL course ever! You are so clear with your explanations and I can just feel your joy in teaching it. Thank you so much for creating this and making it accessible for everyone!
Appreciate this. Been out of touch with SQL due to utilizing SAS but I'm steering back into SQL due to transferable skills and no license costs. Appreciate this 🎉
omg bro this is GOLD! few weeks ago I failed a technical interview at EPAM systems because they asked me about SQL but I had not used sql since I was at the university, I have only worked with non relational databases so My ass was kicked and I Lost a really good offer :c but now I have understood sql thanks to you.
I learned SQL from here and there. Also, did basic to advanced topics in SQL. Still, I watch whole video. It's amazing and so much powerful. I'm feeling confidence in SQL due to strong foundation by Baraa. This is just watch video if someone wants to learn SQL from scratch. Even 9-10th grade student can learn SQL from Baraas style of teaching. I learned not only SQL but Baraa's professionalism, passion for teaching as well. I'm grateful for this video. This is underrated channel.
10 mins in, and I'm already loving how you fully explain things and make them understandable; many just jump into creating tables. This is what I've been looking for. Thank you
Brilliant work Baraa, i was searching for a good lecture on sql and i stopped by your channel only to realize i have spent 4hrs 4 min. You're indeed wonderful
Hey Baraa, I'm thrilled to tell you that I've just completed this awesome course. I started watching it after I watched the masterpiece Tableau Course you created. And I can definitely say, I learnt so much from this tutorial and gonna start the later videos you have created till now. Thanks for all of the efforts you've given creating these awesome tutorials. Fun Fact: You gave me a habit of having a finger always on the shift key of my keyboard as we have to maintain the writing pattern of SQL queries. And now, while typing on other platforms, I'm typing some middle keywords of words in capital.😅 Again, Thanks for this video. Stay healthy and happy and give us so much of these fantastic contents.
I am very lucky to find this channel after watching many videos about sql on TH-cam. This is the most understandable, most systematic and clear video about sql. Please continue to teach us. Thank you, you deserve more❤
Hi Baraa, I am finding it hard to express my feelings and gratitude towards you. This tutorial is the best on Internet for SQL. Your teaching style is more than amazing! I cannot imagine the amount of hard work you must have put to make this video and make it easy for us to understand. I did not skip the video even for one second. It was so engaging and beautiful. Please keep up the amazing work! Much Love, Respect and Gratitude!!!❣
I wanted to learn SQL and your video tutorial was SPOT ON - seems easy but it is difficult at the same time as I will get to trully learn SQL by practicing and practicing. Thank you so much for the Tutorial for Beginners, looking forward for the Advanced Tutorial. BIG SUBSCRIBE!
This is such a structured & well tailored course! I used this as a refresher before my interview & it helped extensively! I am hoping to see the other part of the this course where you would give a deeper dive in advanced topics. I really appreciate your habit of not compromising upon quality. I would appreciate if you could come up with a interview preparation series on #tableau and #SQL .
I just completed this course and i can’t thank you enough for how easy it was to understand and to run to sql queries on my computer. It also increased my curiosity to explore more, i took the practice test on W3schools and i performed well just by learning from this course! Thank you so much again! You’re doing an amazing job and I can’t wait to learn more from the advanced course.
I am so happy to see this! You have exactly the cadence, voice, and most importantly, detailed information that makes learning MySQL so much better! Already subscribed to your website as well.
This was fantastic giving an all round clear view of everything and very easy to follow along. Looking forward to the advanced SQL series. Jumping into Tableau series in the meantime.
Explanation from granular to the top level, making it much easier for a person who has never been introduced to coding too. Very much appreciated the hard work, going through videos and practicing given tasks side by side makes understanding easier than slicing a cake.
"Wow! 🎉 This 4-hour SQL tutorial was absolutely amazing! The tutor explained all the foundational topics so clearly and made everything super easy to understand. 🙌 Perfect for beginners like me. Thank you for this incredible resource! 💡📊👏"
Hi Baraa, I just wanted to say that your explanations are excellent! I think you’re truly unique in using social media to do this job so effectively. Keep up the amazing work-you're making a big difference! We will support you with all our resources and efforts to help you continue doing such a great job. Best regards,
If there is something better than excellent, I would give it to your content, presentation, style. It just makes SQL sweet. I saw something at 1:23:56 and I was like, wait a minute. You will want to take a look at the Comparison Operator - GREATER THAN OR EQUAL TO. The operator is NOT correct. Thank you Sir. You are awesome
As I am total new to Sql, this tutorial gives me lot more confidence in terms of basics. Waiting for SQL Advanced tutorial as am switching my career to data science it is very helpful. When can i expect advanced SQL Tutorial. Thankyou very much Baraa.
Thank you so much Baraa ! I really appreciate your efforts in making these Courses. They are the roots of my Data Analytics Journey. I have Completed Your Tableau Course and Now SQL basics Course, Now i will be Moving on to the Advanced SQL. I am really Grateful to you for providing all this high quality learning for absolutely free. Once Again Thank you so much and i am glad i found your channel. I will keep sharing and Liking your videos, wishing you Great and a Healthy life ahead❤😊
Oh my goodness This man is just great Have being learning SQL for months but still don't understand somethings but just came across this vid. and within 3hrs i am good to go already. Thank you u so much Mr gentleman.
I have started watching your videos and these are very helpful for Upskilling my skills. Thank you so much Barra for all the amazing content and keep uploading more videos like this.Lots of Love from INDIA.
Haven't seen SQL for 2 years since University and might need it in my next interview, thanks for this great review and definitely also enhanced my understanding in some things.
I love this SQL Course. You explain everything so well and in great detail. Please Baraa can you do an Advanced SQL Course with Views/Triggers/complex joins ect.. can you explain everything like you have here in detail. You are an amazing teacher!
Appreciate what you're doing Baraa. This really helps us big time in such a professional way; every aspect is covered and the quality is priceless. Thanks again, and you've got another groupie here.
I live this video. I started with chapter 2, time point 29:48. I hate introductions. Yeah yeah. I know I'm wrong. But I go to the introduction *after* I know that everything else works for me. This video works for me. 😊
Amazing how you didn't take a single short cut when explaining every single step you took to figure out each solution...very informative and educational! Thank you Sir👊
Successfully completed this course, thank you very much for crystal clear instructions and diagrammatic representations, expecting you to do one full video on SQL, like you have done for Tableau. We are seeing your hard work in this channel, I wish you will get more subscribers, for this kind of stuff you could have more than million subscribers. Let's hope for the best. Love from India brother ❣
Amazing educational video🤩🤩🤩 I start to learn for the first time and liked the way how you teach and how you explained difficult themes in easy way😍😍😍 Good luck!
The best SQL Course for beginners like me !!! Thank you so much for this amazing data tutorial, please make a detailed Tutorial on Power BI like you made on Tableau
This is really a very nice tutorial, you indeed have a good teaching technique and skill. I am very grateful to run into this tutorial. It is the best I have seen on SQL so far
Another way to think of sql database is like a folder on your computer..for eg . You have a folder on your computer named as 'Starbucks' . When you click to open the folder there is other folders inside of this folder. For example : one folder that is named locations, another named branch managers, another called supplier. You can click on any one of the folders. When you click on the locations folder you see a csv file of the different locations that starbucks is located...hope this makes it simpler to visualize... Happy sequeling 🐬
Yessiree! Just as you said...30 steps (baby steps I'll term those) and walla! SUCCESS! Excellent tutor/trainer/teacher/lecturer! Ze BEST! Tqsvm Mr. Baraa Khatib Salkini! More trainings please! So very CLEAR indeed!
Thank you so much for the video. It was clear and very helpful. Just a little observation. At 1:17:00, I guess you meant to write >= instead of => . Thank you once again.
Thank you Simon for supporting my content, i really loved your blog in LinkedIn about my course, it motivated me and made me very happy. Thanks again for nice the nice comment, have a nice day!
Hi Baraa, Daniel here firstly I want to say thank you for the tutorial, I have been wanting to learn SQL for a long time now, got tutorials but non have been able to teach me until this came along. Thank you for the tutorial it was helpful. Secondly I want to continue with tableau just like the way you taught the SQL, using your website and the tutorial. Thirdly I need task that will help me grow more with the new skill I have aquire, so please how can you send task my way. Lastly I will say thank you again, you are a great teacher.
Hi Daniel, wow thank you for taking your time writing this amazing feedback. I really appreciate it, I'm really happy to hear that i am able to help with my courses and such comments really motivates me. Now back to your question, there are many different ways to learn SQL, here are some scenarios: 1. Create a database schema for a new project or a hypothetical scenario. 2.Write SQL queries to analyze trends, patterns, and other insights from a large dataset. 3.Design and implement a data warehouse or a data integration project. 4. Explore different SQL features, such as window functions, subqueries, and common table expressions. I hope this helps!
☕ If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
---------------------------------
⏱ TIMESTAMPS ⏱
---------------------------------
00:00:00 Intoruction to SQL Course
00:01:58 Course Curriculum Overview
00:03:41 Chapter1 - SQL Basics
00:03:50 #1 Introduction to SQL
00:10:20 #2 Why learn SQL?
00:14:29 #3 SQL Database Concepts
00:18:27 #4 SQL Table Concepts
00:21:13 #5 Main SQL Commands
00:25:35 #6 Elements of SQL Statements
00:29:48 Chapter2 - Prepare the Environment
00:30:04 #7 Download & Install MySQL
00:35:54 #8 Tour in MySQL Interface
00:41:26 #9 Install the Course Database
00:46:02 #10 Guide to SQL Coding Style
00:50:26 Chapter3 - Querying Data
00:50:44 #11 SQL SELECT
00:58:13 #12 SQL DISTINCT
01:01:33 #13 SQL ORDER BY
01:10:27 Chapter4 - Filtering Data
01:10:43 #14 SQL WHERE
01:17:05 #15 SQL Comparison Operators
01:24:11 #16 SQL Logical Operators AND, OR, NOT
01:35:41 #17 SQL BETWEEN
01:41:54 #18 SQL IN
01:46:36 #19 SQL LIKE
01:58:45 Chapter5 - Joining Data
01:59:00 #20 JOINS Concept
02:03:42 #21 SQL Alias - AS
02:07:28 #22 SQL INNER JOIN
02:15:49 #23 SQL LEFT JOIN
02:19:00 #24 SQL RIGHT JOIN
02:21:30 #25 SQL FULL JOIN
02:25:37 #26 SQL UNION & UNION ALL
02:35:35 Chapter6 - SQL Functions
02:35:47 #27 SQL Aggregate Functions
02:48:01 #28 SQL String Functions
03:00:39 Chapter7 - SQL Advanced Topics
03:00:51 #29 SQL GROUP BY
03:09:24 #30 SQL HAVING
03:15:09 #31 SQL Subquery: EXISTS vs IN
03:24:47 Chapter8 - Modifying Data
03:25:00 #32 SQL INSERT
03:39:53 #33 SQL UPDATE
03:45:47 #34 SQL DELETE & TRUNCATE
03:50:08 Chapter9 - Defining Data
03:50:24 #35 SQL CREATE Table
04:00:28 #36 SQL ALTER Table
04:02:18 #37 SQL DROP Table
04:03:05 Next SQL Course & THANK YOU
Enjoy :)
Hello Baraa.. This is very awesome SQL tutorial. Thanks for your effort.
Please let us know when will you release SQL advance Tutorial....
Hi Baraa... When you release SQL advance topics like CTE, Stored procedures and so on ..
How do I become an SQL developer
@DataWithBaraa when is the advance sql tutorial going to come out
ThankYou for these amazing tutorials BARAA.Just Loved them.
I would like to kindly inform you that the playlist ' SQL Course I For Beginners ' misses out ALTER & DROP videos at the last.
Whereas we can find them in this 'SQL Tutorial for Beginners [Ultimate Full Course] '
Please do add them so as to make the playlist a complete guide.
Hope this comment grabs your attention and does the needful.
I have not seen a video on SQL where someone explains the logic behind everything so clearly as you did. Thank you!
Thank you 🙏
I confirm its a powerful video easily comprehensive
I have been looking for an A to Z SQL course and this the most comprehensive beginner course one can find on TH-cam. You have put so much effort to create the content and any person can easily follow the course. Thank you so much .
This is the best intro to SQL. Very organized and instructional, great examples and visuals. This is awsome and thank you sooooooooo much for doing this. Your a great teacher!!!
It means a lot to me that you took the time to leave a comment and publicly subscribe. Thank you again!
🎯 Key Takeaways for quick navigation:
00:00 *🎓 This SQL course covers everything from basics to advanced topics, designed to take beginners from zero to hero, applicable across different databases.*
02:07 *🗺️ The course is structured into nine chapters covering SQL basics, setting up the environment, querying data, filtering, joining tables, using functions, advanced topics, modifying data, and defining data.*
04:03 *📚 Data, information, and databases are explained, emphasizing SQL's role in managing structured and related data easily accessible and managed.*
08:42 *🤔 SQL, pronounced as "sequel" or "SQL", is the standard language for managing, manipulating, and retrieving data in databases, offering simplicity, readability, and widespread usage.*
21:29 *📝 SQL commands are grouped into categories such as Data Definition Language (DDL), Data Query Language (DQL), and Data Manipulation Language (DML), each serving specific purposes in managing and querying databases.*
23:13 *🔧 SQL commands like INSERT, DELETE, and UPDATE are used for data manipulation within databases.*
23:43 *🛡️ Data Control Language (DCL) includes SQL commands for granting or revoking access to databases, tables, or schemas.*
24:11 *💼 Transaction Control Language (TCL) commands like COMMIT, ROLLBACK, and SAVEPOINT manage database transactions for data integrity.*
26:20 *🧩 SQL statements consist of SQL commands, comments, clauses, keywords, identifiers, and operators.*
46:17 *💻 It's essential in programming to write code that is not only functional but also concise, high-performing, and visually organized.*
50:50 *📊 SQL querying forms a significant part of SQL usage, constituting about eighty percent of SQL tutorials.*
51:19 *🧩 SQL statements consist of various clauses such as select, from, join, where, group by, having, order by, and limit, each serving specific functions.*
52:44 *🛠️ The order of clauses in SQL statements is crucial, and violating this order leads to errors. Following the correct order is necessary for successful execution.*
53:11 *📊 The basic SQL statement for data retrieval is the SELECT statement, which retrieves data from tables. It can be tailored to specific needs using clauses like WHERE and ORDER BY.*
58:28 *🔄 To remove duplicates from SQL query results, the DISTINCT keyword is used, ensuring unique values are returned.*
01:01:42 *🎯 The ORDER BY clause in SQL sorts query results based on specified columns, allowing sorting in ascending or descending order.*
01:05:26 *🔄 ORDER BY can be used with multiple columns to sort query results further, providing flexibility in sorting criteria.*
01:08:07 *📝 While ORDER BY can use column names for sorting, using column positions is possible but not recommended due to potential issues when altering database structures.*
01:08:34 *📊 When using SQL queries, it's recommended to write the full name of columns instead of using numbers, as it ensures consistency and adaptability to schema changes.*
01:11:01 *🎯 Filtering data using the `WHERE` clause: SQL queries can filter data based on specific conditions, enabling the retrieval of relevant information.*
01:14:32 *🎚️ SQL's `WHERE` clause allows filtering data based on comparison operators like greater than, less than, and equal to, facilitating precise data retrieval.*
01:17:03 *🛠️ Comparison operators like less than, greater than, and equal to enable fine-grained data filtering in SQL queries.*
01:23:33 *📊 Understanding how SQL databases process `WHERE` clause conditions helps in comprehending query execution and result filtering.*
01:30:10 *🔍 When using the "AND" logical operator, all conditions must be true for a row to be included in the result.*
01:31:38 *🛠️ The "OR" logical operator returns true if at least one condition is true.*
01:33:41 *🔀 The "NOT" logical operator negates the condition, returning false if the condition is true and true if it's false.*
01:35:45 *🎯 "BETWEEN" is used to select rows within a specified range, including the boundary values.*
01:42:04 *📋 The "IN" operator allows defining a list of values to filter rows based on matching values.*
01:46:34 *🎭 The "LIKE" operator is used to match patterns in data, with "%" representing any sequence of characters and "_" representing any single character.*
01:51:29 *🧩 SQL's LIKE operator helps filter data based on patterns.*
01:52:39 *🎯 Use `%` in patterns to match any sequence of characters in SQL queries.*
01:53:51 *📝 To specify a character position in a pattern, use `_` in SQL.*
01:59:56 *🔄 SQL joins are crucial for querying data from multiple tables effectively.*
02:02:52 *🤝 SQL offers four types of joins: inner, left, right, and full join.*
02:04:00 *💡 SQL aliases help simplify queries and distinguish columns from different tables.*
02:12:40 *🔑 When using SQL joins, the order of tables matters, with the first table specified being considered the left table and the subsequent tables as the right tables.*
02:13:21 *🧩 Inner joins only present records that have matching values in both tables based on the specified key column.*
02:19:40 *📊 Right joins show all records from the right table and matching records from the left table, with nulls for non-matching records on the left.*
02:22:24 *💡 Full joins combine left and right joins, showing all records from both tables, but they might have performance issues with large datasets.*
02:29:13 *🚫 Using "UNION" removes duplicate rows from the result set, while "UNION ALL" retains all rows, including duplicates.*
02:34:27 *💡 Understanding data types in SQL is crucial to avoid errors, especially when combining strings and integers in queries.*
02:35:40 *🛠️ Aggregation functions like COUNT, SUM, AVG, MAX, and MIN are essential for analyzing and summarizing data in SQL projects.*
02:37:33 *📊 COUNT function is used to count the number of rows in a table, considering NULL values differently depending on the specified column.*
02:41:18 *🔄 SUM function works only on columns containing numbers, treating NULL values as zero.*
02:44:44 *📏 MIN and MAX functions are useful for identifying the minimum and maximum values in a column, respectively, while ignoring NULLs.*
02:49:11 *✂️ String functions in SQL like CONCAT, LOWER, UPPER, TRIM, LENGTH, and SUBSTRING are essential for manipulating text data.*
02:51:02 *📝 CONCAT function combines strings, while LOWER and UPPER functions convert text to lowercase or uppercase, respectively.*
02:53:34 *🕵️♂️ TRIM function removes leading and trailing white spaces from strings, essential for cleaning up text data.*
02:56:34 *💡 The `LENGTH` function in SQL calculates the number of characters in a string, useful for tasks like determining the length of a last name.*
02:57:43 *🧹 Combining SQL functions like `TRIM` and `LENGTH` can clean data by removing white spaces and then calculating the length of the resulting string.*
03:00:55 *📊 `GROUP BY` clause in SQL is used to group rows that have the same values into summary rows, typically used with aggregate functions like `COUNT`, `MAX`, etc.*
03:02:42 *🎯 In SQL, the `HAVING` clause filters groups created by the `GROUP BY` clause based on specified conditions, similar to `WHERE` but for aggregated data.*
03:13:44 *🔍 While `WHERE` clause filters data based on columns existing in the database, `HAVING` clause filters aggregated data based on conditions applied to those aggregates.*
03:17:24 *📊 Using SQL to filter data from multiple tables can be inefficient and static, requiring manual updates as data changes.*
03:19:28 *🔄 Subqueries offer a dynamic solution to filtering data, allowing for easier maintenance and adaptability as tables change.*
03:21:31 *🚀 Utilizing nested queries and subqueries enables solving complex tasks efficiently in SQL.*
03:22:15 *🛠️ Exist and in operators provide similar results in SQL, but "exist" may offer better performance for large tables.*
03:25:41 *📝 Data Manipulation Language (DML) commands like INSERT, DELETE, and UPDATE enable modifying data within SQL tables.*
03:27:32 *💡 Understanding table structure and column definitions is crucial before inserting data into SQL tables to avoid errors.*
03:32:42 *🧰 Utilizing default values and proper column mapping simplifies data insertion in SQL, improving efficiency and accuracy.*
03:39:03 *📝 In SQL, when inserting data into tables, you can omit columns with null values, allowing the database to handle them, making queries more concise.*
03:39:58 *🛠️ The `UPDATE` statement in SQL is used to modify existing rows in a table by changing their values based on specified conditions.*
03:54:16 *🛠️ When creating SQL tables, specify column names, data types, and constraints like primary keys and not null values to define the structure of the table effectively.*
04:00:41 *🔄 The `ALTER TABLE` command in SQL allows for modifying existing table structures, such as adding new columns, altering column definitions, or dropping columns.*
Made with HARPA AI
Give this man award for simplifing all topics very easily
❤️❤️
This is the first video of 2+ hours that I have watched from the start till the end while keeping all my attention, OUTSTANDING work! YOU are the BEST! thank you!
My man has only 2k subcribers, UNBELIVEABLE!!!
GIVE THIS MAN THE CREDIT HE DESERVES
Genial content, I'm loving it! Keep it up!
EXCEL COURSE LIKE BUTTON
This is the BEST SQL course ever! You are so clear with your explanations and I can just feel your joy in teaching it. Thank you so much for creating this and making it accessible for everyone!
Wow, thank you!
Appreciate this. Been out of touch with SQL due to utilizing SAS but I'm steering back into SQL due to transferable skills and no license costs.
Appreciate this 🎉
omg bro this is GOLD!
few weeks ago I failed a technical interview at EPAM systems because they asked me about SQL but I had not used sql since I was at the university, I have only worked with non relational databases so My ass was kicked and I Lost a really good offer :c
but now I have understood sql thanks to you.
Keep pushing 💪 and happy to hear my videos helped
I learned SQL from here and there. Also, did basic to advanced topics in SQL.
Still, I watch whole video. It's amazing and so much powerful.
I'm feeling confidence in SQL due to strong foundation by Baraa.
This is just watch video if someone wants to learn SQL from scratch.
Even 9-10th grade student can learn SQL from Baraas style of teaching.
I learned not only SQL but Baraa's professionalism, passion for teaching as well.
I'm grateful for this video.
This is underrated channel.
10 mins in, and I'm already loving how you fully explain things and make them understandable; many just jump into creating tables. This is what I've been looking for. Thank you
Exactly this is what I want all to understand ❤️
@@DataWithBaraa you're awesome. Thank you.
The best SQL Course in TH-cam!! Thanks Baraa, very well explained, where were you all these years?! I love this tutorial 😍
The best out there, I took SQL with the google data analytics course, and this is waaaay better in explaining it also tableau as well, Cheers BARAA
This is the best tutorial on SQL I have seen on TH-cam.
@@MadduruThrilokNath glad you liked it ❤️
@@DataWithBaraa do you have any plans on python too
Brilliant work Baraa, i was searching for a good lecture on sql and i stopped by your channel only to realize i have spent 4hrs 4 min. You're indeed wonderful
You are way too underrated. You deserve more than a million subscribers. God bless you for all these amazing content at no cost!
Hey Baraa, I'm thrilled to tell you that I've just completed this awesome course. I started watching it after I watched the masterpiece Tableau Course you created. And I can definitely say, I learnt so much from this tutorial and gonna start the later videos you have created till now. Thanks for all of the efforts you've given creating these awesome tutorials.
Fun Fact: You gave me a habit of having a finger always on the shift key of my keyboard as we have to maintain the writing pattern of SQL queries. And now, while typing on other platforms, I'm typing some middle keywords of words in capital.😅
Again, Thanks for this video. Stay healthy and happy and give us so much of these fantastic contents.
I am very lucky to find this channel after watching many videos about sql on TH-cam. This is the most understandable, most systematic and clear video about sql. Please continue to teach us. Thank you, you deserve more❤
Hi Baraa,
I am finding it hard to express my feelings and gratitude towards you.
This tutorial is the best on Internet for SQL. Your teaching style is more than amazing!
I cannot imagine the amount of hard work you must have put to make this video and make it easy for us to understand.
I did not skip the video even for one second. It was so engaging and beautiful.
Please keep up the amazing work!
Much Love, Respect and Gratitude!!!❣
The best SQL tutorial ever, for the first time i came across a very detailed and step-by-step SQL video. thank you Sir
This is the more explicit ,concise and logical to follow. Masterful technique for teaching!!!
Excellent course, to be a Data analyst, and finally to be a data scientist.
You have done what no one else has. Absolutely fantastic Baraa! You have made SQL so much easier to understand. Thank you 🙏🏻
I have never seen such an organized course. just wow
I am really happy that you loved it! Thank you for the nice words, and have a nice day✌️
I wanted to learn SQL and your video tutorial was SPOT ON - seems easy but it is difficult at the same time as I will get to trully learn SQL by practicing and practicing.
Thank you so much for the Tutorial for Beginners, looking forward for the Advanced Tutorial.
BIG SUBSCRIBE!
This is such a structured & well tailored course! I used this as a refresher before my interview & it helped extensively! I am hoping to see the other part of the this course where you would give a deeper dive in advanced topics. I really appreciate your habit of not compromising upon quality. I would appreciate if you could come up with a interview preparation series on #tableau and #SQL .
Very impressive introductory course on SQL. Will be waiting for advanced SQL course series.
I just completed this course and i can’t thank you enough for how easy it was to understand and to run to sql queries on my computer. It also increased my curiosity to explore more, i took the practice test on W3schools and i performed well just by learning from this course! Thank you so much again! You’re doing an amazing job and I can’t wait to learn more from the advanced course.
Wow thanks for sharing your experience, glad you liked it ❤️
You are great man ! - your Full Course for SQL is the Best yet
I finished it in 2 days thank You so much
waiting for the next SQL for intermediate
I am so happy to see this! You have exactly the cadence, voice, and most importantly, detailed information that makes learning MySQL so much better! Already subscribed to your website as well.
This was fantastic giving an all round clear view of everything and very easy to follow along. Looking forward to the advanced SQL series. Jumping into Tableau series in the meantime.
Explanation from granular to the top level, making it much easier for a person who has never been introduced to coding too. Very much appreciated the hard work, going through videos and practicing given tasks side by side makes understanding easier than slicing a cake.
Many thanks for the feedback, makes me happy to hear that my content are easy to follow.
"Wow! 🎉 This 4-hour SQL tutorial was absolutely amazing! The tutor explained all the foundational topics so clearly and made everything super easy to understand. 🙌
Perfect for beginners like me.
Thank you for this incredible resource! 💡📊👏"
Thanks, Mr. Baraa, for this crystal-clear tutorial on basic SQL. really worth it.
Completed this course in one go.. Must say This is gold 🎉.. Thank you so much for providing this..❤
Great 👍
Hi Baraa,
I just wanted to say that your explanations are excellent! I think you’re truly unique in using social media to do this job so effectively. Keep up the amazing work-you're making a big difference! We will support you with all our resources and efforts to help you continue doing such a great job.
Best regards,
thanks for the kind words and your amazing support. I'll do my best to bring high quality content 👊
This video has been so helpful for my college course. The quality is amazing and you truly need more subs. keep up the good work!
Thank you so much. revised the course 2nd time and taken all the notes. Only practicing left.
Keep it up
Hi Baraa, your explanation of SQL is exceptional, and I comprehend it fully. Many thanks!
Thank you Baraa for your exceptional SQL tutorials, your clear explanations makes it so easy to understand. Keep up the fantastic work.
You're very welcome!
If there is something better than excellent, I would give it to your content, presentation, style. It just makes SQL sweet. I saw something at 1:23:56 and I was like, wait a minute. You will want to take a look at the Comparison Operator - GREATER THAN OR EQUAL TO. The operator is NOT correct. Thank you Sir. You are awesome
As I am total new to Sql, this tutorial gives me lot more confidence in terms of basics. Waiting for SQL Advanced tutorial as am switching my career to data science it is very helpful. When can i expect advanced SQL Tutorial. Thankyou very much Baraa.
The best SQL Course for beginners like me !!! Thank you so much for this amazing data tutorial.🙏🙏🙏
Thank you so much Baraa ! I really appreciate your efforts in making these Courses. They are the roots of my Data Analytics Journey. I have Completed Your Tableau Course and Now SQL basics Course, Now i will be Moving on to the Advanced SQL. I am really Grateful to you for providing all this high quality learning for absolutely free. Once Again Thank you so much and i am glad i found your channel. I will keep sharing and Liking your videos, wishing you Great and a Healthy life ahead❤😊
Oh my goodness
This man is just great
Have being learning SQL for months but still don't understand somethings but just came across this vid. and within 3hrs i am good to go already. Thank you u so much Mr gentleman.
Happy to help! Thanks for the support ❤️❤️
This a very detailed SQL course. I stumbled on this last night . You made learning so easy.
Happy you found the channel thanks for the nice feedback 👌
BEST LECTURE ON SQL
THANKS A LOT FROM INDIA
The best SQL course on TH-cam hands down.
Great course for beginners, everything is so organized and clear
Your practical approach and breakdown of details are super exceptional. I haven't seen it this good before.
Instantly subscribed ❤ love you from Sri Lanka 🇱🇰
I have started watching your videos and these are very helpful for Upskilling my skills. Thank you so much Barra for all the amazing content and keep uploading more videos like this.Lots of Love from INDIA.
Thanks for uploading again Baraa, Trust me You are the best teacher. Thanks a ton
I have seen multiple SQL courses, and you are by far the BEST at explaining everything about SQL. Congrats!
Wow, thanks! Glad to hear than :)
I love this SQL Course. You explain everything so well and in great detail. Is the advance course out yet???
Haven't seen SQL for 2 years since University and might need it in my next interview, thanks for this great review and definitely also enhanced my understanding in some things.
Thanks for the nice feedback 👍
best video created for begginers sql 🥰🥰🥰 amaizing work and should deserve more
Glad you liked it
I love this SQL Course. You explain everything so well and in great detail. Please Baraa can you do an Advanced SQL Course with Views/Triggers/complex joins ect.. can you explain everything like you have here in detail. You are an amazing teacher!
Baraa bro... thank a lot for your effort .... i am learning a lot..
This is so well presented and taught! Amazing :D
Appreciate what you're doing Baraa. This really helps us big time in such a professional way; every aspect is covered and the quality is priceless. Thanks again, and you've got another groupie here.
I live this video.
I started with chapter 2, time point 29:48.
I hate introductions. Yeah yeah. I know I'm wrong. But I go to the introduction *after* I know that everything else works for me. This video works for me. 😊
Hallo Lieber Baraa, ich habe diesen Kurs abgeschlossen. Es war wirklich toll und ich habe so viel gelernt. Vielen dank!
Freut mich, danke für nette Kommentar
Thanks, bro, for the best video!
Additionally, your voice is well-spoken.
This is the best SQL tutorial for beginners on TH-cam! I'd like it more than once if I could.
Glad you liked it! And your support is very appreciated and important!
This is the best intro to SQL Thank you
Thank you very much baraa I am from India you have done a great work thanks you again from the bottom of the heart
Amazing how you didn't take a single short cut when explaining every single step you took to figure out each solution...very informative and educational! Thank you Sir👊
I really appreciate it, thank you for the kind words. Happy you liked it and for leaving this nice feedback. Have a nice day 🙏
This is amazing
Thanks for simply SQL in such a way that everyone can understand.
Learning made simple
Successfully completed this course, thank you very much for crystal clear instructions and diagrammatic representations, expecting you to do one full video on SQL, like you have done for Tableau. We are seeing your hard work in this channel,
I wish you will get more subscribers, for this kind of stuff you could have more than million subscribers. Let's hope for the best.
Love from India brother ❣
Amazing educational video🤩🤩🤩 I start to learn for the first time and liked the way how you teach and how you explained difficult themes in easy way😍😍😍 Good luck!
You are the number one SQL instructor in the whole world. God Bless You wherever you are. It is so intersting and so helpful tutorial. Thanks indeed
Wow, the whole world!? God Bless you for writing me this nice words, you made me happy today !
Really worth baraa 💥👍
The best SQL Course for beginners like me !!! Thank you so much for this amazing data tutorial, please make a detailed Tutorial on Power BI like you made on Tableau
The best SQL course so far😊
Glad you like it ✌️
Amazing!!!!!!
Can't wait for advance SQL video. Hope you will upload it soon...........
You are amazing 👌
You made SQL quick and easy . Thank you so much. Grateful to find your channel. ✨
I am happy that I was able to help
THANKS!!!. INCREDIBLE COURSE.
This is really a very nice tutorial, you indeed have a good teaching technique and skill. I am very grateful to run into this tutorial. It is the best I have seen on SQL so far
Kudos man, loved it ❤
I love the tutorials. You are a teacher indeed. please do a video on python for beginners
Another way to think of sql database is like a folder on your computer..for eg .
You have a folder on your computer named as 'Starbucks' . When you click to open the folder there is other folders inside of this folder. For example : one folder that is named locations, another named branch managers, another called supplier. You can click on any one of the folders. When you click on the locations folder you see a csv file of the different locations that starbucks is located...hope this makes it simpler to visualize...
Happy sequeling 🐬
great analogy!
Yessiree! Just as you said...30 steps (baby steps I'll term those) and walla! SUCCESS! Excellent tutor/trainer/teacher/lecturer! Ze BEST! Tqsvm Mr. Baraa Khatib Salkini! More trainings please! So very CLEAR indeed!
Walla Thank you Bro, the best comment ever!
simply fantastic. very detailed and well structured even a 4 year old will have little trouble following. great job Baraa
Thanks dear because of you i learn SQL
You are the best tutor in TH-cam. Many gratitude
Really appreciate all the effort that you put into this!
My pleasure!
Watching the great tutorial from Regensburg.
Thank you so much for the video. It was clear and very helpful. Just a little observation. At 1:17:00, I guess you meant to write >= instead of => . Thank you once again.
Wow wow baraa you kill it, from frensh educated person its very clear , Thank you so much
Thank you too ☺ for supporting
Best SQL tutorial I have watched so far. Thank you for this.
I'm happy you enjoyed it :) thank you for the wonderful feedback
This tutorial was really helpful! Thank you for sharing your knowledge with us !
Oooh wow, Baraa, you explain the concepts so well and easy to understand, glad i found this channel. AMAZING!!!
Thank you Simon for supporting my content, i really loved your blog in LinkedIn about my course, it motivated me and made me very happy. Thanks again for nice the nice comment, have a nice day!
The BEST SQL TUTORIAL I have come across and enjoyed learning. Please make a Python tutorial too
Thank you 🙏
thanks for the course and its absolute best
Hi Baraa, Daniel here firstly I want to say thank you for the tutorial, I have been wanting to learn SQL for a long time now, got tutorials but non have been able to teach me until this came along. Thank you for the tutorial it was helpful. Secondly I want to continue with tableau just like the way you taught the SQL, using your website and the tutorial. Thirdly I need task that will help me grow more with the new skill I have aquire, so please how can you send task my way. Lastly I will say thank you again, you are a great teacher.
Hi Daniel, wow thank you for taking your time writing this amazing feedback. I really appreciate it, I'm really happy to hear that i am able to help with my courses and such comments really motivates me. Now back to your question, there are many different ways to learn SQL, here are some scenarios:
1. Create a database schema for a new project or a hypothetical scenario.
2.Write SQL queries to analyze trends, patterns, and other insights from a large dataset.
3.Design and implement a data warehouse or a data integration project.
4. Explore different SQL features, such as window functions, subqueries, and common table expressions.
I hope this helps!
@@DataWithBaraa thank you, will get right to it and give you feedback on my progress. Thanks again.
remarkable job..keep up with the great work please..GOD BLESS YOU