• LOGIN
    • No products in the cart.

Overview:

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other “AMP” stacks). LAMP is an acronym for “Linux, Apache, MySQL, and Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.


Objectives:

In this course you will Design a database from scratch so that you understand the thought process that goes into such a design. We will then bring in the basic skills of SQL and give you example upon example of how to use this skill while building on those basic skills adding in more technique and more difficulty until they become more advanced. You will learn a skill that even you average DBA doesn’t do properly.

  • SQL Statements.
  • Views.
  • Stored Procedures.
  • Triggers.
  • User Defined Functions.
  • And a lot more!

When you are done with this course, you will be able to walk into a interview with a calm confidence and show them that you know what you are doing and apply these skills to build the database back end for an application that will stand the test of time.


Audience:

  • If you have ever wanted to understand databases you should take this course.
  • If you want to know how to speed up Queries you should take this course.
  • If you have never seen a Database You should take this course.

Prerequisites:

This course doesn’t require any prior programming knowledge. Basic computer science knowledge will be enough to get started with this course.


Share this...
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Course Curriculum

Describe the features and benefits of MySQL
MySQL Overview
Explain the basics of relational databases
Design an effective database
Select appropriate data types for your database
Build a database and tables by using SQL
Modify the structure of your database
Create indexes and keys
Add or update database data
Query data with SELECT statements
Join data from multiple tables
Use built-in MySQL functions
Export and import database data

Course Reviews

4.8

ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

All Rights Reserved © 2016.  Powered By
x Shield Logo
This Site Is Protected By
The Shield →