About TAG11

1. About TAG11 • TAG11 is India’s emerging standalone software and website development company. • TAG11 offers distinctive web services and software solution to its global clientele. • TAG11 offers complete cycle of development beginning with software version formulating and requirements management analysis, designing up to coding, implementation, rigorous testing, deployment and support. • We provide training in PHP and .NET

2. Web Developement Web development is a broad term for the work involved in developing a Website for the Internet. This can include the following : • Web design • Web content development • Client side/ server side scripting • Web server • Network security configuration • E-commerce development

3. Client – Server Model

4. Client – Server Model • Client-Server architecture is sometimes called as two-tier architecture. • The client-server model is a computing model. • It acts as a distributed application which partition tasks or workloads between the Server and Clients. • Functions such as email exchange, web access and database access are built on the client-server model. • The ideal client/server model is independent of hardware or OS platform.

5. What is Client • A client is an application or system that accesses a service made available by a Server. • Clients can reside in the same machine or separate machines. • A client is a person or system that send request to server. • Your browser like Internet Explorer, Mozilla Firefox, Google Chrome etc. works as client side. • All websites are made on client side. • The Client side supports 3 languages: • HTML (Presentation language) • CSS (use to set styling on HTML components) • Java script (used for client side validation)

6. What is Server • A server is a computer program that provides services to other computer programs. • The server performs some computational task on behalf of clients. • Any request is first compiled and executed on server side and then the responses is sent back to the client. • At server side following languages are supported: • PHP • .NET • ASP • JSP

7. How this model works • Server is installed as an application or a service on the computer to serve as the enterprise-wide timeserver. • Server is listening on the LAN / WAN for Client request. • Independently, a Client requests from Server over the LAN / WAN. • Server responds to each Client with correct standard time, logging Client Request. • Server supports 1 to 1000 Clients.

8. What is Website • A collection of related webpage containing contents such as text, images, video, audio etc. • A website is hosted on at least one web server. • The webpage of a website can usually be accessed from a URL. • Any user accessing a web use a web-browser Client to send a request to a web Server. • For any website we need 5-6 different languages.

9. What is Domain Name • The Domain Name System (DNS) is a hierarchical distributed naming system for computers, services, or any resource connected to the Internet or a private network.

10. About Domain Name It’s a 3 to 4 level naming system : • Root • TLD (Top Level Domain) • Second Level Domain • Sub – Domain E.g. of a DNS- www.google.com/index.html Root level Second level Top level

11. About Hosting • A Domain Name is an identification string that defines a realm of administrative autonomy, authority, or control on the Internet. • A domain name represents an Internet Protocol (IP) resource, such as a personal computer used to access the Internet, a server computer hosting a web site, or the web site itself or any other service communicated via the Internet. • Hosting (also known as Web site hosting, Web hosting, and Webhosting) is the business of housing, serving, and maintaining files for one or more Web sites • Hosting is a web space where electronic data are placed on the Internet for website. • Physical location for the storage of web pages and files. • Host is a computer where Server Language are installed like PHP,DOTNET,WAMP….. • We can upload data through FTP.

12. About Database manipulate

13. About Database • Database is an organized collection of  data. • In database system the data is stored at a central location and is shared among multiple users. • We require a database to save our documents or files securely. • Database languages : • Access • MsSql • Mysql • Oracle

14. Use of Database To build a web site that shows some data from a database, you will need the following: • An RDBMS database program (i.e. MS Access, SQL Server, MySQL) • A server-side scripting language, like PHP or ASP.NET • SQL • HTML / CSS/ JAVA SCRIPT

15. DDL - DML DDL (Data Definition Language) : DDL statements are used to define the database structure or schema.  For e.g. • SELECT : retrieve data from the a database DML (Data Manipulation Language) : DML statements are used to managing data within schema objects.  For e.g. • INSERT : insert data into a table • UPDATE : updates existing data within a table • DELETE : deletes all records from a table, the space for the records remain

16. SQL What is SQL ? • SQL is a structured query language. • SQL lets you access and manipulate databases. • SQL is an ANSI (American National Standards Institute) standard. What can SQL do? • SQL can create new databases • SQL can create new tables in a database • SQL can insert records in a database • SQL can retrieve data from a database • SQL can update records in a database • SQL can delete records from a database

17. Any Query …?