|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞达紝2013骞�锛涘潎鎻愪緵鏀惰不涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛炴搳鈥�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛炴搳鈥�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
娴欐睙杈�(n贸ng)鏋楀ぇ瀛�(xu茅)纰╁＋鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│
淇℃伅鎶€琛�(sh霉)缍滃悎(鏋楁キ(y猫)淇℃伅鎶€琛�(sh霉))鑰冭│澶х侗
涓€銆佽€冭│鎬ц唱(zh矛)
娴欐睙杈�(n贸ng)鏋楀ぇ瀛�(xu茅)纰╁＋鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│銆婁俊鎭妧琛�(sh霉)缍滃悎銆嬫槸鐐烘嫑鏀舵灄妤�(y猫)淇℃伅鎶€琛�(sh霉)灏堟キ(y猫)鐨勭ⅸ澹�
鐮旂┒鐢熻€岃ō(sh猫)缃殑鍏锋湁閬告挜鍔熻兘鐨勬按骞宠€冭│銆傚叾涓昏鐩殑鏄脯瑭﹁€冪敓鎺屾彙淇℃伅鎶€琛�(sh霉)鐨勫熀鏈妧鑳斤紝
娓│鑰冪敓鏄惁鍏峰倷鏀昏畝鏋楁キ(y猫)淇℃伅鎶€琛�(sh霉)灏堟キ(y猫)纰╁＋鎵€蹇呴爤鐨勫熀鏈礌璩�(zh矛)銆佷竴鑸兘鍔涘拰鍩归(y菐ng)娼涜兘锛屼互
鍒╀簬閬告嫈鍏锋湁鐧�(f膩)灞�?ji茅)鎽课﹁啲?y艒u)绉€浜烘墠鍏ュ(xu茅)锛岀偤鍦嬪鐨勭稉(j墨ng)婵熷缓瑷�(sh猫)鍩归(y菐ng)鍏锋湁杓冨挤鍒嗘瀽鑸囪В姹哄闅涘晱
椤岃兘鍔涚殑楂樺堡娆�銆佹噳(y墨ng)鐢ㄥ瀷銆佸京(f霉)鍚堝瀷鐨勬灄妤�(y猫)淇℃伅鎶€琛�(sh霉)灏堟キ(y猫)浜烘墠銆�
浜�銆佽€冭│鐨勫熀鏈姹�
瑕佹眰鑰冪敓鎺屾彙鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)鐨勫熀鏈悊璜栧拰鎶€琛�(sh霉)锛涙帉鎻℃暩(sh霉)鎿�(j霉)鍒嗘瀽銆佺祫绻旂瓑鏁�(sh霉)鎿�(j霉)搴殑鍩烘湰鎶€鑳�锛�
鐔熸倝瑷堢畻姗熺恫(w菐ng)绲�(lu貌)鐨勫熀鏈師鐞嗭紝鎺屾彙缍�(w菐ng)绲�(lu貌)鎳�(y墨ng)鐢ㄧ殑鍩烘湰鎶€鑳�銆�
涓夈€佽€冭│鏂瑰紡鍜岃€冭│鏅傞枔
鏈│鍗烽噰鐢ㄩ枆鍗风瓎瑭﹀舰寮忥紝瑭﹀嵎婊垮垎鐐� 150 鍒�锛岃€冭│鏅傞枔鐐� 180 鍒嗛悩銆�
鍥�銆佽€冭│鍏�(n猫i)瀹瑰拰鑰冭│瑕佹眰
銆婁俊鎭妧琛�(sh霉)缍滃悎銆嬭€冭│鍏�(n猫i)瀹瑰寘鎷細鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)銆佽▓绠楁缍�(w菐ng)绲�(lu貌)鎶€琛�(sh霉)鍏╅儴鍒嗗収(n猫i)瀹�銆傚悇閮ㄥ垎鑰�
瑭﹀収(n猫i)瀹瑰強瑕佹眰濡備笅锛�
(涓€) 鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)(60%)
1锛�?d膩ng)?sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝堪
1). 淇℃伅銆佹暩(sh霉)鎿�(j霉)鑸囨暩(sh霉)鎿�(j霉)铏曠悊
浜嗚В淇℃伅銆佹暩(sh霉)鎿�(j霉)鑸囨暩(sh霉)鎿�(j霉)铏曠悊鐨勬纰哄惈缇┿€�
2). 鏁�(sh霉)鎿�(j霉)绠＄悊鐨勯€插睍
浜嗚В鏁�(sh霉)鎿�(j霉)绠＄悊鎶€琛�(sh霉)鐧�(f膩)灞曠殑鍥涘€嬮殠娈靛悇鑷殑鐗归粸锛涙暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐩告瘮浜庢枃浠剁郴绲�(t菕ng)鍏锋湁
鐨勫劒(y艒u)榛�銆�
3). 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祫鎴愩€佺祼(ji茅)妲�(g貌u)
鐞嗚В涓夌礆妯″紡锛屽叐绱氭槧鍍�锛屽叐绱氱崹绔嬫€�锛�
浜嗚В鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祫鎴�銆佺祼(ji茅)妲�(g貌u)鍙婂叾鍚勭祫鎴愰儴鍒嗙殑鍏�(n猫i)瀹广€�
4). 鏁�(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)(DBMS)
鐞嗚В DBMS 鐨勪富瑕佸姛鑳�锛�
浜嗚В DBMS 鐨勭祫鎴愩€�
5).鏁�(sh霉)鎿�(j霉)妯″瀷
鐞嗚В纰煎拰閸�锛�
浜嗚В鏁�(sh霉)鎿�(j霉)妯″瀷鐨勪笁鍊嬮儴鍒嗐€佷笁鍊嬩笘鐣岀殑鍔冨垎鍙婂叾鍩烘湰姒傚康銆佹蹇垫暩(sh霉)鎿�(j霉)妯″瀷浠ュ強 E_R
妯″瀷鐨勫熀鏈绱�锛�
浜嗚В涓夌ó閭忚集鏁�(sh霉)鎿�(j霉)妯″瀷锛氱恫(w菐ng)鐙€妯″瀷銆佸堡娆℃ā鍨嬨€侀棞(gu膩n)绯绘ā鍨嬬殑鍩烘湰鐗归粸銆�
2锛庨棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�
1).鍩烘湰姒傚康
鐞嗚В闂�(gu膩n)绯荤殑鍊欓伕纰煎拰涓荤⒓锛涗富灞€у拰闈炰富灞€�锛�
浜嗚В闂�(gu膩n)绯绘ā鍨嬬殑绲勬垚锛氭暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)銆侀棞(gu膩n)绯荤殑鎿嶄綔鍜屽畬鏁存€х磩鏉燂紱闂�(gu膩n)绯荤殑瀹氱京锛涢棞(gu膩n)绯�
鐨勬€ц唱(zh矛)銆�
2).澶栭儴纰�
浜嗚В澶栭儴闂�(gu膩n)绯荤⒓锛涘畬鏁存€х磩鏉燂細瀵﹂珨瀹屾暣鎬с€佸弮鐓у畬鏁存€�銆佺敤鎴跺畾缇╁畬鏁存€�銆�
3).闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴ā寮忚垏闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴€�
浜嗚В闂�(gu膩n)绯绘ā寮忓拰闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴ā寮忕殑瀹氱京锛涢棞(gu膩n)绯昏垏闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴殑瀹氱京銆�
4).闂�(gu膩n)绯讳唬鏁�(sh霉)
鐞嗚В闂�(gu膩n)绯讳唬鏁�(sh霉)鐨勫垎椤�锛涘偝绲�(t菕ng)鐨勯泦鍚堥亱绠�锛涘皥闁€鐨勯棞(gu膩n)绯婚亱绠�銆�
3锛嶴QL 瑾炶█
1). SQL 瑾炶█姒傝矊鍙婄壒榛�
浜嗚В SQL 瑾炶█鐨勭櫦(f膩)灞曞強妯�(bi膩o)婧�(zh菙n)鍖�锛汼QL 瑾炶█鏀寔鐨勪笁绱氭ā寮忓強鍩烘湰琛ㄥ拰瑕栧湒绛夋蹇碉紱
SQL 瑾炶█鐨勪富瑕佺壒榛�銆�
2). SQL 鏁�(sh霉)鎿�(j霉)瀹氱京鍔熻兘
鐞嗚В SQL 鐨勭祫鎴愶紱
鎺屾彙 SQL 鏁�(sh霉)鎿�(j霉)搴ā寮忕殑鍓�(chu脿ng)寤哄拰鎾ら姺锛涘熀鏈〃鐨勫壍(chu脿ng)寤恒€佷慨鏀瑰拰鎾ら姺锛涜鍦栫殑鍓�(chu脿ng)寤哄拰
鎾ら姺锛涚储寮曠殑鍓�(chu脿ng)寤哄拰鎾ら姺銆�
3). SQL 鏁�(sh霉)鎿�(j霉)鏌ヨ鍔熻兘
鎺屾彙 SELECT 瑾炲彞鐨勬牸寮忓拰鍚勭ó鏌ヨ鏂规硶锛屼緥濡�锛屽柈琛ㄦ煡瑭�銆侀€ｈ〃鏌ヨ銆佸祵濂楁煡
瑭紙瀛愭煡瑭㈠拰鐩搁棞(gu膩n)瀛愭煡瑭級銆侀泦鍚堟煡瑭�锛涘付搴嚱鏁�(sh霉)锛堥泦鍑芥暩(sh霉)锛夎▓绠楃殑鏌ヨ鍜�
鍒嗙祫鏌ヨ銆�
4). SQL 鐨勬暩(sh霉)鎿�(j霉)鏇存柊
鎺屾彙 SQL 瑾炲彞瀹氱京 INSERT銆丏ELETE銆乁PDATE 瑾炲彞鐨勬牸寮忓拰鐢ㄦ硶銆�
4锛庨棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴悊璜�
1). 鍩烘湰姒傚康
鐞嗚В鍑芥暩(sh霉)渚濊炒鐨勫畾缇╁拰鐩告噳(y墨ng)鐨勬蹇�锛涘畬鍏ㄥ嚱鏁�(sh霉)渚濊炒銆侀儴鍒嗗嚱鏁�(sh霉)渚濊炒鍜屽偝閬炲嚱鏁�(sh霉)渚�
璩�銆�
2). 瑕�(gu墨)鑼冨寲鐞嗚珫
鐞嗚В绗竴鑼冨紡銆佺浜岃寖寮�銆佺涓夎寖寮忓拰鐨勫畾缇┿€�
5锛�?d膩ng)?sh霉)鎿�(j霉)搴畨鍏ㄤ繚璀�
1). 鏁�(sh霉)鎿�(j霉)搴殑瀹夊叏鎬ф帶鍒�
浜嗚В鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€х殑鍚京锛涙暩(sh霉)鎿�(j霉)搴畨鍏ㄦ帶鍒剁殑涓€鑸柟娉曘€�
2). 鏁�(sh霉)鎿�(j霉)搴畬鏁存€ц(gu墨)鍓�
浜嗚В瀹屾暣鎬ц(gu墨)鍓囩殑绲勬垚锛涘畬鏁存€х磩鏉熸浠剁殑鍒嗛銆�
3). 骞剁櫦(f膩)鎺у埗鑸囧皝閹�
浜嗚В浜嬪嫏(w霉)鐨勫畾缇╁拰鐗规€�锛涘苟鐧�(f膩)鎿嶄綔鑸囨暩(sh霉)鎿�(j霉)鐨勪笉涓€鑷存€�锛涘皝閹�銆�
4). 鏁�(sh霉)鎿�(j霉)鍔犳仮寰�(f霉)
浜嗚В鏁�(sh霉)鎿�(j霉)搴仮寰�(f霉)鐨勫師鐞嗗強鍏跺鐝�(xi脿n)鎶€琛�(sh霉)锛涙暩(sh霉)鎿�(j霉)搴殑鏁呴殰鍜屾仮寰�(f霉)绛栫暐銆�
6锛�?d膩ng)?sh霉)鎿�(j霉)搴ō(sh猫)瑷�
浜嗚В鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷堢殑涓昏闅庢鍙婂悇闅庢鐨勪富瑕佺壒榛炪€�
(浜�) 瑷堢畻姗熺恫(w菐ng)绲�(lu貌)(40%)
1锛庤▓绠楁缍�(w菐ng)绲�(lu貌)姒傝堪
瑕佹眰鎺屾彙瑷堢畻姗熺恫(w菐ng)绲�(lu貌)鐨勫畾缇╁拰鍏�(n猫i)娑�锛�
浜嗚В瑷堢畻姗熺恫(w菐ng)绲�(lu貌)鐨勫垎椤烇紱
鎺屾彙鍗�(xi茅)璀�銆佸堡娆°€佹帴鍙ｈ垏缍�(w菐ng)绲�(lu貌)楂旂郴绲�(ji茅)妲�(g貌u)鐨勫熀鏈蹇�锛�
浜嗚В TCP/IP 鍙冭€冩ā鍨嬬殑灞ゆ鍔冨垎銆佸悇灞ょ殑鍩烘湰鏈嶅嫏(w霉)鍔熻兘鑸囦富瑕佸崝(xi茅)璀般€�
2锛庣墿鐞嗗堡
瑕佹眰浜嗚В鏁�(sh霉)鎿�(j霉)閫氫俊鐨勭浉闂�(gu膩n)姒傚康鍜岀煡璀�锛岄€氫俊鎶€琛�(sh霉)鍩烘湰鍘熺悊銆侀€氫俊妯″瀷绛�锛�
鐞嗚В鍚勭ó鍌宠几浠嬭唱(zh矛)鐨勭壒榛烇紱
浜嗚В鏅傚垎寰�(f霉)鐢�锛岄牷鍒嗗京(f霉)鐢ㄦ妧琛�(sh霉)绛夌殑姒傚康銆�
3锛�?d膩ng)?sh霉)鎿�(j霉)閺堣矾灞�
瑕佹眰鎺屾彙鏁�(sh霉)鎿�(j霉)閺堣矾灞ょ殑鐩搁棞(gu膩n)姒傚康鍜岀煡璀�锛�
鎺屾彙 CSMA/CD 鍗�(xi茅)璀扮殑宸ヤ綔鍘熺悊銆傜悊瑙ｇ恫(w菐ng)姗嬬殑宸ヤ綔鍘熺悊銆�
鎺屾彙缍�(w菐ng)姗嬬殑杞�(zhu菐n)鐧�(f膩)閬庢烤姗熷埗锛屼互鍙婇€忔槑缍�(w菐ng)姗嬭綁(zhu菐n)鐧�(f膩)琛ㄧ殑寤虹珛閬庣▼
鎺屾彙铏涙摤灞€鍩熺恫(w菐ng)鐨勬蹇�
4锛庣恫(w菐ng)绲�(lu貌)灞�
鎺屾彙鍒嗛 IP 鍦板潃鐨勫熀鏈蹇佃垏鍒嗛鏂规硶锛�
鎺屾彙鍦板潃瑙ｆ瀽鍗�(xi茅)璀� ARP锛�
鎺屾彙鍔冨垎瀛愮恫(w菐ng)鐨勬蹇�锛�
浜嗚В鍏�(n猫i)閮ㄧ恫(w菐ng)闂�(gu膩n)鍗�(xi茅)璀� RIP 鍜� OSPF锛�
浜嗚В Internet 鎺у埗鍫辨枃鍗�(xi茅)璀拌垏澶氭挱绠＄悊鍗�(xi茅)璀扮殑姒傚康锛�
浜嗚В VPN 鍜� NAT 鐨勫熀鏈蹇碉紱
5锛庡偝杓稿堡
鐞嗚В缍�(w菐ng)绲�(lu貌)鐠�(hu谩n)澧冧腑閫茬▼閫氫俊鐨勫熀鏈蹇�锛�
浜嗚В甯歌绔彛锛屾帉鎻￠€茬▼鐩镐簰浣滅敤鐨勫鎴�/鏈嶅嫏(w霉)鍣ㄦā鍨嬶紱
鎺屾彙鐢ㄦ埗鏁�(sh霉)鎿�(j霉)鍫卞崝(xi茅)璀� UDP 鐨勫熀鏈収(n猫i)瀹�锛�
鎺屾彙鍌宠几鎺у埗鍗�(xi茅)璀� TCP 鐨勫熀鏈収(n猫i)瀹癸紱
鎺屾彙 TCP 閫ｆ帴鐨勫熀鏈亷绋�锛�
6锛庢噳(y墨ng)鐢ㄥ堡
浜嗚В Internet 鍚勯爡鏈嶅嫏(w霉)锛圖NS,FTP,DHCP,SMTP,HTTP锛夌殑鍩烘湰閬庣▼鑸囧伐浣滃師鐞�锛�
浜斻€佷富瑕佸弮鑰冩浉鐩�
1. 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)灏�(d菐o)璜栵紙绗簲鐗堬級锛岃柀甯厞銆佺帇鐝婄法锛岄珮绛夋暀鑲插嚭鐗堢ぞ锛�2014 骞�.
2. 瑷堢畻姗熺恫(w菐ng)绲�(lu貌)锛堢涓冪増锛�锛岃瑵甯屼粊锛岄浕瀛愬伐妤�(y猫)鍑虹増绀�锛�2017 骞�.
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠ｈ〃浣滆€呭€嬩汉瑙€榛�锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹广€佹枃瀛楃殑鐪熷鎬�銆佸畬鏁存€с€佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵︾浉闂�(gu膩n)鍏�(n猫i)瀹�銆�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
