LETVC

In this video, I have explained how to use DISTINCT function in the query to eliminate duplicate rows in the table.

In this video, I have explained how to use BETWEEN and AND condition to check the range between the values in the columns.

In this video, I have explained the queries about how to delete a row in the table.

In this video, I have explained how to update a row in the table. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog                                                 https://www.twitter.com/techyvicky                                                 https://www.pinterest.com/techyvicky/techy-vicky-blog                                                 https://plus.google.com/109896475845510580320/

In this video, I have explained how to insert the row in the table. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog                                                 https://www.twitter.com/techyvicky                                                 https://www.pinterest.com/techyvicky/techy-vicky-blog                                                 https://plus.google.com/109896475845510580320/

In this video, I have explained how to sort the columns with ORDER BY keyword.  It would be very useful when the user is having large number of rows in the table to easily sort out the particular column. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog                                                 https://www.twitter.com/techyvicky                                                 https://www.pinterest.com/techyvicky/techy-vicky-blog                                                 https://plus.google.com/109896475845510580320/

In this video, I have explained how to add_subtract_multiply the two columns from the particular table.

In this video, I have explained to start with simple queries like SELECT * FROM { TABLE NAME }

In this video, I have explained how to create the table names and insert columns in the database under WAMPSERVER. I have provided the download link below for the source files of the sql queries.

In this video, I have explained how to configure the user id and password in WAMP and to access the server and database via MYSQL Workbench. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog                                                 https://www.twitter.com/techyvicky                                                 https://www.pinterest.com/techyvicky/techy-vicky-blog                                                 https://plus.google.com/109896475845510580320/

In this video, I have explained how to install the essentials software and apps such as WAMPSERVER and MYSQL Workbench in the system. WAMPSERVER is an web development environment server and MYSQL Workbench is the client to access the database from the server.

Shiny, sparkly items that reflect light seem like theyd be impossible to capture with watercolor, but thanks to the miracle of masking fluid, theyre a lot easier than you might think. The video is sped up 5x at the beginning, and 8x for most of it, so youll be able to see my process a little easier. Honestly, when I paint something this big and this wet, at least half of my time is spent waiting for it to dry in between glazes.

In this video, I have given the overview of SQL and introduction of the chapter 1.

In this video, I have explained how to recall your gmails.

In this video, I had explained about the computer screen image capture and screen recorder using Jing tool from Techsmith software