Database Fundamentals: Getting Started with SQL

Database    |    Beginner
  • 12 videos | 55m 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Because a database is only the storage medium, we need to use a different kind of tool in order to work with that stored data. Take this course to learn how to use structured query language (SQL) to manage data in a relational database management system (RDBMS). Perform create, read, update, and delete (CRUD) operations on data using SQL, to make raw data useful. Examine data definition language (DDL) commands that work with database and table objects. Use SQL to add constraints to data in tables, for example, to specify what kind of data gets stored in which column. And explore the repercussions of constraint violation. After completing this course, you will be able to illustrate how SQL can be used within a database to add and secure tables.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Define sql and recognize its connection to the relational database management system (rdbms)
    Use the most common sql commands and discuss their purposes
    List the common reserved words in sql
    Discuss the data types supported by any rdbms
    Identify the more common ddl commands
  • Create and alter tables in a database
    Work with the entire table by using truncate and drop features
    Create tables with constraints and discuss the need for constraints
    Apply constraints on a table and rows
    Examine the consequences of violating a constraint
    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

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book MySQL Crash Course: A Hands-on Introduction to Database Development
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Traditional Data Architectures: Relational Databases
Rating 4.0 of 72 users Rating 4.0 of 72 users (72)
Course MySQL: Getting Started
Rating 4.6 of 363 users Rating 4.6 of 363 users (363)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)