Cursos de SQL en MySQL

Algunos de nuestros clientes

Código del Curso

sqlmysql

Duración

14 horas (usualmente 2 días, incluidas las pausas)

Requerimientos

  • Computer literacy
  • Knowledge of any operating system

Descripción General

  • ¿Cómo construir una consulta?
  • ¿Qué es una base de datos relacional?
  • ¿Qué es la estructura y los comandos SQL ?

Machine Translated

Programa del Curso

Relational database models

  • Relational operators
  • Characteristics of declarative SQL language
  • SQL syntax
  • Division language DQL, DML, DDL, DCL

Data Query Language

  • SELECT queries.
  • Aliases columns of tables
  • Service date (DATE types, display functions, formatting)
  • Group Features
  • Combining internal and external tables (JOIN clause)
  • UNION operator
  • Nested Subqueries (the WHERE clause, the table name, column name)
  • Correlated subqueries

Data Modification Language

  • Inserting rows (INSERT clause)
  • Inserting rows by request
  • Variation of the rows (UPDATE)
  • Delete rows (DELETE)

Data Definition Language

  • Creating, altering and dropping objects (CREATE, ALTER, DROP)
  • Creating tables using subquery (CREATE TABLE .... AS SELECT...)

CONSTRAINTS

  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • ENUM type
  • type SET
  • PRIMARY KEY condition
  • UNIQUE condition
  • FOREIGN KEY condition
  • DEFAULT clause

Transactions

  • The command COMMIT, ROLLBACK, SAVEPOINT

Testimonios

★★★★★
★★★★★

Categorías Relacionadas

Cursos Relacionados

Promociones

Descuentos en los Cursos

Respetamos la privacidad de su dirección de correo electrónico. No transmitiremos ni venderemos su dirección a otras personas.
En cualquier momento puede cambiar sus preferencias o cancelar su suscripción por completo.

is growing fast!

We are looking to expand our presence in Venezuela!

As a Business Development Manager you will:

  • expand business in Venezuela
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

Este sitio en otros países / regiones