Basic Networking Tips for Network security and Wireless Network:

Basic Networking:A network is a group of Computer,and one to one computer,basic network mean hardware combination match network,like I will share my data others computer this is the more system,

1) Local area connection

2) One to One pc; Cross connection

3) One to multi pc state connection;

This system use in local network,some of the part match hardware,Bios setting,hardwar configaration etc

Basic Network Instrument:basic Network for is most essential

*)  Connector.

*) Cable.

*) Switch.

*) Cater.

*) Tester.

What is Basic Networking Connector:Connector Mean Cable path for cable connectabity,R-j 45 connector.

Type Of Cable:

1)R-j 45 cable.

2)Optical fiber cable.

3)Coaxial cable.

4)Twisted pair cable.

What is Switch: Network Connection Establish For switch use this media for networking.

Networking Type:lots of Networking type

1)Business Networking type.

2)Wireless Networking type.

3)Social Network.

4)software network

5)Security network

6)Ml M Network

Etc………………………….

Types of Wireless Network: wireless net work of definition

This network we use without cable connection just use by Ethernet this is call wireless network

1)Radio communication

2)Television communication

3)satellite communication

4)Rader communication

Computer Networking:this modern it technology is the most important computer network,like lan,man ,wan this is the most popular system for this situation and communication.

Netwriting I will provide step by step Networking system.

Basic Concept for Off page optimization

SEO (Search Engine Optimization)

1. On Page Optimization

2. Off Page Optimization

1. On page Optimization

a) Meta Keyword

b) Meta Description

c) Robots.txt

User-agent: *

Disallow: /

d) Site Map

Go to

http://www.xml-sitemaps.com/

Create Site Map link and download for Html Site

http://medicalstips.blogspot.com/sitemap.xml

Then go to google webmaster tool

and setup the sitemap url and submit.

2. Off Page Optimization

a) Forum Posting

b) Comment Marketing

c) Chat Marketing

d) Email Marketing

e) Group Posting

f) Social Bookmarking

g) Url or Directory Submission

h) Ping

i) Social Media Marketing

Real ON PAGE OPTIMIGATIONN

	ON PAGE OPTIMIGATIONN
1	Title tage
2	Meta Tage ,1=meta keyword 2=Description
3	Robots,txt 1 = Keyword density 2=long tail Keyword 3=h1,h1,h3 , 4=Hyper link anchortag 5 =alternet tag ,6=Image optimization
4	SEF(Search Engin Friendly ) URL
5	Site Mape any kind of search engin

Graphics Design

Important for Wordpress Web site and wordpress tutorial

What is Wordpress:Wordpress is a content mangagement system,you can easy create you on web site by wordpres,and easy handle your plugin;

How I can Install Wordpress:follow step

1) First you create your database

2) create your theme

3) and install your theme in wordpress

Using system:Firste step you should learn customizing sysem then you esyly know your theme option,

Build your on web site:

Firstly we need to install your own personal web server to run Wordpress. Wordpress requires a web server, a MySQL database and the PHP scripting language to run. Installing and configuring these in the past was hard work but there's now an application called WAMP (Windows - Apache - MySQL - PHP) which installs and configures everything to get your own personal web server up and running,learn html css and css3

Normally you'd pay a web host to host your website or blog and they'd provide the web server, database server and scripting but we're going to install our own personal web server so we can do anything we like in our own personal Wordpress test lab at zero cost.

Visit the WAMP site and download the WAMP Server. Once the file has downloaded double-click it to install the WAMP software.

Mysql Advance functoin system step by step list

SQL DML and DDL

SQL can be divided into two parts: The Data Manipulation Language (DML) and the Data Definition Language (DDL).
The query and update commands form the DML part of SQL:

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database

The DDL part of SQL permits database tables to be created or deleted. It also define indexes (keys), specify links between tables, and impose constraints between tables. The most important DDL statements in SQL are:

• 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
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index 

SQL Essential and most popular topic and funstion list:

………SELECT……

1.SELECT * FROM `user` ;

2.SELECT  user_name FROM user;

3.SELECT user_name,user_roll FROM user;

…………DISTINCT……

1. SELECT DISTINCT user_name FROM user;

……………..Combind Distinct…….

1. SELECT DISTINCT user_name,user_roll FROM user

…….WHERE …..

1. SELECT * FROM user WHERE user_name='saiful';

…… AND……

1. SELECT * FROM user WHERE user_name='saiful' AND user_roll='30091';

…… OR….

1. SELECT * FROM user WHERE user_name='saiful' or user_roll='300091';

……..COMBIN AN D & OR…..

1. SELECT * FROM user WHERE user_name='saiful' AND (user_roll='300091' OR user_password='454358');

…….. ASC……..

1. SELECT * FROM user ORDER BY id ASC;

…… DESC……..

1.SELECT * FROM user ORDER BY id  DESC;

…..ORDER BY….

