Master Using SQL with Python: Lesson 5 - Using SQLite Studio

[@jeroencommandeur]

To the point, not too long. Well done!

[@bleacherbum18]

Literally what I need for an interview data project this week. My favorite content creator hands down.

[@BryanCafferky]

Thanks. Glad it helps.

[@chilansethuge8487]

Surprised, you don"t have more subscribers ! Absolute 1st class material

[@BryanCafferky]

Thanks!

[@chilansethuge8487]

Hi Bryan, could you recommend, a open source tool to built a Schema for a relational db ?

[@BryanCafferky]

Which database do you want to build a schema for, i.e. PostgreSQL, Oracle, SQL Server?

[@chilansethuge8487]

@@BryanCafferky It would be a SQL server. I am using SQLite3 in python to build it. But I should be able to connect to via SQLite Studio correct ? Is there a way to view the Schema in SQLite Studio ?

[@BryanCafferky]

@@chilansethuge8487 SQlite Studio only works for SQLite but SQL Server has an awesome IDE, SQL Server Management Studio for Windows and Data Studio for Mac. See learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

[@chilansethuge8487]

@@BryanCafferky Many thanks for the great info !

[@didierleprince6106]

Merci (:

[@Bobylly]

Hi Bryan,
your videos are very good, but you need to work a lot on your titles. It's a shame most of your clips have hundreds of views, you deserve a lot more. Sacrifice some hours and rename them. It will be worth it. Cheers !

[@BryanCafferky]

Interesting. How would you name a video like this one? Glad to improve.

[@Sonya_Makepeace]

I think you wasted a lot of time explaining how to install SQLite. Anyone using a computer should know how to install programs. If they are watching this, they must be more than beginners to computers.

[@BryanCafferky]

Thanks for your thoughts. I try not to assume to much about the skill level of my audience.