Aktualne promocje

20/01/2017
29/09/2020
31/10/2020

Barcampy, konferencje, wydarzenia

29/11/2016 - 18:00
08/11/2016 - 08:30
04/11/2016 (Caly dzien)

Developing Applications with MariaDB & MySQL

Kod szkolenia: 
MDB-DApps
Opis szkolenia: 

This instructor-led class is for anyone developing applications with the MariaDB or MySQL databases. We cover the basics of how to use MariaDB & MySQL efficiently and tuning queries for performance and high concurrency, as well as strategies for approaching complex problems that aren’t easily solved with SQL. Get the latest tips & tricks for developing with MariaDB or MySQL!

Cel szkolenia: 

Learn how to:

  • Choose storage engines for your tables
  • Write basic SQL for MariaDB or MySQL
  • Use the MariaDB-specific commands and syntax
  • Optimize joins and sub-queries for MariaDB & MySQL
  • Design your schema, normalize it, and know when to de-normalize!
  • Tune your SQL queries with inside knowledge of the MariaDB Optimizer
  • Use programming logic for stored procedures, functions and triggers
  • Design your application to handle scaling out with MariaDB or MySQL Replication
  • Solve complex problems using standard SQL
Grupa docelowa: 

If you are developing applications for MariaDB or MySQL, this course is for you. Our instructors will provide you with the knowledge to make the most out of the core of MariaDB & MySQL, as well as how to take advantage of a host of new features.

Wymagania wobec słuchaczy: 

Knowledge of basic SQL and relational databases is required. Basic MariaDB or MySQL knowledge is recommended but not required.

Cena netto PLN: 
6724
Cena brutto PLN: 
8270.52
Cena EURO: 
1500
Czas trwania: 
5 dni
Uwagi: 

Cena w PLN jest kosztem orientacyjnym.

Koszt szkolenia w Euro przeliczany jest wg kursu sprzedaży w NBP z dnia wystawienia faktury.
Kurs Euro przyjęty do powyższej kalkulacji 1Euro=4,4829 PLN - Tabela nr 099/C/NBP/2016 z dnia 2016-05-23.

Przyjmujemy wpłaty w PLN lub EURO.

Oferujemy  szkolenia w naszych ośrodkach w Warszawie, Wrocławiu i Krakowie, jak i w lokalizacjach wskazanych przez klienta.W celu ustalenia szczegółów prosimy o kontakt na osec@osec.pl

Konspekt: 

Course Highlights
You’ll learn many things in this course related to developing applications utilizing MariaDB and MySQL. In particular, you'll learn how to:

  • Choose the Most Appropriate Storage Engines;
  • Optimize Joins and Sub‐queries for MariaDB & MySQL;
  • Normalize Table Schema—and when to De‐Normalize;
  • Tune SQL queries with inside knowledge of the MariaDB Optimizer;
  • Use Programming Logic for Stored Procedures, Functions and Triggers;
  • Design Applications to Handle Scaling with MySQL Replication; and
  • Solve Complex Problems using Standard SQL

Course Outline
Below is the outline of this course. Based on student needs, though, this may change for each teaching of the course.

  • Architecture
  • Storage Engines
  • Data Types
  • Writing Data
  • Reading Data
  • Joins
  • Sub‐Queries
  • Views
  • Query Optimization
  • Schema Design
  • Programming
  • Error Handling
  • Clients & Connectors
  • Scaling Up & Out
  • Tips & Tricks

Logowanie

O osec.pl

Nasz serwis działa dzieki następującym projektom:

Drupal CMS - http://www.drupal.org
Apache HTTPD - http://www.apache.org
PHP - http://www.php.net
MySQL - http://www.mysql.com

ipv6 ready