? Python Connect with SQL SERVER ?

Support this channel, become a member:
https://www.youtube.com/channel/UCBGENnRMZ3chHn_9gkcrFuA/join

? Udemy Courses LOW COST Coupons/ Cupões Cursos Udemy BAIXO CUSTO ?:
https://linktr.ee/AllTechProgramming

With Udemy Courses you get/ Com Cursos da Udemy você terá:
♾️ Full lifetime access/ Acesso Vitalício Completo
?? Access on mobile and TV/ Acesso no celular e TV
? Certificate of completion/ Certificado de Conclusão

In this video:
Install PyODBC library
Connect to SQL Server
Basic CRUD operations - Create, Read, Update and Delete.

???'? ?????? ?? ????????? ??? ????? ??? ???? ??????!

⏰TIMESTAMPS⏰
0:00 Intro
0:19 Install PyODBC
0:45 Create Connection to SQL Server
2:08 CRUD Operations
2:39 Read Table - select * from dummy;
3:34 Create record - insert into dummy(a,b) values(3232,'catzzz');
5:00 Update record - update dummy set b = 'dogzzz' where a = 3232;
6:08 Delete record - delete from dummy where a &gt 5;
7:03 SQL
7:49 RUN!!!

Download source code at:
https://drive.google.com/file/d/1WtzSt4jYHYHMbvXqI2WNrCOLNAglEnVy/

? Some useful books from Mike Driscoll ?:

Jupyter Notebook 101: https://gumroad.com/a/635769971/rozo
Python 101: 2nd Edition: https://gumroad.com/a/635769971/ikdWt
Python 201: Intermediate Python: https://gumroad.com/a/635769971/aMtdh

Pillow: Image Processing with Python: https://gumroad.com/a/635769971/LRAJQA

ReportLab: PDF Processing in Python: https://gumroad.com/a/635769971/bgQJY

Other videos:
ASP.NET Web API intro and Hello World - https://youtu.be/RJpBix5s3BY
ASP.NET Web API - Controllers - https://youtu.be/nlFVQddx1wc
ASP.NET Web API - Routing - https://youtu.be/2GvX8puS2is
ASP.NET Web API - Parameter Binding - https://youtu.be/LuFoVFeEBPw
ASP.NET Web API - File Uploading - https://youtu.be/MzDQALXH-SI
ASP.NET Web API - Client Console App - https://youtu.be/Ry45EkZQ2CM
ASP.NET Web API - BSON - https://youtu.be/BXnfCMcERaw
ASP.NET Web API - Action Results - https://youtu.be/W80Vflesu8s
ASP.NET Web API - Content Negotiation - https://youtu.be/vdKF1WTYVq0
ASP.NET Web API - Media Type Formatters - https://youtu.be/SGeudFDlvCI
ASP.NET Web API - Action Filters - https://youtu.be/x7kZJf416J4
ASP.NET Web API - Model Validation - https://youtu.be/sN3qYlxr_vA
ASP.NET Web API - Save File in SQL Server with ADO.NET - https://youtu.be/LixIRqhzUNQ
ASP.NET Web API - File Downloading - https://youtu.be/bS_bXsT0kq4
ASP.NET Web API - Get File from SQL Server with ADO.NET - https://youtu.be/zxPVmGpX07I
ASP.NET Web API - Save File in SQL Server with Entity Framework - https://youtu.be/JYPaOO_fCug
ASP.NET Web API - Get File from SQL Server with Entity Framework - https://youtu.be/QxOeuuosgH4
ASP.NET Web API - Exception Filters - https://youtu.be/1x0s0K3w3Z4

Generate PDF with Python - Reportlab: https://youtu.be/ZDR7-iSuwkQ
Generate PDF with Python - Reportlab - Create Table: https://youtu.be/B3OCXBL4Hxs
Generate PDF with Python - Reportlab - Create Table - Part 2: https://youtu.be/r--iZCQbxzE
Generate PDF with Python - Reportlab - Create Charts: https://youtu.be/FcZ9wTGmMrw

Run Python Script from Excel VBA: https://youtu.be/Z4SC53VZh-w
Run Python Script from Excel VBA - Part 2: https://youtu.be/4Z9via5_q9k
Run Python Script from Excel VBA - Part 3.1: https://youtu.be/PoEnWr6c1cM
Run Python Script from Excel VBA - Part 3.2: https://youtu.be/Tkk0aedRyU4

Image to Text with Python - pytesseract: https://youtu.be/4DrCIVS5U3Y
Speech to Text with Python: https://youtu.be/If2HJ23zP2U
Weather Forecast with Python: https://youtu.be/O9G4vBsiV40
Search Movie with Python - IMDbPY: https://youtu.be/vzOdCPV7zvs
Generate and Read QR Code with Python: https://youtu.be/2QK942FPCw0
Run JavaScript from Python: https://youtu.be/ByjpBvpPp8Q
Run Python in Browser - Brython: https://youtu.be/dFNXwq5kmNk
Hide Text in Image with Python - Stegano: https://youtu.be/IhXbJfLCst0
HTML to PDF with Python: https://youtu.be/m3u3oLgDcJI
Web Scraping with Python - BeautifulSoup: https://youtu.be/Jnn2kIqPH7o
Generate Excel with Python - OpenPyXL: https://youtu.be/KNdqnIpl2UE
Translate Text with Python - googletrans: https://youtu.be/yRFkI8miPHA
Convert Python 2 to Python 3 Code - 2to3: https://youtu.be/t0v4F396_nc
Face Detection with Python - OpenCV: https://youtu.be/FeUAmWZ7Clw
Run Python Script in LibreOffice: https://youtu.be/3Ef_ordyWQs
Generate Excel with Python - xlwings: https://youtu.be/sGvMLmLOH5g
RESTful Web Service - Hello World - Java Spring: https://youtu.be/RXkLlq8YxeM

Playlists:
Python Pandas: https://www.youtube.com/playlist?list=PLOGAj7tCqHx_c5uWrZX4ykdujODcqczmQ
Python and SQL Server: https://www.youtube.com/playlist?list=PLOGAj7tCqHx9Add6MWzl_5Wbix9V1OjSx
Numpy Exercises: https://www.youtube.com/playlist?list=PLOGAj7tCqHx9eQjST2RV-_Py3EJHqRq0C

Follow us on Facebook
https://www.facebook.com/AllTech-1089946481026048/

#AllTech #Python #SQLServer #DataBase #pyodbc