Home
Videos uploaded by user “PhpSword”
Download & Install MySQL 8.0.11 on Windows 10 Operating System
 
16:34
Watch the step by step video tutorial to to download & install MySQL 8.0.11 database server on Windows 10 Operating System. Course Link: https://www.udemy.com/sql-tutorial-learn-sql-with-mysql-database-beginner2expert/?couponCode=YT_SQL MySQL Installer 8.0.11 download page for Windows https://dev.mysql.com/downloads/mysql/ MySQL Installer 8.0.11 direct download link for Windows https://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-8.0.11.0.msi Microsoft Visual Studio 2015 Redistributable Package https://www.microsoft.com/en-in/download/details.aspx?id=48145 If you have any question or suggestion or encounter error while installing the MySQL database server, feel free to post your comments. Thanks again for watching the video :-)
Views: 78485 PhpSword
MySQL Workbench: Understand What is MySQL Workbench?
 
05:15
MySQL Workbench is a unified visual tool for database architects, developers, and Database Administrators. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available for all major operating systems like Windows, Linux and Mac OS X. Download and install MySQL Workbench from the following link. https://www.mysql.com/products/workbench/ Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 25718 PhpSword
Learn How to Install MySQL Database Server on Windows Operating System
 
13:32
Learn How to Install MySQL Database Server on Windows Operating System. To practically write and execute the SQL commands, we will require MySQL database server installed on our local computer. In this video, we will learn how to download and install MySQL database server on a computer running windows operating system. In my case, I'm using Windows 7 64 bit operating system. You may be using a different version of windows like Windows 8 or Windows 10. Whichever windows version you may be using the installation steps will be similar. Download MySQL Database Server Software from following link and follow the steps given in this video for the installation. http://dev.mysql.com/downloads/mysql/ Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 28598 PhpSword
MySQL Workbench Add User and Connect to Database
 
04:21
Learn how to add a new user and connect to the database using MySQL workbench. Open MySQL Workbench tool and load MySQL connection window from top menu Database and Connect to Database. Use Hostname, port number, 'root' username, click OK and enter the 'root' username password to connect to database server. Once we are logged in to the database server, in the left hand column window, under 'Management' menu, there is a link for 'Users and Privileges' window. Open the 'Users and Privileges' window. Click the bottom 'Add Account' button to add a new user, which opens a new window to enter new user details. Fill out the details and click 'apply' button to save the new user. Close the active session by clicking this cross icon, and now connect to the database server again using the new user details. Enter new user information, press OK and enter the new user password. If you successfully logged in to to MySQL database server, you will see MySQL Workbench default window. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 39752 PhpSword
How to Uninstall or Remove the Software Applications from Mac OS X operating System
 
04:34
In this video tutorial we will learn how to uninstall or remove the software applications from Mac OS X operating system. Most of the users directly delete the shortcut icon or application folder to remove the application from Mac OS X, which is not a proper way to uninstall the application as in that method not all the system files are removed from the your computer. This video guide will help you to systematically remove all the application files and system files associated with it. Before you uninstall any application, make sure its not currently used. Also disable any background instances of the application. Select "Go" menu and open applications folder. In the top right hand corner "search bar" search for the application name you want to uninstall. To search all the system files, click this "Plus" icon just bellow the "search bar". It will open advanced search bar with a couple of drop-down options. From first drop-down option select "Other" and in this popup window search for "system files". Select the "system files" search attribute and press OK. Now in second drop-down option change from "aren't included" to "are included". Once you select this option, the operating system will show you all the system files associated with the application. Now select all the files and move to trash. This is the proper way to uninstall the software application files and all the system files associated with it. If you have any question, suggestion or feedback feel free to write in the comments. Subscribe to PhpSword Channel using following Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Learn How To Install MAC X Mavericks Operating System https://www.youtube.com/watch?v=BPMtOBDbFNE Learn How To Install Linux Ubuntu 14.04 LTS https://www.youtube.com/watch?v=1BG0O5ZyNoQ Learn how to install WordPress 4.3.1 on local server https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1 If you find this video helpful, please like the video and subscribe to my channel. Thank You!
Views: 4136 PhpSword
Fix Linux Ubuntu 14.04 Small Screen Resolution Problem on Virtualbox
 
