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 BASIC TAGS
Created by: B Mokshagna Reddy (BMR)
➢All HTML documents must start with a document type declaration: <!DOCTYPE html>.
➢The HTML document itself begins with <html> and ends with </html>.
➢The visible part of the HTML document is between <body> and </body>.
HTML Headings
➢HTML headings are defined with the <h1> to <h6> tags.➢<h1> defines the most important heading. <h6> defines the least important heading:
➢Font-size decreases from <h1> to <h6>
Example
<h1>Heading 1</h1>
<h2>Heading 2</h2>
<h3>Heading 3</h3>
<h4>Heading 4</h4>
<h5>Heading 5</h5>
<h6>Heading 6</h6>
<h2>Heading 2</h2>
<h3>Heading 3</h3>
<h4>Heading 4</h4>
<h5>Heading 5</h5>
<h6>Heading 6</h6>
Result
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
HTML Paragraphs
➢HTML paragraphs are defined with the <p> tag:Example
<p> BMR EDUCATION is offering HTML Course </p>
Result
BMR EDUCATION is offering HTML Course
HTML Horizontal Rules
➢The <hr> tag defines a thematic break in an HTML page, and is most often displayed as a horizontal rule.Example
<p>BMR EDUCATION is offering <hr> HTML Course</p>
Result
BMR EDUCATION is offering
HTML Course
HTML Course
HTML Line Breaks
➢The HTML <br> element defines a line break.Example
<p>BMR EDUCATION is offering <br> HTML Course</p>
Result
BMR EDUCATION is offering
HTML Course
HTML <pre> Element
➢The HTML <pre> element defines preformatted text. ➢The text inside a <pre> element is displayed in a fixed-width font (usually Courier), and it preserves both spaces and line breaks.Example
<pre>
BMR EDUCATION
is offering
HTML Coursebr> </pre>
BMR EDUCATION
is offering
HTML Coursebr> </pre>
Result
BMR EDUCATION is offering HTML Course
Know More at BMR EDUCATION
Comments
Post a Comment