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...
CSS SELECTORS
Created by: B Mokshagna Reddy (BMR)
CSS Selectors
➢CSS selectors are used to "find" (or select) the HTML elements you want to style.➢We can divide CSS selectors into five categories:
➢Simple selectors (select elements based on name, id, class)
➢Combinator selectors (select elements based on a specific relationship between them)
➢Pseudo-class selectors (select elements based on a certain state)
➢Pseudo-elements selectors (select and style a part of an element)
➢Attribute selectors (select elements based on an attribute or attribute value)
The CSS Element Selectors
➢The element selector selects HTML elements based on the element name.Example
p {font-size: 10px;color:red; }
The CSS id Selectors
➢The id selector uses the id attribute of an HTML element to select a specific element.➢The id of an element is unique within a page, so the id selector is used to select one unique element!
➢To select an element with a specific id, write a hash (#) character, followed by the id of the element.
Example
#demo {font-size: 10px;color:red; }
The CSS class Selectors
➢The class selector selects HTML elements with a specific class attribute.➢To select elements with a specific class, write a period (.) character, followed by the class name.
Example
.demo {font-size: 10px;color:red; }
➢You can also specify that only specific HTML elements should be affected by a class.Example
* {text-align: center;color:green; }
The CSS Universal Selector➢The universal selector (*) selects all HTML elements on the page.
Example
* {text-align: center;color:green; }
The CSS Grouping Selector
➢The universal selector (*) selects all HTML elements on the page.Example
body {background-color: red; }
h1 {color: orange; }
p {border: 2px solid green; }
h1 {color: orange; }
p {border: 2px solid green; }
Example
h1, h2,p {background-color: red; }
Know More at BMR EDUCATION
Comments
Post a Comment