Your First Application using MySQL and PHP

Now that Myflixdb, what's next? Congratulations for your successful completion of the SQL tutorial series. We looked at how we can design a database from scratch, the relational database management system model among others, MySQL as a database management system and how it implements the SQL language, what tools are available for us to use in the database design phase, SQL development and MySQL server administration such as MySQL workbench...

Read More

MySQL Index Tutorial - Create, Add & Drop

What are Index? Nobody likes slow systems. High system performance is of prime importance in almost all database systems . Most businesses invest heavily in hardware so that data retrievals and manipulations can be faster. But there is limit to hardware investments a business can make.  Optimizing your database is a cheaper and better solution. Towards this end we can use INDEXES. The slowness in the response time is usually due...

Read More

Views in MySQL Tutorial: Create, Join & Drop with Examples

What are views? Simply put, VIEWS are virtual tables .By virtual, we mean, the tables do not store any data of their own but display data stored in other tables. In other words, VIEWS are nothing but SELECT Queries. Views syntax Let's now look at the basic syntax used to create a view in MySQL. CREATE VIEW `view_name` AS SELECT statement; WHERE "CREATE VIEW `view_name`" tells MySQL server to create a view object in the database...

Read More

MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS

What are JOINS? Joins help retrieving data from two or more database tables.  The tables are mutually related using primary and foreign keys. Note: JOIN is the most misunderstood topic amongst SQL leaners. For sake of simplicity and ease of understanding , we will be using a new Database to practice sample.  As shown below idfirst_namelast_namemovie_id 1AdamSmith1 2RaviKumar2 3SusanDavidson5 4JennyAdrianna8 6LeePong10 idtitlecategory 1ASSASSIN'S...

Read More