06:45
In this video tutorial we will learn how to fix Linux Ubuntu 14.04 small screen resolution problem on Oracle VM Virtualbox (Virtual Machine) on your local computer. Follow the tips given in this video guide step by step and you will be able increase resolution for your Linux Ubuntu on Virtualbox on your PC. After installation of Linux on Virtualbox most of the user will see the Linux loading inside a small window. Even you view full screen the window doesn't fix the full screen resolution. To fix this issue you will have to install some Virtualbox drivers on your Ubuntu operating. Once the drivers are successfully installed, you can increase the screen resolution to full screen mode to your choice. If you have question suggestion feel free to ask me in the comments. If you find this video helpful, please like and subscribe the my channel. PhpSword Channel Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Install Oracle VM Virtualbox https://www.youtube.com/watch?v=U725obClnqE Linux Ubuntu 14.04 LTS Installation: https://www.youtube.com/watch?v=1BG0O5ZyNoQ Learn how to install WordPress 4.3.1 on local server https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1
Views: 15275 PhpSword
MySQL Workbench Database Export and Import
 
08:08
Learn Database Export and Import using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In previous couple of videos we learned how to Create, Alter, Drop Databases and Tables and also how to Insert, Read, Update, Delete data rows using MySQL Workbench. In this lecture we will learn how to Export and Import the database using MySQL Workbench. First of all to Export the databases or tables, from top menu 'Server' select 'Data Export' Option, which opens a new window of data export settings and options. The left section on the window displays all the existing databases on our MySQL database server. When we select a database by clicking on it, it displays all the respected tables under the selected database. We can select one or multiple database check-boxes to include the database in the Export file. Under 'Export Options' section, You can change the default export path of you choice. I'll keep the default one. By selecting first option that is 'Export to Dump Project Folder'. MySQL Workbench will save the save all tables as separate SQL file under one folder. Which is useful when you will be importing or restoring the export file one by one table. I'll go ahead quickly and first save as 'Export to Dump Project Folder', MySQL Workbench displays the progress bar and log. Now, I'll again export the database using 'Export to Self-contained File' option. To demonstrate the import first I'll delete the existing 'students' table under 'mytestdb' database. Display database details by clicking on 'i' symbol, select 'tables' tab. Select and right click 'students' table, and click 'Drop Table' option, confirm and delete the table. Click 'refresh' to update the tables section and we have no table in our 'mytestdb' database. Now select the database and from 'data import' window, select 'import from dump folder. 'Load folder contents' and select only 'mytestdb' database and click start import button to import 'students' table again. Go to 'mytestdb' database information window again and click 'refresh' button to reload table list again. and the 'students' table is back. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 102990 PhpSword
Learn how to configure Bitnami WAMP Stack
 
15:21
In previous video tutorial we successfully installed Bitnami WAMP stack (All in one) easy to install package. Though by default Bitnami installer sets all the components configuration, it is better to understand where the configuration files are located and how we can manipulate various settings. In this tutorial we will learn where to find and edit Apache httpd.conf file, MySQL my.ini and PHPs php.ini file. You can enable error reporting, enable disable modules and extensions and more by following the steps given in this tutorial.
Views: 4473 PhpSword
MySQL Workbench Create, Alter, Drop Database
 
03:39
Learn How to Create, Alter and Drop database using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In the left hand column window, under 'Schemas' menu, To create a new database, right click the 'schemas' area and select 'Create Schema' menu. OR from the top window toolbars, select this 'database' icon. In new schema window screen enter the new database name. Click 'apply' button which pops up a SQL script window. Click apply and finish to create the new database. Select the new database and click this 'i' alphabet icon to display more information about the database. The information window displays several tabs like tables, columns, function and also the users who can access the database from 'Grants' tab. MySQL Workbench does not provide any option to rename the 'database name' but we can CREATE, UPDATE OR DELETE tables and data rows using MySQL Workbench tool. To drop a database, select the database name, from under 'Schemas' menu, right click and select drop schema option. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 11032 PhpSword
Learn How to Add Data Rows in a Table using SQL
 
06:05
Learn about using INSERT INTO SQL statements. The INSERT INTO statement is used to insert or add new data rows in a table. There are two methods to INSERT the data rows in a table. In First method, column names are not specified and the values are given in a bracket separated by a comma. In this method the values for each column must be specified and the values should be provided sequentially by columns. "INSERT INTO tablename VALUES (value1, value2, value3);" In second method, the column names are given in first bracket and the values are given in another bracket. In this method we can INSERT values to only selected column names. This is the convenient way to store the data rows, as we can see which value is going to be stored in which column. "INSERT INTO tablename (column1, column2, column3) VALUES (value1, value2, value3);" While using INSERT INTO statement the string values must be wrapped in single quotes, while wrapping numeric values in quotes is optional or not required. I'll select the "school" database, "USE school;" I'll run a simple SQL statement to display all the data rows in teachers table using SQL statement, "SELECT * FROM teachers;" Add new data row using SQL statement, "INSERT INTO teachers VALUES (NULL, 'Peter Brown', 1234509876);" In this INSERT INTO SQL statement, column names are not specified. Since, the teacherid column is auto increment that is it will automatically add the next number for the data row, we provided the 'NULL' value means no value for that column. Press enter to execute the SQL statement. If you see the message, "Query OK, 1 row affected", it means the data row was successfully inserted to the table. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 5900 PhpSword
Learn What is SQL? Introduction to SQL
 
02:24
In this video we will learn What is SQL? and a brief Introduction to SQL. The full form of SQL is "Structured Query Language". web applications, desktop applications and also mobile applications developed in PHP, ASP, Perl, C, JAVA, .NET etc. use databases to store application information and SQL is the language to communicate with those databases. SQL is used by all major database systems like MySQL, PostgreSQL, SQL Server, DB2, Oracle etc. SQL was initially developed at IBM by Donald Chamberlin and Raymond Boyce. It was initially called "Structured English Query Language" (SEQUEL) and pronounced as "sequel". SQL is ANSI standard (American National Standards Institute) standard. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 23241 PhpSword
MySQL Workbench Create, Alter, Drop Table
 
07:35
Learn How to Create, Alter, Drop database tables using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. Under 'schema' menu, double click to select the newly created database in my case 'mytestdb', it display the submenu under the database. The submenu contains, the tables, views, stored procedures, function stored under the selected database. At this moment we've just created the database so there are no tables or other information stored in it. Select 'Tables' submenu, right click on it and select 'create table' option, We can also click this top menu 'create new table' icon to create a new table under the selected database. By clicking the 'create table' link or icon open a new screen to enter the database table details. Click inside the middle window and type column name. Lets create the students table here which we saw in practical examples. Click apply button to save the changes, it opens 'SQL statement' window, and click 'apply' button to execute the statement and finish to save the changes. Now under schemas menu, under the selected database, the 'Tables' link will contain the newly created table. We can select the table name to open the table details screen. On this screen, we can modify the column name, data type and other table settings from here. To delete the table, simply select the table name, right click on it, and select 'drop table' option. On confirmation window, select 'drop now' option to instantly delete the table from the database. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 18763 PhpSword
How to install use and setup virtual machine using Oracle VM VirtualBox
 
