MySQL MySQL E-learning
MySQL E-learning
€159,00
MySQL

MySQL E-learning

EUR 159,00 Excl. tax
  • Buy 2 for €155,82 each and save 2%
  • Buy 3 for €154,23 each and save 3%
  • Buy 5 for €147,87 each and save 7%
  • Buy 10 for €143,10 each and save 10%
  • Buy 25 for €135,15 each and save 15%
  • Buy 50 for €124,02 each and save 22%
  • Buy 100 for €111,30 each and save 30%
  • Buy 200 for €79,50 each and save 50%

MySQL E-learning ✓ Award-winning e-learning course ✓ Extensive interactive videos with spoken text ✓ Certified teachers ✓ Practical exercises ✓ Certificate

  • E-Learning - Online toegang: 365 dagen
  • Taal: Engels (US)
  • Certificaat van deelname
In stock
Order before 4:00 PM and start today.
  • Ordered before 23:00:00, delivered tomorrow
  • Gecertificeerde docenten
  • Interactieve training + praktijkopdrachten
  • Certificaat van deelname
  • More information? Contact us about this product
Product description

MySQL E-learning Training

Order this amazing, award-winning MySQL E-learning Training course online, 1 year 24/7 access to extensive interactive videos, speeches, hands-on tasks and progress monitoring. After the course you will receive a certificate of attendance.

Content

MySQL: Getting Started
Course: 1 Hour, 9 Minutes

Course Overview
Introducing Database Systems
Installing MySQL
The MySQL CLI
Getting Started with MySQL
Installing MySQL Workbench
Entities in Database Design
Getting Started with MySQL Workbench
Insert and Query Operations
Describing and Truncating Tables
Course Summary

MySQL: Creating & Updating Tables
Course: 1 Hour, 11 Minutes

Course Overview
Keys in Table Design
Relationships in Database Design
Table Creation
Simple Queries
Introducing SQL
Specifying Uniqueness Constraints
Update Operations
Altering and Dropping Tables
Course Summary

MySQL: Querying Data
Course: 1 Hour, 2 Minutes

Course Overview
Principles of Good Database Design
Choices in Column Design
Compound Conditions
Pattern Matching in Queries
Subqueries
Foreign Key Constraints
Dates in Queries
Refining Query Output
Course Summary

MySQL: Understanding & Implementing Joins
Course: 1 Hour

Course Overview
Introducing Joins
Cross Joins
Inner Joins
Left Outer Joins
Right Outer Joins
Natural Join4
Cross Products in MySQL7
Joins in MySQL
Course Summary

MySQL: Grouping & Aggregation Operations
Course: 58 Minutes

Course Overview
Data Setup
Unique Values
Aggregate Functions
Filtering Aggregates
Subqueries and Aggregates
Three-way Joins
Course Summary

MySQL: Views, Indices, & Normal Forms
Course: 1 Hour, 20 Minutes

Course Overview
Understanding Views
Implementing Views
Working with Views
Understanding Indices
Creating Indices
Working with Indices
Normal Forms in Database Design
Choices in Table Design
First Normal Form
Second Normal Form
Fix Violations of the Second Normal Form
Course Summary

MySQL: Triggers & Stored Procedures
Course: 1 Hour, 24 Minutes

Course Overview
Understanding Triggers
Implementing Triggers
Working with Triggers
Triggers and Foreign Keys
Cascading Deletes and Updates
Stored Procedures
Creating Stored Procedures
Invoking Stored Procedures
Redefining Stored Procedures
Complex Stored Procedures
Course Summary

MySQL: Transactions, Savepoints, & Locks
Course: 1 Hour, 28 Minutes

Course Overview
The ACID Properties
Introducing Transactions
Rollback and Commit
Implicit Commits
DDL Operations
Transactions and Stored Procedures
Error and Warning Handlers
Savepoints
Semantics of Savepoints
Sessions and Connections
Read Locks
Write Locks
Course Summary

 

Specifications
Availabilty 9:38 hours
Language English
Certificate of participation Yes
Online access 90 days
Progress monitoring Yes
Award Winning E-learning Yes
Suitable for mobile Yes
What our customers say

average of 0 review(s)

No reviews found
Read or write a review
* We'll never share your email with anyone else.
Questions?
We are happy to help you. Provide our customer service advice
My account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Language
Cart
Your cart is empty
Menu
Search
Search suggestions
No courses or trainings found...
Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »