Database programming in SQLite. Video course (2018)

Expand ▼

An approximate list of terms for express control in the discipline “Theoretical Grammar”: 1. absolute clause 2. absolute expression of time 3. abstract noun 4. active voice 5. actual division of the sentence 6. addressing enclosure 7. adjective 8. adverb 9 adverb of degree 10. adverb of manner 11. adverb of place 12. adverb of time 13. adverbial clause 14. adverbial modifier 15. adversative coordination 16. agreement (concord) 17. alternative question 18. animate noun 19. antecedent 20. appended clause 21. article 22. aspect 23. asyndetic connection 24. attribute 25. attribute clause 26. attribute appositive clause 27. attribute limiting clause 28. attribute non-limiting clause 29. attribute relative clause 30. auxiliary verb 31. binary privative opposition 32. cardinal numeral 33. category of case 34. category of gender 35. category of number 36. category of primary time 37. category of prospective time 38. causal functor 39. causative-consecutive coordination 40. clause 41. collective noun 42. collective nouns proper 43. common aspect 44. common case 45. common noun 46. communicative sentence-type 47. comparative degree 48. complex sentence 49. composite phrasal adverb 1 50. composite pronoun 51. composite sentence 52. compound adjective 53. compound adverb 54. compound pronoun 55. compound sentence 56. compound verb 57. concrete noun 58. conditional mood 59. conjunction 60. conjunctive cumulation 61. conjunctive mood 62. conjunctive pronoun 63. connector 64. consecutive subordination 65. constant categories 66. continuous aspect 67. coordination 68. copulative coordination 69. correlative cumulation 70. countable noun 71. cumulative sentence 72. cumuleme 73. declarative sentence 74. definite article 75. demonstrative pronoun 76. derivational morpheme 77. derivative verb 78. derived adjective 79. derived adverb 80. detaching pronoun 81. determiner 82. dialogue sequence 83. dicteme 84. discourse 85. disjunctive coordination 86. disjunctive question 87. durative verb 88. dynamic verb 89. elementary unit 90. elliptical question 91. elliptical sentence 92. emphatic ( cleft) clause 93. enclosure 94. equipollent opposition 95. exclamatory sentence 96. factual expression of time 97. finite form of the verb 98. formal speech 99. functor 100. general question 101. genitive (possessive) case 2 102. 103. 104. 105. 106. 107. 108. 109. 110. 111. 112. 113. 114. 115. 116. 117. 118. 119. 120. 121. 122. 123. 124. 125. 126. 127. 8. 129. 130. 131. 132. 133. 134. 135. 136. 137. 138. 139. 140. 141. 142. 143. 144. 145. 146. 147. 148. 149. 150. 151. 152. 153. gerund government grammar gradual opposition grammatical category grammatical classes (parts of speech) grammatical meaning grammatical oppositions grammatical system grammatical (functional) words grammeme immanent categories immediate constituent imperative mood sentence imperative impersonal pronoun inanimate noun indefinite article indicative mood indefinite pronoun infinitive inflectional morpheme informal (colloquial) speech intensifier interjection interjectional enclosure intermediary predicative construction interrogative pronoun interrogative sentence intransitive verb irregular verb language lexical (notional) words lexical system link-verb main clause marked (strong, positive) member material noun middle “voice” modal verb modal word mode functor monolithic complex sentence monologue sequence mood morpheme negative pronoun neutralization nominative division of the sentence non-absolute expression of time non-finite form of the verb non-pronominal question 3 154. 155. 156. 157. 158. 159. 160. 161. 162. 163. 164. 165. 166. 167. 168. 169. 170. 171. 172. 173. 174. 175. 176. 177. 178. 179. 180. 181. 182. 183. 184. 185. 186. 187. 188. 9. 190. 191. 192. 193. 194. 195. 196. 197. 198. 199. 200. 201. 202. 203. 204. 205. notional verb noun nouns of multitude numeral object object clause omission of the article one-member sentence operator operator of conjunction operator of disjunction operator of equivalent operator of implication operator of negation oppositional reduction (substitution) ordinal numeral paradigm parallel subordination parenthetical clause parenthetical enclosure participle I participle II particle passive voice perfective aspect personal pronoun phasal functor phonological system phrasal verb plural number Pluralia tantum polypredicative construction positive degree possessive the predicate predicative clause predicative construction preposition presupposition pronominal question the proper noun proposition prospective connection pseudo-complex sentence qualitative adjective reciprocal pronoun reciprocal “voice” reflexive pronoun reflexive “voice” reflective categories relative adjective 4 206. 207. 208 . 209. 210. 211. 212. 213. 214. 215. 216. 217. 218. 219. 220. 221. 222. 223. 224. 225. 226. 227. 228. 229. 230. 231. 232. 233 . 234. 235. 236. 237. 238. 239. 240. 241. 242. 243. 244. 245. 246. 247. 248. 249. 250. 251. 252. 253. 254. 255. 256. 257. relative pronoun regular verb relative expression of time retrospective connection rheme root morpheme segregative complex sentence semantic explosion semantics semi-complex sentence semi-composite sentence semi-interrogative question sentence simple adjective simple adverb simple pronoun simple sentence simple verb singular number Singularia tantum speech speech act statal voice stative stative verb structural verb subject clause subjunctive mood subordinate clause subordination substantivized adjective superlative degree supra-sentential construction syndetic connection tense terminative verb text text linguistics theme theoretical grammar transitional element transitive verb transposition two-member sentence uncountable noun universal pronoun unmarked (weak, negative) member utterance variable categories verb voice 5 258. word 259. word-group 260. zero article Questions to prepare for the exam in the discipline “Theoretical Grammar” 1. Grammar in the systematic conception of language. 2. The peculiarities of the grammatical structure of the English language. 3. The grammatical form of the word, the categorical grammatical meaning, the grammatical category, the paradigm, the grammatical opposition. 4. Three main qualitative types of oppositions. The oppositional reduction. The means employed for building up member-forms of categorical opposition. 5. Units of grammar. Morphological units of grammar. 6. Units of grammar. Syntactic units of grammar. 7. Grammatical classes of words. The choice of the term. Three criteria of their discrimination, the definition. 8. The notional and functional words. 9. The syntactico-distributional classification of the words. 10. Verb: general. The classification of the verb. 11. Verb: the category of tense. The category of primary time. 12. Verb: the category of tense. The category of prospective time. 13. Verb: the category of mood. The indicative mood. The imperative mood. 14. Verb: the category of mood. The subjunctive mood. 15. Verb: the category of voice. 16. Verb: the category of aspect. 17. Verb: the perfect forms. 18. The noun, its definition, characteristic traits, subclasses. The category of gender. 19. Noun: the category of number. 20. Noun: the category of case. The theory of the positional cases. The theory of the prepositional cases. 21. Noun: the theory of the limited inflexional system of two cases. The theory of the possessive postposition. The particle expression of the case system in English. 22. The article. The number of articles in English. The definition of the articles. The problem of the zero article. Two types of the use of the noun without an article. 23. Pronoun: general. Morphological composition and categorical characteristics. 24. Pronoun: Subclasses of pronouns and the ir functions. 25. The adjective, its definition. Semantic characteristics of the adjectives. 26. Adjective: morphological composition and morphological characteristics. 27. Adjective: syntactic functions. Comparative constructions with adjectives. 28. The numeral, its definition. Morphological characteristics and composition. Patterns of combinability. Syntactic function. 29. Stative: general. Morphological characteristics and syntactic function. 30. Adverb: morphological composition and morphological characteristics. Semantic characteristics. 31. Adverb: syntactic functions and patterns of combinability. Positional characteristics. 32. Functional words: general. The preposition, its definition, morphological composition and semantic characteristics. Positional characteristics. 33. Functional words: the conjunction and the particle. 34. The sentence. The general characteristic. Structural classification of sentences. Simple Sentence, its system of the members and their hierarchy. 6 35. The three main groupings of the members of the sentence. The traditional parsing presentation. 36. The subject. Its definition and classification, functions in the sentence. Ways of expressing the subject. 37. The predicate. Its definition and classification, functions in the sentence. Ways of expressing the predicate. 38. The object, its definition and classification of its types. Ways of expressing the object. 39. The attribute. Its definition, the position of attributes, types of connection between an attribute and its headword. Ways of expressing the attribute. 40. The adverbial modifier. Its definition and classifications. Ways of expressing the adverbial modifier. 41. Independent parts of the sentence. 42. Two-member and one-member sentences. One-member and elliptical sentences. Two approaches. Types of elliptical sentences. 43. The model of immediate constituents. 44. The composite sentence as polypredicative construction. The sphere of its usage. The classification of composite sentences. The two main types and the means of connection of clauses in a composite sentence. 45. The compound sentence, its characteristic features. The types of coordinate connection. 46. ​​Complex sentence, its definition and composition. The two approaches to the principles of classification of subordinate clauses. Connection of the clauses in a complex sentence. 47. Subordinate clauses of primary nominal positions. 48. Subordinate clauses of secondary nominal positions. 49. Subordinate clauses of adverbial positions. 50. The traditional communicative classification of the sentences. 51. The declarative sentence. 52. The imperative sentence. 53. The interrogative sentence. The system of the interrogative sentence. 54. The exclamatory sentence and its relation to the three communicative types. The purely exclamatory sentence. 55. The classification of the utterances given by Ch. Fries. The main principle of classification. 56. The intermediary predicative constructions. 57. Communicative intentions and “speech acts”. 58. Written and oral variety of the language. The main distinctive features of colloquial speech. Types of colloquial constructions. 59. The actual division of the sentence. Different terms proposed for the main components of the actual division of the sentence. The means of expressing the distinction between the theme and the rheme (given and new information). 60. The communicative properties of sentences in the light of the theory of the actual division of the sentence. 61. Sentence in the text. 62. Text linguistics: grammatical approach. 63. Sentence in a situation. The concept of “Semantic explosion”. Semantic view on the sentence. Semantics of the sentence members. 64.Proposition. Types of predicates. Semantic roles and configurations. 65. Cognitive grammar as a part of cognitive linguistics. The concept of concept. Cognitive theories and grammar. 66. The basic semantics of the sentence and the sense of the utterance. Basic and occasional sense. Types of sense-making operators. Literature: 7 a) basic literature 1. Aleksandrova O.V., Komova T.A. Modern English: morphology and syntax. – M.: Publishing Center “Academy”, 2007. – 224 p. 2. Blokh M.Ya. Theoretical grammar of the English language: textbook. – 4th ed., rev. M.: Higher. school, 2003. – 423 p. 3. Blokh M.Ya. Workshop on theoretical grammar of the English language: textbook. allowance / M.Ya.Blokh, T.N.Semenova, S.V.Timofeeva. – M.: Higher. school, 2004. – 471 p. 4. Kobrina N.A., Boldyrev N.N., Khudyakov A.A. Theoretical grammar of modern English: textbook. allowance. – M.: Higher. school, 2007. – 368 p. 5. Kobrina N.A., Korneeva E.A., Ossovskaya M.I., Guzeeva K.A. English Grammar. Morphology. Syntax: textbook. manual for pedagogical students. institutes and universities in specialty No. 2103 “Foreign languages”. – St. Petersburg: Union, 1999. – 496 p. 6. Lutovinova O.V. Theoretical grammar of modern English: textbook. allowance. – Volgograd: Peremena, 2007. – 76 p. 7. Khudyakov A.A. Theoretical grammar of the English language: textbook. aid for students philologist. fak. and fact. in. language higher textbook establishments / Andrey Aleksandrovich Khudyakov. – 2nd ed., erased. – M.: Publishing Center “Academy”, 2007. – 256 p. b) additional literature 1. Blokh M.Ya. Theoretical foundations of grammar: Textbook. – 2nd ed., rev. – M.: Higher. school, 2000. – 160 p. 2. Grammar of modern English: A textbook for students. higher textbook institutions / O.V. Emelyanova, A.V. Zelenshchikov, E.S. Petrova, etc.; Under. ed. A.V. Zelenshchikova, E.S. Petrova. – St. Petersburg: Faculty of Philology of St. Petersburg State University; M.: Publishing center "Academy", 2003. - 640 p. 3. Gurevich V.V. Theoretical grammar of the English language. Comparative typology of English and Russian languages: textbook. – M.: Flinta, 2003. – 168 p. 4. Ivanova I.P., Burlakova V.V., Pochentsov G.G. Theoretical grammar of modern English: Textbook. – M.: Higher. school, 1981. – 285 p. 5. Ilyish B.A. The structure of modern English. – 2nd ed. – L.: Enlightenment, Leningrad. department, 1971. – 366 p. 6. Iofik L.L., Chakhoyan L.P. Reader on theoretical grammar of the English language. – Ed. 2nd, add. Benefit for faculty students foreign language ped. Inst. – L.: Education, 1972. – 224 p. 7. Karasik V.I. Text linguistics and discourse analysis: Proc. allowance. – Arkhangelsk – Volgograd: Peremena, 1994. – 36 p. 8. Kverk R., Greenbaum S., Leach J., Svartvik J. Grammar of modern English for universities / Ed. I.P.Verkhovskoy. – M.: Higher. school, 1982. – 391 p. 9. Krylova I.P., Gordon E.M. Grammar of modern English: Textbook for institutes and faculties. foreign language – 4th ed., rev. – M.: Book House “University”, 1999. – 448 p. 10. Levitsky Yu.A. Grammar of modern English: A course of lectures. – Perm: Perm Publishing House. University, 1997. – 100 p. 11. Leach D., Svartvik J. Communicative grammar of the English language: A manual for teachers. – M.: Education, 1983. – 304 p. 12. Morokhovskaya E.Ya. Fundamentals of theoretical grammar of the English language. – Kyiv: Vishcha School, 1984. – 288 p. 13. Morokhovskaya E.Ya. Workshop on theoretical grammar. – L.: Education, 1973. – 180 p. 8 14. Khaimovich B.S., Rogovskaya B.I. Theoretical grammar of the English language. – M.: Higher. school, 1967. – 298 p. 15. Khlebnikova I.B. Fundamentals of English morphology: Textbook. manual - M.: Higher. school, 1994. – 125 p. 16. Khudyakov A.A. Theoretical grammar of the English language: Textbook. aid for students Philol. fak. and fact. in. language higher textbook establishments / Andrey Aleksandrovich Khudyakov. – M.: Publishing Center “Academy”, 2005. – 256 p. 17. Stehling D.A. Grammatical semantics English language. The human factor in language: A textbook. – M.: MGIMO, CheRo, 1996. – 254 p. 18. Linguistic encyclopedic dictionary/ ch. ed. V.N. Yartseva. – M.: Sov. encyclopedia, 1990. – 685 p. 19. Textbook on English linguistic terminology / comp. THEM. Deeva, L.H.Isho, A.I.Litvinenko and others - Gorky, 1975. - 404 p. 9

