Lesson 1.3 Managing Databases
Learn the essential SQL commands used to manage databases within a MySQL instance. This lesson covers how CREATE DATABASE and DROP DATABASE are used to add or remove entire databases, including all their tables. You’ll also see how the USE statement selects a default database for queries, and how SHOW commands—like SHOW DATABASES, SHOW TABLES, and SHOW COLUMNS—help you explore system structure and metadata. A practical introduction to database administration basics.