Course code: GOC660« Back

Introduction to SQL in MySQL

The course Introduction to SQL in MySQL is designed for anyone who wants to learn techniques for working with data in a MySQL database system. Students will gain a comprehensive overview of SQL syntax and acquire practical skills to use it on real examples.

GOPAS Official Curriculum
 DateDurationCourse priceHandbook priceCourse languageLocation 
GTK 11/11/2019 3 12 600 CZK included in course price Český jazyk GOPAS Praha
 
1/27/2020 3 12 600 CZK included in course price Český jazyk GOPAS Praha
 
4/15/2020 3 12 600 CZK included in course price Český jazyk GOPAS Praha
 
2/10/2020 3 12 600 CZK included in course price Český jazyk GOPAS Brno
 
12/2/2019 3 375,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
3/16/2020 3 375,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
5/5/2020 3 375,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 12 600 CZK included in course price 30
Brno3 12 600 CZK included in course price 30
Bratislava3 375,00 EUR included in course price 30

Who is the course for

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

After completing this course, students will be able to use new features in these areas:

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

Required skills

  • Basic computer literacy
  • Understand the basics of relational databases

Teaching methods

Expert instruction with practical examples, computer practic

Literature

Printed presentation

Course Outline

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
        Tištěné nebo elektronické studijní materiály GOPAS

        Price:
        included in course price
        The prices are without VAT.