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.