0:00 - Intro 0:07 - Cross Join Introduction 0:56 - Cross Join Syntax - Example 1:50 - Beware of the Cartesian Product 2:41 - Real World Example - Budget Allocation
Thank you. This video has been helpful for me. I am in a SQL course where I am learning about SQL in less than 10 weeks. I am subscribing to your channel for more guidance.
I'm pretty happy to see you posting new content again. I got a question: how to insert dummy data using SQL? (Like: using SQL commands to insert test data. Example: in "table 1" inserting "name 1" and incrementing to "name 2", "name ..." until reach a up limit defined by us. I remember seen something like this but I can't remember the right terms used for the video I saw.
I'm quite happy with your Udemy course-it's very good! Our goals are to increase enrollments, foster positive feedback, and optimize income. I'm excited to come up with unique tactics to elevate your course even further.
Thank You for your Video, I am working on a Fuel Management Program which expresses the information over both a Hire Allocation Table which has several Joins, this had to be CROSS JOIN with a Data Table to show each Asset's Hire Per Date with an Event showing whilst the Asset was on Hire which Date did it refuel. I did figure it out, but the program took 2 hours to run as it is a quantum of multiple tables. Now have simply Updated the Hire Allocation with all the necessary information then i will CROSS JOIN using select. Out of interest sake, has anyone done an UPDATE with CROSS JOIN?
0:00 - Intro
0:07 - Cross Join Introduction
0:56 - Cross Join Syntax - Example
1:50 - Beware of the Cartesian Product
2:41 - Real World Example - Budget Allocation
I can see me using this in some future projects. Thank you.
U sir have the best Sql explaining method on the internet... bravo
Thank you. This video has been helpful for me. I am in a SQL course where I am learning about SQL in less than 10 weeks. I am subscribing to your channel for more guidance.
I'm pretty happy to see you posting new content again.
I got a question: how to insert dummy data using SQL? (Like: using SQL commands to insert test data. Example: in "table 1" inserting "name 1" and incrementing to "name 2", "name ..." until reach a up limit defined by us. I remember seen something like this but I can't remember the right terms used for the video I saw.
I'm quite happy with your Udemy course-it's very good! Our goals are to increase enrollments, foster positive feedback, and optimize income. I'm excited to come up with unique tactics to elevate your course even further.
you have the right example for cross join... liked it..
You're videos are great!
Sir I wanna learn SQL from beginning. can you help me?
Are the videos in the sql basic training playlist arranged in order? Or the videos are just randomly added to this playlist.
Thank you!
your videos are really great please keep going
Great example, thank you!
Well done!
thanks for the video, sir what the format function of getting a number to be in such way 123-4642-452-56
Thank You for your Video,
I am working on a Fuel Management Program which expresses the information over both a Hire Allocation Table which has several Joins, this had to be CROSS JOIN with a Data Table to show each Asset's Hire Per Date with an Event showing whilst the Asset was on Hire which Date did it refuel.
I did figure it out, but the program took 2 hours to run as it is a quantum of multiple tables.
Now have simply Updated the Hire Allocation with all the necessary information then i will CROSS JOIN using select.
Out of interest sake, has anyone done an UPDATE with CROSS JOIN?
Very good
Thanks
Videos in spanish please!!
Poor Accounting Department :(