Introduction to Microsoft SQL Server Database

Deskripsi

Program yang membimbing peserta mempelajari Database MSQL Server yang meliputi pengenalan dan konsep database, Model relational database, DDL dan DML SQL pada SQL Server, Menggunakan TSQL Server, VIEW, TRIGGER dan Store Procedure, juga mempelajari Manajemen User dan Izin akses Database, Backup dan Restore database.

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

Target Peserta

  • Pengembang aplikasi / programmer
  • IT Technical support
  • Mahasiswa dan umum yang ingin mengenal konsep database relational

Syarat

Tidak ada syarat khusus, namun peserta harus menguasai dasar komputer, instalasi software dan mengetahui data base mysql.

1. Introducing the MySQL Relational Database Management System

  • Databases and Database Management Systems
  • The SQL Framework
  • Data-Driven Applications

2. Installing MySQL

  • Getting Started
  • Installing MySQL
  • Testing Your MySQL Installation

3. Working with MySQL

  • Understanding the MySQL Directory Structure
  • Using the MySQL Programs
  • Assigning Account Passwords

4. Designing a Relational Database

  • The Relational Model
  • Data Normalization
  • Relationships
  • Creating a Data Model
  • Designing the DVDRentals Database

5. Managing Databases, Tables, and Indexes

  • Managing Databases
  • Managing Tables
  • Managing Indexes
  • Retrieving Information About Database Objects

6. Manipulating Data in a MySQL Database

  • Inserting Data in a MySQL Database
  • Updating Data in a MySQL Database
  • Deleting Data from a MySQL Database

7. Retrieving Data from a MySQL Database

  • The SELECT Statement
  • The SELECT Statement Options
  • The Optional Clauses of a SELECT Statement

8. Using Operators in Your SQL Statements

  • Creating MySQL Expressions
  • Using Operators in Expressions

9. Using Functions in Your SQL Statements

  • Comparing and Converting Data
  • Managing Different Types of Data
  • Summarizing Data
  • Performing System Operations

10. Accessing Data in Multiple Tables

  • Creating Joins in Your SQL Statements
  • Creating Subqueries in Your SQL Statements
  • Creating Unions That Join SELECT Statements

11. Exporting, Copying, and Importing Data

  • Exporting Data Out of a Table
  • Copying Data into a Table
  • Importing Data into a Table

12. Managing Transactions

  • Introducing Transactions
  • Performing a Transaction
  • Setting the Autocommit Mode and Transaction Isolation Level
  • Locking Nontransactional Tables

13. Administering MySQL

  • Performing Administrative Tasks
  • Managing System Variables
  • Managing Log Files

14. Managing MySQL Security

  • The Access Privilege System
  • MySQL Access Control
  • Managing MySQL User Accounts

15. Optimizing Performance

  • Optimizing MySQL Indexing
  • Optimizing SQL Queries
  • Optimizing MySQL Tables
  • Optimizing Your System’s Cache

16. Managing Backup, Recovery, and Replication

  • Backing Up Your Database
  • Restoring Your Database
  • Replicating Your Database

17. Connecting to MySQL from a PHP Application

  • Introduction to PHP
  • Building a Data-Driven PHP Application

18. Connecting to MySQL from a Java/J2EE Application

  • Introduction to Java/J2EE
  • Building a Java/J2EE Web Application

Waktu Pelaksanaan 4 Hari

Complimentary Download

Terima kasih atas ketertarikan Anda pada Edutech Training and Konsultan. Untuk mendownload brosur ini, lengkapi formulir pendaftaran di sebelah kanan.

Jika Anda mengalami masalah dalam menyelesaikan formulir, kirimkan ke email ke : info@edutechsolution.co.id dan kami dapat mengirimkan file brosurnya