Mysql Tutorial Series


How to create tutorial videos for youtube using Mac?

Youtube Videos in fashion Videos monetisation is in fashion right now. Every day we see new youtube stars coming out. You are also interested in creating your own how to videos and want to monetise them, but don't know how to create. So this article will tell you that how you can create screen capturing videos by using your Mac. If you want to see the video you can see How to create tutorial videos for youtube using Mac     Steps to create tutorial videos So let us get started....

Read Full

SQL Overview

SQL stands for Structured Query Language. SQL is a language for Computer to manage, process and retrive large amount of data stored in relational database. By using SQL you can execute queries against database, insert new data, update data, can delete and modify data. SQL queries are classified as Data Definition Language (DDL) The standard for group of commands which are used to define structures in a database are called Data Definition Language (DDL). DDL statements such...

Read Full

SQL RDBMS Concept

RDBMS stands for Relational Database Management System. RDBMS data are stored in database tables, record and fields in structured manner. Each RDBMS table consists of table rows and each row consists of data in the form of fields. RDBMS is collection of data stored in table consisting of rows and columns. RDBMS also provides several operators to define, manipulate the data stored into the tables and indexes. Most RDBMS use SQL as a database query language. Edgar Codd is the one...

Read Full

SQL Syntax

SQL syntax or query follows a particular rules and regulation which are denoted as SQL Syntax. Every SQL starts with standard operators and ends with the semicolon. Some of The Most Important SQL Commands CREATE DATABASE - creates a new database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DROP TABLE - deletes a table INSERT INTO - inserts new data into a database SELECT - retrieves data...

Read Full

MYSQL Create Table Like

Overview Sometimes you can get a requirement where you need to create a new table like an already exiting with different table name. There you can use " create table like " command. Syntax Syntax for create table like command is CREATE TABLE table_name like already_exiting_table_name; CREATE TABLE table_name AS SELECT [COL1, COL2] FROM already_exiting_table_name [WHERE]; Example For ex: If you want to create abc table like hotel_list table...

Read Full