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

From Script | Spoken-Tutorial
Jump to: navigation, search
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