Working with SQL Tutorial Videos for Beginner - PowerPoint PPT Presentation

Loading...

PPT – Working with SQL Tutorial Videos for Beginner PowerPoint presentation | free to download - id: 853830-NzkxO



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Working with SQL Tutorial Videos for Beginner

Description:

Our Working with SQL Tutorial Videos for Beginner provides you an indepth knowledge on select statement,insert statement, update statement,delete statement, ORDER BY class, WHERE clause,wildcards use in WHERE clause and sorting results in SQL databases.Also access free online,video, classroom resources on SQL Server 2014. – PowerPoint PPT presentation

Number of Views:58

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com