0
SUBTOTAL :
empty cartcheckout
MySQL Database for Beginners

MySQL Database for Beginners

Size
Price:
Add to CartProduct Added View Cart Checkout

Read more

 2Month/20 Hours                                                  Price:35,000

                                                                                      30,000

MySQL Database for Beginners


MySQL Introduction 

MySQL is one of the most popular open-source relational database management system (RDBMS). You will learn how to install MySQL and create a database from scratch from this instructor led, hands-on classroom based training. Our MySQL Database for Beginners course covers all the basics syntax and SQL statements to create, insert, update, delete data and manage tables.

Why MySQL?
Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.

MySQL Course Key Learning 


Module-o1 MySQL Introduction

MySQL Introduction
What is SQL?
Installing MySQL on Mac
Installing MySQL on Windows
Creating the Databases for this Course

Module-o2 Working with My SQL Statements and Operators
The SELECT Statement
The SELECT Clause
The WHERE Clause
The AND, OR, and NOT Operators
The IN Operator
The BETWEEN Operator
The LIKE Operator
The REGEXP Operator
The IS NULL Operator
The ORDER BY Operator
The LIMIT Operator


Module-o3 Working with Joins
Inner Joins
Joining Across Databases
Self Joins
Joining Multiple Tables

Module-o4 Using Joins and Unions
Compound Join Conditions
Implicit Join Syntax
Outer Joins
Outer Join Between Multiple Tables
Self Outer Joins
The USING Clause
Natural Joins
Cross Joins
Unions

Module-o5  Using Joins and Unions
Column Attributes
Inserting a Single Row
Inserting Multiple Rows
Inserting Hierarchical Rows
Creating a Copy of a Table

Module-o6  Using Joins and Unions
Updating a Single Row
Updating Multiple Rows
Using Subqueries in Updates
Deleting Rows
Restoring Course Databases
Final Project 
MySQL Database Management Final Project


Skills Required
Fresh IT Student /No programming knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes:
able to use keyboard and mouse
know how to create, save, move and rename files
International Student Fee : 100 USD | 375 AED | 375 SAR







0 Reviews

Contact form

Name

Email *

Message *