MySQL, SQL and Stored Procedures from Beginner to Advanced
A beginners' guide to MySQL queries, database design, transactions and stored procedures.
Lo que serás capaz de hacer
This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you. Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database. MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites. Master Advanced MySQL Features, Starting from the Ground Up In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures. You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool. By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.
- Create, query and update databases
- Use triggers, views and stored procedures
- Understand transactions and database isolation levels.
- Understand database users and security.
Temario
UNIDAD 1 - Introduction · 1 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Introducing MySQL
UNIDAD 2 - Getting Started · 11 leccionesUNIDAD 2 - Getting Started
UNIDAD 2 - Getting Started
- Installing MySQL and the Workbench
- Using the Command Line
- Creating Tables
- Multiple Columns, int and Data Types
- Null Values and Not Null
- Mysql Storage Engines and Configuration
- SQL Modes
- Deleting All the Data in a Table
- Primary Keys
- Auto Increment
- Narrowing Down Select Statements
UNIDAD 3 - Importing and Exporting Data · 3 leccionesUNIDAD 3 - Importing and Exporting Data
UNIDAD 3 - Importing and Exporting Data
- Exporting and Importing Data
- Exporting Using the Command Line
- Importing Using the Command Line
UNIDAD 4 - MySQL Operators · 6 leccionesUNIDAD 4 - MySQL Operators
UNIDAD 4 - MySQL Operators
- Some Test Data
- Comparison Operators
- Logical Operators
- 018 Exclusive Or
- Exercises Part 1
- Solutions Part 1
UNIDAD 5 - Update, Order and Limit · 3 leccionesUNIDAD 5 - Update, Order and Limit
UNIDAD 5 - Update, Order and Limit
- Beginning Update Statements
- Order By
- Limiting Results
UNIDAD 6 - MySQL Data Types · 12 leccionesUNIDAD 6 - MySQL Data Types
UNIDAD 6 - MySQL Data Types
- Mysql Types
- Text Types
- Floating Point Types and Ints
- The Bit Type
- Bool
- Blobs
- Time, Date and Year
- Timestamp and Datetime
- Enumerations
- Brackets and Conditions Revisited
- Exercises 2
- Solutions 2
UNIDAD 7 - Aggregate Functions and Grouping · 9 leccionesUNIDAD 7 - Aggregate Functions and Grouping
UNIDAD 7 - Aggregate Functions and Grouping
- The distinct keyword
- Counting Distinct Values
- Aggregate Functions
- Arithmetic in MySQL
- The Health Survey Dataset
- Group By
- Having- Restricting Groups By Aggregate Functions
- Exercises 3
- Solutions 3
UNIDAD 8 - Foreign Keys and Multiple Tables · 15 leccionesUNIDAD 8 - Foreign Keys and Multiple Tables
UNIDAD 8 - Foreign Keys and Multiple Tables
- Naming Columns and Tables
- Foreign Keys
- ER Diagrams
- Joins and Cartesian Products
- Inner Joins
- Left and Right Outer Joins
- Joins on Multiple Tables
- Querying Chains of Tables
- One to Many and One to One
- Many to Many
- Joining Tables to Themselves
- Restrict Foreign Keys
- Cascade Foreign Keys
- Exercises 4
- Solutions 4
UNIDAD 9 - Combining Queries · 3 leccionesUNIDAD 9 - Combining Queries
UNIDAD 9 - Combining Queries
- Union and Union All
- Subqueries with "in"
- Inline Views
UNIDAD 10 - Altering Schemas · 4 leccionesUNIDAD 10 - Altering Schemas
UNIDAD 10 - Altering Schemas
- Adding Columns
- Adding Foreign Keys
- Adding Indexes
- Indexes on Multiple Columns
UNIDAD 11 - Users and Privileges · 2 leccionesUNIDAD 11 - Users and Privileges
UNIDAD 11 - Users and Privileges
- Creating Users
- Granting Privileges
UNIDAD 12 - Views · 3 leccionesUNIDAD 12 - Views
UNIDAD 12 - Views
- Creating a Simple View
- View Algorithms
- With Check Option
UNIDAD 13 - Locks and Transactions · 17 leccionesUNIDAD 13 - Locks and Transactions
UNIDAD 13 - Locks and Transactions
- Exclusive Table Locks
- Shared Table Locks
- Using Variables
- Setting Variables with Selects
- A Select-Update Example
- Fixing Select-Updates with Table Locks
- ACID
- A Simple Transaction
- Start Transaction
- InnoDB Row Locking and Isolation
- ACID Isolation Levels
- Serializable and Row vs Table Locking
- Demonstrating the Other Isolation Levels
- Rolling Back to Savepoints
- The Account Transfer Problem
- Select for Update
- Lock in Share Mode
UNIDAD 14 - MySQL Functions · 8 leccionesUNIDAD 14 - MySQL Functions
UNIDAD 14 - MySQL Functions
- String Functions
- Dates, Intervals and Queries
- Date Diff and Dayname
- Str_To_Date and Date_Format
- Control Flow Functions
- Casting
- Functions Exercises
- Functions Solution
UNIDAD 15 - Stored Procedures · 27 leccionesUNIDAD 15 - Stored Procedures
UNIDAD 15 - Stored Procedures
- Introducing Stored Procedures
- Changing the Delimiter
- Hello World
- Editing Stored Procedures 2
- Setting the Definer
- Procedure Permission
- Passing Parameters
- Multiple Parameters
- Select Into Variables
- Out Parameters
- Inout Parameters
- The If Statement
- Local Variables
- Implementing Account Withdrawal
- Transactional Withdrawal
- Errors and Warnings
- Handling Errors
- While Loops
- Labelled Loops
- Generating Random Data
- A Data Generating Procedure
- Cursors
- Fetching Cursor Data in a Loop
- The Case Expression
- Variable Scope and Multiple Cursors
- Exercises 6
- Solutions 6
UNIDAD 16 - Triggers · 5 leccionesUNIDAD 16 - Triggers
UNIDAD 16 - Triggers
- Introducing Triggers
- Validating with Triggers
- Triggers and Transactions
- Triggers Exercise
- Triggers Solution
UNIDAD 17 - User-Defined Functions · 2 leccionesUNIDAD 17 - User-Defined Functions
UNIDAD 17 - User-Defined Functions
- Functions vs Procedures
- User-Defined Functions
UNIDAD 18 - Visual Design · 3 leccionesUNIDAD 18 - Visual Design
UNIDAD 18 - Visual Design
- Designing Databases Visually
- Connecting with Java
- Retrieving Data with Java
UNIDAD 19 - Final Exercise · 2 leccionesUNIDAD 19 - Final Exercise
UNIDAD 19 - Final Exercise
- Final Exercise
- Conclusion
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
19 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por John Purcell.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 19 unidades · 136 lecciones · 60 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por John Purcell; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
