Database Fundamentals: Getting Started with SQL
Database | Beginner
- 12 videos | 55m 58s
- Includes Assessment
- Earns a Badge
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 coursedefine SQL and recognize its connection to the relational database management system (RDBMS)use the most common SQL commands and discuss their purposeslist the common reserved words in SQLdiscuss the data types supported by any RDBMSidentify the more common DDL commands
create and alter tables in a databasework with the entire table by using truncate and drop featurescreate tables with constraints and discuss the need for constraintsapply constraints on a table and rowsexamine the consequences of violating a constraintsummarize 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
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course MySQL: Getting Started