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...
Tutorials
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...
JavaScript. Include script in document
In upcoming lessons I will answer to your questions and comments which you send me on my youtube channel. In this lesson I'll consider js scripts including, function calling from one script to another Scripts work in the order in which they are connected in the...
Javascript. Regular expressions. Part four
This is last lesson which dedicated to regular expressions in javascript. If you didn't see last lessons, I strongly recommended to watch it. In this lesson we'll discuss brackets groups, full text search and variation. part 1 part 2 part 3...