SQL Data Analysis Portfolio Project #02/10 | Beginner to Advanced Guide for Library Project SQL

[@zero_analyst]

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems kzbin.info/www/bejne/gGrUd3x3fZxrbrM 🐍 All Python Projects: Python ETL - Data Cleaning Project kzbin.info/www/bejne/q3W0gGyuhMxnrsk

[@BhaaRaThh]

I will share this video to all my college groups ❤

[@zero_analyst]

Thank you so much mate!

[@vkfreedomzone]

It's amazing video for Learning all about sql commands and how to design database .

[@zero_analyst]

Glad you liked it

[@vinothkumars7421]

Do more of this even if it takes time

[@bdfirst3578]

long waiting part coming finally, love from :Germany

[@rancho3543]

Just subscribed the channel. Will watch all the playlist.😊

[@zero_analyst]

Welcome aboard!

[@mansithakkar-v6h]

helpful... looking for more such videos...!!😃

[@zero_analyst]

Thank you!

[@abhishekdubey9920]

exited to see the next video

[@zero_analyst]

Thank you mate! Please make sure to subscribe and support the channel!

[@shamanthrao528]

thank you really nice video

[@zero_analyst]

thanks

[@abhishekdubey9920]

please generate more errors intentionally and correct them live in video

[@shubhamsharma8642]

i think in task 5 we have to count issued_member id but you count emp_id

[@footballskills6574]

Yeah, I think you are right. That is what I expected. At least he's helping us improve

[@meetlimbani3721]

In task 5 you have used emp id column but question was about member so we have to use member id column right??

[@adityavamsi12]

Please make a video on On delete cascade and on delete set null

[@zero_analyst]

sure mate!

[@abhishekdubey9920]

sir what happen if i import data twice it will be same as once imported?

[@abhishekdubey9920]

how you import one by one live and caught error in branch table varchar limit it make us learn error resolving.

[@sambugarisupraja]

Can i know for project 1 y didn't you create an ERD table and y for this?

[@zero_analyst]

Because here we have more than 1 table! in Project 1 we only have one table!

[@sambugarisupraja]

@@zero_analyst while im trying to make a db connection for employee and branch in getting this error.can i know what this is ERROR: there is no unique constraint matching given keys for referenced table "branch" SQL state: 42830

[@animeshsingh7333]

As per explanation in video & provided CSV files issued_status & Return_status tables can't be joined on the basis of Issued_id column as 3 values in return_status table are not in issued_status table..How to resolve this...

[@victoriannam3032]

I am having the same problem where you able to solve it

[@aniketsingh7005]

bhai when can we expect the new video to come??

[@Morningbcode]

It’s already uploaded 1 month back mate part check from the playlist

[@vinothkumars7421]

There is no column named - membership_date in members table. It should be reg_date for the Task 9. Please validate

[@zero_analyst]

correct

[@virajlohakare6067]

linkedin profile

[@abhishekdubey9920]

Please guide i know mysql

[@zero_analyst]

You can use same code in mySQL Just change 1- 2 line you can check with chatgpt

[@abhishekdubey9920]

@@zero_analyst ok thanks i will do same if got error

[@abhishekdubey9920]

i respect the doing every little thing live but making tables again and again part can be cut.

[@zero_analyst]

Hi everyone! Part -2 Of library project is out please check it here kzbin.info/www/bejne/nl7WkJ6Hftahmsk

[@9969618470]

ALTER TABLE issued_status ADD CONSTRAINT fk_employee FOREIGN KEY (issued_book_isbn) REFERENCES employee(emp_id); I wanted to changes FOREIGN KEY (issued_emp_id ) Kindly help