my SQL basics--MySQL Tutorial Great Learning

Greatlearning login

1,conception ofDBMS

DBMS(database management system):a software used to store,retrieve,define and manage your data.

2,type

Herarchical DBMS

Network

(widely used) 2D tables,My SQL,Oracle,Mircosoft SQL server;

Relational DBMS

Object Oriented

:security and concurrency,combination of relationship and OOPs concepts,Object DB software

3,Advantages of using a DBMS

4,DBMS VS file system

5,History of DBMS vs RDBMS

6,Keys in RDBMS

primary key;

super key;candidate key(subset of super keys ,so lees than super keys);

alternate key;

composite key;

foreign key

7,Normalization in RDBMS:

1NF

2NF

3NF

Boyce-codd normal form.

5,Types of commands in SQL

DDL

DML

DQL

DCL

TCL

6,More SQL Commands:

filters

operators(where，and,or,not)

pattern matching

null values

7，Types of commands- Demonstration

insert

or and

like

8,Filtering and operators Demonstration

9,Aggregate functions- Demonstration

min,max,specific column,count,

10,Operators and Pattern Matching- demonstration