LibreOffice-Suite-Base/C4/Indexes-Table-Filter-SQL-Command-window/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:03	Ha kane ka jinghikai, ngin ia pule ia kine ki topics harum: Indexes, Table Filter, Bad ka SQL Command window.
00:14	To ngin ia pule shwa nyngkong shaphang ka “Index”es.
00:16	Kaei ka “Index”?
00:18	Ka Index kadei ka rukom ha kaban wad bad sort stet ia ki “record”s hapoh ka “database table”.
00:26	Ngi lah ban jied ia kawei ka “field” lane bun tylli ki fields ha ka “table” ha kaba ki records ki donkam ban buh ia ka indexed.
00:36	Ka Index ka buh ia ka jaka jong ki records kaba shong nongrim ha ka field ba la jied lane fields.
00:43	Te, ban sei ia ka data, ka “Base” ka lah ban leit beit sha ka jaka ba ka data kadon da kaba pyndonkam da ka index.
00:51	Bad te, ka long ka ba stet da shisha ban ia ka scanning jong baroh ki records ban it ia ka data.
00:59	Ka “primary key” jong ka table lah indexed hi.
01:03	Mynta, to ngin ia shna ia ka index ha ka nuksa jong ka “Library” database jong ngi.
01:09	Ngin ia shna ia ka index ha ka “Title” column ha ka “Books” table kaban pynstet ia ka jingit ia ki kyrteng jong ki kot.
01:18	To ngin ia plie shwa nyngkong ia ka ‘Library’ database jong ngi, lada khlem pat plie ia ka.
01:34	Bad plie ia ka “Books” table ha ka “Edit” mode.
01:39	Ha ka “Table Design” window, to ngin leit sha ka “Tools” menu bad jied “Index Design”.
01:48	Ha ka “Indexes” window, phin iohi ia ka “Base” ka lah kynthup lypa ia ka “Primary Key” kum ka “Unique” Index.
01:57	To ngin ia nioh ha u icon uba sha kadiang duh, “New Index”, ban shna ia ka index jong ngi.
02:05	Bad jied “Title” ha ka drop-down lis hapoh ka “Index field ha kamon.
02:14	Bad ngi lah ruh ban jied ia ka “Ascending” lane “Descending” order nangne
02:19	Bad “rename” ia kane ka index sha ka ‘IDX_Title’ da kaba nion ha u icon ba lai ha kadiang bad save ia ka da kaba pyndonkam ia u “Save” icon marbud bad ka.
02:37	Te, hangne ka index jong ngi ha ka “Title” field.
02:42	Ha kane ka rukom ngi lah ban shna, edit, rename lane pyndam ia ki indexes na ka bynta ki tables da kaba pyndonkam da ka “Base”.
02:51	Hangne ka kam na ka bynta jong phi:
02:54	Shna ia ka index jong ki kyrteng ha ka “Members” table bad khot ia ka “IDX_MemberName’.
03:03	Hadien kane, to ngin ia peit kaei ka “Table Filter”.
03:07	‘Table Filter’ featurs ka ai lad ia ngi ban buhrieh ia ki tables ha ka “Base” database na kawei pat ka applications.
03:15	Kum ka nuksa, to ngin buhrieh baroh ki tables lait noh ia ka “Books” table ha ka ‘Library’ database.
03:22	Mynta, “Table Filter” kadon hapoh jong u “Tools” menu.
03:27	Hangne, to ngin ia check “All Views” bad check ia ka “Books” table.
03:33	Kaba mut, ba ngi buh dak tang ia ki “Books” table kiba ngi lah ban iohi da kiwei ki applications.
03:39	Mynta, to ngin nion ha u “OK” button.
03:43	Hadien kane, to ngin nion ha u “View” menu bad nangta ha u “Refresh Tables”.
03:50	Phin iohi ba ka “Books” kadei tang maka ka table kaba paw hangne.
03:54	Bad ruh, lada ngi access ia kane ka database na ka “LibreOffice Writer” lane “Calc”, ngin sa iohi tang ia ka “Books” table hangta.
04:04	Hangne kawei pat ka kam iaphi:
04:06	1. Plie ia ka “LibreOffice Writer”, access ia ka “Library” database bad check ia ki tables kiba don hangne.
04:14	2. Wanrah biang ia baroh ki tables sha kaba ngin iohi biang sa shisien ha ka “Base”.
04:19	3. Bad plie biang ia ka ‘LibreOffice Writer’ ban check ia ka jingdon ki tables’ sa shisien.
04:26	Khatduh eh, to ngin ia pule shaphang ka “SQL command window”.
04:31	Ka ‘SQL command window’ la accessed da kaba jied “SQL” na ka “Tools” menu.
04:41	Ngi lah ban pyndonkam ia kane ka window ban pynithuh ia ka “SQL statements” sha ka “database”.
04:47	Mynta, ngi lah ruh ban pyndonkam ia ka “Queries” ban pyntreikam ia ka SQL queries hynrei ngi lah tang ban pan ia ka data na ka database.
04:59	Kaba mut ngi lah ban pynithuh tang ia ka “SELECT” statements hangne.
05:04	Hynrei ngim lah ban “execute” ia ka SQL statements kaba lah ban pynkylla ia ka data bad ka table structure lane ban shna ia ki tables ba thymmai hangne.
05:14	Bad ka ‘SQL command window’ ka iarap ia ngi ban pyndonkam kum ia ka “data manipulation” bad ka “data definition” statement lane ka language.
05:24	Ki nuksa jong ka “Data Manipulation Language” lane “DML” kidei:
05:31	INSERT, UPDATE bad DELETE data.
05:37	Bad katto katne ki nuksa jong ka “Data Definition Language” lane “DDL” kidei:
05:45	CREATE TABLE, DROP TABLE bad ALTER statements.
05:51	Ngin ia peit shwa nyngkong ia ka nuksa jong ka “DML”.
05:55	Ha ka “Base” window, to ngin ia plie ia ka “SQL Command Window” na ka “Tools” menu.
06:02	To ngin ia thep ia ka record ba thymmai ha ka “Books” table da kaba type ha ka jaka “Command to execute”.
06:12	INSERT INTO "Books" ( "Title", "Author", "PublishYear", "Publisher", "Price") VALUES ('The Hobbit', 'J.R.R Tolkien', 2002, 'Oxford', 500);
06:45	Shwa ban nion ha u “Execute” button, to ngin ia peit bniah mynta ia ka command.
06:52	Ka “INSERT” statement ka lis ia ka kyrteng jong ka “table” bad ka kyrteng ki “field” bad nangta ia ka “Values” kaba donkam ban leit sha ka record ba thymmai.
07:03	Phin iohi ba ka kyrteng jong ka table bad ka kyrteng jong ki field ki lah don hapoh jong ki quotes ba ar tylli.
07:11	Ngi tip ba ka “Base” kadei case sensitive bad ki quotes badon ar tylli ki pynthikna ba ka Base kan sa pdiang ia ka kyrteng ba ngi la shna.
07:22	Lada ngim pyndonkam ia kine ki quotes, ka Base kan sa pynkylla hi ia baroh ki kyrteng sha ki upper cases.
07:31	Ngi hap ban pyndonkam ia ki single quotes ban encase ia ki values kiba dei jong ka data type “TEXT”.
07:37	NUMERIC fields kim da donkam ban don hapoh ki kino kino ki quotes.
07:43	Bad ruh, ngim da donkam ban kynthup ia ka “BookId” field kaba dei ka “AutoNumber” field.
07:51	Ka “Base” kan sa shim khia hi ia ka number ba ka pynmih hi dalade.
07:56	Te, to ngin ia pyntreikam ia ka SQL. Phin iohi ia ka khubor “Command successfully executed”.
08:05	Lada don kano kano ka jingbakla bad ka SQL kaba ngi thoh, ka Base kan sa pyni ia ki.
08:12	To ngin ia nion ar sien ha ka “Books” table bad peit ia ka record ba thymmai kaba ngi dang shu thep.
08:18	Hangne kadon, la bsiap ia ka ha ka row ba khatduh.
08:23	Hadien kane, to ngin ia peit ia ka nuksa jong ka “DDL”.
08:27	Ngin ia shna ia ka table ba thymmai kaba ngi khot ka “Authors” bad ki fields “AuthorId, Author” bad “Country”.
08:36	Ha ka “SQL command window”, to ngin ia type kumba la pyni ha ka screen
08:43	Bad pyntreikam ia ka.
08:47	To ngin ia leit biang sha ka “Tables” lis bad “Refresh” ia ka tables na ka “View” menu.
08:54	Hangne ka “Author” table ba thymmai jong ngi kaba ngi dang shu dep shna.
08:59	Ban tip kham bha shaphang ka “DML”, leit sha ka website kumba la pyni ha ka screen.
09:06	Ban tip kham bha shaphang ka DDL” leit sha ka Wikipedia website kumba la pyni ha ka screen.
09:13	Hangne sa kawei ka kam na ka bynta jong phi:
09:16	1. Pyndonkam ia ka “UPDATE” statement ban set ia ka dor jong ka kot bad ka “BookId” kum 3, sha ka Rs. 300
09:26	2. Pyndam ia ka kot kaba don ia ka kyrteng ‘The Hobbit’
09:30	3. Thep ia ka record ba thymmai ha ka “Authors” table, “author name” kum ‘J.R.R.Tolkien’, bad “country” kum ‘England’
09:41	4. Pynhap ia ka “Authors” table na ka database da kaba pyndonkam da ka “DROP” statement.
09:47	Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “LibreOffice Base”.
09:52	Ban kyllum lang, ngi la pule ia kine ki topics harum: Indexes, Table Filter, And the SQL Command window.
10:01	“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.
10:13	Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org.
10:18	Kham bun ki jingtip halor kane ki don ha ka link harum.
10:22	nga dei u Pdiangburom na Shillong na pynkut ia kane. Khublei shibun ia ka jingsnohkti lang jong phi.

Contributors and Content Editors

Pdiangburom, PoojaMoolya