Working with SQL Tutorial Videos for Beginner

1
CATCH EXPERTS
https//www.catchexperts.com
http//www.courseing.com
2
Working with SQL Tutorial Videos for Beginner by
3
Highlights

• SQL Introduction
• Basic SELECT statement
• WHERE clause
• Using wildcards in a WHERE clause
• Sorting results
• With INSERT statements
• With UPDATE statements
• With DELETE statements

4
SQL Introduction

• SQL means Structured Query Language.
• Allows users to access and manipulate databases.
• SQL can execute queries against a database
• SQL can insert, update, delete records and can
  retrieve data from a database.
• SQL can create new databases, new tables, create
  stored procedures, create views in a database.
• Sets permissions on tables, procedures, and
  views.

5
Basic SELECT statement

• Uses to select data from a database.
• Stores retrieved data in result-set named table.
• Syntax SELECT column1, column2, columnN FROM
  table_name or SELECT  FROM table_name
  
• Consider selecting one employee details like id,
  name, salary of a company would be follows as
• Syntax SELECT ID, NAME, SALARY FROM CUSTOMERS

6
WHERE clause

• Extract particular records that fulfill a
  specific principle.
• Filter the results and applies conditions on
  SELECT, INSERT, UPDATE, or DELETE statements.
• Syntax SELECT column_name,column_name FROM tab
  le_name WHERE column_name operator value
• WHERE clause uses various operators to filter the
  results, they are equal, not equal, greater than,
  less than, greater than or equal, less than or
  equal, between, like, in.

7
Using wildcards in a WHERE clause

• SQL supports two wildcard operators with LIKE
  operator. They are percentage(), underscore (_).
• Percentage matches one or more characters.
• Syntax SELECT FROM table_name WHERE column LIKE
  'XXXX or
• SELECT FROM table_name WHERE column LIKE
  'XXXX'
• Underscore (_) matches one character.
• Syntax SELECT FROM table_name WHERE column LIKE
  'XXXX_' or
• SELECT FROM table_name WHERE
  column LIKE '_XXXX_'

8
Sorting results

• ORDER BY clause is used to sort the data
• Sorts either in ascending or descending order,
  based on columns.
• Syntax SELECT column-list FROM table_name WHERE
  condition ORDER BY column1, column2,
  .. columnN ASC DESC
• Sort the results in ascending order by NAME and
  SALARY follows as
• Syntax SELECT FROM CUSTOMERS ORDER BY NAME,
  SALARY
• INSERT  statement is used to add new rows of data
  to a table in the database.

9
Sorting results

• Syntax INSERT INTO TABLE_NAME (column1, column2,
  column3,...columnN) VALUES (value1, value2,
  value3,...valueN)
• UPDATE Query is used to modify the existing
  records in a table.
• Syntax UPDATE table_name SET column1 value1,
  column2 value2...., columnN valueN WHERE
  condition
• DELETE Query is used to delete the existing
  records from a table.
• Syntax DELETE FROM table_name WHERE condition

10
Feedback
Like It ? Hate It?
We would love to hear from you whatever you think
about the course.
Click HERE to share what you think!
11
Thank you
Thank You for Watching Working with SQL Tutorial
Videos for Beginner by
http//www.courseing.com