Intermediate Relational Database and SQL
How to create, modify and remove tables and databases.
The design principles of tables and databases.
How SQL is applied in applications.
In this 1-hour long project-based course, you will gain hands-on experience and learn how to create and maintain relational databases such as MySQL, Oracle and MS Access. Concepts covered include database and table creation, primary keys and foreign keys. If you have some experience with end-user level SQL and want to advance to a designer or database administrator role, this course is for you! Note: Taking my course "Introduction to Relational Database and SQL" before taking this course is highly recommended. Especially if you do not have any previous experience with relational database and SQL.
Skills you will develop
Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
User interface orientation
Preview finshed products
Creating and dropping databases
Creating and dropping tables
Creating and dropping primary keys
Creating and dropping indexes
Creating and dropping foreign keys
Testing and creating technical documentation
How Guided Projects work
Your workspace is a cloud desktop right in your browser, no download required
In a split-screen video, your instructor guides you step-by-step
Reviews
TOP REVIEWS FROM INTERMEDIATE RELATIONAL DATABASE AND SQL
Great instructor and covered some excellent mysql tips and tricks. The course just needs a little bit o' polish. If I could, I would give this 4.5+ stars. Thank you for your work!
Gain new knowledge about RDBMS, ER diagram, Foreign key, and primary key. But the foreign key material is still not into my mind.
Great course and lots of practice. Highly recommend this for anyone who want to design good database and learn more SQL commands.
It was between basic and intermediate level. It was not challenging but it was useful to learn how to modify databases.
Frequently asked questions
Frequently Asked Questions
What will I get if I purchase a Guided Project?
Are Guided Projects available on desktop and mobile?
Who are the instructors for Guided Projects?
Can I download the work from my Guided Project after I complete it?
What is the refund policy?
Is financial aid available?
Can I audit a Guided Project and watch the video portion for free?
How much experience do I need to do this Guided Project?
Can I complete this Guided Project right through my web browser, instead of installing special software?
What is the learning experience like with Guided Projects?
More questions? Visit the Learner Help Center.
Coursera Footer
