鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁+銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞达紝2013骞�锛涘潎鎻愪緵鏀惰不(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
鍖椾含鏋楁キ(y猫)澶у(xu茅) 銆婅▓(j矛)绠楁(j墨)缍滃悎銆�鑰冪爺澶х侗 涓€銆佽€冭│鍏�(n猫i)瀹癸細 鏁�(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u) 100 鍒� + 鏁�(sh霉)鎿�(j霉)搴� 50 鍒� 锛堜竴锛夋暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)閮ㄥ垎 1.鏁�(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鍩烘湰姒傚康 (1) 鏁�(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鐨勫熀鏈蹇碉細鏁�(sh霉)鎿�(j霉)銆佹暩(sh霉)鎿�(j霉)鍏冪礌銆佹暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)銆佹暩(sh霉)鎿�(j霉)鐨勯倧杓祼(ji茅)妲�(g貌u)銆佺墿鐞嗙祼(ji茅)妲�(g貌u)銆� 绠楁硶绛夈€� (2) 绠楁硶鏅�(sh铆)闁撳京(f霉)闆滃害鍜岀┖闁撳京(f霉)闆滃害鐨勫垎鏋愭柟娉�銆� 2. 绶氭€ц〃 (1) 绶氭€ц〃鐨勫畾缇�銆� (2) 绶氭€ц〃鐨勯爢搴忓瓨鍎�(ch菙)绲�(ji茅)妲�(g貌u)鍜屼富瑕佺畻娉曞(sh铆)鐝�(xi脿n)锛屽鏌ユ壘銆佹彃鍏ュ拰鍒櫎绠楁硶銆� (3) 绶氭€ц〃鐨勯張?zh菙n)閰遍幆?ch菙)绲�(ji茅)妲�(g貌u)鍜屼富瑕佺畻娉曞(sh铆)鐝�(xi脿n)锛屽鏌ユ壘銆佹彃鍏ュ拰鍒櫎绠楁硶銆� (4)寰挵(hu谩n)閺堣〃銆侀洐鍚戦張琛ㄧ殑鐗归粸(di菐n)銆� (5)寰炴檪(sh铆)闁撳拰绌洪枔寰�(f霉)闆滃害鐨勮搴︽瘮杓冨叐绋瓨鍎�(ch菙)绲�(ji茅)妲�(g貌u)鐨勪笉鍚岀壒榛�(di菐n)鍙婂叾閬╃敤鍫村悎銆� (6)绶氭€ц〃鐨勬噳(y墨ng)鐢�锛屽绶氭€ц〃鐨勫悎骞剁畻娉曘€� 3. 妫у拰闅�(du矛)鍒� (1) 妫х殑瀹氱京鍙婄壒榛�(di菐n)锛屾'鐨勯爢搴忓瓨鍎�(ch菙)鍜岄張鎺ュ瓨鍎�(ch菙)绲�(ji茅)妲�(g貌u)锛岄€�(j矛n)妫у嚭妫х畻娉�锛岄爢搴忔'妫ф豢鍜屾' 绌虹殑姊濅欢銆� (2) 妫х殑鎳�(y墨ng)鐢�锛屽琛ㄩ仈(d谩)寮忔眰鍊肩畻娉�锛屽€熷姪妫ф繁鍏ョ悊瑙i仦姝哥畻娉曘€� (3) 闅�(du矛)鍒楃殑瀹氱京鍙婄壒榛�(di菐n)锛岄殜(du矛)鍒楃殑闋嗗簭瀛樺劜(ch菙)(寰挵(hu谩n)闅�(du矛))鍜岄張鎺ュ瓨鍎�(ch菙)绲�(ji茅)妲�(g貌u)锛岄€�(j矛n)闅�(du矛)鍑洪殜(du矛)绠楁硶锛屽惊 鐠�(hu谩n)闅�(du矛)鍒椾腑闅�(du矛)婊垮強闅�(du矛)绌虹殑姊濅欢銆� 4. 涓插拰鏁�(sh霉)绲� (1) 涓茬殑瀹氱京銆� (2) 涓茬殑鍙ゅ吀妯″紡鍖归厤绠楁硶銆� (3) 鏁�(sh霉)绲勫湴鍧€鐨勮▓(j矛)绠楁柟娉�銆� (4) 鐗规畩鐭╅櫍鐨勫绺瓨鍎�(ch菙)鏂规硶銆� 5. 妯瑰拰浜屽弶妯� (1) 浜屽弶妯圭殑瀹氱京鍜屾€ц唱(zh矛)銆� (2) 浜屽弶妯圭殑鍏╃ó瀛樺劜(ch菙)绲�(ji茅)妲�(g貌u)锛氶爢搴忓瓨鍎�(ch菙)鍜岄張?zh菙n)閰遍幆?ch菙)銆� (3) 浜屽弶妯圭殑鍓�(chu脿ng)寤哄拰涓夌ó涓嶅悓閬嶆绠楁硶锛屽埄鐢ㄩ亶姝风畻娉曞(sh铆)鐝�(xi脿n)浜屽弶妯圭殑鍏朵粬鎿嶄綔锛屽瑷�(j矛)绠� 浜屽弶妯圭祼(ji茅)榛�(di菐n)鍊�(g猫)鏁�(sh霉)銆佽憠瀛愮祼(ji茅)榛�(di菐n)鍊�(g猫)鏁�(sh霉)銆佷簩鍙夋ü鐨勯珮搴︾瓑绠楁硶銆� (4)绶氱储浜屽弶妯圭殑鐗规€у強妲�(g貌u)閫犳柟娉�銆� (5) 妯瑰拰妫灄鐨勫畾缇┿€佸瓨鍎�(ch菙)绲�(ji茅)妲�(g貌u)鑸囦簩鍙夋ü鐨勮綁(zhu菐n)鎻涙柟娉�銆� (6) 妯圭殑鎳�(y墨ng)鐢�锛屽搱澶浖妯瑰強鍝堝か鏇肩法纰肩殑妲�(g貌u)閫犵畻娉�銆佸付娆�(qu谩n)璺緫闀峰害鐨勮▓(j矛)绠�銆� 6. 鍦� (1) 鍦栫殑瀹氱京鍜屾€ц唱(zh矛)銆� (2) 鍦栫殑鍏╃ó瀛樺劜(ch菙)绲�(ji茅)妲�(g貌u)锛氶劙鎺ョ煩闄e拰閯版帴琛ㄣ€� (3) 鍦栫殑鍏╃ó閬嶆绛栫暐锛氭繁搴﹀劒(y艒u)鍏堟悳绱㈢畻娉曞拰寤e害鍎�(y艒u)鍏堟悳绱㈢畻娉�銆� (4) 鍦栫殑鍩烘湰鎳�(y墨ng)鐢紝鍖呮嫭鎷�?f霉)娓戝垽铔╂兇?銆佹眰瑙f渶鐭矾寰戠殑杩澃鏂壒鎷夌畻娉�銆�?g貌u)閫犳渶灏忕敓 鎴愭ü鐨勫叐绋畻娉曪紙鏅噷濮嗙畻娉曞拰鍏嬮鏂崱鐖剧畻娉曪級銆� 7. 鏌ユ壘 (1) 绶氭€ц〃鐨勬煡鎵撅細闋嗗簭鏌ユ壘鍜屾姌鍗婃煡鎵剧畻娉�銆� (2) 妯硅〃鐨勬煡鎵撅細浜屽弶鎺掑簭妯圭殑瀹氱京锛屼簩鍙夋帓搴忔ü鐨勫壍(chu脿ng)寤�銆佹彃鍏�銆佸埅闄ゅ拰鏌ユ壘绠楁硶銆� (3) 鏁e垪琛ㄧ殑鏌ユ壘锛氬叐绋檿鐞嗘矕绐佺殑鏂规硶鍖呮嫭闁嬫斁鍦板潃娉曪紙绶氭€ф帰娓硶銆佷簩娆℃帰娓硶锛� 鍜岄張鍦板潃娉曘€� (4)涓婅堪涓夌ó涓嶅悓鏌ユ壘绠楁硶鐨勫垎鏋�锛屽钩鍧囨煡鎵鹃暦搴� ASL 鐨勮▓(j矛)绠楁柟娉曞強鏅�(sh铆)闁撳京(f霉)闆滃害鍒嗘瀽锛� 涓嶅悓鏌ユ壘绠楁硶鐨勯仼鐢ㄥ牬鍚�銆� 8.鎺掑簭 (1) 鎺掑簭鐨勫熀鏈蹇�銆� (2) 鎻掑叆鎺掑簭锛氱洿鎺ユ彃鍏ユ帓搴�銆佹姌鍗婃彃鍏ユ帓搴忓拰甯岀埦鎺掑簭銆� (3) 浜ゆ彌鎺掑簭锛氬啋娉℃帓搴忓拰蹇€熸帓搴忋€� (4) 閬告搰鎺掑簭锛氱啊鍠伕鎿囨帓搴忓拰鍫嗘帓搴�銆� (5) 姝稿苟鎺掑簭锛�2-璺骞舵帓搴�銆� (6) 涓婅堪鍚勭ó鎺掑簭鏂规硶鐨勭壒榛�(di菐n)鍜屾帓搴忛亷绋嬶紝鏅�(sh铆)闁撳拰绌洪枔寰�(f霉)闆滃害鐨勫垎鏋�锛屾帓搴忔柟娉曗€滅┅(w臎n)瀹氣€� 鎴栤€滀笉绌�(w臎n)瀹氣€濈殑鍚京銆傛帓搴忕畻娉曠殑瀵�(sh铆)鐝�(xi脿n)鍙婇仼鐢ㄥ牬鍚�銆� 锛堜簩锛夋暩(sh霉)鎿�(j霉)搴儴鍒� 1. 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝堪 (1) 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝珫锛氭暩(sh霉)鎿�(j霉)锛屾暩(sh霉)鎿�(j霉)搴�锛屾暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)锛屾暩(sh霉)鎿�(j霉)绠$悊鎶€琛�(sh霉)鐨� 鐢�(ch菐n)鐢熷拰鐧�(f膩)灞�锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭壒榛�(di菐n)銆� (2) 鏁�(sh霉)鎿�(j霉)妯″瀷锛氭暩(sh霉)鎿�(j霉)妯″瀷鐨勭祫鎴愯绱�锛屾蹇垫ā鍨�锛屽堡娆℃ā鍨�锛岀恫(w菐ng)鐙€妯″瀷锛岄棞(gu膩n)绯绘ā鍨嬶紝灏� 璞℃ā鍨�銆� (3) 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲�(ji茅)妲�(g貌u)锛氭暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)妯″紡鐨勬蹇�锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勪笁绱氭ā寮忕祼(ji茅)妲�(g貌u)锛屾暩(sh霉)鎿�(j霉)搴殑 浜岀礆鏄犲儚鍔熻兘鑸囨暩(sh霉)鎿�(j霉)鐛�(d煤)绔嬫€�锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祫鎴�銆� (4) 鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)鐨勭爺绌堕牁(l菒ng)鍩�銆� 2. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴� (1) 闂�(gu膩n)绯绘ā鍨嬫杩�銆� (2) 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鍙婂舰寮忓寲瀹氱京锛氶棞(gu膩n)绯伙紝闂�(gu膩n)绯绘ā寮�锛岄棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�銆� (3) 闂�(gu膩n)绯荤殑瀹屾暣鎬э細瀵�(sh铆)楂斿畬鏁存€э紝鍙冪収瀹屾暣鎬�锛岀敤鎴惰嚜瀹氱京瀹屾暣鎬�銆� (4) 闂�(gu膩n)绯讳唬鏁�(sh霉)锛氶泦鍚堥亱(y霉n)绠楋紝闂�(gu膩n)绯婚亱(y霉n)绠�銆� 3. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴(bi膩o)婧�(zh菙n)瑾炶█鈥斺€擲QL (1) SQL 姒傝堪銆� (2) SQL 鏁�(sh霉)鎿�(j霉)瀹氱京銆� (3) SQL 鏌ヨ锛氬柈琛ㄦ煡瑭�锛岄€f帴鏌ヨ锛屽祵濂楁煡瑭紝闆嗗悎鏌ヨ銆� (4) SQL 鏁�(sh霉)鎿�(j霉)鏇存柊锛氭彃鍏ユ暩(sh霉)鎿�(j霉)锛屼慨鏀规暩(sh霉)鎿�(j霉)锛屽埅闄ゆ暩(sh霉)鎿�(j霉)銆� (5) 瑕栧湒锛歋QL 鍓�(chu脿ng)寤鸿鍦�锛屾煡瑭㈣鍦栵紝鏇存柊瑕栧湒锛岃鍦栨剰缇�銆� (6) 鏁�(sh霉)鎿�(j霉)鎺у埗锛歋QL 鎺堟瑠(qu谩n)锛屾敹鍥炴巿娆�(qu谩n)銆� (7) 宓屽叆寮� SQL銆� 4. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴悊璜� (1) 闂�(gu膩n)绯绘ā寮忕殑鍐椾綑鍜岀暟甯稿晱椤�銆� (2) 瑕�(gu墨)鑼冨寲锛氬嚱鏁�(sh霉)渚濊炒锛岀⒓锛岃寖寮�锛�2NF锛�3NF锛孊CNF锛屽鍊间緷璩达紝4NF銆� (3) 妯″紡鐨勫垎瑙�銆� 5. 鏁�(sh霉)鎿�(j霉)搴畨鍏ㄤ繚璀�(h霉) (1) 鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф帶鍒躲€� (2) 鏁�(sh霉)鎿�(j霉)搴畬鏁存€ф帶鍒�銆� (3) 鏁�(sh霉)鎿�(j霉)搴苟鐧�(f膩)鎺у埗銆� (4) 鏁�(sh霉)鎿�(j霉)鎭㈠京(f霉)銆� 6. 鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷�(j矛) (1) 鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷�(j矛)鐨勬杩�銆� (2) 闇€姹傚垎鏋�銆� (3) 姒傚康绲�(ji茅)妲�(g貌u)瑷�(sh猫)瑷�(j矛)銆� (4) 閭忚集绲�(ji茅)妲�(g貌u)瑷�(sh猫)瑷�(j矛)銆� (5) 鏁�(sh霉)鎿�(j霉)搴墿鐞嗚ō(sh猫)瑷�(j矛)銆� (6) 鏁�(sh霉)鎿�(j霉)搴(sh铆)鏂�銆� (7) 鏁�(sh霉)鎿�(j霉)搴亱(y霉n)琛岀董璀�(h霉)銆� 7. SQL Server 2000 鏁�(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng) (1) Transact-SQL 绋嬪簭瑷�(sh猫)瑷�(j矛)锛氳畩閲忥紝娴佺▼鎺у埗鍛戒护锛屽叾浠栧懡浠�锛屽父鐢ㄥ嚱鏁�(sh霉)銆� (2) 瀛樺劜(ch菙)閬庣▼鍜岃Ц鐧�(f膩)鍣�銆� (3) 鍌欎唤鍜岄倓鍘�銆� 浜�銆佸弮鑰冩浉鐩細 鍤�(y谩n)钄氭晱锛屾潕鍐锛屽惓鍋夋皯. 鏁�(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)锛圕 瑾炶█鐗堬級. 鍖椾含锛氫汉姘戦兊闆诲嚭鐗堢ぞ. 闄冲織娉婏紝鐜嬫槬鐜�.鏁�(sh霉)鎿�(j霉)搴師鐞嗗強鎳�(y墨ng)鐢ㄦ暀绋嬶紙绗簩鐗堬級.鍖椾含锛氫汉姘戦兊闆诲嚭鐗堢ぞ.
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠h〃浣滆€呭€�(g猫)浜鸿榛�(di菐n)锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊(sh铆)锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹�銆佹枃瀛楃殑鐪熷(sh铆)鎬с€佸畬鏁存€�銆佸強鏅�(sh铆)鎬ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵�(sh铆)鐩搁棞(gu膩n)鍏�(n猫i)瀹�銆�
|