Saturday, February 10, 2024
Saturday, November 18, 2023
HTML 5 BASICS
HTML 5
BASIC STRUCTURE OF HTML
<!DOCTYPE html>
<html>
<head>
<meta
charset="UTF-8">
<title>Title
of the Document</title>
</head>
<body>
<!-- Content of
the webpage goes here -->
<h1>Heading 1</h1>
<p>This is a
paragraph.</p>
<img src="image.jpg" alt="Description of the image">
<a href="https://www.example.com">Link to example website</a>
<script
src="script.js"></script>
</body>
</html>
Here's a breakdown of the different parts
<html>: The root element of an HTML page.
<head>: Contains metadata about the HTML document,
such as the character encoding and the title of the page.
<meta charset="UTF-8">: Specifies the
character encoding for the document, typically set to UTF-8.
<title>: Defines the title of the document, which
appears in the browser's title bar or tab.
<body>: Contains the visible content of the webpage.
<h1>: Defines a heading level 1.
<p>: Defines a paragraph.
<img>: Inserts an image into the document, with the
source (src) attribute specifying the image file and the alt attribute
providing alternative text for accessibility.
<a>: Creates a hyperlink, with the href attribute
specifying the URL of the link.
<script src="script.js"></script>:
Includes an external JavaScript file named "script.js" into the HTML
document.
RELATIONAL DATABASE MANAGEMENT SYSTEM - SQL COMMANDS
SQL COMMANDS
- SQL stands for Structured Query Language. It is used for storing and managing data in Relational
- Database Management System (RDBMS).
- It is a standard language for Relational Database System.
- It enables a user to create, read, update and delete relational databases and tables.
- All the RDBMS like MySQL, Informix, Oracle, MS Access and SQL Server use SQL as their standard database language.
- SQL allows users to query the database in a number of ways, using English-like statements
Types of SQL Commands
There are five types of SQL commands: DDL, DML, DCL, TCL, and DQL.
Data Definition Language (DDL):
CREATE: Creates a new database, table, or index.
ALTER: Modifies the structure of an existing table or
database.
DROP: Deletes an existing database, table, or index.
TRUNCATE: Deletes all data from a table.
Data Manipulation Language (DML):
SELECT: Retrieves data from one or more tables.
INSERT: Inserts new data into a table.
UPDATE: Modifies existing data in a table.
DELETE: Deletes data from a table.
Data Control Language (DCL):
GRANT: Provides privileges to users or roles.
REVOKE: Removes privileges from users or roles.
Transaction Control Language (TCL):
COMMIT: Saves all changes made in the current transaction.
ROLLBACK: Discards all changes made in the current
transaction.
SAVEPOINT: Sets a savepoint within the transaction.
Data Query Language (DQL):
JOIN: Combines rows from two or more tables.
GROUP BY: Groups rows based on a column's values.
HAVING: Filters grouped rows based on conditions.
ORDER BY: Sorts rows in the result set.
Data Definition Language (DDL):
CREATE: Creates a new database, table, or index.
ALTER: Modifies the structure of an existing table or
database.
DROP: Deletes an existing database, table, or index.
TRUNCATE: Deletes all data from a table.
Data Manipulation Language (DML):
SELECT: Retrieves data from one or more tables.
INSERT: Inserts new data into a table.
UPDATE: Modifies existing data in a table.
DELETE: Deletes data from a table.
Data Control Language (DCL):
GRANT: Provides privileges to users or roles.
REVOKE: Removes privileges from users or roles.
Transaction Control Language (TCL):
COMMIT: Saves all changes made in the current transaction.
ROLLBACK: Discards all changes made in the current
transaction.
SAVEPOINT: Sets a savepoint within the transaction.
Data Query Language (DQL):
JOIN: Combines rows from two or more tables.
GROUP BY: Groups rows based on a column's values.
HAVING: Filters grouped rows based on conditions.
ORDER BY: Sorts rows in the result set.
Subscribe to:
Posts (Atom)
Introduction to Stack Data Structure