The textbook is a systematic presentation of the main issues of theoretical grammar of the English language and includes lecture texts, accompanied by questions and tasks for self-control, as well as detailed topics of seminar classes, a list of topics for coursework and dissertations on grammar. In addition, the book is equipped with a system of tests that allow students to independently monitor the degree of mastery of the educational material. For students of philological faculties and departments of foreign languages ​​of higher educational institutions.

THE TERM "GRAMMAR".
The term grammar comes from Greek word grammatike, which is a derivative of the word gramma - “letter, writing”. According to the established linguistic tradition, this term is used to refer to: a) the grammatical structure of the language; b) the branch of linguistics that studies this system; c) a textbook containing information about this system. In English, articles are used to mark the differences between these three meanings of the term in question: definite - for the first (the English grammar), the absence of an article - for the second (English grammar), the indefinite - for the third (an English grammar). We are, of course, talking about the non-contextual, non-situational use of articles - in a specific speech situation article determination can be completely different, for example: I didn't like the English grammar you gave me yesterday - it's too thick and difficult.

It should be noted that at a certain period of development linguistic science There was a tendency towards a rather broad interpretation of the term "grammar". Thus, grammar meant not only the grammatical structure of a language, but also its phonetics - it is no coincidence that one of the four volumes of the monograph “Comparative Grammar of the Germanic Languages” is entitled “Phonetics” and is devoted to a description of the phonetic structure and patterns of phonetic correspondences in the ancient Germanic languages. Moreover, in the European tradition, dating back to antiquity, there was often a very broad understanding of grammar as an art, more precisely, the art of eloquence. Occasionally, the term “grammar” is used metaphorically in the meaning of “rule, structure, regularity in general,” for example, in the expression “grammar of thought.”

