{"id":500423,"date":"2022-06-20T07:00:26","date_gmt":"2022-06-20T11:00:26","guid":{"rendered":"https:\/\/gijn.org\/?page_id=500423"},"modified":"2023-06-25T07:31:13","modified_gmt":"2023-06-25T11:31:13","slug":"bayanai-a-aikin-jarida-nazarin-bayanai-sql","status":"publish","type":"post","link":"https:\/\/gijn.org\/ha\/uncategorized-ha\/bayanai-a-aikin-jarida-nazarin-bayanai-sql\/","title":{"rendered":"Bayanai a aikin Jarida: Nazarin Bayanai &#8211; SQL"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-221679\" src=\"https:\/\/gijn.org\/wp-content\/uploads\/2020\/03\/gijnafricaheader.png\" alt=\"\" width=\"770\" height=\"187\" srcset=\"https:\/\/gijn.org\/wp-content\/uploads\/2020\/03\/gijnafricaheader.png 770w, https:\/\/gijn.org\/wp-content\/uploads\/2020\/03\/gijnafricaheader-336x82.png 336w, https:\/\/gijn.org\/wp-content\/uploads\/2020\/03\/gijnafricaheader-768x187.png 768w\" sizes=\"auto, (max-width: 770px) 100vw, 770px\" \/>Ana yawan amfani da SQL idan ana aiki da manhajojin ajiye bayanai. Yana da mahimmancin gaske a lokutan da ake amfani da bayanai masu yawan gaske wadanda Excel ba zai iya dazka ba domin yana iya hada bayanai daban-daban ya yi nazarinsu. Ana amfani da irinsu da dama a dakunan labarai, wadanda su ka hada da\u00a0<a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.postgresql.org\/\"><span style=\"text-decoration: underline\">Postgresql<\/span>\u00a0<\/a>da\u00a0<span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/sqlitebrowser.org\/\">DB Browser SQLite<\/a><\/span>.<\/p>\n<p>Ga wasu shawarwari kan yadda za\u2019a iya amfani da su.<\/p>\n<p>Ga wata kasida mai kashi kashi uku kan yadda ake amfani da QL, an gabatar da kasidar yayin babban taron GIJN 2019. Jodi Upton daga jami\u2019ar Syracuse da \u2018yar jarida mai bincike mai zurfi Crina Boros da Helena Bengtsson daga gidan talbijin na Sveriges da ke Sweden su ka ributa.\u00a0<span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/drive.google.com\/file\/d\/1thsby7DB7ypPgRBSPAIvJUYslTuOkH39\/view?usp=sharing\">SQL (Part 1)<\/a><\/span>,<span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/drive.google.com\/file\/d\/16Nxvk1EPyc3L_ovcTLDX3nnlcQEs05uY\/view?usp=sharing\">SQL (Part 2)<\/a><\/span>,\u00a0<span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/drive.google.com\/file\/d\/1wm37Vr0SsOnVhpqMkar2sYu2ec9yg9VD\/view?usp=sharing\">SQL (Part 3)<\/a><\/span>.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1spB5gs82X1oVmCweuFWHtlZ-hA3xSlYhvIbL7dmAx88\/edit\"><span style=\"text-decoration: underline\">Excel to SQL Crosswalk<\/span><\/a>\u00a0(2017) wanda MaryJo Webster ta rubuta bayanai ne da ke nuna kamanceceniyar da ke tsakanin Excel da SQL dan \u2018yan jaridan da ke so su fara amfani da SQL kuma sun riga sun dan san wani abu a kan Excel.<\/p>\n<p><span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"http:\/\/www.padjo.org\/2014-10-14\/\">Introduction to SQL for Data Journalism\/ Gabatarwa ga SQL ga masu amfani da bayanai dan aikin jarida<\/a><\/span>\u00a0(2014) wannan wani bangare ne na manhajan koyarwar a ajin Dan Nguyen, a jami\u2019ar Stanford. Ya bayar da bayanai dangane da SQL, ta yin amfani da hotunan shafukan, misalai na koyo da adiresoshin shafuka da kuma amsoshi ga tambayoyin da aka fi yi. Ya kuma kara da wasu darussan da ke bayani a kan abubuwan da suka fi wannan wahala.<\/p>\n<p>Khan Academy\/ Makarantar Khan Ya na da darassin da ke bayar da\u00a0<span style=\"text-decoration: underline\"><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.khanacademy.org\/computing\/computer-programming\/sql\">gabatarwa ga SQL<\/a><\/span><b>,\u00a0<\/b>darassin na cikin bidiyo kuma ya na bayar da bayanai daga mafi sauki zuwa mafi wahala.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/nostarch.com\/practicalSQL\"><span style=\"text-decoration: underline\">Practical SQL<\/span><\/a>\u00a0(2018) wanda Anthony De Barros ya rubuta, bayanai ne dangane da manhajojin SQL da wadanda suka fi shi. Amma an yi bayanan yadda kowa zai gane. DeBarros ya dade yana irin wannan aikin. A yanzu haka shi edita ne na labaran irin wadannan bayanan a Washington, D.C. a jaridar Wall Street Journal (Ana iya saye)<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.udemy.com\/topic\/sql\/#sqlexplained\"><span style=\"text-decoration: underline\">Udemy<\/span>\u00a0<\/a>ya na da darussa kan SQL kyauta a yanar gizo-gizo<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ana yawan amfani da SQL idan ana aiki da manhajojin ajiye bayanai. Yana da mahimmancin gaske a lokutan da ake amfani da bayanai masu yawan gaske wadanda Excel ba zai iya dazka ba domin yana iya hada bayanai daban-daban ya yi nazarinsu. Ana amfani da irinsu da dama a dakunan labarai, wadanda su ka hada [&hellip;]<\/p>\n","protected":false},"author":3031153,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_tribe_ticket_capacity":"0","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":"[]","_tribe_ticket_has_attendee_info_fields":false,"republication-tracker-tool-hide-widget":false,"footnotes":"","_tec_slr_enabled":"","_tec_slr_layout":""},"categories":[],"tags":[],"gijn_topic":[],"series":[],"gijn_language":[17798],"gijn_region":[],"class_list":["post-500423","post","type-post","status-publish","format-standard","hentry","gijn_language-ha-ha"],"acf":[],"ticketed":false,"_links":{"self":[{"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/posts\/500423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/users\/3031153"}],"replies":[{"embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/comments?post=500423"}],"version-history":[{"count":0,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/posts\/500423\/revisions"}],"wp:attachment":[{"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/media?parent=500423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/categories?post=500423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/tags?post=500423"},{"taxonomy":"gijn_topic","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/gijn_topic?post=500423"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/series?post=500423"},{"taxonomy":"gijn_language","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/gijn_language?post=500423"},{"taxonomy":"gijn_region","embeddable":true,"href":"https:\/\/gijn.org\/ha\/wp-json\/wp\/v2\/gijn_region?post=500423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}