Install pyodbc Python packagehttps://pypi.org/project/pyodbc/You might need to install unixODBC-devel and python3-devel packages in order to successfully install pyodbc
Install Netezza OBDC(nzodbc) driver https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.datacon.doc/t_datacon_installing_odbc_unix_linux.htmlYou will not be able to use pyodbc driver without installing Netezza OBDC drivers. This step is one of the pre-requisites to use pyodbc.
Install Netezza SQLAlchemy(nzalchemy): The Netezza SQLAlchemy package can be installed from the public PyPI repository using piphttps://pypi.org/project/nzalchemy/Connection Parameters To connect to Netezza with nzalchemy use the following connection string netezza+pyodbc:///?<ODBC connection parameters>
SQLAlchemy Core - schema-centric SQL Expression LanguageIt has a schema-centric view, which like traditional SQL is focused around tables, keys, and index structures. Its main role is to provide programmatic way to generate sql queries and DDL. Result set would be only tuples and not objects like in ORM. We can use SQLAlchemy core to execute SQL queries after creating engine with SQLAlchemy provided basic operations like connect(), execute() etc.
Declare Table, datatypes INTEGER, VARCHAR and CHAR used from nzalchemy
Create table and perform insert operation
Select from table
Update with where clause
Delete row with matching value
2. Different joins on table
Insert some data into student and addresses table
Join on student id
UNION, EXCEPT and INTERSECTION
Two classes Customer & Invoice created. Invoice should be mapped to Customer in such a way that it should be many to one mapping. Customer can have multiple invoices.