Download the e-book for free in a convenient format, watch and read:
Download the book Theoretical Grammar of the English Language, Khudyakov A.A., 2005 - fileskachat.com, fast and free download.

• English Grammar, Book for Parents, Grade 4, Barashkova E.A., 2019 - This manual fully complies with the federal state educational standard(second generation) for primary school. It represents the third component educational kit, … Books on English
• English Grammar, Textbook, Barkhudarov L.S., Shteling D.A., 2013 - This textbook outlines a systematic course in English grammar, including morphology and syntax. The course combines normative information with theory... Books on English
• Keynote Intermediate, Workbook, Lansford L., 2016 - Excerpt from the book: MARK BEZOS got a Bachelor of Science (BSc) degree in advertising and public relations from Texas Christian ... Books on English

The following textbooks and books:

• Commercial correspondence and documentation in English, Izrailevich E.E., 1992 - The book provides information on the structure of commercial correspondence, drawing up requests and proposals, execution of contracts in export and import trade, complaints ... Books on English
• Training examples in the English language, Future Simple (Future Indefinite), Federal State Educational Standard, Barashkova E.A., 2015 - The manual fully complies with the federal state educational standard (second generation). The TRAINING EXAMPLES ON ENGLISH GRAMMAR series consists of books: ... Books on English
• Training examples in the English language, Present Continuous (Present Progressive), Federal State Educational Standard, Barashkova E.A., 2015 - The manual fully complies with the federal state educational standard (second generation) for primary school. The series TRAINING EXAMPLES ON ENGLISH GRAMMAR consists of... Books on English
• Self-instructor of the English language, From elementary level to passing tests, Karavanova N.B., 2014 - This Self-instructor of the English language is aimed primarily at Russian-speaking students and is intended for a wide range of people learning English. ... Books on English

