21Links.com Site Map


Checkout the pages and links hierarchy on 21Links.com

21Links.com home page


Frequently Asked Questions
Contact Us at 21Links.com


Web Design Video Tutorials and Courses
CSS Courses
CSS 3 Courses
WordPress Design Courses

Databases Video Tutorials and Courses
SQL Courses
MySQL Courses


Learn SQL with MySQL Database
What is SQL?
Who should learn SQL?
How to Install MySQL database server on Windows operating system
How to Install MySQL database server on Mac operating system
How to Install MySQL database server on Linux operating system
How to add a new database user and add privileges
How create MySQL shortcut for Windows users
What is DBMS and RDBMS?
Difference between Database Engine, Database Server and Database Software
What is a database? How to create and use a database?
What is a database table? How to create and use a database table?
How to add the data rows to a database table?
Understand Keywords, Identifiers, Constants and Clauses
Learn about SQL Statements
Data Definition Language(DDL) and Data Manipulation Language(DML)?
Create example databases, tables and data rows in MySQL
Learn about SQL SELECT Clause
SQL SELECT DISTINCT Statement
Learn about SQL FROM Clause
Learn about SQL WHERE Clause
SQL True Condition
SQL False Condition
SQL AND Operator
SQL OR Operator
SQL IN Operator
SQL EXISTS Condition
SQL NOT IN or NOT EXISTS? Conditions
SQL Comparison Operators
SQL LIKE Operator
SQL BETWEEN Operator
SQL Numeric Operators
SQL Concatenation Operator
SQL Temporal Operator
Learn about SQL GROUP BY Clause
Learn about SQL HAVING Clause
Learn about SQL ORDER BY Clause
SQL LIMIT or TOP Clause
SQL Wildcards
SQL Aliases
SQL Dates
Add the data rows in a table using INSERT INTO Statement
SQL INSERT INTO SELECT Statement
Update data rows using UPDATE Statement
Delete data rows using DELETE Statement
What is SQL Injection and How to secure a database?
What are JOINS in SQL? Types of SQL JOINS
Learn about INNER JOIN in SQL
Learn about LEFT OUTER JOIN in SQL
Learn about RIGHT OUTER JOIN in SQL
Learn about FULL OUTER JOIN in SQL
Learn about CROSS JOIN in SQL
SQL UNION Operator
SQL VIEWS
Derived Tables or Inline Views
Functions in SQL and Types of SQL functions
SQL COUNT() Function
SQL FIRST() Function
SQL LAST() Function
SQL SUM() Function
SQL MIN() Function
SQL MAX() Function
SQL AVG() Function
SQL UCASE() Function
SQL LCASE() Function
SQL MID() Function
SQL LEN() Function
SQL ROUND() Function
SQL FORMAT() Function
SQL SUBSTRING() Function
SQL COALESCE() Function
SQL CHAR_LENGTH() Function
SQL CAST() Function
SQL CASE() Function
SQL NULLIF() Function
What is data type in SQL?
Integer Numbers in SQL (Exact Values)
Fixed-Point Numbers in SQL (Exact Values)
Floating-Point Numbers in SQL (Approximate Values)
CHAR and VARCHAR in SQL (String Values)
NCHAR and NVARCHAR in SQL (String Values)
CLOB and BLOB in SQL (String Values)
DATE, TIME and TIMESTAMP in SQL (Temporal Values)
Learn how to create and display databases
Select and use existing database
Remove or delete database from database management system
Learn how to create the database table using right method
Modify or update the database table details
Remove or delete an existing table
Understand Constraints in SQL
NOT NULL Constraint in SQL
UNIQUE Constraint in SQL
PRIMARY KEY Constraint in SQL
FOREIGN KEY Constraint in SQL
CHECK Constraint in SQL
DEFAULT Constraint in SQL
AUTO INCREMENT or SEQUENCE in SQL
Understand Database Relationship in SQL
One-to-One (1:1) Relationship in SQL
One-to-Many (1:M) Relationship in SQL
Many-to-Many (M:M) Relationship in SQL
What is Database Normalization in SQL?
First Normal Form (1NF) in database normalization
Second Normal Form (2NF) in database normalization
Third Normal Form (3NF) in database normalization
What is SQL Export and Import?
How to Export the database using SQL statement
How to Import the database using SQL statement
What is MySQL Workbench?
Create a new user and connect to database using MySQL Workbench
Create, Alter, Drop database using MySQL Workbench
Create, Alter, Drop table using MySQL Workbench
Insert, Read, Update, Delete data rows using MySQL Workbench
Database Export and Import using MySQL Workbench
Thank You!


WordPress Essential in one hour
Introduction
What is need to get started
What is wordpress
Creating databse in control panel
Creating FTP account
Downloading wordpress software
WordPress Config File
Uploading files using FTP client
install wampserver
install wordpress on localhost
Install WordPress on live server
WordPress basic settings
Front page introduction
creat post in wordpress
Creating a page in wordpress
creating categories
Creating menu
Install Themes
install plugins in WordPress
conclusion


CSS3 Shadow Effects for Web designers
Welcome
Prerequisites
What is Shadow Effects
Text Shadow
Blur Radius
Shadow Color
Multiple Shadows
Box Shadow
Box Shadow Color
Inset and Spread Radius
3D Text Effect
Inset Effect
Neon Text Effect
Embossed Text Effect
Thanks


CSS 3 Gradients for Web Desingers
Welcome
Introduction
Prerequisites
Who is using CSS Gradients
CSS Gradient Browser Support
How to Create Linear Gradient
How to Specify colors
How to declare Prefixes and Fallback Colors
Specify Directions to Gradient
Use Angles for Gradient Directions
Using Color Stops
Solid Colors Using Color Stops
Using Transparency
Repeating Linear Gradient
CSS3 Radial Gradients
Set Shapes in RadialGradients
Positioning the gradient center
Size Keywords
Repeating Radial Gradient
exercise example 1
Thank You