In this lesson, you will learn how to create and delete database and database schema. First, you will earn about basic SQL Syntax, including the allowed SQL data types. While this will focus on the Sqlite3 syntax and data types, more general information will be conveyed. Next, you will learn how to create and delete databases. Next you will learn how to create database schema, including relational tables, and the columns that define the characteristics of those tables. This will also include a discussion of views, indices, and user defined functions. Finally, you will learn how to drop and alter existing tables.
###Objectives ### By the end of this lesson, you will be able to:
- Understand how to create and delete databases in SQLite.
- Understand how to create and delete relational database tables by using SQLite.
- Understand the creation and maintenance of relational database schema.
- Understand the difference between relational database tables and views.
Approximately 2 hours.
- Introduction to SQL DML Notebook
- Database and SQL Tutorial: From the SQL-Syntax page through the SQL-Drop Table page.
- SQLite Tutorial: From the SQLite-Syntax page through the SQLite-Drop Table page
- SQL Tutorial
- SQL Online Tutorial
When you have completed and worked through the above readings, please take the Week 12 Lesson 2 Assessment.