SQL stands for Structured Query Language. SQL is a standard language that was designed to query and manage data in relational database management systems (RDBMS). An RDBMS is a database management system that is used today in every type of desktop or web-based application.
MySQL is one of the most popular RDBMS used today and a solid understanding of SQL is critical if you want to have a successful career in web development.
This course is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, students will understand SQL functions, join techniques, database objects and be able to write queries and stored procedures.
24 Hrs.
Fundamentals of MySQL
Audience Profile
Any beginner who wants to learn database and SQL statements.
Prerequisite
No prerequisites for this course.
Course Objectives
Android course provide a step-by-step structured training to build Android applications, secure them, and finally publish them to the Google play store and start making profits for personal and business applications.
Overview of MySQL and phpMyAdmin
Understand basic concepts of how a database stores information via tables
Understanding of SQL syntax used with MySQL
Learn how to retrieve and manipulate data from one or more tables
Know how to filter data based upon multiple conditions
Updating and inserting data into existing tables
Learning how the relationships between tables will affect the SQL.
The advantages of store procedures with storing data using variables and functions.