LibreOffice-Suite-Base/C3/Create-simple-queries-in-SQL-View/Khasi

Time	Narration
00:02	Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:06	Ha kane ka jinghikai, ngin ia pule kumno ban:
00:09	Shna ia ki queries kiba suk ha ka “SQL View”, ban thoh ia ka SQL kaba suk.
00:16	Pyndonkam “SELECT, FROM” bad “WHERE” clauses
00:20	Bad jied ki dak heh lane dak rit lane khleh lang ban jer kyrteng ia kine ki “field”s bad “table”s.
00:27	Shwa ban pyndonkam ia ka “Base” ban shna ia ki queries ha ka “SQL View”, to ngin ia kren shaphang ka “LibreOffice Base”.
00:35	Ka “Base” ka treikam halor ka “HSQL database engine”.
00:41	Kane kadei ka open source database engine software kaba la thoh ha ka Java. Leit sha ka http://hsqldb.org na ka bynta kham bun ki jingtip.
01:02	Te, to mynta ngin ia pule shaphang ka SQL.
01:06	SQL ka ieng na ka bynta ka “Structure Query Language”. Kadei ka standard language na ka bynta ban pyndonkam bad treikam ia ka databases.
01:17	Kadei kaba la pdiang da ka ANSI standard ha baroh kawei ka pyrthei.
01:23	Te ia ka, la pyndonkam ha ki rukom bapher bapher jong ka ‘Database Management Systems’ lane ‘DBMS’
01:31	Khyndiat ki nuksa kidei kum kine ki jong ngi LibreOffice Base, MySQL, Microsoft SQL Server, Microsoft Access, Oracle bad DB2.
01:47	Ka kam ba kongsan jong ka SQL kadei ban sei ia ki data na ka database kaba ngi tip ruh kum ka querying a database.
01:58	Ia ka SQL lah ruh ban pyndonkam ban pynrung ia ki data hapoh ka database, update ia ki data lane ban pyndam ia ki data na ka database.
02:09	Bad ngi lah dep leh ia baroh kine ki operations da kaba pyndonkam ia ka “Base”, ha ka jinghikai kaba hashwa,
02:16	Da kaba pyndonkam ia ki wizards kiba suk ban treikam bad da ka designing windows.
02:22	Hynrei da kaba tip ia ki query language kiba don hapoh jong ka, ka pynsuk bad aibor ia ngi ban query na ka database bad ka SQL lah ruh ban pyndonkam ym tang ban pynkylla ia ki data hynrei ruh ban pynkylla ia ka database bad ia ka dur ka dar jong ka table.
02:43	Namar ba ka jinghikai jong ngi kam lah ban hikai lut ia baroh kawei ka SQL, te hangne katto katne ki jinghikai ba iarap bad ka websites jong ki.
02:59	HSQLDB kadon la kajong ka user guides. Ia kine lah ban peit online lane ia ki lah ban download bad save hapoh ka computer jong phi kum ka PDF file.
03:14	To, mynta ngin ia pule katto katne ki SQL. Ngin ia plie ia ka “Library” database jong ngi kum ka nuksa.
03:23	To ngin ia plie ia ka ‘Library’ database jong ngi. Mynta, to ngin ia nion ha u “Queries” list ha ka panel ba sha kadiang
03:34	Bad nangta nion ha “Create Query in SQL View”. Mynta ngi iohi ia ka window ba suda kaba kyrteng “Query Design”
03:46	Bad hangne ngin ia type ia ka queries jong ngi ha ka SQL.
03:51	To ngin ia thoh ia ka query ba suk bad ba nyngkong jong ngi. Bad kata kadei: Ban ioh ia ka jingtip shaphang baroh ki kot ha ka library.
04:02	Kano kano ka jingpynmih donkam ban pyndonkam da ka “SELECT” keyword. Bad te, ngin ia thoh ia ka query jong ngi kum-
04:10	SELECT * FROM Books.
04:15	Hangne, “Books” kadei ka kyrteng jong ka table. Phin iohi ia u dak heh “B” ha ka books.
04:23	Ngin ia bud beit ia ka kyrteng jong ka table lane ka column kaba ngi pyndonkam hashwa.
04:29	Bad ‘*’ kadei ka “wild card”. Hangne, kamut- ban ioh ia baroh ki fields lane column na ka “Books” table.
04:39	Mynta, to ngin ia pyntreikam lane “run” ia ka. Nion ha u “Edit” menu bad nangta nioh ha “Run Query”.
04:48	Mynta ngi iohi ia ka panel ba hajrong bad ka lis jong ki “record”s halor ki books.
04:53	Ngi lah ban save ia kane ka query lane kano kano ka query kaba ngi thoh bad ai ia ka kyrteng ba jrong.
05:00	Te, kane kadei kadei ka query ba suk bad ba nyngkong jong ngi! Hangne katto katne ki jingai jingmut:
05:06	HSQLDB kadei ka case sensitve ryngkat bad ka kyrteng ka Database object kum ka kyrteng jong ka tables bad ka column.
05:17	Kaba mut- Ka kyrteng jong ka table “Books” bad u dak heh ‘B’ kam dei kajuh bad ka “books” bad u dak rit ‘b’.
05:27	Hynrei, na ka bynta ka jingsuk jong ngi ngi lah ban pyndonkam ia baroh ki upper cases lane baroh ki lower cases.
05:34	Kum ka nuksa: ‘BOOKS’ ha ki dak heh, lane ‘member’ ha ki dak rit bad kiwei.
05:44	Hynrei, ban khleh lang ia kine ki cases kalong kaba suk ban pule bad sngewthuh. Kum ka nuksa: ‘BooksIssued’, bad u dak heh ‘B’ bad ‘I’.
05:57	Lane ‘ReturnDate’ bad u dak heh ‘R’ bad ‘D’.
06:03	Te, ngi hap ban pyndonkam ia ka kyrteng jong ka table bad ka column kumba ngi leh haba shna.
06:11	Na ka bynta ka SQL keyword kum ka “SELECT”, ngi lah ban pyndonkam uno uno u case lane ki cases kiba khleh. Hynrei, to ngin leh da kijuh ha ka por ba ngi pyndonkam khnang ban suk ban pule.
06:25	Ha ka nuksa jong ngi, ngin ia pyndonkam baroh da ki dak heh lane upper cases na ka bynta ka keywords.
06:31	Mynta, ha ka query kaba bud jong ngi. Ngi lah ban type ia kane ka query ha ka window ba thymmai lane ngi lah ban thoh ia ka hajrong jong ka query kaba hashwa.
06:42	Ia mynta, to ngin ia thoh ia ka hajrong jong ka query kaba hashwa.
06:47	To ngin ia sei ia kine ki culumns badei na ka “Books” table. SELECT Title, Author FROM Books.
06:58	Bad “run” ia ka query. Ngi lah ruh ban pyndonkam ia ka “Run Query” icon ba hapoh jong ka file menu bar lane pyndonkam da ka keyboard shortcut “F5”.
07:13	Bad hangne ki records jong ngi ryngkat bad tang ki columns kiba ngi donkam.
07:19	Te, to ngin ia iaid shakhmat.
07:22	To ngin ia pynithuh ia ki kyndon lane criteria na ka bynta ka query jong ngi.
07:27	Ngin ia sei tang ia kito ki kot ba la pynmih da ka Cambridge.
07:31	Bad te, ka query jong ngi kadei: SELECT * FROM Books WHERE Publisher = 'Cambridge'.
07:46	Phin iohi ba ngi lah pynithuh ia ka keyword ba thymmai “WHERE”
07:52	Bud da ka kyndon ha kaba ngi ong 'Publisher' equals 'Cambridge'.
07:59	To ngin ia run ia kane ka query jong ngi mynta bad ngi iohi tang ia kito ki kot kiba la pynmih da ka ‘Cambridge’.
08:08	Bad te, ngi lah ban don ia bun tylli ki kyndon lane criteria ha ka query.
08:14	To ngin ia thoh ia ka query da ar tylli ki kyndon.
08:18	To ngin ia sei tang ia ki kot ba lah pynmih da ka Cambridge bad tang ia kito kiba la pynmih hadien u snem 1975.
08:29	Bad ka query jong ngi kadei: SELECT * FROM Books WHERE Publisher = 'Cambridge' AND PublishedYear > 1975.
08:49	Bad ngi iohi ia ar tylli ki kyndon hadien ka “WHERE” keyword lane clause.
08:55	Phin iohi ba ia ki la buh lang ryngkat da kaba pyndonkam ‘AND’. Hangne ‘AND’ la khot ka “logical operator”.
09:04	Bad hangne ka treikam ban khleh lang ia ki kyndon. “OR” kadei kawei pat ka logical operator.
09:13	Wad bniah shuh shuh ia kine da kaba pyndonkam ia ki ha ka query ba hajrong hadien.
09:18	To ngin ia “run” mynta ia ka query bad peit ia ki results hajrong.
09:23	Hangne, kine kidei ki kot kiba iadei bad ka kyndon jong ngi.
09:29	Te, to ngin ia pule ia kawei ka rukom ban kynthup ruh ia bun tylli ki kyndon.
09:36	Kumno ngi lah ban ioh ia ka lis tang jong ki kot kiba la pynmih da ka Cambridge lane Oxford lane da baroh ar?
09:46	Bad hange ka query jong ngi: SELECT * FROM Books WHERE Publisher IN ( 'Cambridge', 'Oxford').
10:09	Phin iohi ia u keyword ba thymmai “IN”.
10:13	Une u iarap ban khleh lang ia ki kyndon kiba shong ha kawei ka column- ha kaba iadei bad kane, ka “Publisher”.
10:21	Bad peit ia results mynta.
10:25	Hangne ka kam na ka bynta jong phi:
10:27	Thoh bad tes ia ka SQL queries jong phi na ka bynta kane harum:
10:33	1. Ban ioh ia ka jingtip jong baroh ki member ha ka library. 2. Ban ioh ia ka lis jong baroh ki kyrteng jong ki kot kaba ka dor jong ka kalong hajrong Rs 150. 3. Ban ioh ia ki lis jong ki kot ba la thoh da u William Shakespeare lane John Milton.
10:56	To ngin ia pule kham bun shaphang ka SQL ha ka jinghikai kaba bud.
11:01	Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ka “Queries in SQL View” ha ka “LibreOffice Base”.
11:09	Ban kyllum lang, ngi la pule kumno ban:
11:12	Shna ia ki queries ba suk ha ka SQL View.
11:17	Ban thoh ia ka SQL ba suk
11:20	Pyndonkam SELECT, FROM, bad WHERE clauses
11:25	Bad jied upper, lower, lane ki cases ba khleh lang ban jer kyrteng ia ki fields bad ki tables.
11:35	“Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
11:47	Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. Kham bun ki jingtip kadon ha ka link harum.
11:55	nga dei u Pdiangburom na Shillong, nga pynkut ia kane. Khublei shibun.

Contributors and Content Editors

Pdiangburom, PoojaMoolya