I will help you in sql query that used in ms sql server, mysql, oracle and mongodb

Hi I'm professional Database Administrator and currently working as Backend Developer in a company. I have 5 years of experience in multiple databases such as:

1. Microsoft SQL Server
2. Oracle Database
3. SQLite
4. MariaDB
5. Microsoft Access
6. MySQL Database
7. MangoDB

I have brief knowledge of both Databases SQL and NoSQL. I have good knowledge of terminologies use in Database Management System e.g.

1. Database and Schemas.
2. ER Diagram, Class Diagram and Data Flow modeling
3. Rational databases (SQL) and NoSQL (key value pair form of data)
4. Table, rows, attributes and tuples
5. Normalization i.e. 1st Normal form, 2nd Normal form, 3rd Normal form and 4th Normal form
6. Primary Key and Foreign Key
7. Views and Triggers
8. Store Procedure and its parameters

I have good hand-on experience in SQL Queries which includes following concepts:

• SELECT, INSERT, UPDATE and DELETE
• IN, ON, HAVING, ORDER BY and GROUP BY
• Joining of tables i.e. LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN and how to use self JOIN ?
• Aggregate Function
• Subqueries and how to use multiple subqueries together?
• DECLARE variable, functions with parameters, conditions and Switch Case in SQL