See how Insoft Services is responding to COVID-19

SQL4401 – mysqli for Beginners

X

Kontakt os

Vi vil gerne høre fra dig. Udfyld denne formular for at forudbestilling eller anmode om yderligere oplysninger om vores leveringsmuligheder.

Tilmeld

Jeg vil gerne modtage e-mails med de seneste oplysninger og kampagner fra Insoft.

Databeskyttelse og privatliv

Jeg tillader hermed Insoft Ltd. at kontakte mig om dette emne. Jeg tillader endvidere Insoft Ltd.-, at indsamle og lagre mine personlige data med henblik på disse aktiviteter. Alle dine data vil blive beskyttet og sikret som beskrevet i vores privatlivspolitik.


Kommende datoer


Feb 15 - Feb 18, 2021
09:00 - 17:00 (CEST)
Online

May 18 - May 21, 2021
09:00 - 17:00 (CEST)
Online

Aug 17 - Aug 20, 2021
09:00 - 17:00 (CEST)
Online

Nov 15 - Nov 18, 2021
09:00 - 17:00 (CEST)
Online

SQL4401 – mysqli for Beginners
4 days  (Instructor Led Online)  |  Database Administration

Course Details

BESKRIVELSE

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool. Students who can benefit from this course: New or existing users of MySQL, who have little or no previous experience with a relational database management system.

KURSETS FORMĂ…L

Delegates will learn how to:

  • Understand the features and benefits of MySQL
  • Be able to find information about products, support and training
  • Be able to install and start the MySQL server
  • Understand the basics of Relational Databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to delete or modify a database
  • Be able to delete or modify table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Understand the primary methods for exporting and importing data
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines

FORUDSÆTNINGER

  • Knowledge of database concepts
  • Previous experience with any command-line program
  • Basic computer literacy is required