07:53
In this video tutorial, we will learn how to install Oracle VM VirtualBox on Windows 7. We will also learn how to use and setup a virtual machine using Oracle VM VirtualBox. VirtualBox lets you create a virtual computer where you can install any operating system. While installation you can set RAM and harddisk size for your virtual PC. When the new machine is created its blank with no operating system. Make sure you have downloaded the bootable image file of the operating system you are going to install. Start virtual machine and select the bootable image of the operating system and run the operating system installer. The operating system installation are same you do on your physical computer. Oracle VM VirtualBox is really a nice softaware for developers to test their applications or several different operating system. You can download the latest release of VirtualBox from the following official download link link. https://www.virtualbox.org/wiki/Downloads
Views: 714 PhpSword
Learn How to Use INSERT INTO SELECT Statement in SQL
 
06:11
Learn about using INSERT INTO SELECT statement. In SQL we can copy the data rows from one table to another table. The INSERT INTO SELECT statement copies the data rows from one table and inserts into an existing table. Both actions are executed in a single SQL statement. The source table and target table must have similar table definition that is the same columns with same data types. Any existing data rows or records in target table remain unaffected. Here are the examples showing use of INSERT INTO SELECT statements, "INSERT INTO targetTable SELECT * FROM sourceTable;" "INSERT INTO targetTable (column1, column2) SELECT column1, column2 FROM sourceTable;" We can copy all columns or specified columns from source table to target table. Select the "school" database, "USE school;" First, lets create a new students table which will act as as target table to store the data rows. "CREATE TABLE students2 ( studentid INT PRIMARY KEY AUTO_INCREMENT, firstname VARCHAR(40) NOT NULL, lastname VARCHAR(40) NOT NULL, class VARCHAR(20), age INT );" Hit enter to create the table. Lets populate the 'students2' table from source table 'students' using INSERT INTO SELECT statement. The SQL statement will be, "INSERT INTO students2 SELECT * FROM students;" Lets get the data rows from 'students2' table, "SELECT * FROM students2;" And we have data rows in our new 'students2' table. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 9694 PhpSword
How to Remove Mysites123.com Browser Malware from Google Chrome, Mozilla Firefox & Internet Explorer
 
08:46
Mysites123.com is a browser hijacker Malware which redirects your web browsers to mysites123.com or any other unknown URLs. The web browsers like Internet Explorer, Mozilla Firefox, Google Chrome are affected by this malicious software. This malware also installs some background application which corrupts the proper functionality of your computer. It also pops up unknown advertises in the web browsers. In this video, we will learn how to remove Mysites123.com virus completely from your web browsers and computer. We will reset Internet Explorer, Mozilla Firefox, Google Chrome to default settings. We will also uninstall any malicious software from the computer and reset registry settings. By following the steps inside these video you will be able to restore your computer to previous safe and secure state.
Views: 4890 PhpSword
Learn How to Delete or Remove Database using SQL
 
02:58
Learn how to remove or delete a database from the database management system using SQL statement. Using standard SQL we can create as as well as remove the database from our database management system. The DROP DATABASE SQL statement is used to remove or delete the database including all the tables and data rows in it. Be careful before deleting the database completely from your database management system because the system does not ask for confirmation. As soon as you run the SQL DROP DATABASE statement, the system will remove the database, tables and data rows instantly and there is no easy method to recover the lost database. Here is the SQL statement to delete the database. "DROP databasename;". First of all lets display all the existing databases using SQL statement, "SHOW DATABASES;" The system displays all the available database. In previous lecture we created 2 databases called '1234d' and 'my_database'. Lets delete the database '1234d', The SQL statement will be, "DROP DATABASE 1234d;" and we get 'Query OK, 0 rows affected' message Now, if display all the existing databases using SQL statement, "SHOW DATABASES;" the database '1234d' is gone. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 1607 PhpSword
Learn how to setup a local development server by installing Bitnami WAMP Stack
 
09:44
Local development server is your computer on which you install all the necessary components to create and test your software codes. If you are a PHP or WordPress developer or using any PHP based CMS (content management system) to develop web applications, it is good practice to have your own local development server to test your application before uploading it to live server. By installing WAMP, you can easily make your windows computer a local development environment. In this video tutorial, we are going to install WAMP stack version 5.5.30 developed by Bitnami. Download WAMP stack installer from the following link https://bitnami.com/stack/wamp
Views: 3797 PhpSword
MySQL Workbench Insert, Read, Update, Delete Data Rows
 
04:20
Learn How to Insert, Read, Update and Delete the data rows using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In previous video we successfully created a test database called 'mytestdb' and 'students' table using MySQL Workbench. In this video we will see how to insert, update or delete data rows in our 'students' table. Under schemas menu, select the database name, tables, and table name we created in previous lecture that is 'students' table. When we hover the mouse pointer, over the 'student' table name, we can see a table icon appears. Click the table icon, which open a new window, in which the upper section shows the MySQL statement, while the lower section show the data rows. At this moment, we have no data row in the 'student' table. So the table shows NULL data row values. To enter a new data row, just select the respected column and type the data value. Its something similar to Microsoft Excel spreadsheet. I'll enter data rows, click 'apply' to generate SQL statement, click apply and finish to execute the statement and save the changes. Similarly, we can edit the data row, save new value and apply the changes, which will generate an update SQL statement and save the changes to the database table. To delete an individual row from the table, select the data row, right click the 'right icon' in-front of the row and select 'delete row' option. Click 'apply' button to execute the SQL statement and save the changes to the database table. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 35370 PhpSword
Learn How to Select and Use Existing Database using SQL
 
02:46
Learn how to Select and use existing database in SQL. After creating the databases successfully, The user must select the database before creating new tables or return the data rows from existing tables. Selecting the desired database is really important because multiple databases may contain, similar table names. And its difficult for SQL statement to figure out the exact database and its table. The database is selected by using USE statement. Here is the SQL statement to select the database. "USE databasename;" lets display all the existing databases using SQL statement, "SHOW DATABASES;". The system displays all the available database. Now, select the company database using SQL statement, "USE company;" Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 1085 PhpSword
Learn What is Database? How to Create and Show Databases using SQL
 
04:12
Learn What is Database? How to Create and Show Databases using SQL. The structured query language is all about databases. Therefore, we must first understand what a database is? The database is a structured set of information or data organized in such a way that a computer program can quickly access, manage and update it. In other words, Database is a collection of one or more tables and the tables contain data "rows" or "records". The SQL statement to display an existing databases is, "SHOW DATABASES;" The SQL statement to create a new database is, "CREATE DATABASE school;" Where "school" is the new database name. To use a database the SQL statement is again very simple, "USE school;" Where "school" is an existing database name. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 1157 PhpSword
Learn How to Modify or Update Database Table using SQL
 
06:11
Learn how to modify or update the database table details using SQL statement. The ALTER TABLE statement is used to rename, add or drop table columns in the existing database table. To rename the table we use, "ALTER TABLE oldtablename RENAME newtablename;" To add a new column in the existing table we can use, "ALTER TABLE tablename ADD columnname datatype" To modify the column data type in the existing table we can use, "ALTER TABLE tablename MODIFY COLUMN columnname datatype" And to drop a column from the existing table we use, "ALTER TABLE tablename DROP COLUMN columnname" Select 'school' database, "USE school;" and display all the tables in 'school' database using SQL statement, "SHOW TABLES;" Rename previously created table 'students3' to 'students4', The SQL statement will be, "ALTER TABLE students3 RENAME students4;" Lets add one more column to store students last name. The SQL statement will be, "ALTER TABLE students4 ADD lastname VARCHAR(10);" Modify the column data type by using ALTER TABLE statement like, "ALTER TABLE students4 MODIFY COLUMN lastname VARCHAR(20);" Drop the column, by using ALTER TABLE statement like, "ALTER TABLE students4 DROP COLUMN lastname;" Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 4875 PhpSword
Setup a local development server by installing Apache, MySQL, PHP and PhpMyadmin Part 2
 
