21 сағат бұрын
14 күн бұрын
21 күн бұрын
28 күн бұрын
Ай бұрын
Ай бұрын
2 ай бұрын
2 ай бұрын
2 ай бұрын
2 ай бұрын
2 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
Пікірлер
@elijahdelrosario-f7s Сағат бұрын
PLEASE HELP, THERE'S ANY WAY TO INSTALL SSMS IN MACBOOK M3?
@ankushchhokar 9 сағат бұрын
nice
@OZTutoh 11 сағат бұрын
Should an SQL beginner even look at this video?
@cugansteamid6252 16 сағат бұрын
thanks good sir!
@DatabaseStar 15 сағат бұрын
You're welcome!
@farzadmf Күн бұрын
+1 on option 4; less headache in the long run
@DatabaseStar Күн бұрын
Thanks for sharing!
@hodadisbirhan652 2 күн бұрын
I would like choose option1 then add simple checking constraint without going write store procedure to meet the requirment becuase storing comment in one place it is helpfull for reply and mentioning feature to incorporate it at one place and for performance optimization we can use view table
@DatabaseStar Күн бұрын
Thanks for sharing what you would do, that's good to know. I'm not sure you can add a check constraint to ensure that only one of the columns is populated, but I could be wrong.
@nader_908 2 күн бұрын
Hi Database Star this is a great video but how i can active hr on it
@DatabaseStar 15 сағат бұрын
Thanks! I'm not sure if it's already included, but I'll create a video on how to do this.
@nader_908 14 сағат бұрын
@@DatabaseStar Thanks❤
@sfermigier 2 күн бұрын
Some of these approchaes are implemented in some ORMs, like e.g. SQLAlchemy which supports three forms of inheritance: - single table inheritance - several types of classes are represented by a single table; - concrete table inheritance - each type of class is represented by independent tables; - joined table inheritance - the class hierarchy is broken up among dependent tables. Each class represented by its own table that only includes those attributes local to that class. Additionally, Django supports what they call "Generic Foreign Keys" and corresponds to your last solution.
@DatabaseStar Күн бұрын
That's good to know how ORMs handle it. I'm not surprised - application code can handle this much easier than databases.
@moayed8081 2 күн бұрын
Amazing video But What about Morph way? I think its the best in this case
@DatabaseStar Күн бұрын
What do you mean by "morph way"?
@ahmad-murery 2 күн бұрын
Call me crazy but I had to use the 5th method in a project where I had attachments table related to multiple content types (more content types still undetermined while developing the app). In the attachment table I added a reference_type and a reference_id Thanks Ben!
@DatabaseStar Күн бұрын
Good to know it worked for you!
@ahmad-murery Күн бұрын
@@DatabaseStar Well, I wasn't fully satisfied but yes it fulfilled the task
@Wormsandconditions 2 күн бұрын
Okay step 2 is insanely helpful to me right now, the entire video is great but step 2 led to some breakthroughs for me
@DatabaseStar Күн бұрын
Glad to hear it's helpful!
@Flite999 2 күн бұрын
thank thank you for not just referring us to some terrible blog for every answer. Very thorough and thoughtful. Great information and educational.
@DatabaseStar 15 сағат бұрын
Glad you liked it! I try to make my videos as useful as possible.
@bac2463 2 күн бұрын
I want to use Ubuntu for C++ programming. I know Ubuntu doesn't officially support Oracle installation. But will your instructions work on Ubuntu?
@DatabaseStar 15 сағат бұрын
I'm not sure, actually, as I've never used Ubuntu. I assume they would though, if Docker works on Ubuntu.
@DatabaseStar 2 күн бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using SSMS? Get my Timesaver Guide to SSMS here: www.databasestar.com/timesaver-ssms/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using SSMS? Get my Timesaver Guide to SSMS here: www.databasestar.com/timesaver-ssms/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using SQL Developer? Get my Timesaver Guide to Oracle SQL Developer here: www.databasestar.com/timesaver-sqldeveloper/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using SQL Developer? Get my Timesaver Guide to Oracle SQL Developer here: www.databasestar.com/timesaver-sqldeveloper/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@DatabaseStar 2 күн бұрын
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
@ahmadirfan7840 3 күн бұрын
I have learned the database design when i took an IT course at my college at early 2005.database design is my favorite subject and until now it is still my favorite. Before i start developing my app, what i have to do first is collect the data as a requirement and start build the ERD. From there, i will understand how to store the data into the database effectively. I remember when my last manager wanted me to design a database that related to healthcare. I have to make a research to use the crowfoot for the relationship, because i designed the databse using Chen design. And while i researched about it, I found your website link - Database Star. Your content is easy to understand and that's why i subscribe your channel. Oh yeah.. I still refer to your resource to build my current app with Laravel.
@phuhuy9797 3 күн бұрын
can you give me query to demonstrate the problem of missing or duplicating data when it matches the same criteria. i have already tried but have never faced your issue
@DatabaseStar 15 сағат бұрын
Hi, I have a video on my channel about duplicate rows: kzbin.info/www/bejne/rWrHqIttrdh1nbs
@phuhuy9797 8 сағат бұрын
@@DatabaseStar thank you
@veda41 3 күн бұрын
Thank you so much, perfect explanation. Greetings from Colombia 💛💙❤
@DatabaseStar Күн бұрын
Glad you liked it!
@sachintamangyonjan66 3 күн бұрын
Hi, I tried importing a csv file on MySQL workbench with more than 10 columns. While importing, it doesn't allow me to check the data types of all the columns and change them before hand. Do you have any solution for that?
@DatabaseStar 15 сағат бұрын
Hmm that makes it tricky. I would probably try to import the CSV into a table with a text or varchar data type, as this will likely import the data as-is. Then you can convert it into the type you need.
@CookedEli 3 күн бұрын
No matter what driver i try, it gives me "error" when testing the connection. All default parameters, basically all that is changed are the names and the password. What am I supposed to do, considering that everyone has no issues by the looks of it.
@DatabaseStar 15 сағат бұрын
Which database vendor are you using (Oracle, SQL Server, MySQL, Postgres, or something else)? Are you able to use the same connection details in another editor?
@md.marufbinsolaiman4038 3 күн бұрын
Just finished the 4th. eagerly waiting for the next. Please make it early.
@DatabaseStar 3 күн бұрын
Glad you liked it! I have part 5 coming up in my queue of videos.
@nagareddyyelti4628 4 күн бұрын
Good one thank you, here is I found some more techniques: kzbin.info/www/bejne/sHaliKttiM6XebMsi=CvirZgOp82zRddAJ kzbin.info/www/bejne/paWYdqGpaLKeg5osi=kjtcNtMk8G13gtzI
@b.7353 4 күн бұрын
where to find the password pls ?
@DatabaseStar 3 күн бұрын
The password for your database? It will be the password that you use in any other SQL editor you have, or the password you use when you set up the database.
@avinashavi6536 4 күн бұрын
No docker or podman executable found in your PATH it is showing like this
@DatabaseStar 3 күн бұрын
Have you installed Docker?
@michaellebediev6715 4 күн бұрын
Your presentation and explanation are so understandable) You have a teaching talent I think, thanks!! 💛💙
@DatabaseStar 3 күн бұрын
Thanks for the kind words, I'm glad you like my teaching style.
@michaellebediev6715 4 күн бұрын
Great job, bro! Thanks!!
@DatabaseStar 3 күн бұрын
You're welcome!
@michaellebediev6715 4 күн бұрын
you and your channel are awesome) so happy i've found it)
@DatabaseStar 3 күн бұрын
Thanks!
@ranjanadissanayaka5390 4 күн бұрын
Awsoeme video thank you so much 😊. Please make more database tutorials. Wish you all the best.
@DatabaseStar 3 күн бұрын
Thanks, I'm glad you like it. Sure, I have more tutorials coming.
@sardarsajju 5 күн бұрын
FINALLY..... Thank you so much for the video each and every step is sooo clear. Finally i got Oracle running on my computer🤗🤗🤗🤗
@DatabaseStar 3 күн бұрын
Glad to hear it worked!
@tommyli526 5 күн бұрын
Thank you for sharing, But I get ./buildContaInerImage.sh -e -v 19.3.0 following error on m1 macbook pro: Building image 'oracle/database:19.3.0-ee' ... [+] Building 240.6s (12/14) docker:desktop-linux => [stage-2 1/4] COPY --chown=oracle:dba --from=builder /opt/oracle /opt/oracle 36.8s => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh 0.4s ------ > [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh: 0.380 /bin/sh: /opt/oracle/oraInventory/orainstRoot.sh: No such file or directory ------ Dockerfile:130 -------------------- 129 | USER root 130 | >>> RUN "$ORACLE_BASE"/oraInventory/orainstRoot.sh && \ 131 | >>> "$ORACLE_HOME"/root.sh 132 | -------------------- ERROR: failed to solve: process "/bin/sh -c \"$ORACLE_BASE\"/oraInventory/orainstRoot.sh && \"$ORACLE_HOME\"/root.sh" did not complete successfully: exit code: 127 ERROR: Oracle Database container image was NOT successfully created. ERROR: Check the output and correct any reported problems with the build operation. any solution please ?
@DatabaseStar 3 күн бұрын
Oh interesting. I haven't seen that before, but this is a process that Oracle has created, so perhaps there's a solution on the Oracle forums or on StackOverflow.
@MengoMyth 5 күн бұрын
Very helpful thanks. I think it is worth to mention that if you install docker on Windows, you need first to install WSL and enable virtualization in your BIOS
@DatabaseStar 3 күн бұрын
Oh that's good to know, thanks for sharing.
@patientson 5 күн бұрын
Bad teaching... teach the art of applying subquery to a table and two tables. No tip was helphul at at all.
@DatabaseStar 5 күн бұрын
Thanks for the feedback! Is there a better way that you would explain it?
@michaellebediev6715 5 күн бұрын
thanks a lot!
@DatabaseStar 5 күн бұрын
You’re welcome!