Kurser

Kursusadministration

Brug for hjælp?

  • Gregersensvej 8
  • 2630 Taastrup
Google MapsApple MapsRejseplanen
  • Forskerparken Fyn, Forskerparken 10F
  • 5230 Odense M
Google MapsApple MapsRejseplanen
  • Teknologiparken Kongsvang Allé 29
  • 8000 Aarhus C
Google MapsApple MapsRejseplanen
  • NordsøcentretPostboks 104
  • 9850Hirtshals
Google MapsApple MapsRejseplanen
  • Gammel Ålbovej 1
  • 6092Sønder Stenderup
Google MapsApple MapsRejseplanen
365 dages online kursus

Online kursus: My SQL Essentials

Få indblik i, hvad der kendetegner MySQL, og hvordan du får det optimale ud af MySQL gennem grundig indføring i de forskellige elementer. Kurserne er på engelsk og foregår online, når det passer dig. Du har adgang til online kursuspakken i 365 dage.

online kurser

MySQL and database management

MySQL is fast, reliable, easy to use, free to download and supports standard SQL. In this course package, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. The courses explore all key areas for developing and administering MySQL databases, such as viewing, retrieving and editing data, data definition and manipulation statements, general syntax, creating programs, writing advanced routines, storage engines, optimization and scaling MySQL databases and monitoring and maintaining your servers.

Video

 

Target audience

This course is for personnel at all levels of an enterprise seeking to attain competency in MySQL.

Benefits

  • Install and configure of MySQL
  • Define and configure the Workbench
  • Create and maintain database connections
  • Use basic syntax of the SELECT statement for data retrieval
  • Create a new database with its specific syntax and parameters
  • View and perform changes to existing records
  • Manage data, and create, alter, and delete databases
  • Identify the properties of different data types and their appropriate usage
  • Recognize data types and general syntax and manage and retrieve data
  • Recognize the difference between stored procedures and stored functions
  • Examine the available storage engines for MySQL databases

Collection content

Database Concepts, Design, and Installation
In this course, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. You’ll also be introduced to the core concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design.
Querying Data Using the SELECT Statement
In this course, you’ll learn basics of the SELECT statement and how to work with multi-table queries. You’ll also be introduced to Functions and Grouping and how to work with Visual Query Builders.
Using the Data Manipulation and Definition Statements
In this course, you’ll learn how to use insert, update, and delete statements to manage data within a MySQL database. You’ll also learn how to use DDL statements to create, drop, and alter databases, tables, and views.
General Syntax, Advanced Queries, and Stored Programs
In this course, you'll learn about the general syntax of MySQL, including comments, identifiers, and data types. The course also covers how to handle advanced queries and data management, as well as how to create and use stored programs.
Advanced Routines, Optimization, and DCL
In this course, you'll learn how to create and use advanced procedures, functions, and triggers and how to optimize queries and performance of a MySQL database. This course also covers how to grant, revoke, and deny user permissions for the underlying database objects.
Storage Engines, Advanced Indexing, and Maintenance
In this course, you'll take an in-depth look at storage engines and how they affect the performance of your MySQL databases. The course also covers index structures and types, indexing for performance, and index maintenance.
Administration, Transactions, Optimization, Scaling, Backup, and Recovery
In this course, you'll explore the core administrative tasks of managing and maintaining your MySQL databases as they grow and as performance demands increase. The course also covers the transactions in MySQL, storage engines and server optimization, and scaling and high availability. You'll also learn about partitioning, replication, import and export, and backup and recovery.
Performance Monitoring, Database Health and Integrity, and Security
In this course, you'll learn about monitoring and maintaining your servers while planning for growth, and about security measures to keep your data safe. The course also covers monitoring systems, measuring performance, securing databases, reviewing database metadata, and ensuring data integrity.

Tidsforbrug

Kursuspakken består af 8 kurser, hvor hvert kursus gennemsnitligt varer to en halv time. Hele kursuspakken kan således gennemføres på ca. 20 timer.

Form

Denne online kursuspakke består af flere forskellige kurser, som du ved tilmelding har adgang til i 365 dage. Hvert enkelt kursus er opdelt i flere kursusmoduler, som du via en oversigtsmenu kan tage i den rækkefølge, du ønsker. Modulerne indeholder lyd, billeder og tekst, der gennemgår kursusindholdet. Nogle moduler indeholder små videofilm med scenarier og cases. Ved hvert kursus har du mulighed for at teste din forståelse af indholdet med tests, som du kan tage både før, under og efter kurset. Du gennemfører kursusmodulerne via din computer eller tablet med lyd og adgang til Internettet. Du kan selv styre, hvornår du vil tage modulerne – og de kan sættes på pause undervejs. Der bliver indsat bogmærker, der hvor du er nået til, så du altid har mulighed for at fortsætte, hvor du sidst kom til.

Læs mere om vores online kurser og se svar på dine spørgsmål (FAQ)

Søgte du et andet online kursus?

Vi tilbyder over 7.000 forskellige online kurser inden for mange forskellige områder. Kontakt os på tlf. 72203000 eller kurser@teknologisk.dk, så vi kan hjælpe med at imødekomme dit behov.

Se desuden listen over vores udvalgte online kurser.

Køb online kurser til flere

Er I en afdeling, en hel virksomhed eller blot flere personer, der ønsker adgang til online kurser, så kontakt os og få et tilbud på tlf. 72203000 eller kurser@teknologisk.dk

Har du faglige spørgsmål så kontakt