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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course CompTIA IT Fundamentals: Database Concepts
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: Database Design Fundamentals
Rating 4.6 of 122 users Rating 4.6 of 122 users (122)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Advanced SQL Queries
Rating 4.6 of 321 users Rating 4.6 of 321 users (321)