Description

  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Audience
  • Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Requirements
  • Basic computer skills and knowledge of set theory fundamentals
  • Understanding of first order logic
  • Understanding of search algorithms and complexity theory
  • Prior SQL programming experience is helpful but not required
Objectives
  • Understand Relational Model
  • Understand Normal Forms
  • Learn SQL and how it's used
  • Build and run SQL scripts
  • Perform basic database operations using MySQL
  • Write basic SQL scripts for MySQL
Curriculum
  • DBMS
  • Relational Model
  • SQL basics
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Best Practices