Master Using SQL with Python: Lesson 6 - Create a Data Warehouse with SQLite

This video is the culmination of a series on Python + SQL. I'll show you how to extract data from enterprise SQL Server and PostgreSQL databases, transform it, and create your own local data warehouse in SQLite to support your data analysis. It's easy and greatly simplifies your analysis work.

[ivanmaverick]

It's been a week since I've been watching Bryan's videos. They are always full of fundamentals, practical examples, straight to the point, and sorry but, no B.S.: it's just pragmatic.
To support him on Patreon (especially if you are chill with your finance), is a no brainer.
Thank you very much, Bryan.

[andrewgutierrez]

Boosting this channel, the real deal plain and simple explanation from an expert with credentials. 🎉

[justtulsa]

This is the teaching format I've been looking for.

[the-ghost-in-the-machine]

I appreciate your work! Such a clear lecture.

[danielflorea]

Super useful. Business oriented and pragmatic.

[jimcallahan]

Great video, my suggestions are just riffs inspired by your work. ;)

[akpofureenughwure]

@BryanCafferky I like your detailed approach to learning. I don't like 5 minutes videos with loads of gaps! I look forward to watching more content. Thank you!

[ivanmaverick]

Just to mention, actually, ACID stands for:
Atomicity : everything executes or not at all (rollback)
Consistency : modifications are compliance with database table constraints, cascade definitions, triggers, etc.
Isolation : transactions running concurrently, leave the database in the same state if they were running sequentially
Durability : modifications performed by a transaction (one or multiple queries), will persist in the database, even in case of a system failure (power outage, data is in the hard drive).

[font]

great content mate, been recommending you to multiple colleagues

[santoshkumarilango]

Simple superb. You are an awesome teacher :)

[darkknight]

great videos and also Sheldon joke :))), thank you very much!

[Omer]

Hey Bryan I keep getting the "ModuleNotFoundError: No module named 'dbutils'" how do I import that into Jupyter Notebook, tried looking stackoverflow to no avail

[aninditadey]

being a ML enthusiast i have learnt python (as a go-to for data analysis) what other platforms should i be comfortable with to learn more of data analysis?

[VirenPatel-okzb]

Is your book available as a hardcopy version ? I found only kindle version on the Amazon. Please let me know.

[samitranjan]

Hello Bryan, Thank you for explaining so nicely, I have been searching for this. While running aw_sql_is.get_db_data('select top 2 * from dbo.DimProduct') I get error :

OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2]. (2) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (2)')

Do I need to install SQL Server?

[marcgentner]

I have read to not use SQL lite in production. Then why use SQL lite?

[VirenPatel-okzb]

Your book available as a physical book ? I found only kindle version on the Amazon. Please let me know. Thanks