Database Fundamentals: Working with SQL Commands
Database
| Beginner
- 12 videos | 48m 55s
- Includes Assessment
- Earns a Badge
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 courseList and define data control language (dcl) commands with syntax and exampleList the most important data manipulation language (dml) commandsPerform a bulk insertDefine and discuss data query language (dql)Use the most common dql commands
-
Filter and sort data in a tableUse a table to perform grouping and aggregationBuild a subquery by joining tablesUse various join types on a databaseCompare and contrast joins and subqueriesSummarize the key concepts covered in this course
IN THIS COURSE
-
1m 36s
-
3m 56s
-
4m 15s
-
3m 24s
-
3m 35s
-
4m 30s
-
5m 44s
-
5m 31s
-
4m 22s
-
5m 6s
-
3m 47s
-
3m 9s
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
Job Ready SQL