{"product_id":"sql-with-python-for-data-engineers-data-analysts-data-scientists-and-who-loves-python-sql-9798324701413","title":"SQL with PYTHON: For DATA ENGINEERS, DATA ANALYSTS, DATA SCIENTISTS, and who loves Python \u0026 SQL","description":"This book is about the recipes on PYODBC and SQLAlchemy to work with Microsoft SQL Server databases and its data in table. \u003cp\u003e\u003c\/p\u003eHere are various recipes covering almost all the activities that are required by a Data Engineer, Scientist, Analyst or Python Developer. \u003cp\u003e\u003c\/p\u003eThe book is divided into two sections, \u003col\u003e\n\u003cli\u003ePYODBC recipes\u003c\/li\u003e\n\u003cli\u003eSQLAlchemy recipies\u003c\/li\u003e\n\u003c\/ol\u003eThe topic starts with the heading or title and gives some context about the topic and the lists the complete code block of that topic.\u003cbr\u003eAfter that there may be one or more approaches or ways that we have implemented in that topic. \u003cp\u003e\u003c\/p\u003eThe book covers the over the following topics and recipes, \u003cp\u003e\u003c\/p\u003eIntroduction to Python, SQL, VS Code, Python extensions, pyodbc, sqlalchemy, odbc driver\u003cbr\u003eGuidance on installing python, VS code, pyodbc, sqlalchemy \u003cp\u003e\u003c\/p\u003eSetting up database, tables, and creating stored procedures used in this book. \u003cp\u003e\u003c\/p\u003eThen code recipes are divided into 2 parts, \u003col\u003e\n\u003cli\u003epyodbc recipes\u003c\/li\u003e\n\u003cli\u003esqlalchemy recipes\u003c\/li\u003e\n\u003c\/ol\u003eBoth are covering the following topics, \u003cp\u003e\u003c\/p\u003eMultiple ways to prepare connection string and connecting SQL Server\u003cbr\u003ePYODBC connection, cursor, commit, execute, objects \u0026amp; methods\u003cbr\u003eCRUD Operations (insert, update, delete, and select\/read data) with various approaches\u003cbr\u003eHandling parameters of parameterized SQL queries \u0026amp; USPs\u003cbr\u003eHandling SQL 'IN' operator parameters\u003cbr\u003eHandling multiple resultsets of USP\u003cbr\u003eHow to handle multiple parameters\u003cbr\u003eDifferent approaches to create and pass parameters\u003cbr\u003eCursor functions fetchall(), fetchone(), fetchval(), fetchmany(), rowcount etc.\u003cbr\u003eAccessing rows \u0026amp; columns of a result set\u003cbr\u003eWorking with row by row or batch of rows\u003cbr\u003epandas methods read_sql(), read_sql_query(), read_table()\u003cbr\u003eCalling stored procedures with \u0026amp; without parameters\u003cbr\u003eWorking with multiple databases, and looping through list of databases\u003cbr\u003eUsing 'with' statement\u003cbr\u003eSQLALCHEMY core data api\u003cbr\u003eSQLALCHEMY engine url, engine, connection, execute, cursor etc.\u003cbr\u003eSQLALCHEMY exec_driver_sql(), raw_connection(), etc.\u003cbr\u003eWorking with pandas dataframe to insert \u0026amp; update multiple records \u003cp\u003e\u003c\/p\u003eAnd many more important topics in pyodbc, and sqlalchemy\u003cbr\u003e","brand":"Independently Published","offers":[{"title":"Default Title","offer_id":51500448809234,"sku":"9798324701413","price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_d538e24f-9990-420a-9ff4-3a5705007b70.jpg?v=1753191787","url":"https:\/\/surprise-castle.myshopify.com\/products\/sql-with-python-for-data-engineers-data-analysts-data-scientists-and-who-loves-python-sql-9798324701413","provider":"Surprise Castle","version":"1.0","type":"link"}