Working with SQL Training Videos for Beginner - PowerPoint PPT Presentation

About This Presentation
Title:

Working with SQL Training Videos for Beginner

Description:

learn SQL basic concepts and select statement,insert statement,update statement,delete statement, ORDER BY class, WHERE clause,wildcards use in WHERE clause and sorting results in SQL databases through courseing Working with SQL Training Videos for Beginner – PowerPoint PPT presentation

Number of Views:83

less

Transcript and Presenter's Notes

Title: Working with SQL Training Videos for Beginner


1
Working with SQL Training Videos for Beginner by
2
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

3
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.

4
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

5
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.

6
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_'

7
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.

8
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

9
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!
10
Thank you
Thank You for Watching Working with SQL Training
Videos for Beginner by
http//www.courseing.com
Write a Comment
User Comments (0)
About PowerShow.com