Previous articles:

• Workshop on translation from Russian into English, Meshkov O., Lambert M., 1997 - Workshop on translation from Russian into English is a collection parallel texts in Russian and English. In the book... Books on English
• Memo on the English language, Yagudena A., 2015 - Memo on the English language is coffee table book for schoolchildren, applicants, students, as well as for all lovers of the English language. The directory can... Books on English
• The best humorous stories in English, Best Humorous Short Stories, Adaptation using the method of inductive reading, Popovets M., 2016 - In this edition, non-adapted stories by O. Henry, Mark Twain, Stephen Leacock, A. Conan Doyle, Saki and Bret Harte will be able to read ... Books on English
• English in diagrams and tables, 2016 - The book includes all the basic rules of the English language studied in elementary school: Noun, Verb tense, Personal pronouns... Books on English

The structured database query language SQL is a standard in modern programming. Knowledge of it is one of the basic skills that are necessary for any programmer creating programs for any platform. The course examines the SQLite database management system, which is actively used in the development of both desktop and mobile applications.

SQL is widely used in software development desktop computers, mobile phones, web services and many others. You will be able to write a program that will interact with databases. This can be any application for a small business for customer accounting, warehouse, accounting calculations, a program for creating a library, searching and recording absolutely any data. The range of application of databases in programming is unlimited.

