SQL

Key Difference Between SQL and MySQL SQL is a language which is used to operate your database whereas MySQL was one of the first open-source database available in the market SQL is used in the accessing, updating, and manipulation of data in a database while MySQL is an RDBMS that allows keeping the data that…

Now that Myflixdb, what’s next? Congratulations for your success 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…

What is an Index? Indexes in MySQL sort data in an organized sequential way. They are created on the column(s) that will be used to filter the data. Think of an index as an alphabetically sorted list. It is easier to lookup names that have been sorted in alphabetical order than ones that are not…

What are Views in MySQL? VIEWS are virtual tables that do not store any data of their own but display data stored in other tables. In other words, VIEWS are nothing but SQL Queries. A view can contain all or a few rows from a table. A MySQL view can show data from one table…

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…

What is a Union? Unions combine the results from multiple SELECT queries into a consolidated result set. The only requirements for this to work is that the number of columns should be the same from all the SELECT queries which needs to be combined . Suppose we have two tables as follows Let’s now create…

What are sub queries? A sub query is a select query that is contained inside another query. The inner select query is usually used to determine the results of the outer select query. Let’s look into the sub query syntax – A common customer complaint at the MyFlix Video Library is the low number of…