STRUCTURED QUERY LANGUAGE(SQL) Created by: B Mokshagna Reddy (BMR) SQL DATA DEFINITION AND DATATYPES SQL Schema: An SQL schema is identified by a schema name and includes an authorization identifier name to indicate user or account who owns the schema, as well as descriptor for each elements in the schema. Schema creation with authorization: CREATE SCHEMA DATABASE_NAME AUTHORIZATION IDENTIFIER; Eg: CREATE SCHEMA COMPANY AUTHORIZATION ‘JSMITH’; Catalog: Named collection of schemas. Data Definition, Constraints, and Schema Changes Used to CREATE, DROP, and ALTER the descriptions of the tables (relations) of a database Creating a Database Syntax: CREATE DATABASE database_name; Creating a Table Syntax CREATE TABLE table_name (Column_name datatype[(size)], Column_name datatype[(size)], ); Specifies a new base relation by giving it a name, and specifying each of...
HTML ELEMENTS
Created by: B Mokshagna Reddy (BMR)
➢An HTML element is defined by a start tag, some content, and an end tag.
➢The HTML element is everything from the start tag to the end tag.
| Start tag | Element Content | Eng tag |
|---|---|---|
| <h1> | Headings | </h1> |
| <p> | Paragraphs | </p> |
| <br> | none | none |
Nested HTML Elements
➢HTML elements can be nested (this means that elements can contain other elements).➢All HTML documents consist of nested HTML elements.
The following example contains four HTML elements (<html>, <body>, <h1> and <p>):
Example
<!DOCTYPE html>
<html>
<body>
<h1>Heading</h1>
<p>Paragraph</p>
</body>
</html>
<html>
<body>
<h1>Heading</h1>
<p>Paragraph</p>
</body>
</html>
Result
Heading
Paragraph
➢Some HTML elements will display correctly, even if you forget the end tag.
Example
<!DOCTYPE html>
<html>
<body>
<h1>Heading
<p>Paragraph
</body>
</html>
<html>
<body>
<h1>Heading
<p>Paragraph
</body>
</html>
Anchor Tag or a Tag
➢HTML links are defined with the <a> tag.➢<a> tag is also called the anchor tag.
➢The most important attribute of the <a> element is the href attribute, which indicates the link's destination.
Example
<a href="https://bmreducation.com/">This is a Link</a>
Result
Bold Tag
➢The <b> tag darks the text.Example
<p>Welcome to <b> BMR EDUCATION</p>
Result
Welcome to BMR EDUCATION
Know More at BMR EDUCATION
Comments
Post a Comment