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

Подписаться 43 тыс.

Просмотров 6 тыс.

50% 1

SQLite is a robust and lightweight database management system built into Python. SQLite Studio is a visual interface into SQLite databases and lets you query and modify database objects. I'll show you how to install and use SQLite Studio and explain how it can work with Python to provide a complete data analysis platform!
Newly edited to improve audio and shorten the the run time.

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 11

@chilansethuge8487 Год назад

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

@BryanCafferky Год назад

Thanks!

@bleacherbum18 2 года назад

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

@BryanCafferky 2 года назад

Thanks. Glad it helps.

@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 !

@Bobylly 2 года назад

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 2 года назад

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