The three important parts of a Database System are the User Interface, the Business Logic and the database management system. Database System Architecture and Administration – This section covers how applications (web sites, smart phone Apps and other software) interact with a database management system.SQL is the central language for any relational database (see below). Database Programming using Structured Query Language (SQL) – This portion deals with using SQL to create a database schema, add data and then query and manipulate that data.Data Modeling – This deals with learning about an organization’s data needs and developing conceptual and logical models of how the organization’s data will be arranged.What is covered in the intro to database course?įirst off, the topics that I cover in my introductory database course are assembled around three main areas: I get this question so often that I decided to write up a blog post about it. Students in my introductory database course often ask why I use Microsoft Access instead of some other database management system like MySQL, Oracle, SQL Server, Postgres, etc.

Microsoft access database for mac