Archives

Unit-2: Database backup and CSV handling:

Unit-2: Database backup and CSV handling: Unit-2: Database backup and CSV handling: 2.1 SQLite dump : 2.1.1 Dump specific table into file, Dump only table structure 2.1.2 Dump entire database into file 2.1.3 Dump data of one or more tables into a file 2.2 CSV files handling: 2.2.1 Import a CSV file into a table […]

Unit-1: Introduction to SQLite:

Unit-1: Introduction to SQLite: Index 1.1 SQLite advantages, features and Fundamentals: 1.1.1 SQLite datatype : ( Dynamic type, SQLite manifest typing & type affinity) (NULL, INTEGER, REAL, TEXT, BLOB) 1.1.2 Transaction, Rollback, Commit 1.2 Data Filtering and Triggers 1.2.1 Filtering: Distinct, where, between, in, like, Union, intersect, Except, Limit, IS NULL 1.2.2 Having, Group by, […]

Unit-2 : “સત્યાના પ્રયોગ” – લેખક: મહાત્મા ગાંધી

Unit-2 : “સત્યાના પ્રયોગ” – લેખક: મહાત્મા ગાંધી NOTES 🔷 પરિચય (વિગતવાર નોંધ) “સત્યના પ્રયોગો” એ મહાત્મા ગાંધીજી દ્વારા અંગ્રેજી ભાષામાં લખાયેલ આત્મકથા છે, જેનું પૂર્ણ નામ છે:🔹 “The Story of My Experiments with Truth”.તે પછી તેનું ગુજરાતી અનુવાદ રૂપ “સત્યના પ્રયોગો” નામે પ્રસિદ્ધ થયું, જેમાં ગાંધીજીના જીવનના અનેક મહત્વપૂર્ણ તબક્કાઓ અને અનુભવોને હૃદયસ્પર્શી રીતે […]

Querying and SQL Functions

Querying and SQL Functions ASSIGNMENT NOTES 🌐 Relational Data Model – Explained in Detail. The Relational Data Model is a way of organizing data into tables (also called relations). It was introduced by E.F. Codd in 1970 and is widely used in modern database systems like MySQL, PostgreSQL, Oracle, and SQL Server. 🔹 Key Concepts […]

Unit 2: Advanced PHP and File Management

Unit 2: Advanced PHP and File Management ASSIGNMENT NOTES 2.1 File Handling and Directories in PHP Introduction: File handling in PHP allows developers to create, read, write, and manage files and directories on the server. It is essential for storing data persistently, logging activities, managing uploads, and more.