SHI SQL Querying Fundamentals Course
Za maphunzirowa
Mabungwe nthawi zambiri amasunga zidziwitso zawo zofunika kwambiri - zomwe zimagwiritsidwa ntchito poyang'anira zochitika za tsiku ndi tsiku mkati mwa database. Kutha kupeza ndikusanthula chidziwitsochi ndikofunikira pakugwira ntchito kwa bungwe. Structured Query Language (SQL) ndiye chilankhulo choyambirira chomwe chimagwiritsidwa ntchito pokwaniritsa ntchito zotere. Kwenikweni, SQL ndi chilankhulo chomwe mumagwiritsa ntchito polumikizana ndi database.
Kukhoza kulemba SQL ndi luso lofunikira la ntchito kwa iwo omwe amafunikira kuyang'anira kuchuluka kwa deta, kupanga malipoti, mgodi wa data, kapena kuphatikiza deta kuchokera kuzinthu zambiri. Ngakhale wina pagulu lanu atakupangirani malipoti, kumvetsetsa kofunikira pakufunsa kwa SQL kudzakuthandizani kufunsa mafunso oyenera ndikudziwa zomwe mukuyang'ana pazida zanu zosanthula deta.
Maphunzirowa samakuphunzitsani kugwiritsa ntchito SQL ngati chida chopezera zomwe mukufuna kuchokera m'madatabase, komanso imayambitsa njira yokonzekera bwino komanso kupanga nkhokwe zogwira ntchito, zogwira mtima. Kudziwa momwe mungakonzekere nkhokwe yaubale ndikofunikira kuti nkhokwe zomwe mumapanga zitheke. Popanda kukonzekera, simungathe kudziwa zomwe database ikuyenera kuchita, kapenanso zomwe mungaphatikizepo munkhokwe. Kukonzekera nkhokwe ndikofunikira ndipo kumalepheretsa ntchito yowonjezera yokonza zovuta zokonza deta pambuyo pake.
Omvera ovomerezafile
Maphunzirowa ndi ophunzirira anthu omwe ali ndi luso loyambira pakompyuta, odziwa bwino malingaliro okhudzana ndi kapangidwe ka database ndi mawu ofotokozera, omwe akuyenera kuphunzira zofunikira za kamangidwe ka database ndikugwiritsa ntchito SQL kufunsa nkhokwe.
- Business Analysts
- Akatswiri Ofufuza
- Madivelopa
- Omwe akufunika kudziwa momwe angafunsire mu database ya SQL
Pomaliza maphunziro
Akamaliza maphunzirowa, ophunzira azitha:
- Tsatirani njira yabwino yopangira database yolumikizana.
- Tanthauzirani lingaliro la database.
- Tanthauzirani chitsanzo chomveka cha database.
- Gwiritsani ntchito njira zosinthira database kuti muwongolere kapangidwe kawo koyambira.
- Malizitsani mapangidwe a database, kuphatikiza zowongolera kuti muwonetsetse kukhulupirika kwake komanso kukhulupirika kwa data.
- Lumikizani ku database ya SQL Server ndikufunsani funso losavuta.
- Phatikizani zomwe mukufuna mufunso losavuta.
- Gwiritsani ntchito ntchito zosiyanasiyana kuti muwerengere pa data.
- Konzani zomwe zapezedwa kuchokera pafunso musanawonetse pazenera.
- Fukulanso data kuchokera kumatebulo angapo.
- Tumizani zotsatira za funso.
Ndemanga ya Maphunziro
Phunziro 1: Kuyamba ndi Relational Database Design
- Mutu A: Dziwani Zomwe Zili pa Database
- Mutu B: Dziwani Vuto Lopanga Ma Database Wamba
- Mutu C: Tsatirani Ndondomeko Yopangira Ma Database
- Mutu D: Sungani Zofunikira
PHUNZIRO 2: Kufotokozera Mafayilo a Database Conceptual Model
- Mutu A: Pangani Conceptual Model
- Mutu B: Dziwani Maubale a Gulu
PHUNZIRO 3: Kutanthawuza Chitsanzo cha Database Logical Model
- Mutu A: Dziwani Mizati
- Mutu B: Dziwani Makiyi Oyambirira
- Mutu C: Dziwani ndi Kujambula Maubale
Phunziro 4: Kusintha Deta
- Mutu A: Pewani Zolakwitsa Zofanana ndi Zolemba Zazopezekanso
- Mutu B: Tsatirani Mafomu Apamwamba Apamwamba
PHUNZIRO 5: Kumaliza Mapangidwe a Database
- Mutu A: Sinthani Mawonekedwe a Thupi a Kachitidwe Kosiyana
- Mutu B: Onetsetsani Kukhulupirika kwa Referential
- Mutu C: Onetsetsani Kukhulupirika kwa Deta pa Mzere wa Column
- Mutu D: Onetsetsani Kukhulupirika kwa Data pa mlingo wa tebulo
- Mutu E: Mapangidwe a Cloud
Phunziro 6: Kuchita Funso Losavuta
- Mutu A: Lumikizani ku SQL Database
- Mutu B: Fufuzani ku Database
- Mutu C: Sungani Mafunso
- Mutu D: Sinthani ndikuchita Funso Losungidwa
PHUNZIRO 7: Kuchita Kusaka Koyenera
- Mutu A: Sakani Pogwiritsa Ntchito Chimodzi kapena Zambiri
- Mutu B: Saka a Range of Values and NULL Values
- Mutu C: Sakani Zambiri Potengera Zingwe Zingwe
Phunziro 8: Kuchita ndi Zochita
- Mutu A: Kuwerengera Tsiku
- Mutu B: Werengetsani Data Pogwiritsa Ntchito Aggregate Functions
- Mutu C: Sinthani Zingwe Zazingwe
Phunziro 9: Kukonza Deta
- Mutu A: Sanjani Data
- Mutu B: Rank Data
- Mutu C: Gulu Data
- Mutu D: Zosefera Zamagulu
- Mutu E: Fotokozerani mwachidule Deta ya Gulu
- Mutu F: Gwiritsani ntchito PIVOT ndi UNPIVOT Operators
Phunziro 10: Kubweza Deta ku Matebulo Angapo
- Mutu A: Phatikizani Zotsatira za Mafunso Awiri
- Mutu B: Fananizani Zotsatira za Mafunso Awiri
- Mutu C: Fukulani Data polowa Matebulo
Phunziro 11: Kutumiza Zotsatira Zamafunso
- Mutu A: Pangani Mawu File
- Mutu B: Pangani XML File
Zolemba / Zothandizira
 |
SHI SQL Querying Fundamentals Course [pdf] Malangizo SQL Querying Fundamentals Course, SQL, Querying Fundamentals Course, Fundamentals Course, Course |
