Introduction to Relational Database and SQL
What you'll learn
- SQL
- Entity Relationship Model
- Relational Database
Requirements
- No
Description
This course teaches you how to design a relational database and how to write SQL. It covers all the important SQL statements, including CREATE, INSERT, UPDATE, DELETE, SELECT, ALTER, and DROP, and provide some insight into entity-relationship model design. This course is based on my on-campus teaching at colleges and comes with a mid-term project and a final project. There is no prerequisite for this course.
Who this course is for:
- SQL and Relational Database Beginner
Instructor
Mr. Shan is a data architect with 20+ years of experience in the data management, data engineering, and data science field. He received his MS degree in Computer Science from Virginia Tech and has lead the delivery of multiple data projects to Fortunate 500 companies in his career. In recent years, Mr. Shan has been putting more emphasis on utilizing enterprise data to the use of data science principles such as artificial intelligence and machine learning. Mr. Shan also teaches as adjunct faculty in Columbia University and City University of New York.