MySQL pamatkurss

Veicināt zināšanas un prasmes darbā ar MySQL:

• izskaidrot datubāzes darbību;
• iegūt datubāzes metadatus;
• aprakstīt MySQL GUI rīkus;
• pārraudzīt datubāzes veiktspēju;
• veikt datubāzes dublēšanu un atkopšanu;
• eksportēt un importēt datubāzes datus;
• aprakstīt MySQL funkcijas un priekšrocības;
• izskaidrot relāciju datubāzu pamatus;
• izveidot efektīvu datubāzi;
• veidot datubāzi un tabulas, izmantojot SQL Modify vai dzēst datubāzes entītijas;
• pieprasīt datus ar komandu SELECT;
• apvienot datus no vairākām tabulām;
• izmantot iebūvētās MySQL funkcijas.

Datubāzu administratori, datubāzu dizaineri un izstrādātāji.

• izskaidrot relāciju datubāzes modeli;
• aprakstīt MySQL funkcijas un priekšrocības;
• instalēt un konfigurēt MySQL serveri un klientus;
• izstrādāt efektīvas datubāzes;
• izmantot strukturēto vaicājumu valodu (SQL), lai izveidotu datubāzi un vaicājumu datus;
• izmantot atbilstošus MySQL rīkus.

Obligātie priekšnoteikumi:

• Nepieciešamas pamata datorprasmes.

Ieteicamie priekšnoteikumi:

• Zināšanas par datubāzes jēdzieniem;
• Iepriekšēja pieredze darbā ar jebkuru komandrindas programmu.

Oracle University Event Learning Subscription.

Nav paredzēts.

1. Introduction to MySQL

• Course Goals;
• Course Lesson Map;
• MySQL Overview;
• MySQL Database Server Editions;
• MySQL Products;
• MySQL Services and Support;
• MySQL Resources;
• Example Databases.

2. MySQL Server and Client

• MySQL Client/Server Model;
• Communication protocols;
• MySQL Connectors;
• The LAMP Stack;
• Installation of the MySQL server;
• MySQL Server and Client Startup;
• Keyboard Editing;
• Session Logging With the tee File.

3. Database Basics

• Basics of Relational Databases;
• Spreadsheet Versus Database;
• Entities and Relationships;
• Relationship Categories;
• SQL Language and MySQL;
• SQL data definition language;
• SQL data manipulation language.

4. Database Design

• Database Modeling;
• Structure and Cardinality Diagram (ERD);
• Keys;
• Normalization;
• Database Design;
• Viewing and Evaluating a Database.

5. Table Data Types

• Data Types as Part of Database Design;
• Numeric Data Types;
• Temporal Data Types;
• Character String Data Types;
• Character Set and Collation Support;
• Binary String Data Types;
• Data Type Considerations;
• The Meaning of NULL.

6. Database and Table Creation

• Creating a Database;
• Creating a Table;
• Showing How a Table Was Created;
• Column Options;
• Table Options;
• Table Indexing;
• Table Constraints.

7. Basic Queries

• The SELECT Statement;
• Troubleshooting;
• SQL Modes for Syntax Checking;
• Common SQL Modes;
• MySQL Workbench for SQL Development.

8. Database and Table Maintenance

• Deleting databases and tables;
• Creating a new table using an existing table;
• Confirming the creation of a new table;
• Copying an existing table structure;
• Creating a temporary table;
• Adding, removing and modifying table columns;
• Adding, removing and modifying indexes and constraints.

9. Table Data Manipulation

• Manipulating Table Row Data;
• The INSERT Statement;
• The REPLACE Statement;
• The UPDATE Statement;
• The DELETE Statement.

10. Functions

• Functions in MySQL Expressions;
• Using Functions;
• String Functions;
• Temporal Functions;
• Numeric Functions;
• Control Flow Function;
• Aggregate Functions;
• Spaces in Function Names.

11. Exporting and Importing Data

• Exporting with a Query;
• Exporting with a MySQL Utility;
• Importing from a Data File;
• Importing with a MySQL Utility.

12. Joining Tables

• Combining Multiple Tables;
• Joining Tables with SELECT;
• Comma-Separated Joins;
• Inner Joins;
• Outer Joins;
• Table Name Aliases.

13. Table Subqueries

• Advantages of Using a Subquery;
• Placement of Subqueries;
• Subquery Categories;
• Subquery Result Table Types;
• Subquery Type/Placement;
• Finding Mismatches;
• Modifying Tables using Subqueries;
• Converting Joins to Subqueries.

14. MySQL Graphical User Interface Tools

• MySQL Workbench;
• MySQL Enterprise Monitor.

15. Supplementary Information

• Storage Engines;
• Creating Views;
• Transactions;
• Retrieving Metadata;
• Performance Schema;
• MySQL Enterprise Backup.

16. Conclusion

• Course Goals;
• MySQL Curriculum Path;
• MySQL Resources;
• Evaluation;
• Final Q&A.