Administer

Table Creation and modification

Create a Table with SQL: learn how to create tables with SQL. Learn about column types.

Create a Table with SQL- Quiz: test your understanding of the article “Create a table”.

SQL ALTER TABLE: learn how to add or modify a column, how to change the table name.

SQL ALTER TABLE – Quiz: test your understanding of the article “Modify a table”.

Database Administration Commands

Database administration with SQL : learn the syntax of actions related to database administration. Learn how to grant or revoke rights, create or delete a user, modify a password.

Database administration with SQL – Quiz: test your understanding of the article “Database administration with SQL”.

Indexes and Keys

Index, Unique Key, Primary Key: understand indexes, unique keys and primary keys. Learn how to create them and what are their differences.

Index, Unique Key, Primary Key – Quiz
: test your understanding of the article “Index, Unique Key, Primary Key”.

Foreign Key: understand foreign keys and how to add them. Understand the “on delete cascade” statement.

Foreign Key – Quiz: test your understanding of the article “Foreign Key”.

 
Share on: