Database Fundamentals: Working with SQL Commands

Database    |    Beginner
  • 12 videos | 48m 55s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 212 users Rating 4.7 of 212 users (212)
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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Rating 4.6 of 274 users Rating 4.6 of 274 users (274)
Rating 4.5 of 6258 users Rating 4.5 of 6258 users (6258)