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...
PYTHON INTRODUCTION
Created by: B Mokshagna Reddy (BMR)
INTRODUCTION
➢Created by Guido Van Rossum.➢First released in 1991.
➢Supports object-oriented Programming with classes and multiple inheritance.
➢Comes with large standard library.
➢Includes an IDLE.
➢Runs on Mac OS X, Windows, Linux as Freeware.
FEATURES
Easy to Use:Python is very easy to use and high level language. Thus it is programmer-friendly language.
Expressive Language:
Python language is more expressive. The sense of expressive is the code is easily understandable.
Interpreted Language:
Python is an interpreted language i.e., interpreter executes the code line by line at a time. This makes debugging easy and thus suitale for beginners.
Cross-platform language:
Python can run equally on different platforms such as Windows, Linux, Unix, Macintosh etc.
Thus, Python is a portable language.
Free and open source:
Python language is freely available.
Object-Oriented Language:
Python supports object oriented language. Concepts of classes and objects comes into existence.
Large Standard Library:
Python has a large and board library.
GUI Programming:
GUI can be developed using Python.
Integrated:
It can be easily integrated with languages like C, C++, Java etc.
APPLICATIONS
➢Web Applications
➢Desktop GUI Applications
➢Console-Based Applications
➢Software Development
➢Scientific & Numeric
➢Business Applications
➢Audio or Video-Based Applications
➢3D CAD Applications
➢Enterprise APllications
➢Image Processing Applications
Know More at BMR EDUCATION
Comments
Post a Comment