SQL Selecting, Ordering, & Filtering

SQL Server 2014    |    Beginner
  • 9 videos | 55m 15s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 310 users Rating 4.7 of 310 users (310)
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

  • 6m 55s
    Find out how to use the SELECT statement in SQL queries. FREE ACCESS
  • 6m 30s
    In this video, find out how to use the SELECT statement to retrieve data from more than one table in SQL. FREE ACCESS
  • Locked
    3.  Query Your Data Types in SQL
    4m 38s
    In this video, you will learn how to use SQL to create several data types. FREE ACCESS
  • Locked
    4.  Deleting a Record Using a DELETE Query
    4m 42s
    In this video, you will use the DELETE command to remove data from a table in SQL. FREE ACCESS
  • Locked
    5.  Introduction to Using UPDATE
    4m 50s
    In this video, you will learn how to use UPDATE to change data in SQL. FREE ACCESS
  • Locked
    6.  Ordering Results with ORDER BY
    6m 10s
    To sort data in SQL using ORDER BY, first find the results you want, then use ORDER BY to specify how you want them sorted. FREE ACCESS
  • Locked
    7.  Filter Results with WHERE Clause
    9m 21s
    Learn how to use the WHERE clause to filter data and retrieve the requested results in SQL. FREE ACCESS
  • Locked
    8.  Use Case Example Using Data Management Components
    7m 14s
    In this video, learn how to use all data management components in an example using SQL. FREE ACCESS
  • Locked
    9.  Exercise: SQL Main Components and Why They're Used
    4m 56s
    After completing this video, you will be able to describe SQL and the query while demonstrating how to create a table and manipulate it. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Job Ready SQL
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Course Database Fundamentals: Database Concepts
Rating 4.4 of 503 users Rating 4.4 of 503 users (503)
Course SQL Transactions
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)