MySQL for Beginners

Logo TailorIT RGB

MySQL for Beginners

 1.768,00

MySQL for Beginners

If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.

Doel

If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.

Doelgroep

Administrators, Database Administrators, Database Designers

Voorkennis

Basic computer literacy is required

Vorm

Klassikaal en Maatwerk

Inhoud

Introduction
• MySQL Product
• MySQL Services and Support
• MySQL Resources
• Example Databases

MySQL Server and Client
• The client/server model overview
• Communication protocols
• Connectors and MySQL
• The LAMP Stack
• Installation of the MySQL server
• MySQL Server and Client Startup

Database Basics
• Basics of Relational Databases
• SQL Language and MySQL

Database Design
• Database Modeling
• Keys
• Normalization

Table Data Types
• Data Types
• Numeric Data Types
• Temporal Data Types
• Character String Data Types
• The Meaning of Null

Database and Table Creation
• Database Structure Creation
• Database Creation
• Table Creation

Basic Queries
• The SELECT Statement
• MySQL Workbench for SQL Development
• Troubleshooting

Database and Table Maintenance
• Deleting an Entire Database
• Maintaining Tables
• Maintaining Columns
• Indexes and Constraints

Table Data Manipulation
• Delete/Modify Table Row Data
• The INSERT Statement
• The REPLACE Statement
• The UPDATE Statement
• The DELETE Statement

Functions
• Simple Functions
• Grouping with Functions

Joining Tables
• Combining Multiple Tables
• Inner Joins
• Outer Joins

Table Queries
• What is a Subquery
• Categories of Subqueries
• Subquery Types
• Placing Subqueries
• Other Subquery Uses
• Converting Subqueries to Joins

Exporting and Importing Data
• Exporting Data
• Importing Data

MySQL GUIs
• MySQL Enterprise Monitor
• MySQL Workbench

Supplemental Information
• Creating Views
• Transaction
• Storage Engines
• Retrieving Metadata
• Performance Schema
• MySQL Enterprise Backup

Conclusion
• Course Review
• MySQL Training and Certification
• Course Evaluation
• Thank You!
• QA Session

Vervolgopleidingen

Bijzonderheden

Geen

4 dagen

€ 1.768

Cursusdata

Data op aanvraag

Andere data?

Locaties

Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

Andere locatie?

SKU: MYSQL-BE Categorieën: , , Tags: , ,
Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.