SQL Selecting, Ordering, & Filtering

SQL Server 2014
  • 9 Videos | 58m 45s
  • Includes Assessment
  • Earns a Badge
Likes 165 Likes 165
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.

WHAT YOU WILL LEARN

  • use the SELECT statement in SQL queries
    use SELECT to retrieve data from more than one table in SQL
    use SQL to create several data types
    use DELETE to remove data from a table in SQL
    use UPDATE to change data in SQL
  • use ORDER BY with results to sort data in SQL
    use WHERE to filter data and retrieve requested results in SQL
    use all data management components in an example in SQL
    describe SQL and the query while demonstrating how to create a table and manipulate it

IN THIS COURSE

  • Playable
    1. 
    SELECT in More Detail
    6m 55s
    UP NEXT
  • Playable
    2. 
    Selecting Data from More Than One Table
    6m 30s
  • Locked
    3. 
    Query Your Data Types in SQL
    4m 38s
  • Locked
    4. 
    Deleting a Record Using a DELETE Query
    4m 42s
  • Locked
    5. 
    Introduction to Using UPDATE
    4m 50s
  • Locked
    6. 
    Ordering Results with ORDER BY
    6m 10s
  • Locked
    7. 
    Filter Results with WHERE Clause
    9m 21s
  • Locked
    8. 
    Use Case Example Using Data Management Components
    7m 14s
  • Locked
    9. 
    Exercise: SQL Main Components and Why They're Used
    4m 56s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 213 Likes 213  
CHANNEL NoSQL
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141  
COURSE SQL Views
Likes 60 Likes 60  
Likes 39 Likes 39