IQSOFT - John Brice Oktatóközpont
IQJB részvételi opció

MySQL for Beginners NEW

Tanfolyam célja

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.

Learn To:

  • Install the MySQL server.
  • Describe the features and benefits of MySQL.
  • Describe the basics of relational databases.

Course objectives:

  • Understand the features and benefits of MySQL
  • 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
  • View a database design structure and content
  • Create a database design using an efficient structure
  • Extract basic database information using the SELECT command
  • Troubleshoot syntax and understand typical warnings and errors
  • Delete or modify a database, and table row data
  • Group query data with aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use simple functions (String, Date, Numerical)
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines
Tematika
  • 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
Előfeltételek

Kötelező előfeltételek:

  • Basic computer literacy is required

Ajánlott előfeltételek:

  • Previous experience with any command-line program
  • Knowledge of database concepts

Kapcsolódó tanfolyamok