1. SELECT * FROM user ORDER BY user_name;

………ORDER BY DESC…..

1. SELECT * FROM user ORDER BY user_name DESC;

……. LIMIT…….

1. SELECT user_name FROM user LIMIT 3;
2. SELECT * FROM user LIMIT 3;
3. SELECT * FROM accounce ORDER BY O_Id DESC LIMIT 2,4

……. LIKE …..

1. SELECT * FROM user WHERE user_name LIKE 's%'
2. SELECT * FROM user WHERE user_name LIKE '%sai%';
3. SELECT * FROM user WHERE user_name NOT LIKE '%naz%';
4. SELECT * FROM user WHERE user_name LIKE '%ful%';

…… s …..

1. SELECT * FROM user WHERE user_name IN ('rima','nazmul');

……BETWEEN ….

1. SELECT * FROM user WHERE id BETWEEN '1' AND '2';

……..DELETE…..

1. DELETE  FROM user WHERE user_name='saiful' AND user_roll='300091';

…….. LCASE ……

1. SELECT LCASE (user_name) FROM user;

…….UCASE…….

1. SELECT UCASE (user_name)FROM user;

                   ……..MID……

1. SELECT MID(USER_name,1,4) as SmallCity FROM user

                            …… AVG……

1. SELECT AVG (orderprice) AS TOTAL FROM accounce;
2.  SELECT (orderprice) AS total FROM accounce;

…….SUM……..

1. SELECT SUM(orderprice) AS total FROM accounce;
2. SELECT customar FROM accounce
3. WHERE orderprice>(SELECT AVG(orderprice) FROM accounce);

………………COUNT………………………

1. SELECT COUNT(orderprice)FROM accounce;
2. SELECT COUNT(DISTINCT orderprice) FROM accounce;
3. SELECT COUNT(customar) AS customarsaiful FROM accounce WHERE customar='saiful';
4. SELECT COUNT(*) AS NumberOfOrders FROM accounce;
5. SELECT COUNT(*) FROM accounce USE INDEX(PRIMARY);

                          

                          …… MAX……

1. SELECT MAX(orderprice) FROM accounce;
2. SELECT MAX(customar) FROM accounce;
3. SELECT MAX(customar) AS total FROM accounce;
4. SELECT MAX(orderprice) AS total FROM accounce;

……………….MIN………………….

1. SELECT MIN(orderprice) AS total FROM accounce;
2. SELECT MIN(orderprice) AS total FROM accounce;

…………….ALIAS…………………………….

1. SELECT user_name as alias FROM user;

 

………………FIRST………….

……………………..LAST………….

…………GROUP BY………….

1. SELECT Customar,SUM(orderprice) FROM accounce GROUP BY Customar;

………………………ROUND……………..

1. SELECT customar, ROUND(orderprice,0) as orderprice FROM accounce;

……………….NOW………………………..

1. SELECT customar, orderprice, Now() as orderDate FROM accounce;

…………………FORMATE…………………………

1. SELECT customar, orderprice, FORMAT(Now(),'YYYY-MM-DD') as orderDate

FROM accounce

……………RAND……………

1. SELECT * FROM accounce ORDER BY RAND();
2. SELECT * FROM accounce ORDER BY RAND()LIMIT 2,4
3. SELECT FLOOR(RAND()*10) FROM accounce;

…….. DATABASE INDEX FOR ALL SHOW…..

1. SHOW INDEX FROM accounce;

…………….NOW…………..

1. SELECT NOW() FROM table_name
2. SELECT NOW()FROM accounce
3. SELECT NOW()customar FROM accounce WHERE customar = 'saiful'
4. SELECT NOW()customar FROM accounce WHERE customar = 'saiful' AND O_Id = '6'

====     FORMAT==== 

1. SELECT user_roll, FORMAT(Now(),'YYYY-MM-DD') as PerDate

FROM user;

============= ROUND=============

1. SELECT ROUND(user_roll) FROM user;

==================== Update function ================

1.

Step by step most popular guid line for PHP programming and php emiol form

What is PHP: PHP is asever scripting language,and is a powerful tool for making dynamic web site and application.

PHP is use world wid so that it is very important for programming life.

Over view of PHP:

1)PHP Introduction

2)PHP install

3)PHP Syntax

4)PHP variables

5)PHP Echo/Printft

6)PHP Data type

7)String of Php

8)Constant

9)Operator of PHP

10)If..Else /else if

11)Swithc of PHP

12)While Loop

13)For loop

14)Function

15)Array

16)Sorting of array

17)Form handling

18)Form Validation

19)Form Required

20)Form URL/E-mail

21)Form Complete

Without this php lotst of function and programming c full system is use in c.

Next Tutorial for PHP Installaton system:

Step by step Guid line Learning c programmin and Visual c

What is programming language c: Easy thinking this is call mother of language,and strutural language,Step by step problem solbing system called programming c.

