Hurry Up! And Get Flat 10% Discount On Your First Order                                   We are available by 24/7 for your support!

RealCode4You

+91 82 67 81 38 69

realcode4you@gmail.com

Order Now
  • Home
  • Services
    • Python Expert Help
    • Java Expert Help
    • Data Science Assignment Help
    • Machine Learning Expert Help
    • C Programming Assignment Help
    • Database Assignment Help
    • PHP Assignment Help
    • SQL Assignment Help
    • Data Structure Assignment Help
    • .Net Assignment Help
    • Android Assignment Help
    • Python Project Help
    • Python Programming Help
    • Python Homework Help
    • JavaFx Assignment Help
    • Spring Boot Assignment Help
    • JSP Servlet Assignment Help
    • Computer Science Assignment Help
  • Web Expert Help
    • Python Web Expert Help
    • Java Web Expert Help
    • PHP Web Expert Help
    • ASP .Net Web Expert Help
    • HTML Project Help
    • Java Script Project Help
    • Python GUI Assignment Help
    • Python Django Assignment Help
    • Python Flask Assignemnt Help
    • Python Tkinter Assignment Help
    • NodeJs Assignment Help
    • Angular Assignment Help
    • React Native Assignment Help
    • ReactJS Assignment Help
  • Machine Learning
    • OpenCV Assignment Help
    • Machine Learning Assignment Help India
    • Deep Learning Assignment Help
    • R Programming Assignment Help
    • Data Mining Assignment Help
    • Matlab Assignment Help
    • Tensorflow Assignment Help
    • Keras Assignment Help
    • Data Visualization Assignment Help
    • Computer Vision Assignment Help
    • Image Processing Assignment Help
    • Data Analysis Assignment Help
    • Big Data Assignment Help
    • Map Reduce Assignment Help
    • PySpark Assignment Help
    • Tableau Assignment Help
    • Power BI Assignment Help
    • NLP Assignment Help
    • Research Paper Assignment Help
    • D3.js Assignment Help
  • Database
    • MySQL Assignment Help
    • SQL Server Assignment Help
    • PostgreSQL Assignment Help
    • MongoDB Assignment Help
    • Oracle Assignment Help
    • MS Access Assignment Help
    • DBMS Assignment Help
    • Neo4j Assignment Help
    • Excel Assignment Help
  • Other Services
    • Mathematics Assignment Help
    • Abstract Algebra Assignment Help
    • Calculus Assignment Help
    • Linear Algebra Assignment Help
    • Discrete Mathematics Assignment Help
    • Trigonometry Assignment help
    • Set Theory Assignment Help
    • Mathematics Homework Help
    • Boolean Algebra Assignment Help
    • Case Study Assignment Help
    • Essay Writing Assignment Help
    • Report Writing Assignment Help
  • Blog
  • Payment
To see this working, head to your live site.
  • Categories
  • All Posts
  • My Posts
realcode4you
May 28, 2020
Edited: May 28, 2020

SQL Tutorial: Part-2 | SQL Assignment Help | SQL Homework Help | Realcode4you

in MySQL

SQL – Check, Default and Index Constraints

Check Contraints

It use as a condition and check the value of columns.


CREATE TABLE employee (
     ID int NOT NULL,
     LastName varchar(255) NOT NULL,
     FirstName varchar(255),
     Age int,
 CONSTRAINT CHK_Employee CHECK (Age>=18)
 );

Defaults Constraints

It used to provide default value for a column.

Example:

Running on My SQL / SQL Server / Oracle / MS Access:


CREATE TABLE employee (
     ID int NOT NULL,
     LastName varchar(255) NOT NULL,
     FirstName varchar(255),
     Age int,
 Address varchar(100) DEFAULT ‘Etah’
 );

Index Constraints

Used to create indexes in tables

It used for speed up data.

Syntax:


CREATE INDEX index_name ON table_name;


SQL – Aggregate function

In this section we will learn about aggregate function.

There are different types of aggregate function which is used in SQL

AVG, COUNT, MAX, MIN, SUM, LTRIM, RTRIM, POWER, ROUND, etc.

AVG:

Returns the average value of ‘n’

Syntax:


Avg([<DISTINCT>|<ALL>] <expr>)

Example:

Table structure with data


CREATE TABLE `employee` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `firstname` varchar(50) DEFAULT NULL,
 `lastname` varchar(50) DEFAULT NULL,
 `salary` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `employee` */
insert into `employee`(`id`,` firstname `, ‘lastname’, `salary`) values (1,'Naveen', ‘kumar’,15000),(2,’jitendra’,’singh’,16000),(3,'sachin',‘pandit’,15000),(4,'adarsh',’kumar’,18000);
 
SELECT AVG(salary) FROM employee;
SELECT count(salary) FROM employee;
SELECT max(salary) FROM employee;
SELECT min(salary) FROM employee;
 SELECT sum(salary) FROM employee;
 

SQL like

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

% - The percent sign represents zero, one, or multiple characters

_ - The underscore represents a single character

· LIKE 'a% - Finds any values that start with "a"

· LIKE '%a' - Finds any values that start with "a"

· LIKE '%or%' - Finds any values that have "or" in any position

· Finds any values that have "r" in the second position

· Finds any values that start with "a" and are at least 3 characters in length

· Finds any values that start with "a" and ends with "o"

Example:


WHERE SALARY LIKE '50%'
WHERE SALARY LIKE '%100%'
WHERE SALARY LIKE '_00%'
WHERE SALARY LIKE '5_%_%' : Finds any values that start with 2 and are at least 3 
characters in length.
WHERE SALARY LIKE '%3'
WHERE SALARY LIKE '_1%2' - Finds any values that have a 2 in the second position and
 end with a 3.
WHERE SALARY LIKE '1___3' : Finds any values in a five-digit number that start with 2 
and end with 3.

SQL Logic Operator

Logic Operator that can be used in SQL –

· AND Operator

· OR Operator

· NOT Operator

AND

Syntax:


Select columnname1, columnname2…column3 from tablename
Where columnname1..columnnameN > 50 AND columnname1..columnnameN < 100 ;

Example:

Select salary from employee where salary >25000 AND salary<30000;

As you can use any remaining OR and NOT operator.

SQL Range Serching – Between, IN and NOT IN

Between

In order to select data within the range of values, the BETWEEN opera