MySQL Training
MySQL Training
MySQL Training Award-winning E-Learning course Extensive interactive videos with spoken text Certified teachers Practical exercises Certificate.
Read more- Brand:
- MySQL
- Discounts:
-
- 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%
- Availability:
- In stock
- Delivery time:
- Ordered before 5 p.m.! Start today.
- Award Winning E-learning
- Lowest price guarantee
- Personalized service by our expert team
- Pay safely online or by invoice
- Order and start within 24 hours
MySQL E-Learning
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.
Course 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 MySQL
- 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
| Language | English |
|---|---|
| Qualifications of the Instructor | Certified |
| Course Format and Length | Teaching videos with subtitles, interactive elements and assignments and tests |
| Lesson duration | 9:38 Hours |
| Progress monitoring | Yes |
| Access to Material | 365 days |
| Technical Requirements | Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge. |
| Support or Assistance | Helpdesk and online knowledge base 24/7 |
| Certification | Certificate of participation in PDF format |
| Price and costs | Course price at no extra cost |
| Cancellation policy and money-back guarantee | We assess this on a case-by-case basis |
| Award Winning E-learning | Yes |
| Tip! | Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform. |
There are no reviews written yet about this product.
OEM Office Elearning Menu Trots Genomineerd voor 'Beste Opleider van Nederland'
OEM Office Elearning Menu is vereerd met de nominatie voor 'Beste Opleider van Nederland' door Springest by STUDYTUBE, een blijk van erkenning voor onze excellente trainingen en toewijding aan kwaliteitsonderwijs. Dank aan alle cursisten.
Reviews
There are no reviews written yet about this product.
