Ch1.數(shù)據(jù)庫數(shù)據(jù)庫管理系統(tǒng)(DBMSdatabasemanagement數(shù)據(jù)模型(data數(shù)據(jù)庫用戶，數(shù)據(jù)庫管理員Ch2.TheRelational數(shù)據(jù)結(jié)構(gòu)：表(table/relation)，屬性(column/attribute)，元組(row/tuple)，表頭(tableheading)/關(guān)系模式(relationalschema)，域( 關(guān)系的約束規(guī)則(relational鍵/關(guān)鍵字(key)與超鍵空值(null關(guān)系代數(shù)(relational基本運(yùn)算：并，差，投影，選擇，迪乘θ-（請注意每個運(yùn)算符的執(zhí)行條件和結(jié)果關(guān)系的關(guān)系模式兩個關(guān)系的迪乘積、自然聯(lián)接、θ-聯(lián)&使用表聯(lián)接查詢，還是使用除法Ch3.BasicSQLquery數(shù)據(jù)命令的基本結(jié)SELECTselect/from/where/groupby/having/order兩個必須的子句:havinggroupbyFROM嵌套查詢between…andis innot notsome,any,exists,not結(jié)果元組排序：orderUNION/INTERSECT/UNIONALL/INTERSECTALL/EXCEPT分組統(tǒng)計查詢（GROUP分組選擇統(tǒng)計查詢（GROUPBYHAVINGSQLNOTEXISTSFROMCh4.Object-RelationalOracleSQL&OracleOracle的對象類Ch5.ProgramstoAccessSQL多行數(shù)據(jù)交換：游標(biāo)(HostVariables)(IndicatorCh6.DatabaseERCardinalityofEntityParticipationinaOne-to-One,Many-to-Many,andMany-to-OneERER函數(shù)依賴(FDFunctional關(guān)鍵字(key)，主屬性(primeattribute)，非主屬性(non-prime函數(shù)依賴集的覆蓋(FDsetcover)，最小函數(shù)依賴集/最小覆蓋(minimal算法：屬性集閉包(ClosureofaSetofAttributes)的計算算法，關(guān)鍵字的發(fā)現(xiàn)算無損聯(lián)結(jié)性 position)和依賴保持性(FD 3NFERER（DEALUT，CHECKPrimaryKey&ForeignKey（ONDELETE/ONUPDATE字句 語句(GRANT...TO...)和權(quán)限回收語句Ch8.索引的創(chuàng)建語句：CreateCh10.UpdateACID事務(wù)的控制語句：事務(wù)的提交(commit)與回滾串行調(diào)度(serial可串行化調(diào)度(Serializability與可串行化調(diào)度串