16:01
This is the second part of "Setup a local development server by installing Apache, MySQL, PHP and PhpMyadmin". If you missed watching the first part please check the first part here https://www.youtube.com/watch?v=JUUIwlCmYGo and follow along the steps given in first part to continue with this video. In first part we downloaded all the packages and successfully installed Visual C++ Redistributable for Visual Studio 2012, MySQL Database Server and Apache web server. In this tutorial we are going to install PHP and PhpMyadmin and do some basic configuration so that all packages work together as a local development server to run PHP web applications. Here are the links to download the installer and zip packages once again: Visual C++ Redistributable for Visual Studio 2012: http://www.microsoft.com/en-us/download/details.aspx?id=30679 PHP: http://php.net/ and http://windows.php.net/download/ Apache Web Server: http://www.apachelounge.com/download/ MySQL Database Server: http://dev.mysql.com/downloads/mysql/ PhpMyAdmin: https://www.phpmyadmin.net/
Views: 234 PhpSword
Learn How to Update Data Rows using Update Statement in SQL
 
07:11
Learn about using UPDATE statement in SQL. As the name suggests UPDATE statement is used to update the data rows in a table. The UPDATE statement can update one or multiple column values in single SQL statement. WHERE clause is used to specify the data row to be updated. UPDATE statement without WHERE clause will update all the data rows in the table. Any existing data rows or records in target table remain unaffected. Here are the examples UPDATE statements, UPDATE tablename SET column1 = newvalue; UPDATE tablename SET column1 = newvalue1, column2 = newvalue2 WHERE columnid = 3; Select the "school" database, "USE school;" Run a simple SQL statement to display all the data rows in students table using SQL statement, "SELECT * FROM students;" Here in this result set, take a look at studentid 1. Suppose we have accidentally added this student record under class first instead of second. And now we are going to update this row to change the class value from 'First' to 'Second'. We will use the SQL statement, "UPDATE students SET class = 'Second' WHERE studentid = 1;" Press enter to execute the statement and display all the data rows in 'students' table, "SELECT * FROM students;" And sure enough the class value for studentid 1 is changed from 'First' to 'Second'. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 11711 PhpSword
Learn What is Database Table? How to Create a Database Table using SQL?
 
03:42
Learn how to create the database table using SQL statement. The CREATE TABLE statement is used to create a database table. A valid database table name may contain only letters, numbers and underscore symbol. The database table names are case insensitive. That is table name 'students' (all small letters) is similar to the table name 'StuDenTs' (the letters S, D and T are capital). A single database must contain a unique table name, while in multiple databases, the same table name can exist in another database. The SQL statement to create new database table is, CREATE TABLE tablename ( columnname1 datatype, columnname2 datatype ); Select 'school' database, "USE school;" create a new table called 'students3' with only 2 columns, studentid and firstname. The SQL statement will be, CREATE TABLE students3 ( studentid SMALLINT(5), firstname VARCHAR(20) ); If we display all the tables, "SHOW TABLES;". We can see the new table named 'students3' is successfully created. We can display the information about table structure by using SQL statement, "DESCRIBE students3;" OR "EXPLAIN students3;" Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 1098 PhpSword
Learn How to Delete Data Rows using Delete Statement in SQL
 
03:39
In this lecture we will learn about using DELETE statement in SQL. As the name suggests DELETE statement is used to delete the data rows in a table. The DELETE statement can delete one or multiple data rows from a table. WHERE clause is used to specify the data row to be deleted. DELETE statement without WHERE clause will delete all the data rows in the table. Here are the examples DELETE statements, DELETE FROM tablename; DELETE FROM tablename WHERE column1 = value; Select the "school" database, "USE school;" Run a simple SQL statement to display all the data rows in students2 table using SQL statement, "SELECT * FROM students2;" Currently the 'students2' table have 58 data rows. Lets delete a data record having studentid 6; The SQL statement will be, "DELETE FROM students2 WHERE studentid = 6;" Now if we run the SQL statement again to display all the data rows in 'students2' table, "ELECT * FROM students2;" You can see the studentid 6 is gone. and total data rows are 57. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 2047 PhpSword
Fix MAC X Mavericks Small Screen Resolution Problem on Virtualbox
 
