Coding on a Chromebook - Python and SQL Server Databases

This video shows you how to access your SQL Server databases on Chromebook through Python.

Check out the blog version to be able to copy the source code: https://techwiz.family.blog/2021/05/19/coding-on-a-chromebook-python-and-sql-server-databases/

Relevant Linux commands: Check your Linux version: cat /etc/*release SQL Server Driver commands: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

Install Linux video: https://youtu.be/t0meAuG-jN4 Install Visual Studio Code video: https://youtu.be/j-ThcVBqNO0 Install and use DBeaver video: https://youtu.be/S9VRzLuaeCs DBeaver download page: https://dbeaver.io

Microsoft SQL Server Logo from www.svgrepo.com

Chapters: 0:00 Intro 0:31 Prerequisites 1:32 Check which version of Debian you have 1:56 Install SQL Server Driver 3:07 Install Python pyodbc Package 3:39 Create Python Project 4:17 Using DBeaver to see the database we will access 4:45 Coding - Create Database Connection 6:01 Coding - SELECT query Code 7:37 Coding - CREATE TABLE query 9:07 Coding - INSERT query 10:19 Coding - UPDATE query 11:42 Coding - DELETE query 12:28 Final Comments ... https://www.youtube.com/watch?v=3KRq-qGo2I4