SQL Tutorial 4: Database Fundamentals
i) Database Fundamentals
ii) SQL Language Elements
-----------------------------------
i) Database Fundamentals
• Database Server instance contains multiple databases
• Database contains multiple Tables
• Table contains multiple records (rows together with columns)
What is a Database?
• Influenza A virus subtype H5N1 Database is a systematic collection of data.
• Databases back upwards storage together with manipulation of data
• Databases brand information management easy.
Table together with Record
• Influenza A virus subtype H5N1 Table inward a Relational Database is a predefined format of rows together with columns that define an entity.
• Each column contains a differnt type of attribute together with each ror coresponds to a unmarried record
• Each Table is provided amongst a name.
Example: Table name: Students
SID Name Address ContactNo
10001 abcd errtt,ttt 9878787878
10002 xyz fwew,er 8786767676
What is DBMS?
• Influenza A virus subtype H5N1 Database management System is software designed to assistance inward maintaining together with utilizing large collection of data.
• The alternative to role a DBMS is to shop the information inward files together with write application specific code to cope it.
Using a DBMS to cope information has many advantages:
• Data Independence
• Efficient Data Access
• Data Integrity together with security
• Data Administration
• Concurrent Access together with Data Recovery
etc...
Types of Database Management System
1) Hierarchical DBMS
2) Network DBMS
3) Relational Database Management System (RDBMS)
Ex: Oracle, MS SQL Server, MySQL, DB2 etc...
------------------------------------------------------
ii) SQL Language Elements
1) Identifiers:
Names of Database Objects such equally Tables, Views, Columns etc...
2) Data Types:
Define the type of information that is contained past times a Column
3) Constants:
Symbols that correspond specific information types
4) Operators:
Perform Arithmetic, Comparison, together with Logical Operations
5) Functions: Built-in Functions to perform specific operations
6) Clauses:
Constituent components of statements together with queries.
7) Expressions:
Produce scalar values, or tables containing of columns together with rows of data.
8) Queries:
Retrieve the information based on specific criteria, this an of import chemical element of SQL.
9) Statements Etc...
---------------
Create - It is a Command
Create Database gcreddyabc - It is a Statement
Oracle
Create Database gcreddyabc - It do a Database called gcreddyabc inward Oracle RDBMS
MS SQL Server
Create Database gcreddyabc - It do a Database called gcreddyabc inward MS SQL Server RDBMS
------------------------------------------
Use / Practice SQL
SQL is used to communicate amongst databases, it is the Standard Language for
Relational Database management Systems.
Database Engine is required to use/practice SQL Commands/Queries, nosotros tin role any
Database Engine either Oracle, MySQL or MS SQL Server etc...
MS SQL Server:
MS SQL Server is a Commercial Software only Microsoft providing Free Edition also.
Microsoft SQL Server Express Edition
Download together with Install MS SQL Server Express Edition
(Windows seven - MS SQL Server 2014 Express Edition,
Windows x - 2014 or 2016 Express Edition)
After In Editor,
Write SQL statements together with Execute.
--------------------------------------------------------
Sumber http://www.gcreddy.com/
i) Database Fundamentals
ii) SQL Language Elements
-----------------------------------
i) Database Fundamentals
• Database Server instance contains multiple databases
• Database contains multiple Tables
• Table contains multiple records (rows together with columns)
What is a Database?
• Influenza A virus subtype H5N1 Database is a systematic collection of data.
• Databases back upwards storage together with manipulation of data
• Databases brand information management easy.
Table together with Record
• Influenza A virus subtype H5N1 Table inward a Relational Database is a predefined format of rows together with columns that define an entity.
• Each column contains a differnt type of attribute together with each ror coresponds to a unmarried record
• Each Table is provided amongst a name.
Example: Table name: Students
SID Name Address ContactNo
10001 abcd errtt,ttt 9878787878
10002 xyz fwew,er 8786767676
What is DBMS?
• Influenza A virus subtype H5N1 Database management System is software designed to assistance inward maintaining together with utilizing large collection of data.
• The alternative to role a DBMS is to shop the information inward files together with write application specific code to cope it.
Using a DBMS to cope information has many advantages:
• Data Independence
• Efficient Data Access
• Data Integrity together with security
• Data Administration
• Concurrent Access together with Data Recovery
etc...
Types of Database Management System
1) Hierarchical DBMS
2) Network DBMS
3) Relational Database Management System (RDBMS)
Ex: Oracle, MS SQL Server, MySQL, DB2 etc...
------------------------------------------------------
ii) SQL Language Elements
1) Identifiers:
Names of Database Objects such equally Tables, Views, Columns etc...
2) Data Types:
Define the type of information that is contained past times a Column
3) Constants:
Symbols that correspond specific information types
4) Operators:
Perform Arithmetic, Comparison, together with Logical Operations
5) Functions: Built-in Functions to perform specific operations
6) Clauses:
Constituent components of statements together with queries.
7) Expressions:
Produce scalar values, or tables containing of columns together with rows of data.
8) Queries:
Retrieve the information based on specific criteria, this an of import chemical element of SQL.
9) Statements Etc...
---------------
Create - It is a Command
Create Database gcreddyabc - It is a Statement
Oracle
Create Database gcreddyabc - It do a Database called gcreddyabc inward Oracle RDBMS
MS SQL Server
Create Database gcreddyabc - It do a Database called gcreddyabc inward MS SQL Server RDBMS
------------------------------------------
Use / Practice SQL
SQL is used to communicate amongst databases, it is the Standard Language for
Relational Database management Systems.
Database Engine is required to use/practice SQL Commands/Queries, nosotros tin role any
Database Engine either Oracle, MySQL or MS SQL Server etc...
MS SQL Server:
MS SQL Server is a Commercial Software only Microsoft providing Free Edition also.
Microsoft SQL Server Express Edition
Download together with Install MS SQL Server Express Edition
(Windows seven - MS SQL Server 2014 Express Edition,
Windows x - 2014 or 2016 Express Edition)
After In Editor,
Write SQL statements together with Execute.
--------------------------------------------------------