SQL with PYTHON For DATA ENGINEERS, DATA ANALYSTS, DATA SCIENTISTS, and who Loves Python & SQL - OM PRAKASH. SHAKYA
-25% koodilla BOOKS
Toimitus 10-16 arkipäivässä
30 päivän palautusoikeus
This book is about the recipes on PYODBC and SQLAlchemy to work with Microsoft SQL Server databases and its data in table. Here are various recipes covering almost all the activities that are required by a Data Engineer, Scientist, Analyst or Python Developer. The book is divided into two sections, PYODBC recipesSQLAlchemy recipiesThe topic starts with the heading or title and gives some context about the t ... Täydellinen kuvaus
Saatat myös pitää
TOP
Gödel, Escher, Bach: An Eternal Golden Braid
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Empire of AI: Dreams and Nightmares in Sam Altmans OpenAI
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
The Rust Programming Language
Steve Klabnik, Carol Nichols, Chris Krycho
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
AI Engineering: Building Applications with Foundation Models
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
How Linux Works: What Every Superuser Should Know
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Python Crash Course: A Hands-On, Project-Based Introduction to Programming
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
How To Think About AI: A Guide For The Perplexed
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
The Pragmatic Programmer: journey to mastery, 20th Anniversary Edition, 2/e: your journey to mastery, 20th Anniversary Edition
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Proofs from THE BOOK
Martin Aigner, Günter M. Ziegler
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
The Art of Game Design: A Book of Lenses
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
CompTIA Security+ Certification Kit: Exam SY0-701
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Automate the Boring Stuff with Python
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Fundamentals of Software Architecture: A Modern Engineering Approach
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Speak Data: Artists, Scientists, Thinkers, and Dreamers on How We Live Our Lives in Numbers
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Hacking: The Art of Exploitation
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Slanted 47 Digital Tools: Slanted Magazine
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Hackers. 25th Anniversary Edition: Heroes of the Computer Revolution
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Deep Learning
Ian Goodfellow, Yoshua Bengio, Aaron Courville
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Mathematics for Machine Learning
Cheng Soon Ong, A. Aldo Faisal, Marc Peter Deisenroth
-25% koodilla BOOKS
Toimittajalla varastossa
TOP
Artificial Intelligence: A Modern Approach, Global Edition
-25% koodilla BOOKS
Toimittajalla varastossa
Kuvaus
Here are various recipes covering almost all the activities that are required by a Data Engineer, Scientist, Analyst or Python Developer.
The book is divided into two sections,
- PYODBC recipes
- SQLAlchemy recipies
After that there may be one or more approaches or ways that we have implemented in that topic.
The book covers the over the following topics and recipes,
Introduction to Python, SQL, VS Code, Python extensions, pyodbc, sqlalchemy, odbc driver
Guidance on installing python, VS code, pyodbc, sqlalchemy
Setting up database, tables, and creating stored procedures used in this book.
Then code recipes are divided into 2 parts,
- pyodbc recipes
- sqlalchemy recipes
Multiple ways to prepare connection string and connecting SQL Server
PYODBC connection, cursor, commit, execute, objects & methods
CRUD Operations (insert, update, delete, and select/read data) with various approaches
Handling parameters of parameterized SQL queries & USPs
Handling SQL 'IN' operator parameters
Handling multiple resultsets of USP
How to handle multiple parameters
Different approaches to create and pass parameters
Cursor functions fetchall(), fetchone(), fetchval(), fetchmany(), rowcount etc.
Accessing rows & columns of a result set
Working with row by row or batch of rows
pandas methods read_sql(), read_sql_query(), read_table()
Calling stored procedures with & without parameters
Working with multiple databases, and looping through list of databases
Using 'with' statement
SQLALCHEMY core data api
SQLALCHEMY engine url, engine, connection, execute, cursor etc.
SQLALCHEMY exec_driver_sql(), raw_connection(), etc.
Working with pandas dataframe to insert & update multiple records
And many more important topics in pyodbc, and sqlalchemy
Lisätietoja
| Kirjoittaja | OM PRAKASH. SHAKYA |
|---|---|
| Julkaisija | Amazon Digital Services LLC - Kdp |
| Julkaisuvuosi | 2024 |
| Kannen tyyppi | Pehmeäkantinen |
| EAN | 9798324701413 |