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...
C INTRODUCTION
Created by: B Mokshagna Reddy (BMR)
INTRODUCTION
➢C is a general-purpose programming language, developed in 1972, and still quite popular.➢By design, C's features cleanly reflect the capabilities of the targeted CPUs.
➢C is very powerful; it has been used to develop operating systems, databases, applications, etc.
➢C is strongly associated with UNIX, as it was developed to write the UNIX operating system.
Learning C IS BEST
➢It is one of the most popular programming language in the world➢If you know C, you will have no problem learning other popular programming languages such as Java, Python, C++, C#, etc, as the syntax is similar
➢C is very fast, compared to other programming languages, like Java and Python
➢C is very versatile; it can be used in both applications and technologies
START LEARNING C
➢To start using C, you need two things:1. A text editor, like Notepad, to write C code
2. A compiler, like GCC, to translate the C code into a language that the computer will understand
OR
You can compile the C Programming Code in online Compiler.
You can Compile C language on Online Compiler.
Know More at BMR EDUCATION
Comments
Post a Comment