Introduction to Databases | NYU Tandon School of Engineering

Introduction to Databases

Online

Visual coding interface

Format: microBachelors – 4 months 


Summary

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.

Key Takeaways

  • Sketch conceptual data models (including ER) to describe a database structure.
  • 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.

Who Should Attend

  • Students interested in learning the fundamentals of database management systems, including issuing advanced queries and creating objects in the database

Course Outline

  • Course 1:  Introduction to Database Queries
  • Course 2: Advanced Database Queries
  • Course 3: Advanced Database Administration

Presented in partnership with EdX