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 ATTRIBUTES
Created by: B Mokshagna Reddy (BMR)
➢All HTML elements can have attributes.
➢Attributes provide additional information about elements.
➢Attributes are always specified in the start tag.
➢Attributes usually come in name/value pairs like: name="value"
The href Attribute
➢The <a> or anchor tag defines a hyperlink. The href attribute specifies the URL of the page the link goes to:Example
<a href="www.bmreducation.com">This is a Link</a>
Result
The src Attribute
➢The <img> tag is used to embed an image in an HTML page. The <src> attribute specifies the path to the image to be displayed.Example
<img src="BMR_OFFICIAL.gif">
Result
The width and height Attribute
➢The <img> tag should also contain the <height> and <width> attributes, which specify the width and height of the image (in pixels):Example
<img src="BMR_OFFICIAL.gif" width="50" height="50">
Result
The alt Attribute
➢The required <alt> attribute for the <img> tag specifies an alternate text for an image, if the image for some reason cannot be displayed. This can be due to a slow connection, or an error in the src attribute, or if the user uses a screen reader.Example
<img src="BMR_OFFICIAL.gif" alt="BMR EDUCATION LOGO">
Result
The style Attribute
➢The style attribute is used to add styles to an element, such as color, font, size, and more.Example
<p style="color: red;"> This is a red paragraph</p>
Result
This is a red paragraph
The title Attribute
➢The <title> attribute defines some extra information about an element.Example
<p title="Our website Moto"> EDUCATION IS EVERYTHING</p>
Result
EDUCATION IS EVERYTHING
The lang Attribute
➢You should always include the lang attribute inside the <html> tag, to declare the language of the Web page. This is meant to assist search engines and browsers.Example
<!DOCTYPE html>
<html lang="en">
<body>
...
</body>
</html>
<html lang="en">
<body>
...
</body>
</html>
Know More at BMR EDUCATION
Comments
Post a Comment