A course in the use of SQL database management systems to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the SQL language. It also covers a brief overview of NoSQL (Not Only SQL) data sources such as JSON, and MongoDB.

• Write and implement SQL statements to create and modify database tables with complex relationships, constraints, and views.

• Use all major components of the SQL language for accessing data to analyze business requirements, designing and implementing queries that satisfy those requirements.

•  Insert, update, and delete data in the database using SQL.

• Write and implement code to retrieve data from NoSQL stores.

• Compare the trade-offs between SQL and NoSQL.

Course Outline