Blockchain and SQL Fundamentals

95-827

Units: 6

Description

This is a medley class that combines SQL (accessing and processing data stored in large, centralized data stores) and blockchain smart contracts (accessing and processing data stored in decentralized ledgers). There is significant interest in the industry for both approaches. The course is designed to provide the student with a serious and hands-on introduction to SQL and smart contract programming. Applications will primarily be chosen from the area of computational finance. The student should come to the class with knowledge of at least one programming
language.

Learning Outcomes

By the end of this course, the student will be able to...

... explain the role cryptography and peer-to-peer networks play in securing blockchain-based cryptocurrencies;
... program and deploy smart contracts on an Ethereum test network;
... understand the ERC-20 (fungible token) and ERC721 (non-fungible token) standards;
...understand Automated Market Makers (such as Uniswap V2)
...given an organizational need, identify the data needed to meet the need
... query a database using SQL
... discuss principles of database design
... assess alternatives to the classic relational model (noSQL)

Prerequisites Description

We assume that students have a programming course in their background. So, students will understand the following: syntax errors, logic errors, variables, types, assignment statements, functions, procedures, parameter passing, conditional expressions, iteration, problem-solving, and computational thinking.