Introduction to SQL in MySQL

• Junior programmers and administrators MySQL
• Advanced users who want to familiarize themselves with the MySQL, or need to work with data in v MySQL

• MySQL overview
• The SELECT
• Using multiple data sources
• Functions
• Data modification

• Basic computer literacy
• Understand the basics of relational databases

Introduction to SQL and MySQL database system

• Basic overview of the MySQL database system
• The basic structure of the database
• Overview of client tools
• MySQL installation basics
• Introduction and overview of SQL language

The SELECT

• The basic structure and design of the SELECT statement
• FROM and types of data sources
• ORDER BY, DISTINCT, TOP
• WHERE and operators (AND, OR, NOT, BETWEEN, IN atd.)
• Working with NULL

Using multiple data sources

• The reasons for joining, basics relation
• JOIN types (INNER, OUTER, CROSS, NATURAL)
• Self Join
• Set operators

Functions

• System functions
• Aggregate functions
• Cross Tab

Data modification

• INSERT
• UPDATE
• DELETE
• Temporary tables and their use

Next courses

MySQL administration [GOC661]

Advanced SQL in MySQL [GOC663]