Scribd
Upload
4 views1 page

SQL Session

The document outlines the fundamentals of SQL and its role in database management, emphasizing the distinction between various database systems such as DBMS and RDBMS. It describes the process of handling business requirements through a tech team, including CRUD operations for managing data. Additionally, it highlights the use of SQL Server Management System (SSMS) for creating databases and tables, and the importance of primary and foreign keys in relational databases.

Uploaded by

akashket
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

SQL Session

The document outlines the fundamentals of SQL and its role in database management, emphasizing the distinction between various database systems such as DBMS and RDBMS. It describes the process of handling business requirements through a tech team, including CRUD operations for managing data. Additionally, it highlights the use of SQL Server Management System (SSMS) for creating databases and tables, and the importance of primary and foreign keys in relational databases.

Uploaded by

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

SQL SESSION

Structured query language---it is a language not a DATA BASE


BA -middle man
Business req -- Solution req ---- fun and non-fun --tech team---
appl,website
Store the data into various kind of Data bases
Data base is collection of raw data
School --- 1000 students for each class
Ex 1st class --30 per section A,B,C--total 90 students
Books ---- attend , class marks , students details ,complaints
Capstone ---prep 1 part 1 ---one file
folder Prep 1 part 2 ----one file

SQL SERVER MACHINE LEARNING SYSTEM --- SSMS---tool --creating the data
bases and tables
DBMS – DATABASE MANAGEMENT SYSTEM --no relations to files
RDBMS- RELATIONAL DATABASE MANAGEMENT SYSTEM -- relations Primary key
and foreign keys Data base ---deals with large amount data --- server
mysql ,oracle machine

SQL FUNDAMENTALS
CRUD operations
C- create it will create the data bases , tables, records ------ TECH TEAM
R- Read - retrieve data from the database ---- BA --- DATA ANALYST
U- Update--- update the data ------ TECH TEAM
D-delete --- deleting the data ------- TECH TEAM

You might also like