Introduction to MySQL Development

Introduction to MySQL Development

Bascom Bridge’s Introduction to MySQL Development training course teaches attendees how to develop SQL statements, views, stored procedures, and triggers for their MySQL databases. Participants also learn how to design and implement a database and how to work with foreign keys, transactions, and stored programs.

 

MYSQL TRAINING OBJECTIVES

All students will learn how to:

  • Work with any database
  • Use MySQL Workbench to work with a database and run SQL statements
  • Retrieve, add, update, and delete data from a database
  • Work with summary queries, subqueries, data types, and functions
  • Use MySQL Workbench to create an EER (enhanced entity-relationship) model for their database
  • Design and implement their own databases
  • Use MySQL to create stored procedures, functions, triggers, and events
  • Manage transactions and locking

MYSQL TRAINING PREREQUISITES

Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

MYSQL TRAINING MATERIALS

All MySQL training students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

  • Modern version of Windows, MacOS X, or Linux
  • MySQL version 5 or above (we will provide detailed installation instructions)
  • Local admin privileges
  • Related lab files and database content that the students will extract and install at the start of class
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

MYSQL TRAINING OUTLINE

  • Introduction
  • An Introduction to Relational Databases and SQL
    • An Introduction to Client/Server Systems
    • An Introduction to the Relational Database Model
    • An Introduction to SQL and SQL-Based Systems
    • The SQL Statements
    • How to Use SQL From An Application Program
  • MySQL Workbench and Other Development Tools
    • An Introduction to MySQL Workbench
    • Using Workbench to Run SQL Statements
    • Using the Reference Manual
    • Command Line Client
  • How to Retrieve Data From A Single Table
    • An Introduction to the SELECT Statement
    • The SELECT Clause
    • The WHERE Clause
    • The ORDER BY Clause
    • The LIMIT Clause
  • How to Retrieve Data From Two Or More Tables
    • Inner Joins
    • Outer Joins
    • Other Skills For Working With Joins
    • How to Work With Unions
  • How to Insert, Update, and Delete Data
    • Creating Test Tables
    • Inserting New Rows
    • Updating Existing Rows
    • Deleting Existing Rows
  • Coding Summary Queries
    • Aggregate Functions
    • How to Group and Summarize Data
  • Coding Subqueries
    • An Introduction to Subqueries
    • How to Code Subqueries In the WHERE Clause
    • How to Code Subqueries In Other Clauses
    • Working With Complex Queries
  • The Data Types
    • Converting Data
    • Working With Data Types
  • How to Use Functions
    • String Data
    • Numeric Data
    • Date/Time Data
    • Other Functions You Should Know About
  • How to Design A Database
    • Design A Data Structure
    • Normalize A Data Structure
    • Using MySQL Workbench For Database Design
  • Creating Databases, Tables, and Indexes
    • Databases
    • Tables
    • Indexes
    • A Script That Creates A Database
    • How to Use MySQL Workbench
    • Character Sets and Collations
    • Storage Engines
  • How to Create Views
    • An Introduction to Views
    • How to Work With Views
  • Language Skills For Writing Stored Programs
    • An Introduction to Stored Programs
    • How to Write Procedural Code
  • Transactions and Locking
    • How to Work With Transactions
    • How to Work With Concurrency and Locking
  • How to Create Stored Procedures and Functions
    • Coding Stored Procedures
    • Coding Stored Functions
    • How to Use Workbench With Procedures and Functions
  • How to Create Triggers and Events

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to MySQL Development

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : SQL-180
  •  Theory : 35%
  •  Lab : 65%
  • Duration : 24 hours
Scroll Up
Skip to toolbar