DURASI
4 hari
DESKIRPSI
MySQL adalah salah satu database management system open source yang paling populer di dunia. MySQL telah memperoleh pengakuan dari banyak orang dan juga pengakuan dari banyak industri didunia pengembangan sebagai database management system. MySQL mendukung koneksi keberbagai bahasa pemrograman seperti C, C++, PHP, ASP, ASP.NET, Java, Perl, C# dan Python. MySQL juga dapat diimplementasikan diberbagai platform, seperti Windows, Linux, Unix, SOlaris, FreeBSD, MAC OS, dan HP-UX.
Pada training ini, peserta akan belajar dasar dari MySQL, diantaranya multi-user, multi-threaded SQL Database Server, dan update. Training ini juga mengajarkan tentang instalasi dan konfigurasi MySQL di platform Windows atau Linux dan bagaimana menghubungkan database MySQL dengan PHP dan Java.
TUJUAN
- Mampu menginstall MySQL
- Mampu mengelola data yang terdapat di Database MySQL
- Mampu membuat design Relational Database
- Mampu melakukan manipulasi data pada Database MySQL
- Mampu menggunakan Operators di SQL Statements
- Mampu menggunakan Functions di SQL Statements
- Mampu melakukan import, eksport dan copy data
- Mampu melakukan Backup, Recovery, dan Replication
- Mampu mengkoneksikan MySQL dengan aplikasi PHP
- Mampu mengkoneksikan MySQL dengan aplikasi Java
MATERI
1. Introducing the MySQL Relational Database Management System
- 1.1. Databases and Database Management Systems
- 1.2. The SQL Framework
- 1.3. Data-Driven Applications
2. Installing MySQL
- 2.1. Getting Started
- 2.2. Installing MySQL
- 2.3. Testing Your MySQL Installation
3. Working with MySQL
- 3.1. Understanding the MySQL Directory Structure
- 3.2. Using the MySQL Programs
- 3.3. Assigning Account Passwords
4. Designing a Relational Database
- 4.1. The Relational Model
- 4.2. Data Normalization
- 4.3. Relationships
- 4.4. Creating a Data Model
- 4.5. Designing the DVDRentals Database
5. Managing Databases, Tables, and Indexes
- 5.1. Managing Databases
- 5.2. Managing Tables
- 5.3. Managing Indexes
- 5.4. Retrieving Information About Database Objects
6. Manipulating Data in a MySQL Database
- 6.1. Inserting Data in a MySQL Database
- 6.2. Updating Data in a MySQL Database
- 6.3. Deleting Data from a MySQL Database
7. Retrieving Data from a MySQL Database
- 7.1. The SELECT Statement
- 7.2. The SELECT Statement Options
- 7.3. The Optional Clauses of a SELECT Statement
8. Using Operators in Your SQL Statements
- 8.1. Creating MySQL Expressions
- 8.2. Using Operators in Expressions
9. Using Functions in Your SQL Statements
- 9.1. Comparing and Converting Data
- 9.2. Managing Different Types of Data
- 9.3. Summarizing Data
- 9.4. Performing System Operations
10. Accessing Data in Multiple Tables
- 10.1. Creating Joins in Your SQL Statements
- 10.2. Creating Subqueries in Your SQL Statements
- 10.3. Creating Unions That Join SELECT Statements
11.Exporting, Copying, and Importing Data
- 11.1. Exporting Data Out of a Table
- 11.2. Copying Data into a Table
- 11.3. Importing Data into a Table
12. Managing Transactions
- 12.1. Introducing Transactions
- 12.2. Performing a Transaction
- 12.3. Setting the Autocommit Mode and Transaction Isolation Level
- 12.4. Locking Nontransactional Tables
13. Administering MySQL
- 13.1. Performing Administrative Tasks
- 13.2. Managing System Variables
- 13.3. Managing Log Files
14. Managing MySQL Security
- 14.1. The Access Privilege System
- 14.2. MySQL Access Control
- 14.3. Managing MySQL User Accounts
15. Optimizing Performance
- 15.1. Optimizing MySQL Indexing
- 15.2. Optimizing SQL Queries
- 15.3. Optimizing MySQL Tables
- 15.4. Optimizing Your System’s Cache
16. Managing Backup, Recovery, and Replication
- 16.1. Backing Up Your Database
- 16.2. Restoring Your Database
- 16.3. Replicating Your Database
17. Connecting to MySQL from a PHP Application
- 17.1. Introduction to PHP
- 17.2. Building a Data-Driven PHP Application
18. Connecting to MySQL from a Java/J2EE Application
- 18.1. Introduction to Java/J2EE
- 18.2. Building a Java/J2EE Web Application