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...
FULL SQUADS OF TATA IPL 2023 Created by: B Mokshagna Reddy (BMR) CSK - Chennai Super Kings Squad Size: 25 MS Dhoni (c), Devon Conway, Ruturaj Gaikwad, Ambati Rayudu, Subhranshu Senapati, Moeen Ali, Shivam Dube, Rajvardhan Hangargekar, Dwaine Pretorius, Mitchell Santner, Ravindra Jadeja, Tushar Deshpande, Mukesh Chowdhary, Matheesha Pathirana, Simarjeet Singh, Deepak Chahar, Prashant Solanki, Maheesh Theekshana, Bhagath Varma, Ajay Mandal, Kyle Jamieson , Nishant Sindhu, Shaik Rasheed, Ben Stokes, Ajinkya Rahane. RCB - Royal Challengers Bangalore Squad Size: 25 Faf du Plessis (c), Virat Kohli, Suyash Prabhudessai, Rajat Patidar, Dinesh Karthik, Anuj Rawat, Finn Allen, Glenn Maxwell, Wanindu Hasaranga, Shahbaz Ahmed, Harshal Patel, David Willey, Karn Sharma, Mahipal Lomror, Mohammed Siraj, Josh Hazlewood, Siddarth Kaul, Akash Deep, Sonu Yadav, Avinash Singh, Rajan Kumar, Manoj Bhandage, Will Ja...