Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Programming Foundations: Databases
Discover the fundamentals of database conceptsPreview the first lesson free — get full access to all 38 lessons.
Beginner Provider : Daniel Hanks 11 chapters · 38 Lessons · 1h 34m in Arabic, German, English, Spanish, French, Portuguese, Urdu, Chinese
Course Description
It’s a data driven world and databases are essential to organizing, storing, and understanding this information. Databases offer numerous benefits, like reducing the amount of time needed to manage and analyze the data, the ability to share and update data with others with less errors, and securing the data. How do you begin learning how to create and use a database and take advantage of all of these benefits?
This course introduces the fundamentals of database concepts and assets. Learners will gain a variety of skills and grasp new concepts pertaining to databases, queries, relationships, indexes, and more. You’ll learn about the benefits of using a database, along with how to manage and secure them. You’ll create your own database, and learn how to import existing databases. You’ll learn about database structures and tables, along with the relationships that bind them. You’ll learn about the languages used to create queries that select, modify, group, join, and delete data. Once you’ve finished the course, you’ll be able to design your own database that will allow you to store and present data in a practical and useful way.
What You'll Learn
- Understand basic concepts surrounding databases, including tables, relationships, keys, and indexes
- Learn the types of database languages, such as Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL)
- Write queries to insert, update, delete, and select data
- Create your own database and import existing databases and tables
- Design table structures and define primary and foreign keys, along with one-to-one, one-to-many, and many-to-many relationships
- Manage and secure databases while sorting, filtering, grouping, and joining data
Key Takeaways
- Databases are essential to organizing, storing, and understanding information in a data-driven world.
- Using a database can reduce the time needed to manage and analyze data, allow data to be shared and updated with fewer errors, and help secure the data.
- The course covers database structures, tables, and the relationships that bind them, including one-to-one, one-to-many, and many-to-many relationships.
- Learners study the languages used to create queries that select, modify, group, join, and delete data.
- By the end of the course, learners can design their own database to store and present data in a practical and useful way.
Frequently Asked Questions
What will I be able to do after completing this course?
After finishing the course, you will be able to design your own database that allows you to store and present data in a practical and useful way.
What topics does this course cover?
The course introduces the fundamentals of database concepts and assets, covering databases, queries, relationships, indexes, tables, keys, database software, database languages, storage, and database types such as network, NoSQL, object-oriented, and relational databases.
Is this course suitable for beginners?
Yes. The course introduces the fundamentals of database concepts and starts from topics like what data is and what a database is, including installing database software, so it is designed for learners beginning to learn how to create and use a database.
What database languages are taught in this course?
The course covers database languages including Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
What skills will I gain from this course?
You will gain skills in areas such as basic database concepts, database applications, database development, database management, database programming, and database systems.
