MYSQL
Description
If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable.
MySQL provides an implementation of a SQL database very well suited for small to medium web pages. SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. It is an essential part of almost every open source PHP application.
It is used to create, modify and extract data from the relational database, as well as control user access to the database. It is used by many database-driven web applications and is also used by many popular websites.
This course helps new and intermediate level
database programmers understand how to set up MySQL.
What will you learn
-
You will learn the basic install procedures for MySQL.
-
You will learn the types of databases and how to design them.
-
You can Understand SQL syntax used with MySQL.
-
You will learn how to retrieve and manipulate data from one or more tables.
-
You can understand the advantages of stored procedures along with storing data using variables and functions.
Requirements
- SQL doesn't require any prior programming knowledge.
- SQL developers can benefit from having experience with JavaScript, PHP and C#.
Lessons
- 10 Lessons
- 01:56:29 Hours
- Lesson 1 : Introduction, Introduction to MySQL Databases. 00:03:09
- Lesson 2 : Installation & Administration , Installing MySQL in local Server, Administrating through command line and GUI.00:09:39
- Lesson 3 : Basics, Basics of MySQL Environment.00:09:48
- Lesson 4 : MySQL Tables and Terms, MySQL Terminologies (DB, Table,Attribute,etc.).00:10:57
- Lesson 5 : MySQL Queries, Table Creation, Deletion, Updating Queries. 00:21:58
- Lesson 6 : Queries (cond...) , Sorting Result, Table joins, Limit data, Randam data. 00:14:02
- Lesson 7 : MySQL in PHP, Using MySQL in PHP.00:05:53
- Lesson 8 : Working with PHP & MySQL, Connecting MySQL DB from PHP , Executing Queries from PHP. 00:11:58
- Lesson 9 : Sample Project , Login and Registration Form, Creating Login and Registration , -form using PHP and MySQL. 00:29:05
- MYSQL : Assessment
About instructor
Reviews