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.

YOU MIGHT ALSO LIKE

Book MySQL Crash Course: A Hands-on Introduction to Database Development
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Course CompTIA Linux+: Storage & File systems
Rating 4.6 of 31 users Rating 4.6 of 31 users (31)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)