Это видео недоступно.
Сожалеем об этом.

SQL Tutorial for Beginners [Ultimate Full Course] - From Zero to HERO

Поделиться
HTML-код
  • Опубликовано: 15 авг 2024
  • In this 4-Hour SQL Course for Beginners, you'll learn everything you need to get started with SQL!
    ⬇️ Free Materials (Downloads): datawithbaraa....
    👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
    ☕ Stay connected
    ► Subscribe: bit.ly/3GiCVUE
    ► LinkedIn: / baraa-khatib-salkini
    ► Website: www.datawithba...
    ► Newsletter: bit.ly/BaraaNe...
    ► PayPal: paypal.me/bara...
    ► Join: / @datawithbaraa
    📚 Free Courses
    ✅ Tableau: • Complete HR Tableau Pr...
    ✅ Tableau Project: • Complete HR Tableau Pr...
    ✅ SQL Basics: • SQL Tutorial for Begin...
    ✅ SQL Advanced: • How I'd Learn Advanced...
    ✅ ChatGPT: • ChatGPT Tutorial for B...
    🎓Other Platforms (Certifications)
    ► Udemy: bit.ly/BaraaUdemy
    ► Skillshare (1 Free Month): bit.ly/BaraaSk...
    ⭐ My favorite books: kit.co/DataWit...
    💻 My gear: kit.co/DataWit...
    ⏱️ Timestamp
    00:00 Introduction 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
    #sql #mysql #sqlite #data
    *Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
    *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

