SQL Intermediate: Data Manipulation & Database Creation Using SQL
Issued by
University of California, Irvine
Earners of this badge have completed a course of study focused on intermediate level skills using SQL (Structured Query Language). Utilizing the intermediate components of SQL, the earner understands how to develop a new database using SQL, load external data into a newly created database, and apply DML and DDL for data manipulation techniques. They are also able to create an Entity Relationship Diagram (ERD) to outline relationships within a database structure.
Skills
- SQL Intermediate: Data Manipulation & Database Creation Using SQL
Earning Criteria
-
Demonstrate correct application of DML (Data Manipulation Language) and DDL (Data Definition Language) to insert, update, and delete data within multiple databases
-
Create an Entity Relationship Diagram (ERD) for a new SQL database that includes all table and column names and provides clear and concise relationships between each database structure
-
Outline, develop, and create a new SQL database with proper table relationships, columns, and correct database scripts
-
Appropriately modify datatypes within a newly created SQL database for practical and appropriate use of data within each column
-
Apply DML and DDL to import external data into a newly created database using SQL