INDEX OF Zeek MySQL

Spring Blog Index Page

Basic Concepts of SQL (1-3)

No
Title
Labels
1
Data, DataBase, DataModel Types & Infrastructure
Infrastructure for DATA MODEL Types Of Data Models What is data and database?
2
Concepts of DBMS,RDBMS ,SQL and DBMS vs RDBMS
DBMS vs RDBMS RDBMS and its features and SQL features What is DBMS its benefits
3
SQL Starting(Introduction, Data-Types,Constraints and Command-Groups)
SQL Data Types SQL Constraints SQL | DDL DML DQL DCL and TCL Commands



DDL commands in MySQL (4)

No
Title
Labels
4
DDL commands used in MySQL Workbench
DDL(Data Definition Language) Creating table Deleting the table Adding and Renaming Columns



DML commands in MySQL (5)

No
Title
Labels
5
DML commands used in MySQL WorkBench
DML(Data Manipulation Language) (Inserting/Updating/Deleting) values of data in the Table



Filtering and Agregation (6-8)

No
Title
Labels
6
Filtering Data by using (where , and , or , ! , > , < )
(and . or . ! . > . <) between in WHERE use
7
SQL Aggregation functions
Aggregation Functions( Avg / Count / Max / Min / Sum)
8
Filtering Max or Minimum Salary from each Department(Group By)
Max and Min from respective group Group by



Having Clause- condition on count (9)

No
Title
Labels
9
Having Clause(To put condition on count)
Filter the (Maximum/Minimum) Salary for department whose count is 2 or more than 2



Arranging and Sorting Table (10)

No
Title
Labels
10
Arranging or Sorting the table in Ascending or Descending order(Order by)
Arrange or Sort the table in Ascending or Descending order



Combining Tables in SQL ( 11- 12 )

No
Title
Labels
11
UNION , UNION ALL
UNION- duplicate item becomes distinct UNION ALL - duplicate stays duplicate
12
Combining Two Tables- JOIN ( Inner , Left and Right)
Join (Left / Right / Inner )Join

Comments

Post a Comment

Popular posts from this blog

5 - DML commands used in MySQL WorkBench

Image
DML(Data Manipulation Language)  CREATING A TABLE create table employees( emp_id int not null , first_name varchar ( 20 ) not null , last_name varchar ( 10 ), salary int , primary key (emp_id) ); INSERTING DATA IN TABLE insert into employees(emp_id,first_name,last_name,salary) values ( 1 , 'Zeeshan' , 'Khan' , 50000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 2 , 'Ross' , 'Geller' , 60000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 3 , 'Rachel' , 'Green' , 8000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 4 , 'Joey' , 'Tribbiani' , 99000 ); select * from employees; UPDATING OR CHANGING DATA update employees set last_name= 'Geller' where emp_id= 3 ; select * from employees; DELETING DATA  delete from employees where emp_id= 4 ; select * from employees; OUTPUT GENERATED
Read more

4 - DDL commands used in MySQL Workbench

Image
  I have done following things on MySQL workbench using DDL commands-- 1- Create a table name employee with emp_id , first_name , last_name , salary. 2-Add a column contact. 3- Rename the column contact to job_code. 4-Deleting the table   Create a table name employee with emp_id , first_name , last_name , salary. Table Generated looks like Logical structure of table Add a column contact. Seeing the new table Renaming column contact to job_code Seeing the table Deleting the table
Read more