Development Databases SQL

The SQL and MySQL Master

MySQL database, SQL complete, best practices, Learn now!
Rating: 4.0 out of 5 (350 ratings)
21,742 students
Created by Pablo Tilotta, Cursea.me Online
Enroll now
The SQL and MySQL Master
Rating: 4.0 out of 5 (350 ratings)
21,753 students
Buy now
You’ll learn from the basics to the advanced level on DataBases.
You’ll acquire deep knowledge from scratch to advanced on the Structured Query Language (SQL).
You’ll do practical and real exercises to obtain information from a DataBase.
Everything on Stored Procedures to a high level.
You’ll learn about about VIEWS in MySQL.
You’ll learn how to program EVENTS in the MySQL engine.
You’ll learn about one of the most popular free DataBase engine: MySQL.
You’ll learn about one of the best client tools for the management of MySQL: HeidiSQL.
You’ll have personalized support for your real life, work related, or thesis exercises.
You’ll learn about TRIGGERS in MySQL.
You’ll learn about TRANSACTIONS in MySQL.

Requirements

  • no requisites
Description

+++++++++++++++++ Why should you buy this course?+++++++++++++++++++++

THIS IS THE ENGLISH VERSION, FOR THE SPANISH SUCCESS COURSE , LEADER IN DATABASES

With 640 reviews, 4.51 stars, and over 10.900 students.

/curso-completo-de-bases-de-datos-de-0-a-avanzado/


Nowadays, database knowledge is essential for the student or the consolidated professional.
Every software tool, or business system uses databases to store information that is necessary to work, and to store sensible information, such as clients, products, sales, details of sales, suppliers, and many more.

Learning what you need to optimize and normalize your databases is essential. This is a course that should be taken not only by people who already know about databases, but also by any professional who desires to optimize his or her databases to the maximum.

In this course, the student will have access to this 9 sections:
Concepts on databases.
Database normalization.
Advanced normalization and best practices.
MySQL databases.
SQL language (complete)
SELECT statement exercises
Advanced use of MySQL and HeidiSQL.
Stored Procedures
EER diagrams in Workbench.

Who is this course for?
Every student and professional who wants to learn from 0 to advanced about databases.
Every student and professional who wants to learn about MySQL as a database engine.
MySQL users who want to know how to use HeidiSQL.
Anyone who wants to learn about databases with no previous knowledge.
Every student and professional who works with databases, but it’s interested in the SQL language (universal).


Who this course is for:
  • Everyone that want to learn about databases or MySQL
Course content
13 sections • 60 lectures • 10h 12m total length
  • About this course
    02:32
  • What is a Database ?
    01:42
  • What about Database Engines ?
    01:42
  • TABLE Concepts
    04:47
  • FIELD Concepts
    09:16
  • INDEXES Concepts
    12:37
  • What is MySQL
    02:25
  • Installing MySQL on my PC
    04:18
  • Error while installing MySQL - Install XAMPP
    03:39
  • Installing HeidiSQL on my PC
    02:25
  • Connecting to the database server with HeidiSQL
    07:27
  • Creating our first database
    02:26
  • Creating tables and fields
    48:18
  • Data types in MySQL and indexes
    38:01
  • Download Trained Database
    00:03
  • Importing data from an SQL file
    08:10
  • Additional tools in HeidiSQL
    15:54
  • Exporting data in HeidiSQL
    07:29
  • Query Builder
    04:50
  • The first normal form
    11:10
  • The second normal form
    02:27
  • The third normal form
    04:10
  • Best practice: More tables, less columns
    05:20
  • Best practice: More records, less columns
    12:38
  • Best practices: Using default values
    07:54
  • Best practices: Using status fields
    12:06
  • Best practices: Use indexes for each meaningful field
    13:29
  • Best practices: Summary tables
    16:54
  • Introduction to the database language
    01:42
  • Making queries (SELECT statement)
    05:08
  • WHERE operator
    15:33
  • Combining tables with WHERE
    18:32
  • ORDER BY clause
    06:00
  • Functions: SUM(), COUNT(), MAX(), AVG(), MIN()
    11:26
  • GROUP BY clause
    10:20
  • IN & NOT IN clause
    19:32
  • BETWEEN clause
    02:18
  • LIKE clause
    07:54
  • INNER JOIN clause (combining tables)
    08:49
  • LEFT, RIGHT, and FULL JOIN (combining tables)
    08:13
  • Basic functions in MySQL
    18:16
  • INSERT Statement
    10:30
  • UPDATE Statement
    11:20
  • DELETE Statement
    04:49
  • Only one table exercises
    13:38
  • Joining 2 or more tables
    15:06
  • Looking for strings
    17:14
  • Grouping, and addition joining many tables
    12:54
  • Exporting queries
    03:05
  • Saving SQL queries
    03:14
  • Foreign keys and table relationships
    10:15
  • Users management
    04:51
  • Basic concepts about stored procedures in MySQL
    21:54
  • Error managing
    16:07
  • Cursors and conditionals
    18:15
  • Triggers in MySQL
    19:45
  • Views in MySQL
    18:33

Instructors
Pablo Tilotta
Analista Programador Experto - 31 años de carrera
Pablo Tilotta
  • 4.5 Instructor Rating
  • 4,261 Reviews
  • 75,965 Students
  • 7 Courses

32 años de carrera como Analista Funcional - Analista de Sistemas - Project Leader - Administrador IT. Gerencia y Administración de Área de Sistemas. Consultoría y Management Sr. Implementación de ERP (4 años) en Prestigiosa Cadena de 80 sucursales.

Actualmente trabajando para una de las empresas de Software mas importantes de Argentina. (AXOFT Argentina)

Experto Programador en COBOL  / Visual Basic 6.0.

Desde la experiencia en el Análisis de Sistemas, me he destacado en brindar soluciones a sectores complejos como Administración, Marketing, Tesorería, Logística y Distribución, Recursos Humanos con mas de 2000 soluciones y sistemas (no siempre la solución es un sistema o programa) a lo largo de 30 años ininterrumpidos.

Amplia experiencia como Administrador de Bases de Datos.

Metodologías Ágiles (Scrum Master), ISO 9001, Team Foundation Server, SVN, GIT.

Conocimientos en NODEJS, C++, Javascript, Lenguaje GO, y algunos conocimientos de JAVA.

Excelente predisposición, manejo de equipos, proyectos y objetivos. Perfil pragmático y simplificador, volver fácil lo difícil. 

Amplia experiencia en la documentación funcional y técnica de los Sistemas implementados, manual de usuarios.

Cursea.me Online
  • 4.1 Instructor Rating
  • 553 Reviews
  • 31,062 Students
  • 3 Courses

Computer teacher with more than 15 years of experience. With me you will learn Linux from scratch to be an expert. I have experience as a Debian system administrator and in preparation of students for LPI certifications. Also on local virtual servers and in the cloud using Docker and AWS.