SQL with PYTHON: For DATA ENGINEERS, DATA ANALYSTS, DATA SCIENTISTS, and who loves Python & SQL
商品資訊
定價
：NT$ 920 元無庫存，下單後進貨(到貨天數約30-45天)
可得紅利積點：27 點
相關商品
商品簡介
商品簡介
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,
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 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
- 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
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
您曾經瀏覽過的商品
購物須知
外文書商品之書封，為出版社提供之樣本。實際出貨商品，以出版社所提供之現有版本為主。部份書籍，因出版社供應狀況特殊，匯率將依實際狀況做調整。
無庫存之商品，在您完成訂單程序之後，將以空運的方式為你下單調貨。為了縮短等待的時間，建議您將外文書與其他商品分開下單，以獲得最快的取貨速度，平均調貨時間為1~2個月。
為了保護您的權益，「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨，請在商品鑑賞期內寄回，且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。