In last lessons we were learning frontend. But web site is not only design. We do different actions in sites - search, filter data and so on. This actions are made with programming (backend). This part is hidden for the site visitors. It is realized by backend...
Tutorials
MySQL. Links between tables. JOIN operator
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...
MySQL. Links between tables. Foreign keys
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...
API VKontakte. Get access token
In this lesson we will finish introductory series of lessons with api VKontakte work. We'll consider necessity and getting access token procedure. While api making requests some methods return only public data. For example, users.get method returns only first_name,...
Developing e-commerce from scratch. Create technical task
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.
MySQL. Database architecture stream.
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.
MySQL. Add and modify table and data
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...
Intro to MySQL
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...
JavaScript. Intro to objects
I continue to consider your comments on my youtube channel and today I pay attention to 39th lesson, which one of you asked me to tell about prototype. But it is not correct to tell about it now. First of all it has the meaning to consider the concept of objects in...