Комментарии • 356

  • @DataWithBaraa
    @DataWithBaraa  Год назад +17

    ☕ 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 :)

    • @perfectionist6624
      @perfectionist6624 Год назад +3

      Hello Baraa.. This is very awesome SQL tutorial. Thanks for your effort.
      Please let us know when will you release SQL advance Tutorial....

    • @perfectionist6624
      @perfectionist6624 Год назад +1

      Hi Baraa... When you release SQL advance topics like CTE, Stored procedures and so on ..

    • @drakecarro2588
      @drakecarro2588 Год назад

      How do I become an SQL developer

    • @subhanshu2611
      @subhanshu2611 4 месяца назад

      @DataWithBaraa when is the advance sql tutorial going to come out

  • @MadduruThrilokNath
    @MadduruThrilokNath Месяц назад +6

    This is the best tutorial on SQL I have seen on RUclips.

  • @victoriavictoria7825
    @victoriavictoria7825 7 месяцев назад +28

    I have not seen a video on SQL where someone explains the logic behind everything so clearly as you did. Thank you!

  • @luismograine9221
    @luismograine9221 3 месяца назад +7

    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.

    • @DataWithBaraa
      @DataWithBaraa  3 месяца назад

      Keep pushing 💪 and happy to hear my videos helped

  • @MdAmirulIslam-ve7nq
    @MdAmirulIslam-ve7nq 18 дней назад +3

    Excellent course, to be a Data analyst, and finally to be a data scientist.

  • @ramonarribeno2382
    @ramonarribeno2382 2 месяца назад +4

    This is the more explicit ,concise and logical to follow. Masterful technique for teaching!!!

  • @biglo813
    @biglo813 Год назад +24

    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!!!

    • @DataWithBaraa
      @DataWithBaraa  Год назад +1

      It means a lot to me that you took the time to leave a comment and publicly subscribe. Thank you again!

  • @markrober4851
    @markrober4851 Год назад +10

    The best SQL Course in RUclips!! Thanks Baraa, very well explained, where were you all these years?! I love this tutorial 😍

  • @AlanTheAnalyst
    @AlanTheAnalyst 4 месяца назад +3

    You have done what no one else has. Absolutely fantastic Baraa! You have made SQL so much easier to understand. Thank you 🙏🏻

  • @ShivShankarAcademy-fn9yo
    @ShivShankarAcademy-fn9yo 18 дней назад +2

    Thanks dear because of you i learn SQL

  • @shraddhaw1537
    @shraddhaw1537 Год назад +9

    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 .

  • @punteanu831
    @punteanu831 11 месяцев назад +4

    My man has only 2k subcribers, UNBELIVEABLE!!!
    GIVE THIS MAN THE CREDIT HE DESERVES
    Genial content, I'm loving it! Keep it up!

  • @odafep9404
    @odafep9404 10 дней назад +1

    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

  • @iafofkhadze4628
    @iafofkhadze4628 Год назад +4

    I have never seen such an organized course. just wow

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      I am really happy that you loved it! Thank you for the nice words, and have a nice day✌️

  • @mahithakur8549
    @mahithakur8549 6 дней назад +1

    You made SQL quick and easy . Thank you so much. Grateful to find your channel. ✨

  • @sanjayajayasekera8819
    @sanjayajayasekera8819 Год назад +4

    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.

  • @mirceasavu
    @mirceasavu 7 месяцев назад +2

    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!

  • @ulugbektursunaliev3294
    @ulugbektursunaliev3294 4 месяца назад +2

    Very impressive introductory course on SQL. Will be waiting for advanced SQL course series.

  • @Bumblebeesly
    @Bumblebeesly Год назад +4

    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.

  • @saifkhan-wk2sw
    @saifkhan-wk2sw Месяц назад +1

    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.

    • @DataWithBaraa
      @DataWithBaraa  Месяц назад

      Wow thanks for sharing your experience, glad you liked it ❤️

  • @EstherNyarkoah-v5c
    @EstherNyarkoah-v5c Месяц назад +1

    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.

    • @DataWithBaraa
      @DataWithBaraa  Месяц назад

      Happy to help! Thanks for the support ❤️❤️

  • @healmusic4958
    @healmusic4958 Год назад +4

    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.

  • @lanashkvarets8121
    @lanashkvarets8121 Год назад +3

    The best SQL Course for beginners like me !!! Thank you so much for this amazing data tutorial.🙏🙏🙏

  • @budddmj8191
    @budddmj8191 10 месяцев назад +2

    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!

  • @ashwathraj2084
    @ashwathraj2084 Год назад +6

    Thanks for uploading again Baraa, Trust me You are the best teacher. Thanks a ton

  • @karishmasewraj6437
    @karishmasewraj6437 Год назад +3

    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 🐬

  • @Nomeruno1
    @Nomeruno1 Месяц назад

    This is the best SQL tutorial for beginners on RUclips! I'd like it more than once if I could.

    • @DataWithBaraa
      @DataWithBaraa  Месяц назад +1

      Glad you liked it! And your support is very appreciated and important!

  • @toygar8699
    @toygar8699 Год назад +3

    Great course for beginners, everything is so organized and clear

  • @imran_ashraf
    @imran_ashraf 9 месяцев назад +2

    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!

  • @johnadoga9765
    @johnadoga9765 8 месяцев назад +2

    I love this SQL Course. You explain everything so well and in great detail. Is the advance course out yet???

  • @jopadjr
    @jopadjr Месяц назад +1

    3k+.. Thanks. This is going to be a great video. Will start this weekend.

  • @Ahmed_Rehan0
    @Ahmed_Rehan0 2 месяца назад +1

    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

  • @adamo1262
    @adamo1262 7 месяцев назад +1

    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👊

    • @DataWithBaraa
      @DataWithBaraa  7 месяцев назад

      I really appreciate it, thank you for the kind words. Happy you liked it and for leaving this nice feedback. Have a nice day 🙏

  • @user-rs4jh5mg4f
    @user-rs4jh5mg4f Год назад +1

    I have seen multiple SQL courses, and you are by far the BEST at explaining everything about SQL. Congrats!

  • @micaelzekarias1537
    @micaelzekarias1537 Год назад +2

    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

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      Wow, the whole world!? God Bless you for writing me this nice words, you made me happy today !

  • @venkatb318
    @venkatb318 Месяц назад +1

    Thank you so much. revised the course 2nd time and taken all the notes. Only practicing left.

  • @tonnytrumpet734
    @tonnytrumpet734 2 месяца назад +1

    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.

    • @DataWithBaraa
      @DataWithBaraa  2 месяца назад

      Thanks for the nice feedback 👍

  • @easycommerceclasses8241
    @easycommerceclasses8241 10 месяцев назад +2

    remarkable job..keep up with the great work please..GOD BLESS YOU

  • @cbbcbb6803
    @cbbcbb6803 Год назад +1

    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. 😊

  • @itzboyon6983
    @itzboyon6983 3 месяца назад +1

    Hallo Lieber Baraa, ich habe diesen Kurs abgeschlossen. Es war wirklich toll und ich habe so viel gelernt. Vielen dank!

    • @DataWithBaraa
      @DataWithBaraa  3 месяца назад

      Freut mich, danke für nette Kommentar

  • @aliabboud7177
    @aliabboud7177 3 месяца назад +1

    Wow wow baraa you kill it, from frensh educated person its very clear , Thank you so much

    • @DataWithBaraa
      @DataWithBaraa  3 месяца назад

      Thank you too ☺ for supporting

  • @nitkarshchourasia2406
    @nitkarshchourasia2406 4 месяца назад +1

    🎯 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

  • @tonytodd7011
    @tonytodd7011 28 дней назад +1

    Great presentation, and voice too!

  • @OrleansMakuza
    @OrleansMakuza 2 месяца назад +1

    Simply the best SQL starter pack!👍

  • @osoriomatucurane9511
    @osoriomatucurane9511 7 месяцев назад +1

    Absolutely tutorial, concise and crystal clear! This one stands out of the crowd by all standards!
    I am halfway, where you discuss the operators used to filter the rows/records. Where would fit in the 'any, exists, all'?

  • @opeoluwaagbede3558
    @opeoluwaagbede3558 29 дней назад +1

    lovely teaching. kudos

  • @SivaramanPR-xu1dz
    @SivaramanPR-xu1dz 3 месяца назад +1

    nice course, i have zero knowledge in SQL but your course gave a complete and excellent intro, looking forward for advanced courses and project.
    can you suggest any text book for MY SQL to follow.

  • @adewaleadewoye9401
    @adewaleadewoye9401 Год назад +1

    This a very detailed SQL course. I stumbled on this last night . You made learning so easy.

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      Happy you found the channel thanks for the nice feedback 👌

  • @sureshcsk4872
    @sureshcsk4872 3 месяца назад

    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 ❣

  • @YAF3-Official
    @YAF3-Official Год назад +1

    You are great man ! - your Full Course for SQL is the Best yet

    • @YAF3-Official
      @YAF3-Official Год назад

      I finished it in 2 days thank You so much
      waiting for the next SQL for intermediate

  • @wasimali2175
    @wasimali2175 Месяц назад +1

    thank you so much for the best lecture/explanation of the SQL.👏👏👏👏👏👏👏👏👏👏👏................................but i am still waiting for the CTEs and subqueries

  • @chijiokecontacts4620
    @chijiokecontacts4620 Год назад +1

    You are the best tutor in RUclips. Many gratitude

  • @nelsonmrakpor4070
    @nelsonmrakpor4070 Год назад +1

    simply fantastic. very detailed and well structured even a 4 year old will have little trouble following. great job Baraa

  • @user-ti3ns8zq5z
    @user-ti3ns8zq5z Год назад +3

    Thanks!! Concise and easy to follow:)

  • @saminfo574
    @saminfo574 9 месяцев назад +1

    WOW I love this Channel and the way you explain- I got stuck as I have Mac not windows- How do I download or MAC, I did not see that anywhere.

  • @investerstallone
    @investerstallone 2 месяца назад +1

    Best tutorial ever! Thank you soo much!

  • @davidebuk5309
    @davidebuk5309 7 месяцев назад +1

    The BEST SQL TUTORIAL I have come across and enjoyed learning. Please make a Python tutorial too

  • @AbhikChowdhury-fh5zo
    @AbhikChowdhury-fh5zo 12 дней назад +1

    You are awesome.. thank you soo much for this video. Love your accent as well.

    • @DataWithBaraa
      @DataWithBaraa  12 дней назад

      So nice of you, you are awesome too for leaving this nice comment

    • @AbhikChowdhury-fh5zo
      @AbhikChowdhury-fh5zo 11 дней назад +1

      ​@@DataWithBaraa thanks so much for the comment..shows how kind you are

  • @KunalKumar-hw5lb
    @KunalKumar-hw5lb 3 месяца назад

    Loved all of your courses so far. They're very easy to understand and I always look for your courses when I am looking for something. Thank you for all the hard work and your wonderful courses

  • @ofesegunayodeji6382
    @ofesegunayodeji6382 6 месяцев назад +1

    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.

  • @jani1914
    @jani1914 Месяц назад +1

    It is easy to understand all topics, Thanks for this course👌.

  • @Gloria_Baffoe
    @Gloria_Baffoe Месяц назад +1

    This Channel is the best 😻

  • @successfulvictorypublisher6090
    @successfulvictorypublisher6090 Год назад +1

    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!

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      Walla Thank you Bro, the best comment ever!

  • @sachigadade2634
    @sachigadade2634 7 дней назад +1

    I will forever be gratefully to you. this video is a gem , I have learned so much from you literally you are a definition of perfectionist . Thank you so very much for this
    Also can you please make a video on Power BI I wish to learn so much from you 😀😀😀😀😀😀Thank You Mr. Baraa🙏🙏

    • @DataWithBaraa
      @DataWithBaraa  7 дней назад

      Wow thanks you for taking time writing me this, I really appreciate your support and the kind words ❤️

  • @successeze6759
    @successeze6759 11 месяцев назад +1

    Best SQL tutorial I have watched so far. Thank you for this.

    • @DataWithBaraa
      @DataWithBaraa  11 месяцев назад

      I'm happy you enjoyed it :) thank you for the wonderful feedback

  • @Actuarially-Actuary-yg8tu
    @Actuarially-Actuary-yg8tu 7 месяцев назад +1

    Absolutely Great Tutorial! Thank You so much ! This video's content might even be better than paid content!!

  • @quinth6524
    @quinth6524 2 месяца назад +1

    This Tutorial was EXCELLENT!!!!

  • @dominickalmilla989
    @dominickalmilla989 11 месяцев назад +2

    crystal clear explanations. keep it up.

  • @simonoganga9535
    @simonoganga9535 Год назад +1

    Oooh wow, Baraa, you explain the concepts so well and easy to understand, glad i found this channel. AMAZING!!!

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      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!

  • @istvan5400
    @istvan5400 Год назад +2

    Thank you for all your effort to put this together to help dumb people like me. Easy to understand SQL after this tutorial. You did a great job!

  • @samkhan1735
    @samkhan1735 Год назад +1

    Thanks for this amazing and quite helpful tutorial. Just finished this one. Moving to the next part - 50 SQL queries. Thanks again, a loooooottttttttt

  • @priyanshsaini3527
    @priyanshsaini3527 Год назад +2

    Amazing!!!!!!
    Can't wait for advance SQL video. Hope you will upload it soon...........

  • @AnshulSinghal
    @AnshulSinghal Год назад +2

    Just completed the course and I can say I have understood each topic. This is the easiest tutorial you can find on SQL. So, if you are thinking whether this course is good or not then definitely go for it.
    Thanks Baraa, will be waiting for the Advanced SQL Course :)

    • @DataWithBaraa
      @DataWithBaraa  Год назад +1

      Awesome! Thanks for completing the course and giving such positive feedback! Glad to hear it was helpful and easy to understand. Appreciate your support and encouragement. Stay tuned for the advanced SQL course, coming soon!

    • @008-memanishankarjha6
      @008-memanishankarjha6 8 месяцев назад

      Please release it soon @@DataWithBaraa

  • @rafaedu100
    @rafaedu100 3 месяца назад +1

    Best tutorial ever. You're the best!

  • @venkatb318
    @venkatb318 Месяц назад +1

    Thank you so much Baraa. It is a great course very better than many paid courses on Udemy. You are a very good instructor. Please try to make more courses if you can. Very good content.

    • @DataWithBaraa
      @DataWithBaraa  Месяц назад

      Thank you so much! I will do my best :)

  • @AgataAnio
    @AgataAnio Год назад +2

    You're the best. Thank you very much for your work.
    😃

  • @iqraazhar11
    @iqraazhar11 Год назад +1

    Excellent explanation of each and every SQL concept discussed within the video. Really appreciate your effort.

  • @Tinossauro0
    @Tinossauro0 Месяц назад +1

    thank you very much

  • @mengineer5150
    @mengineer5150 Год назад +1

    This is wayyy better than most of university course! Keep up the good work.

  • @moizpratapgarhwala5279
    @moizpratapgarhwala5279 Год назад +1

    Best of the best course till date.
    Waiting for the advance for Data Analysis.

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      In Progress! Thanks 🙏 appreciate your feedback

  • @islamelsyed9746
    @islamelsyed9746 Год назад +2

    you are the best. thanks my friend💚

  • @hishammohammed5125
    @hishammohammed5125 7 месяцев назад +1

    By far the best tutorial on RUclips. Thank you so much sir.
    Also will there be an advanced SQL video soon?

    • @DataWithBaraa
      @DataWithBaraa  7 месяцев назад +1

      First wish you happy new year!! Thank you for the amazing words, and I am cooking currently the course need few months 🙂 sorry for that and stay tuned !

  • @user-jn5ie3vy2f
    @user-jn5ie3vy2f 5 месяцев назад +1

    We have only one word for you Baraa .... that's THANK U from India ❤❤❤

    • @DataWithBaraa
      @DataWithBaraa  5 месяцев назад

      People from India are just amazing, i work with them every day.. wonderful people.

  • @yosephkumlachew1572
    @yosephkumlachew1572 3 месяца назад +1

    Great introductory video , material ,very engaging

  • @shalormmoses7703
    @shalormmoses7703 Год назад +1

    thanks very much, buddy, I will be expecting the advanced tutorials on data science. God bless you !!!!!!

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      Working on it, thanks for your feedback ✌️

  • @danielbecon7117
    @danielbecon7117 Год назад +1

    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.

    • @DataWithBaraa
      @DataWithBaraa  Год назад +2

      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!

    • @danielbecon7117
      @danielbecon7117 Год назад

      @@DataWithBaraa thank you, will get right to it and give you feedback on my progress. Thanks again.

  • @Ascendify5
    @Ascendify5 3 месяца назад +1

    SUMO FROM JAPAN WRESTLES GORRILLA HAVING ONE LEG(SELECT,FROM,JOIN,WHERE,GROUP BY,HAVING,ORDER BY, LIMIT)

  • @ruchikakhanna9672
    @ruchikakhanna9672 5 месяцев назад +1

    Thanks for teaching SQL.You are a good teacher

    • @DataWithBaraa
      @DataWithBaraa  5 месяцев назад

      You are so welcome, thank you!

  • @ateekagarwal4545
    @ateekagarwal4545 Год назад +1

    @dataWithBaraa..thanku for amazing course for me… u r finest content creators with a great tutor… I ll help me a lot to learn the basics….please upload next SQL course it will be great help for me..Thanku

  • @praveenkagale1841
    @praveenkagale1841 Год назад +1

    One of the best video of SQL on RUclips. very nice content and very well explained. Thanks Baara

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      You are very welcome, and thank you so much for the lovely comment this motivates me to make more!

  • @ifoodieTV
    @ifoodieTV Месяц назад

    Database comparison to a LIBRARY is spot on. Awesome 🎉

    • @ifoodieTV
      @ifoodieTV 14 дней назад

      This is the best tutorial on SQL I have seen on RUclips. I split it over few days. Did I miss the part on FOREIGN KEY?

  • @arsalanbaloch774
    @arsalanbaloch774 Год назад +2

    playback speed: 1.25 and boom you will love the tutorial more

  • @koushikchoudhury2179
    @koushikchoudhury2179 4 месяца назад +1

    You are the best.Hats off to you

  • @sambarajkanaveni7312
    @sambarajkanaveni7312 5 месяцев назад +1

    Really it's unique from other content it helps 🎉👏

  • @user-bv2qd5wt1q
    @user-bv2qd5wt1q 7 месяцев назад +1

    Hello! Thank you so much for this great course! This is my first SQL course and I am very happy I started this journey with you as your explanations are very concise and clear. One thing I am curious about, while modifying data, if we do the wrong modifications are there any shortcuts to undo the last modification?

    • @DataWithBaraa
      @DataWithBaraa  7 месяцев назад +1

      You are very welcome and I’m happy to hear that you are enjoying the course. You typically need to rely on backup or transaction rollback mechanisms to revert changes. You can use ROLLBACK command to undo changes made within the current transaction. Regularly backing up your database also provides a way to restore to a previous state if needed. It is not that easy to undo changes that’s why be very careful when you do modifications to the database. I hope this helped.

    • @user-bv2qd5wt1q
      @user-bv2qd5wt1q 7 месяцев назад +1

      @@DataWithBaraa Thank you :)

  • @luckycreative7418
    @luckycreative7418 Год назад +1

    You are doing such a greate job i wish u knew that...

  • @tubetubepotato6455
    @tubetubepotato6455 Год назад +1

    Bro you deserve at least 500k subs.THIS VIDEO IS EXCELLENT.

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      Bro i only wish! But thank you for the nice words!! With your support I might someday reach that :)

  • @mdkhalilurrhaman790
    @mdkhalilurrhaman790 2 месяца назад +1

    Hi Baraa, Very nice for SLQ. I need more SQL with Project like "Tableau Project😀👍👍👍"

    • @DataWithBaraa
      @DataWithBaraa  2 месяца назад

      Planned in the new course !

    • @mdkhalilurrhaman790
      @mdkhalilurrhaman790 2 месяца назад +1

      @@DataWithBaraa yes. To learn SQL. it's completely new to me

    • @mdkhalilurrhaman790
      @mdkhalilurrhaman790 2 месяца назад +1

      @@DataWithBaraa you are doing easy learning for new learners. We appreciate your hard work .

  • @enobongoguntola8632
    @enobongoguntola8632 Год назад +1

    U made SQL very easy to understand n interesting, thanks so much

    • @DataWithBaraa
      @DataWithBaraa  Год назад

      U made me happy! Glad to hear you liked it

  • @wasimali2175
    @wasimali2175 Месяц назад +1

    so much explanation thank you "BARAA''
    but i am waiting for the CTEs and subqueries lecture ........... please make video on this one thank you