This course provides students with the core concepts of database design through data modeling, data definition language (DDL), and data manipulation language (DML). Microsoft's SQL Server - a relational database - is our primary interest, as it is one of the most widely used database management system. The underlying foundation and technologies behind database design will be discussed. After successfully completing this course, students will be able to effectively and efficiently organize data using the notion of entity-relationship diagram (ERD) and to perform data retrieval using SQL DML statements.