Introduction to SQL

The presentation is designed for students who want to learn to write SQL statements for data analysis.

Topics:

• Relational Database Basics
• Relationships
• Datatypes
• Primary & Foreign Keys
• Introduction to SQL Statements
• Database Manipulation Language (DML)
• SELECTing All Columns and Rows
• SELECTing Specific Columns or Rows
• Using the WHERE Clause and Operator Symbols
• Checking for a NULL value
• Using BETWEEN, IN, LIKE and NOT Operator
• Checking Multiple Conditions using AND and OR
• Using Common Math Functions