Scribd
Upload
4 views1 page

SQL Session

The document discusses SQL as a language used for managing databases, emphasizing the role of Business Analysts as intermediaries between business requirements and technical teams. It outlines the structure of databases, including CRUD operations (Create, Read, Update, Delete) and the distinction between DBMS and RDBMS. Additionally, it mentions the use of SQL Server Management System (SSMS) for creating databases and tables, and highlights 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 discusses SQL as a language used for managing databases, emphasizing the role of Business Analysts as intermediaries between business requirements and technical teams. It outlines the structure of databases, including CRUD operations (Create, Read, Update, Delete) and the distinction between DBMS and RDBMS. Additionally, it mentions the use of SQL Server Management System (SSMS) for creating databases and tables, and highlights 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