In last lesson we created "sport" database and added three tables (countries, sports and teams). Furthermore we created links between tables with foreign keys. But we didn't take into consideration one problem - how we can to delete or update data in these tables. In...
In this lesson we will consider links between tables, types these links and foreign keys. Links between tables need for quickly getting data. Let's imagine, you are in the shop and would like to buy fruits. If all fruits will be in one box you will need more time to...
Today in 10:30 pm we'll record our new stream. Beginning of this live stream we'll begin to develop e-commerce. Today we'll make technical task.
Besides my lessons we with my colleague began to make streams. We have already made three "MySQL. Database architecture" streams. New streams will be soon. Leave comments and wishes. Subscribe to youtube channel.
In this lesson we'll continue to learn MySQL - we will consider adding data with MySQL and modifying structure of table. In last lesson we created database and table in this database First of all we will add two columns in our table. For this purpose MySQL has got...
Starting from this lesson we begin to learn mysql database management system and SQL (structure query language). Today we start from basics. Database is complex data which stores in a certain way for further search and management this data. Database management system...
In our stream we will begin to design e-shop database. First of all we will create scheme and then create tables.