Database Fundamentals: Working with SQL Commands

Database    |    Beginner
  • 12 Videos | 48m 55s
  • Includes Assessment
  • Earns a Badge
The data stored in a database can be used in a variety of ways. Take this course to explore the power of the database as a tool for storing, manipulating, and retrieving data. Use data definition language (DDL) commands to clarify structures like schema, database, and tables. Learn the most important data manipulation language (DML) commands and execute a data query language (DQL) statement. Finally, explore how tables can be combined via joins and subqueries, producing new information from existing data. Upon completion, you will be comfortable using basic commands to set up and work with databases.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    list and define data control language (DCL) commands with syntax and example
    list the most important data manipulation language (DML) commands
    perform a bulk insert
    define and discuss data query language (DQL)
    use the most common DQL commands
  • filter and sort data in a table
    use a table to perform grouping and aggregation
    build a subquery by joining tables
    use various join types on a database
    compare and contrast joins and subqueries
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 36s
    UP NEXT
  • Playable
    2. 
    Data Control Language (DCL) Commands
    3m 56s
  • Locked
    3. 
    Data Manipulation Language (DML)
    4m 15s
  • Locked
    4. 
    Inserting Multiple Records
    3m 24s
  • Locked
    5. 
    Data Query Language (DQL)
    3m 35s
  • Locked
    6. 
    Executing a DQL Statement
    4m 30s
  • Locked
    7. 
    Filtering and Sorting Data
    5m 44s
  • Locked
    8. 
    Aggregating and Grouping Data
    5m 31s
  • Locked
    9. 
    Creating Subqueries
    4m 22s
  • Locked
    10. 
    Using Different Join Types
    5m 6s
  • Locked
    11. 
    Joins vs. Subqueries
    3m 47s
  • Locked
    12. 
    Course Summary
    3m 9s

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.