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...
Get our Latest Coding Arctices From BMR BLOG
Search More on our Coding Articles and Notes Here
HTML Articles
2. HTML BASIC TAGS - Article Here
3. HTML ELEMENTS - Article Here
4. HTMl QUOTATIONS - Article Here
5. HTML ATTRIBUTES - Article Here
Get all additional HTML Course Content at - BMR EDUCATION
CSS Articles
2. CSS Selectors - Article Here
Get all additional CSS Course Content at - BMR EDUCATION
JavaScript Articles
Get all additional JavaScript Course Content at - BMR EDUCATION
Python Articles
Get all additional Python Course Content at - BMR EDUCATION
C Articles
Get all additional C Course Content at - BMR EDUCATION
Search More on our Coding Articles and Notes Here
Search More on our Coding Articles and Notes Here
HTML Articles
Topics Included
1. HTML INTRODUCTION - Article Here2. HTML BASIC TAGS - Article Here
3. HTML ELEMENTS - Article Here
4. HTMl QUOTATIONS - Article Here
5. HTML ATTRIBUTES - Article Here
Get all additional HTML Course Content at - BMR EDUCATION
CSS Articles
Topics Included
1. CSS INTRODUCTION - Article Here2. CSS Selectors - Article Here
Get all additional CSS Course Content at - BMR EDUCATION
JavaScript Articles
Topics Included
No Acticles Included at BMR BLOGGet all additional JavaScript Course Content at - BMR EDUCATION
Python Articles
Topics Included
1. Python INTRODUCTION - Article HereGet all additional Python Course Content at - BMR EDUCATION
C Articles
Topics Included
1. C INTRODUCTION - Article HereGet all additional C Course Content at - BMR EDUCATION
Search More on our Coding Articles and Notes Here
Comments
Post a Comment