0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

Oracle MySQL for Beginners

Oracle MySQL for Beginners

Course Overview

MySQL is the most popular open source database in the world, enabling the cost-effective delivery of reliable, high-performance embedded and scalable Web-based database applications. It is an ACID-compliant and integrated transaction safe database with full commit, rollback, crash recovery, and row-level locking capabilities. Our MySQL course will teach you the database concepts and will give you hands-on experience in using and administering the database at an enterprise level.

  • Explain the relational database model.
  • Describe the features and benefits of MySQL.
  • Install and configure the MySQL server and clients.
  • Design efficient databases.
  • Use Structured Query Language (SQL) to build your database and query data.
  • Employ appropriate MySQL tools.

COURSE START DATES

Start DateTimeDaysDurationLocation
18/03/2017 3.00-7.00pm Sat 4 Classes Bethnal Green
20/05/2017 3.00-7.00pm Sat 4 Classes Wembley
15/07/20173.00-7.00pm Sat 4 Classes Oxford Street
16/09/20173.00-7.00pm Sat 4 Classes Bethnal Green
18/11/2017 3.00-7.00pm Sat 4 Classes Wembley
20/01/2018 3.00-7.00pm Sat 4 Classes Oxford Street

Prerequisites

  • Basic Database skills
  • Basic IT skills

Target Audience

  • Programmers
  • Apps Developer
  • Internet Developers
  • Portal Developer
  • Technical Consultant
  • e-Commerce Developer
  • Apps Users
  • Database Developers

Course Content

Oracle MySQL for Beginners Training Course

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

  • 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

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

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

  • 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

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

  • The SELECT Statement
  • Troubleshooting
  • SQL Modes for Syntax Checking
  • Common SQL Modes

  • 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

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

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

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

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

  • 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

  • MySQL Workbench
  • MySQL Enterprise Monitor

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

Reviews Statistic

0
0 out of 0
0 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

Reviews

There are no reviews yet.

Be the first to review “Oracle MySQL for Beginners”

Duration 4 Classes
Price £690.00

Start Date *

Location map

Share our course