08:32
In this video tutorial we will learn how to fix Macintosh X Mavericks Operating small screen resolution problem on Oracle VM Virtualbox (Virtual Machine) on your local computer. Follow the tips given in this video guide step by step and you will be able increase resolution for your MAC OS X Mavericks on Virtualbox on your PC. After installation of MAC X on Virtualbox most of the user will see the Macintosh X loading inside a small window. Even you view full screen the window doesn't fix the full screen resolution problem. To fix this issue you will have to install some Virtualbox drivers on your MacX operating System. Also customize some system files. Once the drivers are successfully installed, you can increase the screen resolution to full screen mode of your choice. If you have question suggestion feel free to ask me in the comments. If you find this video helpful, please like and subscribe the my channel. PhpSword Channel Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Install Oracle VM Virtualbox https://www.youtube.com/watch?v=U725obClnqE Install MAC X Mavericks Operating System https://www.youtube.com/watch?v=BPMtOBDbFNE Linux Ubuntu 14.04 LTS Installation: https://www.youtube.com/watch?v=1BG0O5ZyNoQ Learn how to install WordPress 4.3.1 on local server https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1
Views: 1438 PhpSword
Learn How To Install MAC X Mavericks Operating System on Windows 7 using VM Virtualbox
 
15:29
In this video tutorial we will learn how to download and install MAC X Mavericks OS on Oracle VM Virtualbox (Virtual Machine) on your local computer. Follow this MAC OS X installation video guide step by step and you will be able to setup Macintosh Operating system on you windows PC. First thing first, make sure you have Oracle VM Virtualbox successfully installed and running on your windows computer. If you have not yet installed Virtualbox check the following link to install Virtualbox on your windows computer. Install Oracle VM Virtualbox https://www.youtube.com/watch?v=U725obClnqE Once you are running your virtual computer follow the steps given in this video tutorial. If you have question suggestion feel free to ask me in the comments. If you find this video helpful, please like and subscribe the my channel. PhpSword Channel Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Learn how to install WordPress 4.3.1 on local server https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1
Views: 272 PhpSword
Learn how to install WordPress 4.3.1 on local server
 
11:01
Installing WordPress on local development server or live production server is extremely easy. Before starting the WordPress installation, make sure you followed the steps in the first video. I assume you successfully installed WAMP on your computer and have active local development environment. In this video tutorial we are going to download and install WordPress version 4.3.1 on our local server. Please visit https://wordpress.org/download/ to download official latest stable release of WordPress (Version 4.3.1).
Views: 490 PhpSword
Setup a local development server by installing Apache, MySQL, PHP and PhpMyadmin Part 1
 
19:22
In previous video tutorials we installed Bitnami WAMP stack (All in one) easy to install package. In this video tutorial we will install Apache, MySQL, PHP and PhpMyadmin individually and configure to run together to work as a local development environment. This installation method is bit lengthy and difficult compared to Bitnami WAMP stack installation. For those who already installed local server using Bitnami WAMP stack can skip this video and goto next video. If you already installed Bitnami and still want to follow the steps, please make sure you uninstall previous WAMP installation. Download the installer and zip packages from following links: Visual C++ Redistributable for Visual Studio 2012: http://www.microsoft.com/en-us/download/details.aspx?id=30679 PHP: http://php.net/ and http://windows.php.net/download/ Apache Web Server: http://www.apachelounge.com/download/ MySQL Database Server: http://dev.mysql.com/downloads/mysql/ PhpMyAdmin: https://www.phpmyadmin.net/
Views: 558 PhpSword
Learn How to Delete or Remove Database Table using SQL
 
