English French German Italian Portuguese Russian Spanish

logo_old

  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

Introduction to MySQL Databases

 PDF PrintEmail

Course duration

  • 3 Days

Course Outline

The MySQL training course targets new or existing users of MySQL with some experience with relational database management systems. The MySQL course covers several essential elements of MySQL and general database theories.

  • Understand the basics of Relational Databases.
  • Learn the features and benefits of MySQL.
  • Use various Data types and database design.
  • Discover a database design structure/content.
  • Retrieve database information using the SELECT statements.
  • Troubleshoot typical warnings and errors.
  • Delete or modify database and its objects.
  • Be able to delete or modify table row data.
  • Use of Simple Functions (String, Date, Numerical).
  • Understand the primary methods for exporting and importing data.
  • Understand various MySQL storage engines and their features.
  • Extensive coverage of MySQL Functions and expressions.
  • Use expressions in SQL statements for more functional and flexible retrieval.
  • Learn bulk data import and export operations.
  • Understand MySQL storage engines, transactions and features of the common engines.
  • Create views to reuse SELECT statements
  • Basic computer literacy with previous experience with command-line programs.
  • Some knowledge of database concepts.
  • Some knowledge of data retrieval and reporting.
  1. MySQL Programs and Executables
    1. MySQL Programs and Executables
    2. Common Options to Commands
    3. Specifying Options
    4. Options on the Command Line
    5. my_print_defaults: Display options from files
    6. perror: Explain Error Codes
  2. User Interfaces MySQL
    1. Overview of User Interfaces
    2. Establishing a Connection
    3. MySQL Query Browser
      1. Keyboard Shortcuts
      2. Main Query Window
      3. Query Toolbar
      4. Result Area
      5. Advanced Toolbar
      6. SQL Commands with Mouse Clicks
      7. History and Bookmarks for SQL Commands
      8. Using Scripts: Executing Several Commands
      9. MySQL Help - Information Browser
      10. Object Browser
      11. The Script Editor
      12. Changing Data in SELECT Results
      13. Stored Procedures
    4. MySQL Administrator
    5. MySQL Migration Toolkit
      1. A Brief Overview of the Migration Process
    6. phpMyAdmin
  3. MySQL Monitor
    1. Using MySQL Monitor (SQL Command Interpreter)
    2. Some Useful Options
    3. Formatting and Output Options
    4. Commands for Interactive Mode
    5. Executing a Script from the Monitor
    6. Using the mysql Command to run a Script
    7. See Database Status
  4. Designing Databases
    1. Relational Database Concepts
      1. Brief History of SQL
      2. Relational Database Management System
      3. Popular Databases
      4. Tables
      5. Rows
      6. Columns
      7. Relationships
      8. Datatypes
      9. Primary Keys
      10. Foreign Keys
      11. Valid Object References
      12. SQL Statements
    2. Database Design Principles
    3. Film Rentals - sakila
    4. Basic Modeling Process: Creating a Data Model
      1. Logical versus Physical Model
      2. The Entity-Relationship Model
      3. Entities And Entity Sets
      4. Attributes
      5. Relationships
      6. Relationship Types
      7. Graphical Representation of a Model
      8. Physical Model: Mapping The ER Model To A Relational Database
    5. Database Normalization
      1. First Normal Form
      2. Warning: Abnormal Normal Form!
      3. Second Normal Form
      4. Third Normal From
  5. Creating Databases and Components
    1. Creating Databases
      1. Deleting Databases
    2. Creating Tables
      1. Dropping Tables
      2. Defining Table Types
      3. Altering Existing Table Structures
      4. Add a column
      5. Renaming Tables
      6. Temporary Tables
    3. Creating Column Definitions
    4. Data Types in MySQL
      1. Numeric Data Types
      2. String Data Types
      3. Character Set Fundamentals
      4. Set Types
      5. Date/Time Data Types
      6. Options and Attributes
    5. Constraints
      1. NOT NULL Constraint: Defining a Column's Nullability
      2. UNIQUE Constraint
      3. PRIMARY KEY Constraint: Defining a Master Key
      4. Defining Auto-Increment Columns
      5. Referential Integrity Constraints: Defining Foreign Keys
      6. Constraint Checking on a Transaction
      7. Deferred Checking
      8. Defining Default Values
    6. Managing Indexes
      1. Defining Indexes when Creating Tables
      2. CREATE INDEX Statement
      3. Full-Text Indexes
      4. Deleting Indexes
  6. Identifiers in MySQL
    1. Identifiers in MySQL
      1. Identifier Names
    2. Schema Object Names
      1. Using Double Quotes
      2. Using Quote Within Names
      3. Using Digits
    3. Some Restrictions
    4. Identifier Qualifiers
    5. Mapping of Identifiers to Filenames
    6. Identifier Case Sensitivity
      1. lower_case_table_names Setting
      2. Avoiding Data Transfer Problems
  7. Show Database Information
    1. SHOW and DESCRIBE Statements
      1. Using Table-Related SHOW Statements
      2. Using DESCRIBE Statement
    2. INFORMATION_SCHEMA Tables
      1. Showing Databases
  8. MySQL Table Types
    1. MySQL Table Types (Storage Engines)
    2. Setting/Changing Engine
    3. MyISAM Tables
      1. Full-Text Search on MyISAM Tables
      2. Creating a Full-Text Index
      3. Using Full-Text Search
    4. InnoDB Tables
      1. InnoDB - Limitations and Drawbacks
      2. InnoDB Disk Management
      3. Preventing Problems
      4. Moving Files
    5. FOREIGN KEY Constraints in InnoDB
      1. Checking Foreign Keys
    6. Choosing - MyISAM or InnoDB?
    7. HEAP or MEMORY Tables
    8. Temporary Tables
    9. MERGE Tables
    10. Other Table Types
      1. ARCHIVE or Compressed Tables (since MySQL 4.1)
      2. CSV Type Tables(since MySQL 4.1)
      3. NDB or Cluster Tables (since MySQL 4.1)
      4. FEDERATED or External Tables (since MySQL 5.0)
      5. BDB Tables
    11. Table Files Storage

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.