After completing the course, you:
Learn to write programs using databases
Learn the most popular SQL language to work with any database
Find out step-by-step methodology custom program development
Learn basic techniques for developing databases for small businesses
Learn the secrets of communicating with customers - how to make sure that they contact you again and again

Course program:
Database Basics
Database Design
SQL language
Data entry
Database normalization
Database deployment
Application development

Name: Database programming in SQLite
Konstantin Sheremetyev
Genre: training video
Language:Russian
Duration: 05:21:04
Format: MP4 (+additional materials)
Video: AVC, 1920x1080, ~512 Kbps
Audio: AAC, 160 Kbps, 48.0 KHz
Size: 1.96 Gb

Attention! If you agree with everything written above, click Download to download this file. These materials are collected in the public domain and on the Internet, and are intended for informational purposes only. All rights to programs, films and other content belong to their authors. The site administration does not bear any responsibility for the further use of these files. If you are a developer software presented on this resource and you believe that the placement of any files violates your copyright, then we will remove links to these files.

Available in formats: EPUB | PDF | FB2

Pages: 368

Year of publication: 2009

The manual is a clearly structured course of theoretical grammar of the English language, corresponding curriculum For language universities. Fundamentally important feature The course is a description of the facts of language from a cognitive perspective as a reflection of human mental activity. The authors are not limited to describing only the systemic norms of the language, but widely use material speech plan, different genres and styles, modifications under the influence of context, etc. For students, graduate students, teachers of higher (pedagogical) educational institutions, as well as a wide range of philologists and linguists.

Reviews

Those who viewed this page were also interested in:

Frequently Asked Questions

1. Which book format should I choose: PDF or FB2?
It all depends on your personal preferences. Today, each of these types of books can be opened both on a computer and on a smartphone or tablet. All books downloaded from our website will open and look the same in any of these formats. If you don’t know what to choose, then choose PDF for reading on a computer, and FB2 for a smartphone.

3. Which program should you use to open the PDF file?
To open PDF file You can use free program Acrobat Reader. It is available for download at adobe.com