| Translate user stories to SQL statements using (SELECT, FROM, WHERE, ORDER BY, DISTINCT, LIKE, BETWEEN, IN, JOIN, GROUP BY, HAVING, sub-queries, ANY, ALL, UNION) |
SQL statements allow users to interact with a database to retrieve and manipulate data. Common clauses include SELECT (to specify columns), FROM (to identify the table), WHERE (to filter results), ORDER BY (to sort data). |
View |
Edit |
Delete
|
| Anomalies, functional dependencies, normalization, normal forms, and conversion to BCNF |
Process of organizing data in a relational database to reduce redundancy and improve data integrity. It involves dividing a database into tables and establishing relationships between them, typically following normal forms like 1NF, 2NF, and 3NF to ensure each table stores data about a single concept. |
View |
Edit |
Delete
|
| Access control: DAC, MAC, RBAC, ABAC |
Security measure that determines who can view or use resources within a database. It involves defining roles and permissions to regulate user access to data and operations based on their identity and role in the organization. |
View |
Edit |
Delete
|
| Model data using tables, rows, columns, keys |
Organizing data in a relational database. Tables store data in a structured format with rows representing individual records, columns representing attributes, and keys (such as primary and foreign keys) ensuring data integrity and establishing relationships between tables. |
View |
Edit |
Delete
|
| User stories and business requirements |
Tools for capturing what a software system should do. User stories describe features from the end user's perspective, focusing on their needs, while business requirements outline the high-level objectives and functionalities the system must fulfill to meet organizational goals. |
View |
Edit |
Delete
|
| SQL procedural language |
Extends standard SQL with procedural programming capabilities, allowing for complex logic and control flow within the database. It includes constructs like loops, conditional statements, variables, and procedures (e.g., stored procedures and functions), enabling more advanced operations directly within the database. Examples include PL/SQL for Oracle and T-SQL for SQL Server. |
View |
Edit |
Delete
|
| Functions and triggers |
Mechanisms in databases for automating tasks. Functions are reusable SQL routines that perform calculations or return a value, often used to encapsulate complex logic. Triggers are special types of stored procedures that automatically execute in response to specific events (e.g., insert, update, delete) on a table, ensuring data integrity or enforcing business rules. |
View |
Edit |
Delete
|
| Conceptual, logical models, and physical models; Transform a conceptual model to a logical model and a logical model to a physical model |
Stages of database design. A conceptual model outlines high-level entities and relationships without technical details, a logical model refines this into a more detailed structure with attributes and keys, and a physical model specifies how the database will be implemented in a specific database management system, including tables, columns, and data types. |
View |
Edit |
Delete
|
| Identify potential for and prevent SQL injections |
Recognizing vulnerabilities in applications that allow malicious users to manipulate SQL queries. |
View |
Edit |
Delete
|
| Views and authorization |
A view is a virtual table created by a query that simplifies data retrieval and enhances security by restricting access to specific data. Authorization involves defining user permissions and roles to control who can access, modify, or perform operations on the database, ensuring that sensitive information is protected and compliance with security policies is maintained. |
View |
Edit |
Delete
|
| Relations, tuples, and fields |
Fundamental concepts in relational databases. A relation is a table, a tuple is a row within that table representing a single record, and a field is a column that represents an attribute of the data stored in the relation. |
View |
Edit |
Delete
|
| Integrity, entity, referential and check constraints |
Rules that ensure the accuracy and consistency of data in a database. |
View |
Edit |
Delete
|
| Data visualization |
Graphical representation of data and information, designed to help users understand complex data sets through visual means. It utilizes visual elements like charts, graphs, maps, and dashboards to convey patterns, trends, and insights effectively. |
View |
Edit |
Delete
|
| Descriptive statistics |
Statistical techniques used to summarize and describe the main features of a data set. They provide a way to present quantitative descriptions in a manageable form, allowing for easier interpretation of the data. |
View |
Edit |
Delete
|
| Relational Algebra |
Formal system for manipulating and querying relational databases. It provides a set of operations that take one or more relations (tables) as input and produce a new relation as output. |
View |
Edit |
Delete
|
| Test Knowledge Element |
This is a test element |
View |
Edit |
Delete
|