Database

 What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

 PostgreSQL is pronounced "post-gres" 

PostgreSQL is a database management system like as oracle

ANSI-standard SQL

General purpose

Object-relational database management system(RDBMS)

Free and Open source RDBMS

Platform independent

Very stabable and require minimum maintenance

Large storage

Fast performance

PostgreSQL is extensible: You can define your own data types, index types, plugins etc

Active community support

Commends

SELECT version();

ব্যাংকের “এসিস্ট্যান্ট ডেটাবেজ এডিমিনিস্ট্রেটর” পদের MCQ Test-এর জন্যে কিভাবে প্রস্তুতি নিবেন?

১. যেসব টপিক ভাল করে পড়বেন:

a) Purpose of Database Systems

b) Problem with file system(Data isolation, Integrity problems, Atomicity problems, Concurrent-access anomalies

c) View of Data: Data Abstraction(Physical Level, Logical Level, View Level)

d) Data Models : Relational Model, Entity-Relationship Model, Object-Based Data Model, Semistructured Data Model. (**)

e) Database Languages: DML, DDL (****)

f) Integrity constraints: Domain Constraints, Referential Integrity, Assertions (*)

g) Different types of Database user and role of DBA

h) Database Schema: Physical Database Schema, Logical Database Schema

i) Relational algebra :select, project, union, set difference, cartesian product, Rename(***)

j) Keys: Super Key, Candidate, Composite, Alternate key, Primary key, Foreign Key, Natural Key( ******)

k) ER Model: Entity, Attribute(Simple, Composite, Derived, Single Valued, Multi Valued etc) (****)

l) Relationship: Mapping cardinalities

m) Constraints: Key constraints, Domain constraints , Referential integrity constraints (*)

n) Normalization: Need For normalization, 1NF, 2NF, 3NF (*****)

o) Indexing (****)

p) Transaction(***): ACID Properties of transaction (*****), State of transaction(*)

q) SQL Queries(*****)