=========1. oralce數(shù)據(jù)庫(kù)安裝以及簡(jiǎn)單的SQL語(yǔ)句========
01-day01-oracle-數(shù)據(jù)庫(kù)相關(guān)概念介紹
02-day02-oracle-數(shù)據(jù)存儲(chǔ)結(jié)構(gòu)&Oracle介紹學(xué)習(xí)
03-day01-oracle-oracle目錄介紹&oracle網(wǎng)絡(luò)配置
04-day01-oracle-oracle監(jiān)聽(tīng)器配置
=========2. oralce賬戶(hù)管理和查詢(xún)語(yǔ)句========
01-day02-oracle-創(chuàng)建scott用戶(hù)并導(dǎo)入練習(xí)數(shù)據(jù)
02-day02-oracle-單表查詢(xún)select&別名
03-day02-oracle-單表查詢(xún)連接符&去除重復(fù)&排序&字段邏輯運(yùn)算
04-day02-oracle-單表查詢(xún)&單條件where子句
05-day02-oracle-where子句關(guān)鍵字學(xué)習(xí)
=========3. oralce的函數(shù)學(xué)習(xí)&分組&增加刪除修改&SQL92========
01-day03-oracle作業(yè)處理
02-day03-oracle-單行函數(shù)學(xué)習(xí)
03-day03-oracle-多行函數(shù)學(xué)習(xí)
04-day03-oralce-轉(zhuǎn)換函數(shù)&其他函數(shù)
05-day03-oracle-分組&分組篩選學(xué)習(xí)
06-day03-oracle-增刪改
=========4. oracle的子查詢(xún)和用戶(hù)管理========
01-day04-oralce-作業(yè)處理
02-day04-oracle-多表聯(lián)合查詢(xún)SQL92講解
03-day04-oralce-多表聯(lián)合查詢(xún)SQL99(1)
04-day04-oracle-多表聯(lián)合查詢(xún)SQL(2)&三表聯(lián)合查詢(xún)
05-day04-oracle-子查詢(xún)
06-day04-oracle-用戶(hù)管理
07-day04-oracle-簡(jiǎn)單的二維表創(chuàng)建學(xué)習(xí)
=========5. oracle表操作和數(shù)據(jù)庫(kù)對(duì)象(序列、索引、視圖)========
01-day05-oracle
02-day05-oracle-作業(yè)處理(2)
03-day05-oracle-主鍵約束&非空約束&檢查約束
04-day05-oracle-檢查約束&唯一約束&外鍵約束
05-day05-oracle-二維表的字段新增&刪除&修改&表名的修改
06-day05-oracle-序列學(xué)習(xí)
07-day05-oracle-索引&視圖學(xué)習(xí)
=========6. oracle圖形界面操作和數(shù)據(jù)備份和分頁(yè)========
01-day06-oracle-作業(yè)處理
02-day06-oracle-分頁(yè)查詢(xún)
03-day06-mysql-mysql介紹
04-day06-mysql-二維表的創(chuàng)建&常見(jiàn)字段類(lèi)型
05-day06-mysql-二維表的創(chuàng)建&約束&字段修改刪除&表名修改
06-day06-mysql-數(shù)據(jù)庫(kù)表數(shù)據(jù)操作&分頁(yè)&備份