Application Programming Interface REST APIs (REpresentational State Tranfer) HTTP methods: transmitting data over the internet. (HTTP messages usually contains a Json File) 1) Client request with HTTP file 2) The operation is transmitted to the Web Service via the internet 3) The service performs the operation. 4) Web Service returns a response via an HTTP message(information is returned via jso..

* Join Operator: for the relationship among the entities, you need to use the JOIN operator. * Primary Key: uniquely identifies each row in a table * Foreign Key: refer to a primary key of another table * Inner Join: displays matches only ( 1 primary key and 1 Foreign key ) select b.borrower_id, b.lastname, b.country, l.borrower_id, l.loan_date from borrower b inner join loan l on b.borrower_id ..

ACID Commands: Start with "BEGIN" End with "COMMIT" -> After the transaction, save the new database state -> If any of the statements fail, you can undo changes by issuing ROLLBACK -> Can be issued by some languages: Java, C, R, Python -> to execute SQL statements from code, use the EXEC SQL command : EXEC SQL COMMIT WORK; EXEC SQL ROLLBACK WORK; --#SET TERMINATOR @ CREATE PROCEDURE TRANSACTION_..

VIEWS Show a selection of data for a given table Combine two or more tables in meaningful ways It can be queried like a table, views are dynamic; only the definition of the view is stored, not the data Create view statement to create view CREATE VIEW (,, ... ) AS SELECT , ,... FROM WHERE ; REPLACE VIEW statement CREATE OR REPLACE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHE..

1. Working with csv files ; comma or semi-colon separated values 2. Querying column names with mixed case (upper and lower) - when it's mixed "Id", use double quotes 3. spaces and special characters - database may change space to underscore( _ ) and these should be within the double quotes 4. in Jupyter notebooks 5. Splitting queries to multiple lines in Jupyter: use \ %sql select "Id", "Name_of..

import pandas as pd csv_path ='file1.csv' df=pd.read_csv(csv_path) *Date Frames (df) :comprised rows and columns : df.head() - first 5 lines : to be able to created out of dictionary (key - columns, value - rows) : single or multiple columns can be extracted -> y = df [ [ 'Length' ] ] or y = df [ ['Length', 'Genre' ] ] -> new dataframe created List unique values - pandas has unique functions : d..

1. Reading files with open # Read the Example1.txt example1 = "Example1.txt" file1 = open(example1, "r") # Open file using with with open(example1, "r") as file1: FileContent = file1.read() print(FileContent) # Read first four characters with open(example1, "r") as file1: print(file1.read(4)) # Read certain amount of characters with open(example1, "r") as file1: print(file1.read(4)) print(file1...

IBM Data Science Certificate course 더보기 What is Data Science? on going(2 out of 3) Tools for Data Science Data Science Methodology Python for Data Science, AI & Development DONE Python Project for Data Science DONE Databases and SQL for Data Science with Python DONE Data Analysis with Python on going( 2 out of 6 ) Data Visualization with Python Machine Learning with Python Applied Data Science C..

Load CSV file into DB2 on cloud : Source-Target-Define-Finalize data.cityofchicago.org/Health-Human-Services/Census-Data-Selected-socioeconomic-indicators-in-C/kn9c-c2s2?utm_email=Email&utm_source=Nurture&utm_content=000026UJ&utm_term=10006555&utm_campaign=PLACEHOLDER&utm_id=SkillsNetwork-Courses-IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork-20127838 Census Data - Selected socioeconomic indic..

How to create tables in DB2 from Python application ibm_db.exec_immediate() The parameters for the functions are: connection, statement, options stmt = ibm_db.exec_immediate (conn, "CREATE TABLE Trucks( serial_no varchar(20) PRIMARY KEY NOT NULL, model VARCHAR(20) NOT NULL, manufacturer VARCHAR(20) NOT NULL, Engine_size VARCHAR(20) NOT NULL, Truck_Class VARCHAR(20) NOT NULL) " ) How to load the ..