The SQL and MySQL Master
What you'll learn
- 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.
Course content
- Preview02:32
Requirements
- no requisites
Description
+++++++++++++++++ Why should you buy this course?+++++++++++++++++++++
THIS IS THE ENGLISH VERSION, FOR THE SPANISH SUCCESS COURSE , LEADER IN DATABASES
With 2000 reviews, 4.51 stars, and over 14.000 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
Instructors
![Pablo Tilotta - +100k students](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 6,373 Reviews
- 113,933 Students
- 9 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. (APER Argentina) como DBA Experto.
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.
- 4.2 Instructor Rating
- 1,106 Reviews
- 43,687 Students
- 5 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.