9.12 Database Management (SQL)
This lesson focuses on managing and manipulating data in a database using SQL statements integrated within programming languages like Python. Students learn how to establish database connections and perform core operations such as retrieving, adding, modifying, and deleting database records securely using validations.
ප්රධාන සංකල්ප
- Database Connection (දත්ත සමුදාය සම්බන්ධතාව)
- The mechanism established by a programming language (like Python) to connect to, open, and communicate with a database system.
- Data Retrieval (දත්ත සමුද්ධරණය)
- The process of searching and fetching specific records from a database table using SQL commands.
- SQL Manipulation Commands (SQL විධාන)
- SQL commands integrated into external program code to perform database actions such as inserting (adding), updating (modifying), and deleting records.
- Data Validation (වලංගුතා ඇතුළත් කිරීම)
- The process of verifying data inputs through an interface program before sending it to the database to ensure accuracy and consistency.
MCQ කට්ටල
MCQ 12විභාගයේදී
- Writing Python code snippets to establish a database connection.
- Drafting integrated SQL queries (INSERT, SELECT, UPDATE, DELETE) inside application scripts.
- Explaining validation concepts before writing to databases in structured paper questions.
