Create a Database in SQL
Explore this section to get hands on all the cheat sheet that help you in order to create a database in SQL.
1. CREATE DATABASE: Create a New Database
CREATE DATABASE company;
This command creates a new database named “company.”
2. USE: Select a Specific Database to Work With
USE company;
This command selects the database named “company” for further operations.
3. ALTER DATABASE: Modify a Database’s Attributes
ALTER DATABASE database_name
4. DROP DATABASE: Delete an Existing Database
DROP DATABASE company;
This command deletes the database named “company” and all its associated data.
SQL Cheat Sheet
In this article, we will explore the ultimate SQL cheat sheet with the PDF, covering a wide range of SQL commands, Joins in SQL, CRUD Operations, SQL Trigger, SQL Transactions, and advanced topics to help master SQL effectively.
SQL (Structured Query Language) is a Query language used for managing and manipulating relational databases databases. It allows users to interact with databases. SQL allows users to perform various tasks such as querying data, updating data, inserting new records, deleting records, creating and modifying database schemas, and managing permissions.
Table of Content
- Create a Database in SQL
- Creating Data in SQL
- Reading/Querying Data in SQL
- Updating/Manipulating Data in SQL
- Deleting Data in SQL
- Filtering Data in SQL
- SQL Operator
- Aggregation Data in SQL
- Constraints in SQL
- Joins in SQL
- SQL Functions
- Subqueries in SQL
- Views in SQL
- Indexes in SQL
- Transactions in SQL
- Advanced Mixed Data in SQL
- SQL Cheat Sheet PDF
Contact Us