MySQL Database Developer

Understanding Database and Database Management Tools

• Idea about - Web Designing, Web Development, Software Development, Outsourcing, Freelancing.
• Basic Ideas on - Domain, Hosting, IP, Server, NameServer, Programming Language, Designing Language, Structured Query Language, Framework, CMS, IDE, cPanel, Domain Control Panel, FTP Client, Local Server.
• Discuss on what we will be Learning in the Web Technology course and how
• Code Concepts, Program Concepts

Understanding Database and Database Management Tools

• What is Database; Traditional and Modern way of storing Data.
• What are the basic Tools for Database Management, Understanding SQLYog
• Understanding the Interface and Features of PhpMyAdmin; Data Export and Import;
• Handling Database and Table Structure (Create, Alter, Delete) using PhpMyAdmin
• Insert, Update, Delete data using PhpMyAdmin; Using Functions from PhpMyAdmin
• Working with SQLYog; Working on Remote Database Server;

Managing Database and Table Structures in SQL/MySQL

• MySQL Intro – How, when and where to use MySQL
• MySQL Connect – How to get connected to MySQL
• CREATE Database – How to Create Database
• DROP Database – How to Drop a Database
• KEYS– Use and Importance of Primary and Unique Key in Database
• NULL & NOT NULL – Importance & Contradiction of NULL & NOT NULL
• AUTO-INCREMENT – How to Auto-Increment in Database
• DEFAULT – MySQL Default and its use
• DATE – Date, Time and Timestamps in MySQL Database
• CREATE Table – How to Create Table using MySQL Query and SQLYog
• ALTER Table – How to Alter Table using MySQL Query and SQLYog
• DROP Table – How to Drop Table using MySQL Query  and SQLYog

Advanced Queries using SQL/MySQL

• INSERT INTO – How to insert data in a Data-Tables
• SELECT – How to select and grab Data from Data-Table (In Different Ways)
• WHERE – How to select Data from Database using Conditions
• ORDER BY – How to bring Data from Database in Order
• GROUP BY – Grouping Database outputs from MySQL
• UPDATE – How to Update Data in a Data-Table
• DELETE – How to Delete Data of a Data-Table
• BASIC JOIN – How to use JOIN and the Importance of it in Database
• LEFT JOIN – Use of Left Join and its Practices
• RIGHT JOIN – Use of Right Join and its Practices
• FULL JOIN – Use of Full Join and its Practices
• OUTER JOIN – Use of Outer Join and its Practices

Working with Advanced MySQL

• MySQL Functions – Understanding the Importance of Functions
• Group By, Having, Count Function
• Average, Minimum, Maximum, Sum, Length
• Round, Format, Now Function
• First, Last, Mid Function
• UCase, LCase Function
• Understanding Primary Key, Foreign Key, Reference, and Constrain
• Implementing Relation, and Creating Relational Database
• Creating Database of an E-Commerce Website
• Upload Database on Real Server (cPanel/PhpMyAdmin)