MYSQL

MYSQL

Price : ₹6,000.00

Offer Price : ₹4,000.00

Estimated Hours : 20 HOURS

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.

Objective

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.

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