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...
KNOW ABOUT BMR
BMR - B MOKSHAGNA REDDY
This BMR is Founded and developed by B MOKSHAGNA REDDY(BMR). Our main aim is to give the students who are preparing in various fields wants some knowledge. We are here to give you knowledge in every field. Our Moto is "Education is Everything". We Prepare Notes and Related Syllabus for Higher, Seconday and Primary Classes in India. We also Prepare Notes For Comptatative Exams for NEET UG, JEE MAINS, etc.
We believe Education is everything wheather it is in studies, sports, art, everything that starts from scratch to learn and become a successfull person in your life. This website contains all the information to study, read and gain the knowledge. We bought Education Sector to get all the books in each class. And then we bought Coding as it is the major area which everyone should learn and can invent new things. Finally we bought Reference sector to refer books in varous regions Eg: In Comptatative exams, in Animals, In General around the world. We try our best to provide you information in all aspects.
We learn everything whether in EDUCATIOn, Games and More. We will try the best to provide better service from us.
OUR SERVICES
BMR EDUCATIONBMR GAMES
BMR BLOG
OUR TEAM
B MOKSHAGNA REDDYB MANOGNA REDDY
B SUSINDRA REDDY
ABOUT OUR TEAM
We have a well Experience persons who have experienced the pressure and the importance of Education for today's generation. They make the best Content and Notes to you In Every Topic for easy understanding. They are B MANOGNA REDDY who makes notes for Comptatative Exams, and B SUSINDRA REDDY who makes Content for Computer Languages(Coding) like HTML, CSS, etc. We hope that you like our content and notes prepared by us.HELP CENTER
BMR SUPPORTGIVE YOUR REVIEWS
Give your reviews at BMR EDUCATION.only available for a Limited Time
Give your Review about our website here
OUR COMMUNITY
YouTubeLearn with BMR EDUCATION
Comments
Post a Comment