02:17
Learn how to Remove or delete the existing table using SQL statement. Using standard SQL we can create as as well as remove the database table from our existing database. The DROP TABLE SQL statement is used to remove or delete the database table including all data rows in it. Be careful before deleting the database table completely from your database because the system does not ask for confirmation. As soon as you run the DROP TABLE statement, the system will delete the database table and the data rows instantly, and there is no easy method to recover the lost database table. Here is the SQL statement to delete the database table, "DROP TABLE tablename;" Select 'school' database, "USE school;" And display all the tables in 'school' database by using SQL statement, "SHOW TABLES;" The system returns all the table names stored in the selected database. In previous lecture we created a table named 'students4'. Lets delete the table. The SQL statement will be, "DROP TABLE students4;" Press enter to execute the SQL statement, and we get 'Query OK, 0 rows affected' message. If we now display all the tables, "SHOW TABLES;" We can see the 'students4' is deleted successfully. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Views: 3454 PhpSword
Learn How To Install Linux Ubuntu 14.04 LTS on Virtualbox
 
13:11
In this video tutorial we will learn how to install Linux Ubuntu 14.04 LTS on Oracle VM Virtualbox (Virtual Machine) on your local computer. Follow this Linux installation video guide step by step and you will be able to setup Linux Ubuntu Operating system on you PC. Check the following link in order to download the latest version of Ubuntu ISO image. If you are using RAM less than 2GB download 32bit version otherwise you can go for 64bit version. http://www.ubuntu.com/download/desktop If you have question suggestion feel free to ask me in the comments. If you find this video helpful, please like and subscribe the my channel. PhpSword Channel Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Install Oracle VM Virtualbox https://www.youtube.com/watch?v=U725obClnqE Learn how to install WordPress 4.3.1 on local server https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1
Views: 167 PhpSword
WordPress 4.4: Learn How To Download & Install WordPress 4.4 on Local Development Server
 
17:00
This video shows step by step guide to download and install WordPress 4.4 on your local development server. Also we will review the new features in the newer released version. From the following link you can download new and stable release of WordPress. https://wordpress.org/download/ Once you download the zip file. Extract the folder and upload it on your server. Create a new MySQL database on your server. You can either enter the database details in config file or run the WordPress installer and enter database details in the given input fields. WordPress 4.4 have default Twenty Sixteen theme. It make images responsive depending on a variety of conditions like screen size, view-port size, and screen resolution. The new WordPress can now embed rich content from nearly all sites that support the oEmbed standard. The core files have improved REST API, Term Metadata Improved title output, Comments and so on. The function wp_title() is now deprecated. Check the following link to read more about new features and changes in new released version. https://wordpress.org/news/2015/10/wordpress-4-4-beta-1/ If you have question suggestion feel free to ask me in the comments. If you find this video helpful, please like and subscribe my channel. PhpSword Channel Link https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw Install Oracle VM Virtualbox https://www.youtube.com/watch?v=U725obClnqE How To Install MAC X Mavericks https://www.youtube.com/watch?v=BPMtOBDbFNE Install Linux Ubuntu 14.04LTS https://www.youtube.com/watch?v=1BG0O5ZyNoQ Learn how to install WordPress 4.3.1 https://www.youtube.com/watch?v=sUimSCMmblk Learn PHP MySQL https://www.youtube.com/playlist?list=PLhwzZMYRiUEpQGGfxMJMj5dAeSyv6aUZ1
Views: 4772 PhpSword
Configure Apache, MySQL, PHP and PhpMyadmin for local server
 
14:02
In previous 2 videos we successfully installed Visual C++ Redistributable for Visual Studio 2012, MySQL Database Server and Apache web server, PHP and PhpMyadmin as individual packages. In this video we will see how to access & modify configuration files for Apache, PHP, MySQL and PhpMyAdmin. We will also learn how to enable or disable some PHP extensions. In Apache, configuration settings are stored in httpd.conf file inside conf folder. For PHP you can change the configuration from php.ini and for MySQL my.ini If you have any question feel free to ask my in comments section.
Views: 667 PhpSword

International sales coordinator cover letter
Accenture internship cover letter
Vthumb application letters
Uk passport cover letter
The tell tale heart annotated bibliography