Introduction to Databases with NYU
Skills Covered: SQL, Database Tools, Database Queries, Querying the Database – Single Table, Querying the Database – Multiple Tables, Modifying the Database, Aggregate Queries, Subqueries, Data Types, Using Functions, Designing a Database, Creating Databases, Creating Views, Creating Stored Procedures, Transactions and Locking, Creating Functions
ABOUT THIS MICRO BACHELOR
This program will teach you everything you need to know to start using a relational database management system in the Web, the Cloud, and embedded applications. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The courses utilize the open-source relational database MySQL. MySQL and it’s open-source fork MariaDB are used in millions of web apps to persist the application data and provide query processing. Students gain valuable hands-on experience programming SQL queries in the labs. In addition to the applied SQL labs, you will also gain an understanding of relational databases in general, learning how to design your database, so it’s robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data, and query that data through extensive hands-on practices.
With the successful completion of this program, passing all courses with a 70% or better via the verified (paid) track, you’ll not only receive a certificate highlighting your achievement from NYU, but also have the option to collect real college credit from an edX credit partner (included in the price!) that you can count towards a pursuit of a bachelor’s degree.
WHAT YOU WILL LEARN
- Apply queries in SQL to create, read, update and delete data in a database.
- Apply the concepts of entity integrity constraint and referential integrity constraint (including definition of the concept of a foreign key).
- Sketch conceptual data models (including ER) to describe a database structure.
- Apply SQL to create a relational database schema based on conceptual and relational models.
- Apply stored procedures, functions, and triggers using a commercial relational DBMS.
- Describe concurrency control and how it is affected by isolation levels in the database.