1. Introduction to SQL | What is SQL? | What is table? | Data types in sql | Oracle SQL
Introduction to SQL | What is SQL? | What is table? | Data types in sql | Oracle SQL
Join SQL WhatsApp group to solve your SQL queries:
https://chat.whatsapp.com/EkcHb9rAaP1...
What is SQL?
SQL stands for Structured Query Language.
SQL is a standard language for accessing and manipulating databases.
SQL queries help us to perform operation on database like inserting data into database or fetching data from database etc.
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
Database Tables, What is table?
Tables are database objects that contain all the data in a database.
In tables, data is logically organized in a row-and-column format similar to a spreadsheet.
Each row represents a unique record, and each column represents a field in the record.
A database most often contains one or more tables.
Each table is identified by a name (e.g. "Customers" or "Orders").
Data types in SQL
Character Datatypes
CHAR
NCHAR
VARCHAR
VARCHAR2
LONG
Numeric Datatypes
NUMBER
NUMBER(,)
Date/Time Datatypes
DATE
Large Object (LOB) Datatypes
bfile
blob
clob
nclob
Join SQL WhatsApp group to solve your SQL queries:
https://chat.whatsapp.com/EkcHb9rAaP1...
Join this channel to get access to perks:
/ @foxtechacademy
📌 Follow us on Instagram :
🔗 / aeron_zafar
🔗 / foxtechacademy
Thanks :
Fox Tech Academy
Instagram : / foxtechacademy
Facebook : / foxtechacademy
Telegram : https://t.me/codingPrep2020
Telegram : https://t.me/fox_the_sharp
Email : [email protected]
WhatsApp : +91 8252348796
#tcs #accenture #infosys #techmahindra #interview