Structured Query Language (SQL)

SQL: Extensively used non­procedural language

Example: Find the name of the customer with customer­id 192­83­7465

Select customer.customer_name

from customer

where customer.customer_id = ‘192­83­7465’

Example: Find the balances of all accounts detained by the customer with

customer­id 192­83­7465

Select account.balance

From depositor, account

where depositor.customer_id = ‘192­83­7465’ and

depositor.account_number = account.account_number

Application programs commonly access databases through one of:-

• Language extension to consent to embedded SQL
• Application program interface (e.g., ODBC/JDBC) which permit SQL
• Queries to be sent to a database