Keep Coding Keep Cheering!
When retrieving data from a single table or by joining data from multiple tables, a condition is specified using the SQL WHERE clause. If the given condition is satisfied, then only it returns a specific value from the table. The WHERE clause should be used to filter the records and only retrieve those that are […]
March 24, 2023 | DBMS | No comments
What is DCL? Data Control Language is known as DCL in SQL. By creating users and granting or removing privileges from users, DCL commands are used to regulate and manage access to the database. There are two main DCL commands in SQL: GRANT REVOKE. GRANT Query: SQL GRANT command is used to grant specific privileges […]
March 23, 2023 | DBMS | No comments
What is TCL? Transactional control commands(TCL) can only be used with DML commands like INSERT, UPDATE, and DELETE. They cannot be used when creating or deleting tables because the database automatically commits these operations. NOTE: Before proceeding with TCL commands, you must know about the DML & DDL commands. COMMIT command: The Commit command is used […]
March 22, 2023 | DBMS | No comments
Insert is a commonly used command in the Structured Query Language (SQL) data manipulation language (DML) used by SQL Server and Oracle relational databases. The insert command inserts one or more rows into a database table with the specified table column values. The insert statement is the first DML command executed immediately after creating a […]
March 16, 2023 | DBMS | No comments
The various DDL commands that are used to redefine the tables will be covered in this tutorial. Truncate Query: TRUNCATE statement is a Data Definition Language (DDL) operation that is used to mark the extent of a table for deallocation (empty for reuse). This method instantly deletes all of the data from a table while […]
March 15, 2023 | DBMS | No comments
The ALTER command is a DDL command that can be used to change the structure of existing tables in the database by adding, modifying, renaming, or removing columns and constraints. Using the ALTER command, you can add columns, rename columns, delete columns, or change the data type of columns. ALTER Command: Syntax Adding a Column: […]
March 14, 2023 | DBMS | No comments
SQL Data Types are an important component of the attributes present in the tables, as well as the queries used to retrieve data from those tables. SQL data types define attributes based on the categories to which they belong. Data types are mainly classified into three categories for every database. String Data types Numeric Data […]
March 12, 2023 | DBMS | No comments
A programming language called SQL (Structured Query Language) was created specifically for managing and modifying relational databases. It offers a common syntax for entering queries and making changes to data in databases. SQL was the first commercial language introduced for E.F Codd’s Relational model of a database. Note: The programming language SQL was created specifically for managing […]
March 12, 2023 | DBMS | No comments
Relational Algebra is a procedural query language, which takes Relation as input and generates relation as output. SQL and relational databases primarily have their theoretical underpinnings in relational algebra. In relational algebra, the input typically consists of a collection of one or more relations, and the output typically consists of another relation that illustrates the […]
February 21, 2023 | DBMS | No comments
This tutorial will teach you what MySQL is, what the prerequisites are for using MySQL in Python, and where you can download and install MySQL and the MySQL Python Connector. What is MySQL? MySQL is an open-source relational database management system (RDBMS) that is based on Structured Query Language (SQL). It is used to store […]
January 27, 2023 | python | No comments