Prefata curs

MySQL
Pret lista: 690 Eur
Durata: 5 zile (40 ore)

Discount-uri

Discount-uri de volum, pentru cursurile organizate la cererea companiilor-client, pentru grupe formate din:
3-7 participanti-10% rezultand pretul final de 621 Euro fara TVA/participant
8-12 participanti-20% rezultand pretul special de 552 Euro fara TVA/participant
>= 13 participanti-30% rezultand pretul exceptional de 483 Euro fara TVA/participant
  1. Pentru cursurile organizate la sediul centrului nostru de training pretul de mai sus include serviciile de instruire in clasa dotata cu infrastructura necesara (laptop/desktop, videoproiector, flipchart), suportul de curs, benefciile post-instruire descrise mai jos si cofeebreak (apa de baut, ceai / cafea). Servicii conexe, oferite la solicitarea dvs.: masa de pranz la restaurant la pretul de 7 Euro / zi / persoana (fara TVA)
  2. Pentru cursurile organizate la sediul companiei client, situat in Bucuresti sau Ilfov, cu infrastructura asigurata de client (laptop / desktop, video-proiector flipchart etc.) , din pretul de mai sus se deduce suma de 7 Euro / zi / participant, reprezentata de cheltuielile noastre cu infrastructura si coffe break.
  3. Pentru cursurile organizate la sediul companiei client, oriunde in tara, pentru un numar de minim 6 participanti, in pretul de mai sus sunt incluse toate costurile legate de deplasarea trainer-ului nostru (cazare, transport, diurna).
  4. Pentru cursurile organizate la sediul companiei client, cu infrastructura aferenta asigurata de noi (laptop-uri, video-proiector, flipchart), la pretul de mai sus se adauga suma de 5 euro / participant / zi de curs (fara TVA), reprezentata de cheltuielile aferente infrastructurii.

Inscrie-te la acest curs sau cere detalii suplimentare

Nume

Email

Despre mine

Tip mesaj

Mesaj

Agendă Curs

MySQL Overview, Products, Services
MySQL Services and Support
Supported Operating Services
MySQL Certification Program
Training Curriculum Paths
MySQL Documentation Resources

The MySQL client/server model
Communication protocols
Storage engines
How MySQL uses memory and disk space
The mysql command line client
Using SQL scripts
How MySQL uses databases
Installing and populating the class database

Invoking client programs
Features of the mysql client
Modifying client behavior with options
Configuring client behaviour with option files
MySQL Workbench
MySQL Utilities

MySQL connectors
Oracle and community connectors
Why write custom programs?
Connecting to MySQL server by using Java and PHP
Embedding a MySQL database in a program
MySQL and NoSQL
InnoDB integration with memcached

The major categories of data types
Character sets and collation
Choosing the correct data type
NULL and NOT NULL
The spatial data type extensions

Components of expressions
Applying numeric, string, spatial, and temporal values in expressions
Pattern matching for string expressions
The properties of NULL values
Functions in expressions
Combining result sets from multiple queries
Comments in SQL statements

Metadata access methods
The INFORMATION_SCHEMA database
Metadata commands
SHOW statements

The MySQL data directory
Database design best practices
Normalization
Choosing identifiers for database entities
Creating a database
Modifying a database
Removing a database

Table properties
Column options
Creating a table
Modifying a table
Displaying table information
Renaming a table
Removing a table
Foreign Keys

Inserting data into a table
Deleting data from a table
Updating data in a table
Replacing data in a table
Truncating table data

Using transactions for concurrent updates
The ACID transaction rules
Isolating transactions

Table join concepts
The different join methods
Cartesian joins
Outer and inner joins
Joining a table to itself
Column references and table aliases
Multi-table UPDATE and DELETE statements

Nesting queries
Correct positioning of subqueries
Using the appropriate type of subquery
Using the correct SQL syntax to create subqueries
Quantifiers for subquery comparisons

What are views?
Reasons for using views
Creating a view
Checking a view
Changing and removing a view
Setting view privileges

Reasons for using prepared statements
Using prepared statements from the mysql command-line client
Preparing, executing, and deallocating prepared statements
Using prepared statements in code, with Connectors

Stored procedures and stored functions
Creating and executing stored routines
Examining an existing stored routine
Deleting an existing stored routine
Assigning variables in stored routines
Flow control statements
Cursor usage and limitations
Limitations of stored routines and stored functions

What are triggers?
When to use triggers
Creating triggers
Deleting triggers
Scheduling events

The effect of SQL modes on error output
Dealing with missing or invalid data values
Interpreting error messages
Using the SHOW WARNINGS and SHOW ERRORS statements
MySQL diagnostic information
The perror utility program
Handling errors when coding with Connectors

The role of the query optimizer
Strategies available for optimizing queries
Using the EXPLAIN statement to predict query performance
Using indexes for optimization
Describing the role of MySQL Enterprise Monitor in query optimization

Course Overview
MySQL Curriculum
Course Evaluation
Thank You!
Q&A Session

Detalii logistice

This MySQL for Developers training teaches developers how to plan, design and implement applications using MySQL.
Expert Oracle University instructors will teach you through realistic examples, interactive instruction and hands-on exercises using Java and PHP languages.

Learn To:

  • Use client programs and options.
  • Access the database from program code.
  • Build „NoSQL” applications.
  • Write effective queries and stored routines.
  • Inspect database metadata.
  • Respond to database events with triggers.
  • Handle errors and exceptions.
  • Optimize SQL statements.
  • Many of the Internet’s most popular websites rely on MySQL. With Hadoop integration, it is a key component of many big data platforms.
  • In addition, MySQL brings you the best of both worlds with SQL and NoSQL.
  • After taking this course, you will be able to write programs that take advantage of the power and flexibility of MySQL.
  • You will have developed the skills to build a database that’s optimal for your application, while creating fast and effective queries.
  • Database Administrators
  • Developer
  • Web Administrator

Required Prerequisites

  • Experience of Java, PHP or another programming or scripting language
  • Basic knowledge of SQL
  • Experience of creating tables and queries in a relational database
  • MySQL for Beginners Ed 3

Suggested Prerequisites

  • MySQL and PHP – Developing Dynamic Web Applications
  • Describe the MySQL client/server architecture
  • Use MySQL client programs and common options
  • Program MySQL applications with Java and PHP connectors
  • Use a “NoSQL” approach to store and retrieve data
  • Design efficient tables
  • Create and delete database objects
  • Use expressions in SQL statements
  • Examine database metadata
  • Use SQL statements to modify table data
  • Maintain database integrity with transactions
  • Write multiple table queries
  • Create “virtual tables” containing specific data
  • Create user-defined variables, prepared statements, and stored routines
  • Create and manage triggers
  • Identify and deal with errors and exceptions in client programs
  • Write queries that are fast and effective, even under heavy loads