MySQL Fundamentals - Brainmatics

Back

Short Courses
Regular Courses
Private Courses
About Us
Account

Login | Register | Cart

header

20 Sections
59 Lessons
32 Hours

Expand all sectionsCollapse all sections

PERSIAPAN
2
- 1.1
  PreTest
  0 Questions
- 1.2
  Bundle Materi
1. INTRODUCING THE MYSQL RELATIONAL DATABASE MANAGEMENT SYSTEM
3
- 2.1
  1.1. Databases and Database Management Systems
- 2.2
  1.2. The SQL Framework
- 2.3
  1.3. Data-Driven Applications
2. INSTALLING MYSQL
3
- 3.1
  2.1. Getting Started
- 3.2
  2.2. Installing MySQL
- 3.3
  2.3. Testing Your MySQL Installation
3. WORKING WITH MYSQL
3
- 4.1
  3.1. Understanding the MySQL Directory Structure
- 4.2
  3.2. Using the MySQL Programs
- 4.3
  3.3. Assigning Account Passwords
4. DESIGNING A RELATIONAL DATABASE
5
- 5.1
  4.1. The Relational Model
- 5.2
  4.2. Data Normalization
- 5.3
  4.3. Relationships
- 5.4
  4.4. Creating a Data Model
- 5.5
  4.5. Designing the DVD Rentals Database
5. MANAGING DATABASES, TABLES, AND INDEXES
4
- 6.1
  5.1. Managing Databases
- 6.2
  5.2. Managing Tables
- 6.3
  5.3. Managing Indexes
- 6.4
  5.4. Retrieving Information About Database Objects
6. MANIPULATING DATA IN A MYSQL DATABASE
3
- 7.1
  6.1. Inserting Data in a MySQL Database
- 7.2
  6.2. Updating Data in a MySQL Database
- 7.3
  6.3. Deleting Data from a MySQL Database
7. RETRIEVING DATA FROM A MYSQL DATABASE
3
- 8.1
  7.1. The SELECT Statement
- 8.2
  7.2. The SELECT Statement Options
- 8.3
  7.3. The Optional Clauses of a SELECT Statement
8. USING OPERATORS IN YOUR SQL STATEMENTS
2
- 9.1
  8.1. Creating MySQL Expressions
- 9.2
  8.2. Using Operators in Expressions
9. USING FUNCTIONS IN YOUR SQL STATEMENTS
4
- 10.1
  9.1. Comparing and Converting Data
- 10.2
  9.2. Managing Different Types of Data
- 10.3
  9.3. Summarizing Data
- 10.4
  9.4. Performing System Operations
10. ACCESSING DATA IN MULTIPLE TABLES
3
- 11.1
  10.1. Creating Joins in Your SQL Statements
- 11.2
  10.2. Creating Subqueries in Your SQL Statements
- 11.3
  10.3. Creating Unions That Join SELECT Statements
11. EXPORTING, COPYING, AND IMPORTING DATA
3
- 12.1
  11.1. Exporting Data Out of a Table
- 12.2
  11.2. Copying Data into a Table
- 12.3
  11.3. Importing Data into a Table
12. MANAGING TRANSACTIONS
4
- 13.1
  12.1. Introducing Transactions
- 13.2
  12.2. Performing a Transaction
- 13.3
  12.3. Setting the Autocommit Mode and Transaction Isolation Level
- 13.4
  12.4. Locking Nontransactional Tables
13. ADMINISTERING MYSQL
3
- 14.1
  13.1. Performing Administrative Tasks
- 14.2
  13.2. Managing System Variables
- 14.3
  13.3. Managing Log Files
14. MANAGING MYSQL SECURITY
3
- 15.1
  14.1. The Access Privilege System
- 15.2
  14.2. MySQL Access Control
- 15.3
  14.3. Managing MySQL User Accounts
15. OPTIMIZING PERFORMANCE
4
- 16.1
  15.1. Optimizing MySQL Indexing
- 16.2
  15.2. Optimizing SQL Queries
- 16.3
  15.3. Optimizing MySQL Tables
- 16.4
  15.4. Optimizing Your System’s Cache
16. MANAGING BACKUP, RECOVERY, AND REPLICATION
3
- 17.1
  16.1. Backing Up Your Database
- 17.2
  16.2. Restoring Your Database
- 17.3
  16.3. Replicating Your Database
17. CONNECTING TO MYSQL FROM A PHP APPLICATION
2
- 18.1
  17.1. Introduction to PHP
- 18.2
  17.2. Building a Data-Driven PHP Application
18. CONNECTING TO MYSQL FROM A JAVA/J2EE APPLICATION
2
- 19.1
  18.1. Introduction to Java/J2EE
- 19.2
  18.2. Building a Java/J2EE Web Application
PENUTUPAN
2
- 20.1
  PostTest
  0 Questions
- 20.2
  Kuesioner

This content is protected, please login and enroll in the course to view this content!

13.2. Managing System Variables

14.1. The Access Privilege System

info@brainmatics.com

Social Media

Partners

Brainmatics Curriculum Booklet (PDF)

Login with your site account

Lost your password?

Remember Me

Not a member yet? Register now

Register a new account

Are you a member? Login now

Modal title

Main Content