SQL Tutorial 4: Database Fundamentals, and SQL Language Elements
HTML-код
- Опубликовано: 8 сен 2024
- www.gcreddy.com...
Database Fundamentals, Database Server, Database Objects, Database management systems, Types of DBMS, and Advantages of Relational Database management System. SQL Language Elements, SQL Identifiers, Constants, SQL Data Types, SQL Operators, SQL Functions, SQL Clauses, SQL Queries, and SQL Statements. Install Database Engine, Launch SQL Query Editor, and Write & Execute SQL Commands.
Class Notes:
Database Fundamentals, and SQL Language Elements
---------------------------------------------------------------------------------------
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 and columns)
What is a Database?
• A Database is a systematic collection of data.
• Databases support storage and manipulation of data
• Databases make data management easy.
Table and Record
• A Table in a Relational Database is a predefined format of rows and columns that define an entity.
• Each column contains a different type of attribute and each row corresponds to a single record
• Each Table is provided with a name.
Example: Table name: Students
SID Name Address ContactNo
10001 abcd errtt,ttt 9878787878
10002 xyz fwew,er 8786767676
What is DBMS?
• A Database management System is software designed to assist in maintaining and utilizing large collection of data.
• The alternative to use a DBMS is to store the data in files and write application specific code to manage it.
Using a DBMS to manage data has many advantages:
• Data Independence
• Efficient Data Access
• Data Integrity and security
• Data Administration
• Concurrent Access and 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 as Tables, Views, Columns etc...
2) Data Types:
Define the type of data that is contained by a Column
3) Constants:
Symbols that represent specific data types
4) Operators:
Perform Arithmetic, Comparison, and Logical Operations
5) Functions: Built-in Functions to perform specific operations
6) Clauses:
Constituent components of statements and queries.
7) Expressions:
Produce scalar values, or tables containing of columns and rows of data.
8) Queries:
Retrieve the data based on specific criteria, this an important element of SQL.
9) Statements Etc...
----------------------------------------------------
Create - It is a Command
Create Database gcreddyabc - It is a Statement
Oracle
Create Database gcreddyabc - It create a Database called gcreddyabc in Oracle RDBMS
MS SQL Server
Create Database gcreddyabc - It create a Database called gcreddyabc in MS SQL Server RDBMS
------------------------------------------
Use / Practice SQL
------------------------------------------
SQL is used to communicate with databases, it is the Standard Language for
Relational Database management Systems.
Database Engine is required to use/practice SQL Commands/Queries, we can use any
Database Engine either Oracle, MySQL or MS SQL Server etc...
MS SQL Server:
MS SQL Server is a Commercial Software but Microsoft providing Free Edition also.
Microsoft SQL Server Express Edition
Download and Install MS SQL Server Express Edition
(Windows 7 - MS SQL Server 2014 Express Edition,
Windows 10 - 2014 or 2016 Express Edition)
After Installation, you launch SQL Server management Studio, launch SQL Query editor,
Write SQL statements and Execute.
--------------------------------------------------------
G C Reddy
hello sir..
hiw can i attend your online classes??
Online Classes are paid, but you can watch our videos with free of cost.
sir,
how much for online classes
www.gcreddy.com/2014/12/selenium-online-training.html
Awesome as usual
Welcome...
Thank u so much sir for this wonderful work. pls how many videos do u have in this series of sql tutorial
Very Informative video.
Welcome
thanks again for the video.
Welcome
It is good tutorial sir thanks
Welcome
very useful sir
Hello Mr. Reddy ,
Could you please upload some good exercises on MY Sql Schema
Hello Sir, I'm unable to connect the server, A message pops up saying that the server doesn't exist
Sir, How to write and execute a query in SQL for beginner. Pls help me. I want to learn. I am beginner
Thank you sir...
In which tutorial practical (How to write a query & run)... Please assist..
Welcome
Nice very helpfull
Welcome...
hi sir,,
can we use delete command instead of drop command
is drop and delete command represents the same
Delete is used to delete specific column but not database where
Drop is used to delete database or table
When you will upload practical session of SQL .
Already started, I will post remaining videos soon.
1st Practical Video: SQL Tutorial 5: Data Definition Language
ruclips.net/video/_RP-SbDV0oM/видео.html
ok, thanks
when you will upload other videos
OK, I will upload remaining Practical videos Soon.
sir i need sql complete tutoriial of sql and aricle please sir help me how it can get
Use this PlayList and Class Notes to learn SQL and we have these Tutorials only,
ruclips.net/p/PLyGqUe6Oa_5Hcb_5QqXIsMZhvsm7Bo_-Z
www.gcreddy.com/2016/08/sql-tutorials.html
@@gcreddy it is enough to learn sql. Or we need learn more?
please add notes