Collection of Important Dynamic Web Programming languages Ebooks

Hello Geeks! - you know i already have Collection of important Programming languages ebooks, but that is Software + Web App programming ebooks and after posting "How to become Web Programmer complete guide for beginners" many readers requested me to upload Dynamic Web Programming languges ebooks. In this post i've covered "AJAX, ASP.NET, Coldfusion, Perl, PHP, Ruby and Ruby on Rails Ebooks - Free giveaway.

Note : We've compressed Ebooks in ZIP format (99% Virus Free) Mediafire Download Links - Just Click on Ebook name & Download instantly. Thank you


I. AJAX (Asynchronous JavaScript and XML)



II. ASP (Advance Static Pages)



III. Coldfusion



IV. Perl



V. PHP (HyperText Preprocessor)

VI. Ruby


VII. Ruby on Rails



Thank you for reading my post, And if any link is broken feel free to comment and let me know your problem. You can also request any other Programming e-books (We'll upload it Asap!) If you like it please do a share to increase us.

How to become Web Programmer Guide for Beginners

Hello, Geeks! today m feeling little energetic and inspired so i thought to share little guide as per my experience and knowledge, well m not Professional Web Programmer - but here i got many tips, guides, tutorials to start learning Web programming language by Professional Programmers like my Sir (Teacher) in my Institute. From past couple of days I'm collecting information about How to start learning Web Programming language and it is totally for Beginners only.


How to start learning Web Programming Lang.

There are many types of Web Programming language being used by the Web Application but you've to start from the most basic Markup language and that is HTML commonly known as Hyper Text Markup language (HTML 5). HTML is very easy and interesting to learn, HTML is almost used by every Web Site & Web Application. After then move to  Dynamic Web Programming languages like JavaScript, AJAX, PHP, ASP etc. And the most  important thing I want to explain you that Programming just can't be learn by reading or  memorizing it - Programming is like body building the more you build the more you get  Stronger - (Hack w0rm). Try to create your own Web Page & App using  Dreamweaver, & test it in Local Host Server etc I'll elaborate more deeply in this Post.


First of all lemme explain you difference between Static & Dynamic Web Pages :

Static : Static pages are the generic .html files usually relegated to FAQs, contact information, Blog Articles etc. HTML is Static : Listen suppose you create an application that Says Hello World!, then anyone can able to see your code using Web Browser (Source Code) because you code is in .HTML and that is Static.

Dynamic : Dynamic Pages are really interesting and little protected, Nowadays almost every Web Site is using Dynamic Pages like (.asp, .jsp, .php, etc), You can't see the code of Dynamic Pages like you can see the code of .HTML. Usually all programmers use Dynamic Pages to generate Static Codes. For Example you create an application like search engine then you've to connect PHP/ASP page into action - well you can also use Static but it isn't like Dynamic. You can't simply see the code of .PHP action file.


Steps to get Started with Web Programming :

*Go through below stage and learn step by step :

1. HTML (Markup Language) : Folks! I want your base to be strong, If you know complete HTML 5 then it would be easy to learn another second stage Languages. HTML is Markup language which comes under Static Web Page. If you're beginner in Web Programming start with HTML.

2. CSS : Cascading Style Sheets is very easy Static Language. CSS is used for designing, fonts, lighting text, effects and whatever that makes your Web Site looks little attractive. CSS can be learnt in just 7 Days! Its pretty small and easy with lots of enjoyment. CSS only got a job of designing, Flash, Adding image effects, Font effects, Color, Application designing etc.

3. JavaScript : Commonly Javascript is used in every Web Sites, Javascript is Dynamic Web Programming language. If you're champ in HTML & CSS then it would be easy to learn Javascript easily. Javascript have an important role in Web Applications, Javascript is very intersting with lots of fun also.

4. AJAX : Now after completing Javascript move to most adorable programming language called AJAX : (Asynchronous JavaScript and XML) AJAX is a novel programming approach to web applications that creates the experience of “fat client” applications using lightweight JavaScript and XML technologies.

5. PHP/ASP : It's time to move on more advance Dynamic Web Programming language likes PHP or ASP. Both have an unbeatable competion but I'll recommend you to learn PHP. PHP (Hypertext Preprocessor) is very interesting dynamic  language. It isn't tough until you know HTML, Javascript etc. PHP is one my mine favorite Programming language.


Now, after learning 5 most important Web Programming languages : HTML, CSS, Javascript, AJAX, PHP. You can move to advance Web Programming languages like Ruby, Ruby on Rails, Visual Basic Web App Dev, C#, .NET, etc. But before doing all these advance please become champ in all that five Programming languages.

How to learn Web Programmnig Languages : (Methods to learn)

To learn Web Programming languages you'll require atleast 2 hour daily practice, refresh your skills everday and think how it works, what is the main conclusion. And go through below Guide to learn Programming easily.


The First Step : If you're going through my guide and learning that five programming languages sequencely then i'll recommend you to start with HTML. While learning HTML create one word file of all HTML Tags, with two line comments and defination of defined Tag. CSS doesn't have any heavy contents like Tag, scripts etc.. it's simply. JavaScript can give you little tough challenge, take your time to learn it slowly don't do rush and never skip any contents saying that i'll do it later, always try to challenge yourself with Programming. AJAX and PHP have coplicated contents, but if you learn sequencely and go on smoothly then it would be easy for you to learn PHP and AJAX.

Always take Tea/Coffee : While practicing and creating some Application with my own, sometimes my brain gets buzzed! that is why i always keep Coffee near to my Computer table. In programming you've to think and create it wisely, so you can impress yourself, public or your Boss/Teacher. But I'm not only recommending you to take Tea or Coffee only - Well mine some friends drink Mountain Dew, Red Bull etc. It will keep your mind cool and little fresh.

Download Dreamweaver CS6 : Adobe Dreamweaver CS6 is one the best Web Application Development Software commonly used by all Web Programmer.  Dreamweaver is easy to use with all types of Static, Dynamic web programming language. It will help you a lot to learn Web Programming and create Web App easily.


How Stuffs work : The main thing in programming is to think and understand how Web Application is working. While learning someguys just memorize Programming tags, scripts and codes , but when it comes to creating and facing an errors they just become BLANK!. Whenever you learn any programming language please always try to understand How it is working, and Visualize its structure & flow in your mind.

Web App Note : When I was pursuing my diploma they always tell us to keep a note of everything what you learn, In case you forget some programming codes or stucked into problem - your Note can remind you the solution. I m not saying to write all things whatever you learn, but just create atleast one note on Hard Stuffs.


How to test Programmed Web Page & Application ?

While learning HTML, JavaScript etc you'll need to test your Program wheather it is working correctly or not? - checking for any Error or Mistakes. So you'll need a Web Server to test Static and Dynamic Web Applications, Therefore i recommend you to download WAMP Server and Install it in your Computer, Start WAMP Server, Go to C:\wamp\www\ and paste your web page file in that folder, now open your browser and type localhost or 127.0.0.1 - Hit enter and you can access your Web Application on offline mode with all HTTP features.

From where Should I learn ?

This is the most common problem faced by learners, they don't get source to get started with simple example and tutorials, But I say if you've curiosity to learn and passion to do something then you can even learn just from an E-book. The best way to learn Programming is to Download E-books, Purchase Web Programming languages Books, Learn from W3Schools, Google your Queries, Try to understand How it works.

There are a lots of Ebooks on internet for Beginners to learn Web Programming languages. Click here to download some ebooks from our blog.


Web Programmers
              In this Era of Internet and technologies, Web Programmers are growing with lots of IT Skills, and Knowledge. well this is a tough Competion for guy like me and you who is interested in Hacking, Programming and other Computer Skills. As fast the IT (Information Technology) is growing the demand of Web Programmer, Computers Programmers are growing. Web Programming is one of the best future carrer option.

Other Tips to learn Web Programming Languages :

* Friends, Curiosity is the best way to learn anything
* Be Passionate and Confident while Learning
* Always test your Web Application in Local Server
* Learn from your mistakes, find an error and fix it
* Always use Google to clear your doubts.
* And always Stay connected with Bolt Geeks.


Thank you for reading my post, This is small guide by Vivek,I hope you enjoyed this post. Feel free to ask any doubt and lemme know your problem. If you liked it please share it to increase us.

Difference between stored procedures and user defined functions


2. Named Batches: Set of T-SQL statements can written and executed as a single unit with a proper name called Named batch. These includes

  1. Stored procedures
  2. User defined Functions
  3. Triggers

  1. Stored Procedures: Stored procedures are one of the database objects. There are two types of stored procedures available in SQL Server.

    1. System Defined Stored Procedures
    2. User Defined Stored Procedures

System Defined Stored Procedures: These are also known as predefined or built-in stored procedures.

E.g.: 
SP_HELP
SP_RENAMEDB
SP_RENAME
SP_HELPCONSTRAINT
SP_HELPTEXT
------
-----
-------

User Defined Stored Procedures: Procedures created by the user are called used defined stored procedures.

Syntax:
 CREATE PROC [EDURE] PROCEDURENAME
            [@PARA 1 DATATYPE (SIZE)[=DEFAULT_VALUE][OUTPUT]
            @PARA 2 DATATYPE (SIZE)[=DEFAULT_VALUE][VALUE],….]
AS
BEGIN
SELECT STATEMENT
END

Syntax to execute the user defined stored procedure:
EXEC [UTE] PROCEDURENAME [VALUE1,VALUE2,…]

Note: The number of values supplied through EXEC statement must be equal to the number parameters.



E.g.1: Write a procedure to select the data from EMP table.

CREATE PROCEDURE P1
AS
BEGIN
SELECT * FROM EMP
END

      EXEC P1

E.g.2: Write a procedure to select the data from EMP table based on user supplied DEPTNO.

CREATE PROCEDURE P2 @X INT
AS
BEGIN
SELECT * FROM EMP WHERE DEPTNO=@X
END

EXEC P2 20






E.g.3: Write a procedure to add two numbers

CREATE PROCEDURE P3 @A INT=10,@B INT=20
AS
BEGIN
DECLARE @C INT
SET @C=@A+@B
PRINT @C
END

EXEC P3
Output: 30
EXEC P3 25, 45
Output: 70

Note: Server will give highest priority to the user supplied values rather than default values.



USER DEFINED FUNCTIONS: Functions created by user are called user defined functions

Types of user defined functions:
1.      SCALAR VALUED FUNCTIONS
2.       TABLE VALUED FUNCTIONS

Scalar valued functions: These functions will return a scalar value to the calling environment
Syntax:
 CREATE FUNCTION < FUNCTION_NAME> (@PARA 1 DATA TYPE ,
@ PARA 2 DATATYPE ,…..)
RETURNS <DATATYPE>
AS
BEGIN
DECLARE  @VARIABLE  DATATYPE
--------
----------
RETURN  @VARIABLE
END

Syntax to execute the user defined function:
SELECT/PRINT DBO.FUNCTIONNAME (VALUE1,VALUE2,……….)

Note: The number of values supplied through PRINT/SELECT statement must be equal to the number parameters.


E.g.1: Write a function to find the product of two numbers

 CREATE FUNCTION F1 (@ A INT, @B INT)
 RETURNS INT
 AS
BEGIN
DECLARE @ C INT
SET @C = @A * @B
RETURN @C
END

SELECT/PRINT DBO.F1 (3,5)


E.g.2: Write function to find the net salary of an employee read  EMPNO though parameter and display the net to return value
 CREATE FUNCTION F2 (@ VNO INT)
            RETURNS  INT
            AS
BEGIN
            DECLARE @ VSAL INT, @VCOM INT, @NET INT
            SELECT @VSAL =  SAL, @VCOM=COM
FROM EMP WHERE EMPNO =@VNO
IF @ VCOM IS NULL
BEGIN
PRINT ‘COMMISION IS NULL’
SET @NET = @VSAL
END
ELSE
BEGIN
SET @ NET = @VSAL + @VCOM
END
RETURN (@NET)
END

PRINT/SELECT DBO.F2(22)








2) Table valued function: These functions will return entire table to the calling environment.

Syntax:
CREATE FUNCTION <FUNCTION_NAME>(PARA 1 DATA TYPE ……….)
RETURNS TABLE
AS
BEGIN
<FUNCTION BODY>
RETURN (SELECT STATEMENT)
END

E.g.1: Write a function to return entire dept table
CREATE FUNCTION F3()
RETURNS TABLE
AS
BEGIN
RETURN (SELECT * FROM DEPT)
END




SELECT * FROM F3()
DEPT
DNAME
LOC







E.g2:
CREATE FUNCTION F4()
RETURN TABLE
AS BEGIN
RETURN(SELECT ENAME, DNAME FROM EMP, DEPT
                      WHERE EMP.DEPTNO = DEPT.DEPTNO)
END
SELECT * FROM F4()
ENAME                                 DNAME
SMITH                        RESEARCH
MILLER                     ACCOUNTING