SQL training
sql in 15 sessions
Keys in DBMS and difference between candidate key and composite key.
Second highest salary in sql
Sql part 2
Select command
1.The purpose of this sql command is to retrieve the data from the tables
2.Retrieving all the data from customers table
Syntax:select*from Customers;
3.Retrieving specific column data from customers table
¹.select Customer name from customers;
².select CustomerName,Country,Coty,Postalcode from Customers;
Hi all sql classes are starting interested persons call to no 9701362942
In order to understand sql,we have to first understand different database conceptslike:
Database
DBMS
Data Models
RDBMS
SQL etc
Database concepts:
Databases
The place we can store the related data and later retrieve the data is known as database
DBMS
Software that stores data in databases in an organized way to make it easier to create,retrieve,update etc
Ex :mysql
Data Models
Defines how related data is connected to each other and stored inside the database
RDBMS
DBMS using relational data models are known as rdbms
I will teach you sql basics
I will train you sql basics with examples