Видео

How to create a user in this database ? It showing error when using this command “CONN USER user_name IDENTIFIED BY mypassword “after connecting database

Lovely!

Amazing explanation!

Clear and concise instructions. Thank you!

This lesson is as sweet as Sugar. 🍬🍬Thank you for sharing

like new_app....how do i set my database

please share some queries to get data from this library database

Great Job .

Installation on MacBooks is a problem in itself, thanks for sharing.

I really appreciate the time you took to make this video. It's beautifully explained and has a great amount of information! If I could, I would like to ask something in regards to the shopping cart and orders. Say a user is signed in and he adds a few products to the shopping cart - now those products will be saved to the database and added to the shopping_cart as I understand. Then when the user decides to checkout those products, will they be copied to the shop_order table through order_line? Or is it that when the user adds products to the shopping_cart, those products should get added to order_line directly too?

this really helped me learn about CTEs, so thank you very much!!! Now I just need to learn what "recursive" means and find your video on hierarchical queries.

Brother the script U provided in Ur GitHub repository has possible errors, I ran it in MySQL workbench but it failed saying "Error Code: 1824. Failed to open the referenced table 'attribute_type' ". Can U plx fix this ASAP as I have to practice queries on some meaningful data. Plx provide the correct script to create this database or guide me if I made a mistake.

Brilliant, thanks! It is convenient that offset returns null if there are not enough rows. One correction: you need to select distinct salary values, otherwise some test cases will fail.

i'm a fan of yours

Thankyou for this wonderful explanation Lot of my doubts automatically got solved as I kept listening your explanation

this guy is really good help me a lot in database design

awesome, i need to run apex on cloud, can you make a video to learn this topic?

Great video your solution to the problem is amazingly well explained

Thank you. I used to use mysqlYog but moved over to Linux and thus needed something new, this was very helpful. I haven't watched the full video yet but I hope this program has the ability to export your databases as sql quarries for backups 🤔 Also a bit of a side note but do you know of any reputable mysql clients on Android? Nothing fancy, I just want to be able to quickly review the information when I'm out and about. 🤔

Bunch of thanks

What is temp table ? does it mean View Table ?

Thank you for your lessons with wonderful voice. Looking forward to part 4

first time it was connected but lator when i open again vs code and try to connect it shows error

you're the best

really good thanks for everything

what is Tible?! its a Table! not so hard and its Paper not Piper

Why is my select not capitalized, how can I fix this?

It removed my confusion about volume and bind mount.

Nice explanation. 🙂

I Liked you tutorial, but how website for this database work? & I'm beginner

1:18 why do we need the parenthesis around the asterisk in the SELECT FROM statement?

Great!

bra, i took one of ur udemy courses on databases and it was the best course i ever did but i could never find you to see if you had anymore courses, now im learning sql 1 year later and i find you. destiny or what lol, this teacher is a master.

Thanks for this video

it actually worked at first but couldnt go into my root where i have the schemas....i just lost a data😭😭😭😭😭😭😭😭😭😭.have been try to sign in to my localhost

what if it doesnt connect?

Not everything you see in a website has to be in a table. For example the status for a movie could be a calculated value based on the date of the first and last showing. Otherwise you need to have a cron job somewhere checking this and updating the movie status. Another thing I wonder is how the website will know how to render the theater structure and exactly where to put the seat icons just from the seat location. Sounds like a cool challenge Besides that I think the explanation makes sense and was well presented 👍

really good video

thaaaaaaaaanks

Thank you for this! Extremely easy given your tutorial...

Great video, helpful. Thank you :)

why i cant find my table which i created earlier whenever i close vs code

Thank you! :)

Awesome and to the point. Thanks for taking the time to record this video.

Hi, my question is more towards VS Code and VS Code Server. I have VS Code installed and had no problem adding the SQL Developer extension. However, this doesn't seem to be available for the Server version of VS Code (which I am hosting in my home lab). Any thoughts on why this is or if there is a work-around to getting it installed?

Very helpful videos. Can you make video about airline PNR database. A PNR can have 1. passenger name (first name, last name, title) 2. flight details (airlineCode, flight number, startCity, endCity, startTime, endTime) 3. phone (cityCode, number) 4. email 5. remarks 6. Special service requests (requestCode, status, remark)

I personally really like your clarification of what the candidate key actually is and how it differs from the primary key. That was great help, thank you! Liked and Subscribed! 🤘

can you do for a financial System like a complex one

i love your videos

Thank you so much for this content. can we have a session where you give a set of requirements and allow us to come up with our designs and then release your solution in a future video and see how we were to the actual design. i believe this way your content will be more interactive for us follow up