Much of the world’s data is stored in databases, a structured system created to hold data in a digital environment controlled by various Database Management Systems. Among all the other options, a crucial creation of the late-1980s, Relational Database Management Systems, still manages to maintain its glory in the industry, even recently. Consisting of a collection of tables “related” to each other from various aspects, Relational Databases have become one of the most valuable assets of a data scientist, obliging individuals of the field to learn the usage of RDBMS such as SQLite, MS SQL Server, and MySQL.
For beginners who wish to lay the foundations of their knowledge on relational databases, the self-paced course “Introduction to Database” is tailor-made, so to speak. Welcoming its participants with thoughts on what databases are and their importance, the course then explains the terminology of relational databases; including the types of relations & keys such as primary and foreign keys, along with essential principles of the field, ACID & Normalization, in particular. The exclusively-designed learning path then steers the theme towards practical application of SQL, Structured Query Language, and combines it with Python; finalizing the course with a simple project utilizing all the course content in the latter.
Hub
You are invited to join our Introduction to Database Hub and use this space to discuss topics related to the course, share interesting and relevant material and links, ask questions and engage with peers.
All Our Programs Include
A joint certificate issued by Global AI Hub for each successful learner
Additional access to active mentoring by Global AI Hub experts
The certificate you will earn in this training is valid for privileged membership applications under theCoreRelation Program
Sponsored by
Thanks to the Swiss-based AI Business School and the «10million.AI» project this course is free
It is part of the national education campaigns aiming at educating more than 10 million learners for free on AI and other digital technologies
What is the importance of the Database in the World of Artificial Intelligence and Data Science?
Why do we need a Programming language for databases?
Key Distinction Between Traditional Software Projects and Machine Learning Projects
Module 1
What is Database? Why do we need it?
What is Database Management Systems (DBMS)?
Types of DBMS
What is a Relational Database?
Relational Database Types
Key types
Some Anomaly (Error) Types Seen in the Database
What is Normalization?
ACID(Atomic, Consistent, Isolated, Durable)
Database index(Indexing)
Module 2
SQL – Basic SQL Commands
Operators
Queries
Transactions
Query multiple tables
Module 3
SQL Setup & Queries with Python
Phonebook Application with SQLite
Epilogue
Practical Use Of What Has Been Learned
Further Projects
What’s Next
Learning activities
The course includes a series of lessons that lead you through the content in small, bite-sized learning blocks. Each lesson includes exciting video sessions followed by thought-provoking assessment questions.
Video sessions have to be marked as complete and can be accessed freely after the completion of each lesson.
Assessment questions are graded for the calculation of certification progress.
Each day has a “Materials” section to help you revise the topics that are seen that day.
Preview this Course
Not Enrolled
Next course will start soon
Course Includes
Login
Accessing this course requires a login. Please enter your credentials below!
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
The following panel allows you to customize your consent preferences for any tracking
technology used to help us achieve the features and activities described below. To learn more about how these
trackers help us and how they work, refer to the cookie policy. You may review and change your choices at any
time.
Strictly necessary
These trackers are used for activities that are strictly necessary to operate or deliver the service you requested from us and, therefore, do not require you to consent.
Measurement
These trackers help us to measure traffic and analyze your behavior with the goal of improving our service.
We are always working to improve your experience on our website. Part of this involves
using cookies to collect anonymous data for statistics and personalization. Further information can be found
in our Cookie Policy.