Intermediate Relational Database and SQL
Intermediate Relational Database and SQL – Certificate
Coursera Project Network
How to create, modify and remove tables and databases.
The design principles of tables and databases.
How SQL is applied in applications.
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.
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