PHP & MySQL
My SQL & PHP
PHP is one of the fastest growing web scripting languages on the Internet today, and for good reason. PHP (which stands for Hypertext Preprocessor) was designed explicitly for the web. Designed in 1994 to enable the creation of dynamic web pages quickly and easily, PHP has exploded in growth and has been adopted by major vendors such as Linux that have included the language with their web servers. The language is easy to learn and works with a variety of operating systems. PHP’s strong performance, coupled with its modest learning curve, has made it the language of choice for many businesses wanting a cost-effective rapid application development solution for the web. PHP is easily customized to work seamlessly with Open Source databases such as MySQL. MySQL is a relational database management system (RDBMS) MySQL stands for “My Structured Query Language”. The program runs as a server providing multi- user access to a number of databases. Learning PHP along with MySQL will enable the learner to develop web applications
PROGRAMMING LOGIC AND TECHNIQUES
- Represent logic by using flowcharts
- Identify data and data types and use operators
- Represent decisions in a flowchart
- Identify repetitive processes
- Represent complex conditions and iterations by using flowcharts
- Break down a problem into modules
INTRODUCTION to RDBMS
- Deline a Database Management System (DBMS)
- Describe the types of data models Create an entity-relationship model
- Map an entity-relationship diagram to tables
- Normalize and de-normalize data in tables
DEVELOPING WEB APPLICATIONS USING MYSQL AND PHP
- Utilize the basic components of PHP to build foundation for more complex web applications
- Understand the basic components of MySQL to build a foundation for the development of fully dynamic and database-driven sites
- Utilize SQL query commands and SQL expressions to retrieve data from the MySQL Database
- Retrieve data from multiple MySQL tables using Joins Create web based forms that interact with the end user and the data within MySQL
- Utilize session handling and error and exception handling
- Use PHP’s authentication capabilities
- Use MySQL’s user and privilege management capabilities
SQL SERVER 2005
The course ‘Designing, Implementing, and Administering Databases using SQL Server 2005’ introduces the learner to the databases, explains the processes of designing and implementing databases. Further, it also explains how to manage a database server
INTRODUCTION TO THE RELATIONAL DATABASE MANAGEMENT SYSTEM
- Define a Database Management System (DBMS)
- Create an entity-relationship model
- Map an entity-relationship diagram to tables
- Normalize and denormalize data in tables
QUERYING AND MANAGING DATA USING SQL SERVER 2005
- Appreciate SQL Server 2005
- Query Data
- Query Data using Joins and Sub queries
- Manage Databases and Tables
- Manage Data in Tables
- Implement indexes, Views, and Full-Text Search
- Implement Stored Procedures and Functions
- Implement Triggers and Transactions
- Implement Managed Code
- Implement HTTP Endpoints
- Implement Services for Message-Based Communication
ADMINISTERING DATABASES USING SQL SERVER 2005
- Install and Configure SQL Server 2005
- Create and Manage Databases
- Secure Databases
- Back Up and Restore Data
- Monitor, Optimize, and Troubleshoot Performance
- Maintain High Availability
- Implement Replication Import and Export Data