Пікірлер

• 
  @christophersalazar69842 сағат бұрын

  I couldnt connect due to the security group thank you!

• 
  @DatabaseStarСағат бұрын

  Glad it helped!

• 
  @patrickkahng22744 сағат бұрын

  Excellent. Thank you.

• 
  @DatabaseStarСағат бұрын

  You are welcome!

• 
  @buddy.abc1234 сағат бұрын

  Tip number 18, I learned the hard way 5 years ago 😢

• 
  @DatabaseStarСағат бұрын

  Oh yeah this tip can definitely be learned the hard way (I've done it too)

• 
  @patrickkahng22744 сағат бұрын

  Excellent. Thank you.

• 
  @DatabaseStar2 сағат бұрын

  You’re welcome!

• 
  @neila8805 сағат бұрын

  Excellent tips. Thank you!

• 
  @DatabaseStar2 сағат бұрын

  Glad it was helpful!

• 
  @codeswithsumon6 сағат бұрын

  Thank you for this video. I want to user ORACLE APEX using docker. how can I do this? If you have any helpful content please share me? Thank you

• 
  @DatabaseStarСағат бұрын

  You're welcome! I've never used Oracle Apex so I'm not sure how to get it working.

• 
  @walkingradiance95567 сағат бұрын

  Valentina Studio Pro has a feature that issues a warning when you execute an update without a where clause.

• 
  @hasnaouiacademy78998 сағат бұрын

  Your channel literally changed my life, I am backend I learned sql and database but I found your channel amazing Thanks a million 😊

• 
  @DatabaseStar2 сағат бұрын

  Wow thanks for the kind words. I’m glad you like the channel 😊

• 
  @proatgaimz10 сағат бұрын

  Great advice, thanks Ben!

• 
  @DatabaseStar2 сағат бұрын

  No worries!

• 
  @dn941610 сағат бұрын

  Thanks Ben

• 
  @DatabaseStar2 сағат бұрын

  No problem!

• 
  @deeppatel400211 сағат бұрын

  THANKS FOR THIS RELLY HELPFUL

• 
  @DatabaseStar2 сағат бұрын

  Glad it helped!

• 
  @UdemeImeh12 сағат бұрын

  Thanks A lot

• 
  @DatabaseStar2 сағат бұрын

  You’re welcome!

• 
  @saoudahmedkhan254913 сағат бұрын

  Great

• 
  @DatabaseStar2 сағат бұрын

  Thanks!

• 
  @naveenchandpandey794017 сағат бұрын

  Great video. Just a question I had about this. How are you capturing the progress of a student for restricting him from going to the next session before completing the current lesson. You have used is_progress_limited but till which point the student is allowed to access is not available i guess. Can you explain it a bit?

• 
  @GENESIS429-yx8im20 сағат бұрын

  thank you for the video very helpful

• 
  @DatabaseStar2 сағат бұрын

  Glad it was helpful!

• 
  @sdmagicКүн бұрын

  You never disappoint! The plan goes liked this: You send and I receive an email -> I click the link and watch the video -> I learn A LOT! Thank you so very much.

• 
  @DatabaseStar23 сағат бұрын

  Thanks a lot! I'm glad you liked the video.

• 
  @danielsehnoutek2016Күн бұрын

  Amazing tutorial, both this and also for the SQL Database installation, because everything is simply working :D

• 
  @DatabaseStar23 сағат бұрын

  Thanks! Glad it's working for you.

• 
  @kodekorp2064Күн бұрын

  If the "ROW_KEY" is a randomly assigned key value by the database that can change at a later time, why would you audit the "ROW_KEY"?

• 
  @DatabaseStar23 сағат бұрын

  Good question. It depends on whether you consider that as an update you want to track. Maybe you do want to track it so you know when it was changed and what it changed from and to.

• 
  @andreasansa6569Күн бұрын

  Very clear!!

• 
  @DatabaseStar23 сағат бұрын

  Glad it was helpful!

• 
  @MohammedAbdelkrimGuendouzКүн бұрын

  كلامك صحيح 100%

• 
  @DatabaseStar23 сағат бұрын

  Thanks!

• 
  @SelvamSelvam-qe3wfКүн бұрын

  Which software is used

• 
  @DatabaseStar23 сағат бұрын

  I use LucidChart for this.

• 
  @naveenchandpandey7940Күн бұрын

  Just a query I have. where are you capturing the actual reaction of the users Like/Dislike? in the reaction table I can see only user_id and post_id

• 
  @DatabaseStar23 сағат бұрын

  Good question. For this example, I only captured Likes, so there's only one reaction to capture. If we want to capture Dislikes, we could add a new column to that reaction table. If there is only Like and Dislike, perhaps a boolean or tinyint column called is_like, which could be 1 or 0.

• 
  @ChrisLloyd-s8o2 күн бұрын

  Thanks Ben really appreciate your insight on the install and usage of this game changing new Visual Studio code extension 😎😎

• 
  @DatabaseStar23 сағат бұрын

  No problem, glad it was useful!

• 
  @huntercoleman13472 күн бұрын

  Great video. Derailed information and useful. Thank you.

• 
  @DatabaseStar23 сағат бұрын

  Glad it was helpful!

• 
  @sam-uw3gf2 күн бұрын

  Great video

• 
  @DatabaseStar23 сағат бұрын

  Thanks!

• 
  @andyj1152 күн бұрын

  INSERT or BULK-INSERT do not have a linear data insertion time, but an exponential one. Therefore the test should be repeated using 250,000 records for each database (in the comparison of no-cost databases). Oracle and MSSql in the paid versions have very respectable performances as they no longer have RAM or CPU core limits

• 
  @DatabaseStar23 сағат бұрын

  Thanks for the tip, yeah that's right. Others have pointed that out as well. In hindsight I should have used different versions of Oracle and SQL Server to avoid the size limits, so I could import the billion rows in all vendors.

• 
  @robderrt3 күн бұрын

  how to do it in python?

• 
  @DatabaseStar23 сағат бұрын

  I'm not sure, I don't have a lot of experience in Python. I assume you can write some code to read the CSV file and analyse it directly.

• 
  @TsegazeabWuta3 күн бұрын

  Thank you, Database Star, for the awesome explanation. However, I have a question about choosing relational databases for e-commerce apps. What are the criteria for selecting relational databases over non-relational databases? Additionally, which relational database is best for an e-commerce app and why?

• 
  @DatabaseStar23 сағат бұрын

  Good question. I don't know a lot about the benefits of non-relational databases so I can't really give any advice on that. Regarding the best relational database, I think any of them could work well. I personally recommend Postgres for most situations as it's free, performs well, and has a lot of features.

• 
  @julesnestt3 күн бұрын

  Thank you for your tutorials. I’m learning and watching something from a simple start to a full end product serves a lot. 😃👍

• 
  @DatabaseStar23 сағат бұрын

  You're welcome! Glad you like them.

• 
  @YacineBenjedidia-wm6pw3 күн бұрын

  thanks a lot

• 
  @DatabaseStar23 сағат бұрын

  You're welcome!

• 
  @TheLitu893 күн бұрын

  Appreciate

• 
  @DatabaseStar23 сағат бұрын

  Thanks!

• 
  @nagasaireddy7743 күн бұрын

  Hi , I am getting an error when typing the command ./buildcontainerimage.sh" failed to compute cache key: failed to calculate checksum of ref 06afb456-c5e3-40af-a561-7ccbe4729cdc::y1asmyidkj6fyofphwrh3uj3h: "/LINUX.ARM64_1919000_db_home.zip": not found" ,

• 
  @buddy.abc1234 күн бұрын

  Interesting, thank you for sharing. For the postgres part, do you think the pagination negatively affected the results?

• 
  @DatabaseStar3 күн бұрын

  No problem! I think it did, actually, based on a couple of other comments. In hindsight I should have shown all results at once in the query to get a more accurate number.

• 
  @jatinsaini29144 күн бұрын

  Your Content is true GEM 💎

• 
  @DatabaseStar3 күн бұрын

  Thanks!

• 
  @MrTrollland4 күн бұрын

  why cant guardian_type and levels be enums?

• 
  @DatabaseStar4 күн бұрын

  They could be, but you have more control over separate tables and they can appear in drop-down lists. I created a video about enum vs lookup table here: kzread.info/dash/bejne/dZ-GxMl9dJrQfrA.html

• 
  @osoriomatucurane95114 күн бұрын

  Awesome, interesting to know that it can be done in SQL. But I would rather go for the Power BI calendar table.

• 
  @DatabaseStar4 күн бұрын

  Oh good to know!

• 
  @MrTrollland4 күн бұрын

  How about many to many relationships between 3 tables? 4, 5, n tables?

• 
  @DatabaseStar4 күн бұрын

  It's a similar concept. You can add the foreign key of the third table into the joining table. I can create another video on this to explain it further.

• 
  @osoriomatucurane95114 күн бұрын

  Awesome Tip. I wish there is was a short cut in SQL to get value counts in percentage (distinct count of categories and their percentage)

• 
  @DatabaseStar4 күн бұрын

  Yeah that would be handy!

• 
  @rajands654 күн бұрын

  Thank you so much !

• 
  @DatabaseStar4 күн бұрын

  You're welcome!

• 
  @Yourzanny4 күн бұрын

  I wonder who does that 🤔

• 
  @DatabaseStar4 күн бұрын

  I've seen it more often than I like!

• 
  @GUENDOUZ7965 күн бұрын

  Where is Requirement pdf

• 
  @DatabaseStar4 күн бұрын

  You can get the PDF for this video here: www.databasestar.com/dbdesign/

• 
  @VKY-XLR85 күн бұрын

  Nothing, alternative for mysql then?

• 
  @DatabaseStar4 күн бұрын

  Yeah, there's a keyword or technique called INSERT ON DUPLICATE KEY UPDATE which I can make a video about in the future.

• 
  @syfre95065 күн бұрын

  You should use SQL Server for developers edition, it's not limited

• 
  @DatabaseStar4 күн бұрын

  That's true! Others have mentioned it and I wasn't aware of that when I made the video.

• 
  @asrytube5 күн бұрын

  Oh I love Oracle! I've been using for years and fascinated with all its features, functions and properties. Its direct path loading feature is also awesome.

• 
  @DatabaseStar4 күн бұрын

  Yeah, it does have a lot of features.

• 
  @sameerkurhade64365 күн бұрын

  thank you so much really

• 
  @DatabaseStar4 күн бұрын

  You're welcome

• 
  @havefun55195 күн бұрын

  Thx, really great tut for me.

• 
  @DatabaseStar4 күн бұрын

  Glad you liked it

• 
  @walkingradiance95565 күн бұрын

  I would use UUIDs.

• 
  @DatabaseStar4 күн бұрын

  UUIDs for the primary keys? Yeah that's another option that I've seen and it can work.

• 
  @JohnoScott6 күн бұрын

  this sounds like a job for DuckDB 🦆🔥💪

• 
  @DatabaseStar4 күн бұрын

  Oh good to know!

• 
  @nagesh0076 күн бұрын

  Awesome

• 
  @DatabaseStar4 күн бұрын

  Thanks!

• 
  @ChrisWard746 күн бұрын

  20+ years in IT never knew about the wrong way have always used JOIN so now I'm curious how many people have been doing it the wrong way.

• 
  @DatabaseStar4 күн бұрын

  Yeah I see many examples of it in blog posts, books, and sample code online :|