Defination of programming c:

#inlcude

#include

Vodi main(){

Clrscr();

Int a=10;

Printf(“%d”,a);

Getch();

}

Explaing:#mean preprocesive deractiv

Inlcude mean connectivity sytem with library function.

Stdio mean standard inpur and out pur.this is carry all library function.void main mean programe starting gate,conio mean consol input and outpur.

Printf() is a printing function,

Overview of c:

1)data type

2)operator

3)array

4)function

5)for loop

6)while loop

7)sturcture

I will provide some programe for your idea

Testing program

#include

#include

void main()

{

clrscr();

//printf("%s",20>180?"Arafat":"Nazmul");

/*

int a=10,b=5,c;

c=a>b?a:b;

printf("%d",c);

*/

getch();

}

Other program

2)

#include

#include

int show(int m,int n){

int p;

p=m+n;

return(p);

}

void main(){

clrscr();

int a=10,b=20,c;

c=show(a,b);

printf("%d",c);

getch();

}

Most Popular Tips for Update Knowledge About Web Technology:

Do you Know About Web Technology:

This time Web Technology is the most popular Subject, Because This is Helpful for learn more information, and World Communication Line, When We think any kind of Service first time we crate that design after that include  lot’s of information for User satisfaction, Mainly Web Technology create by Web language, for work plate form web technology tow flat form

1)Design flat for.

2)Development flat form.

About Design: Creative Design for Need

*) HTML,HTML5,CSS,CSS3,PHOTOSHOP,ANIMATION ,This is  for most Important topic Color matching and creative mind.

About Development: If you Interest learn for Development you should learn Programming language c,c++,PHP,MYSQL,JAVASCRIPT,AJAX,ORACLE,ASP.NET ETC, after that you can go successfully Developer like real class Developer.

Why We Learn Web Technology: Web Technology is the most importance topic for this modern civilization, this is help us learn for new knowledge and cuts for technology, web help full us for Online communication and long distance speak about common subject that’s for we learn web technology.

How We Learn Web Technology: First time We learn Design and when our learning complete then we create professional design by use all design pattern, know we know appropriately design then learn about development, development way is some logical technique we should lean it step by stem using more way.

Step by step Line Guide for Web Technology:

1)Design mode is creative mode first we use html for create web frame that time we use  html5 for advance frame create, frame modification for us css this is help full for color combination,css3 is advance speech for design, css can possible best and unique design.

2)Graphics design is most important for real web design because this is help any kind of design logo and banner so graphics help our complete design.

3) programming c this is mother of language law of programming, we should learn for increase knowledge, c help our advance thinking and create of function.

4) PHP is the most important for Web development this is come form programming language c , when we learn c after that php is most easy for new learner, Web development is a functional work so any king of function come from c base php.

5)MYSQL is a server site for web development, Web development isn’t one item site develop by mix language that for Mysql is important any king of dynamic site.

6)OOP(object oriented programming) is most important for server security and and smart code design and function security,I believe in this person oop knowledge is available he is great for programming.

7)Java is most important for advance knowledge this language for very essential program c++, so that this is quality programmer.

8)ASP.NET is desktop and web combination create this plat form is correct for Application development.

How We Can Achieve Our Web technology Success: any kind of success for Need hard work I believe you can win by hard work and hard study, and knowledge searching, you can go more blog site for line guide help line.

Web Technology for Future Guide line: Web future is color full future your advance help for always ready our programming team, follow our programming activities.

Update Important Topic For html5,By New Idea

What is Html5?:The Full abbreviation for “HTML”standard for Heper Text Markup language,it is the standard formating language for Web site creation.html provides short codes ,this is called tag.html5 is responsible for image,audio,video,any kind of player,this is very easy way for player updaing system,HTML5 is the next revision of HTML and it will be released in 2012 .in 2008 the w3c published its first working draft of HTML5 currently.

Why HTML5 and why should for advance web technology:HTML5 is very essential for web creation smart technology,we should learn it every tag for knowledge develop,HTML5 give us Update edditing system and player motivation system,this language use is very strong tag for security system.

Why it’s Not Browser supportable :Yes the Newest the browser like Opera,and Firfox,Chrome support HTML5 but Nothing,you have to code all the css3 defferntly so html5 is not all broser compabelity.

Is your Site Ready for HTML5:if you use HTML5 code you should use browser compability code,then your site is ready for user friendly,not for browser any kind of device easy way support is possible,then your site is ready for condidering.

Flash Vs HTML5 In Google Chrome:I think flash is a presentaion part,Now this situation is create like flash movement,any kind of presentation,and chome and firefox supportable,this is very essential for HTML5 user mean Web designer and Gaming technology.

How HTML5 Will change Your Website:if you create your on web site by html4 this is more limitaion,and html5 is some advance content and tag this is can more,changing your site,new video and audio advance system,flash movi system.