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

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.
cta-mail
cta-call

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