DATABASES TESTOUT IT FUNDAMENTALS PRO Compare and contrast

DATABASES TESTOUT IT FUNDAMENTALS PRO

Compare and contrast different methods of accessing data from a database. Describe the purpose of basic SQL commands. Interpret simple SQL queries. Answer basic questions about existing Microsoft Access queries. Use Microsoft Access to perform basic queries on a database. TESTOUT IT FUNDAMENTALS PRO

Write SQL commands to do the following: Retrieve all data from a particular table. Retrieve table data that matches certain criteria. Add a new record to an existing table. Delete a record from a table. TESTOUT IT FUNDAMENTALS PRO

Query Direct Access Query Builder User Interface Access Programmatic Access SQL Data Definition Language (DDL) Data Manipulation Language (DML) TESTOUT IT FUNDAMENTALS PRO

Query: A command sent to a database. Queries are most commonly used for CRUD operations (create, read, update, delete). Direct Access: A method of accessing a database directly using the database management system itself. Query Builder: A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database. User Interface Access: A method of accessing a database using forms that allow users to interact with the database. TESTOUT IT FUNDAMENTALS PRO

Programmatic Access: A method of accessing a database using custom computer programs. SQL: A computer language that makes relational databases work. Data Definition Language (DDL): Database commands that change the structure, or schema, of the database. Data Manipulation Language (DML): Database commands that modify the records within the database and not the schema itself. TESTOUT IT FUNDAMENTALS PRO

TESTOUT IT FUNDAMENTALS PRO

Direct access Query builder User interface Programmatic access TESTOUT IT FUNDAMENTALS PRO

TESTOUT IT FUNDAMENTALS PRO

Do the following labs: 7. 4. 5 Microsoft Access Queries 7. 4. 7 Create Queries for a School Database TESTOUT IT FUNDAMENTALS PRO

What kinds of database queries do I already use? What is the relationship between queries and CRUD (Create, Read, Update, Delete)? TESTOUT IT FUNDAMENTALS PRO