Cart
You have no items in your shopping cart
MySQL MySQL E-learning
MySQL E-learning
€159,00

Cheaper somewhere else?

Let us know!

+31367601019 [email protected]

MySQL E-learning

Brand: MySQL
|
Click to enlarge
€159,00 Excl. tax
€192,39 Incl. 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%
In stock
|
Order before 4:00 PM and start today.
You have got counting... hours
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Information

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

 

Heeft u niet gevonden wat u zocht?
Let us help!
Specifications
General properties
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
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »