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...
BMR COINS Created by: B Mokshagna Reddy (BMR) 1. REFERRING A FRIEND - 30 Per Referral: Get 30 Per Referral for a existing user. The Coins will be instantly Credited into your BMR EDUCATION account after the new user verifies your account. To avail this option you to register by entering the refferal code of your friend's BMR EDUCATION account. For new registration using referal code can also get 15 BMR COINS. 2. PAGE VIEWS - 1 Per Page View: Get 1 Per Page View The Coins will be instantly Credited into your BMR EDUCATION account after the user views the pages of BMR EDUCAION Website. To avail this option the user needs to login into their BMR EDUCATION account. 3. SHARING - 5 Per Sharing: Get 5 Per Sharing on Social media accounts. The Coins will be instantly Credited into your BMR EDUCATION account after the user share on Social media accounts. You can share only on facebook and Twit...