Scribd
Upload
144 views18 pages

1 Introduction and Installation of SQL

The document is a micro course on SQL, outlining its definition, purpose, and importance in data management. It highlights SQL's universal application across various database systems and its relevance to multiple job roles in the data field. Additionally, it explains the concept of databases and their management through Database Management Software (DBMS).

Uploaded by

itmanarif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
144 views18 pages

1 Introduction and Installation of SQL

The document is a micro course on SQL, outlining its definition, purpose, and importance in data management. It highlights SQL's universal application across various database systems and its relevance to multiple job roles in the data field. Additionally, it explains the concept of databases and their management through Database Management Software (DBMS).

Uploaded by

itmanarif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

30 DAYS SQL MICRO

COURSE
"30 Days, 30 Lessons: Unlock the Power of SQL!"
What is SQL ?
SQL (Structured Query Language) is
a programming language used to
interact with databases. It is the
standard language for querying,
inserting, updating, and managing
data stored in relational databases.
Why we use SQL?
1. Simplifies working with large datasets.

2. Enables easy and efficient data management.

3. SQL is universal and works with most


database systems (like PostgreSQL, MySQL,
SQL Server).
SQL used in following job roles of data field

Business
Analyst
Data SQL
Scientist Developer
Data
Engineer
Data Quality
Analyst Analyst
DATA

✓ Anything & Everything can be considered as data.


✓ Any information or fact can be considered as data.
✓ For any Financial Institute, details related to its employees,
customers, their Services or even their address can be data.
✓ Data can be in any form such as a text message or an image or a
video or a document or single character itself.
What is
Database?
A database is collection of Data that can be easily
access (Digitally)

A software to manage database is called DBMS


(Database Management Software)
SCHOOL DATABASE
BANK DATABASE
Purpose of storing data
in the database is:

• Easily Accessed
• Modified
• Protected
• Analyzed
Table
Structured
RDBMS
Is SQL
Different in
Different
RDBMS?
RDBMS
RDBMS
Click and Run downloaded file

You might also like