PHP5 and MySQL® Bible by Tim Converse and Joyce Park with Clark Morgan

Sinopsis

PHP is the Web development language written by and for Web developers. PHP stands for PHP: Hypertext Preprocessor. The product was originally named Personal Home Page Tools, and many people still think that’s what the acronym stands for. But as it expanded in scope, a new and more appropriate (albeit GNU-ishly recursive) name was selected by community vote. PHP is currently in its fifth major rewrite, called PHP5 or just plain PHP.
 

PHP is a server-side scripting language, which can be embedded in HTML or used as a standalone binary (although the former use is much more common). Proprietary products in this niche are Microsoft’s Active Server Pages, Macromedia’s ColdFusion, and Sun’s Java Server Pages. Some tech journalists used to call PHP “the open source ASP” because its functionality is similar to that of the Microsoft product—although this formulation was misleading, as PHP was developed before ASP. Over the past few years, however, PHP and server-side Java have gained momentum, while ASP has lost mindshare, so this comparison no longer seems appropriate.
 

We’ll explore server-side scripting more thoroughly in Chapter 2, but for the moment you can think of it as a collection of super-HTML tags or small programs that run inside your Web pages—except on the server side, before they get sent to the browser. For example, you can use PHP to add common headers and footers to all the pages on a site or to store form-submitted data in a database.

 

Content

1. PHP: The Basics
2. Why PHP and MySQL?
3. Server-Side Web Scripting
4. Getting Started with PHP
5. Adding PHP to HTML
6. Syntax and Variables
7. Control and Functions
8. Passing Information between Pages
9. Strings
10. Arrays and Array Functions
11. Numbers
12. Basic PHP Gotchas
13. PHP and MySQL
14. Choosing a Database for PHP
15. SQL Tutorial
16. MySQL Database Administration
17. PHP/MySQL Functions
18. Displaying Queries in Tables
19. Building Forms from Queries
20. PHP/MySQL Efficiency
21. PHP/MySQL Gotchas
22. Advanced Features and Techniques
23. Object-Oriented Programming with PHP
24. Advanced Array Functions
25. String and Regular Expression Functions
26. Filesystem and System Functions
27. Sessions, Cookies, and HTTP
28. Types and Type Conversions
29. Advanced Use of Functions
30. Mathematics
31. PEAR
32. Security
33. Configuration
34. Exceptions and Error Handling
35. Debugging
36. Connections
37. PostgreSQL
38. Oracle
39. PEAR Database Functions
40. E-mail
41. PHP and JavaScript
42. PHP and Java
43. PHP and XML
44. Web Services
45. Graphics
46. Case Studies
47. Weblog
48. User Authentication
49. A User-Rating System
50. A Trivia Game
51. Converting Static HTML Sites
52. Data Visualization with Venn Diagrams

Click here to download

Read more »

Download PDF MySQL and Java Developer’s Guide by Mark Matthews, Jim Cole and Joseph D. Gradecki

Sinopsis

Have you ever been assigned a project and realized that you had no idea how you were going to accomplish it? Many developers have experienced this feeling when asked to interface their code with a database.
 

With a few exceptions, most developers were busy learning Lisp, linked lists, and big-O notation during their formal education instead of learning the fundamentals of relationship database management systems. When the time comes to interface their code with a database, they turn to a book like the one you are holding.
 

Your challenge might be to write a Web-based system using servlets and Enterprise JavaBeans (EJBs) to transfer shipping records from the home office in Bend, Oregon, to a satellite shipper in New Jersey. Or perhaps your father just opened his new medical office and you volunteered to create a scheduling system over the weekend.
 

Whatever the situation, interfacing an application to a database is one of the most fundamental tasks a developer is required to perform. This book is designed for developers who either have a pressing task ahead of them or who are curious about how to read database information into their application. By combining MySQL, the number-one open source database available, with Java, the most portable language ever developed, you can create an undisputable champion. So, sit back in your desk chair with a hot chocolate and get ready to supercharge your coding.

Content

1. An Overview of MySQL
2. JDBC and Connector/J
3. Working with MySQL SQL
4. Installing MySQL, Java, and Connector/J
5. Using JDBC with Java Applications and Applets
6. Achieving Advanced Connector/J Functionality with Servlets
7. MySQL Type Mapping
8. Transactions and Table Locking with Connector/J
9. Using Metadata
10. Connection Pooling with Connector/J
11. EJBs with MySQL
12. Building a General Interface for MySQL
13. Database Administration
14. Performance and Tuning

Click here to download

Read more »

Download PDF MySQL®/PHP Database Applications, Second Edition by Brad Bulger, Jay Greenspan, and David Wall

Sinopsis

Soon we will head off on a fabulous journey, a journey on which we will explore the ins and outs of MySQL and PHP database applications in great detail. It’s goingto be a fun trip; we just know it.
 

Okay, maybe we’re being a bit optimistic. If you’re anything like us, points of this particular journey will be a lot more tedious than they are exciting. Let’s face facts: Application development isn’t always the most exciting thing in the world. And as with any other venture that involves programming, some very frustrating times are sure to be ahead, whether because of a syntax error you can’t find or a piece of code that won’t do what you think it ought to do. But despite all that, here you are, and we think there is a very good reason for that.
 

Web applications are the present and the future. No matter your background, whether you have a history with Visual Basic or COBOL, or maybe just some HTML and JavaScript, your résumé is only going to improve with some Web application development experience. We don’t think there’s a better combination of tools to have under your belt than PHP and MySQL. The numbers bear us out. PHP and MySQL are becoming increasingly popular, and the demand for people who can use these tools will only increase.
 

A bit later in this introduction we go into a more detailed explanation of why you should use PHP and MySQL. However, before we can get to that, we want take a bit of time to go over the architecture of Web applications. Once we’ve done this, we can explain in detail why PHP and MySQL should be the centerpieces of your application-development environment. Once we’ve sold you on these tools, we present
a very quick and grossly under-coded application. As you look over this application, you can see the basic syntax and principles behind PHP and MySQL.

Content

1. Working with MySQL
2. Database Design with MySQL
3. The Structured Query Language for Creating and Altering Tables
4. The Structured Query Language for Inserting, Editing, and Selecting Data
5. Working with PHP
6. Getting Started with PHP Variables
7. Control Structures
8. PHP’s Built-in Functions
9. Writing Organized and Readable Code
10. Simple Applications
11. Guestbook 2003, the (Semi-)Bulletproof Guestbook
12. Survey
13. Not So Simple Applications
14. Threaded Discussion
15. Content-Management System
16. Catalog
17. Problem-Tracking System
18. Shopping Cart
19. XML Parsing
20. SOAP
21. Project Management

Click here to download

 

Read more »

Download PDF MySQL Enterprise Solutions by Alexander “Sasha” Pachev

Sinopsis

MySQL has penetrated the enterprise in a way that perhaps would be odd for a typical proprietary application, but is very common for an open-source package. Developers brought it in through the back door, and sometimes by the time management found out, developers had a working solution based on MySQL with zero database licensing costs. This often won acceptance for MySQL at both the management and development levels.
 

Some prominent users of MySQL have publicly released the fact that they are using MySQL and somewhat elaborated on their use, which allows us to talk about them in this book. Others are using it in production frequently under heavy load but treat this information as a trade secret. The organizations I mention in this section have made their use of MySQL public, so we can discuss a few details about their implementations. The companies listed here are the tip of the iceberg.
 

MySQL AB collects user stories and publishes them at www.mysql.com/ press/user_stories/, so you might want to check there for more information.

Content

1.  Bringing MySQL into Your Enterprise
2. Overview of MySQL
3. Selecting a Platform for MySQL Server
4. Installing MySQL
5. Testing Your MySQL Installation
6. Access Control and Security
7. Developing MySQL Applications
8. Choosing the Client Language and Client-Server Network Architecture
9. MySQL Client in a Web Environment
10. C/C++ Client Basics
11. PHP Client Basics
12. Perl API Basics
13. Java Client Basics
14. Writing the Client for Optimal Performance
15. Maintaining and Optimization
16. Table Design
17. Configuring the Server for Optimal Performance
18. Analyzing and Improving Server Performance
19. Replication
20. Backup and Table Maintenance
21. Exploring MySQL Server Internals

Click here to download

Read more »

Download PDF MySQL™ Bible by Steve Suehring

Sinopsis

The telephone company that owns my area stores basic information about me—first and last name, address, city, state, ZIP code, and telephone number—information that’s not only basic but also common across almost all customer databases. Beyond the basic information, the local telephone company also requires my social security number (which helps them find me should I attempt to forego payment and leave the area).
 

Within the telephone company database is a system to keep notes and correspondence. For example, each time I call to talk with a customer service representative, a note goes into my file—indicating what I was calling about, the outcome (if any), as well as the date, time, and representative’s name—all of which is recorded automatically when the note is entered.
 

Beyond the personal information and correspondence notes, the telephone company database also serves as a billing system that generates my phone bill automatically on the fourth day of every month. The database tracks what services I have (such as Call Waiting, Caller ID, and so forth), associates each service with a price, and tallies my bill for the month.
 

Having customer, billing, and rate information in a database allows the telephone company to produce reports that can pinpoint how many customers have a certain rate group, how many live in a certain area, how many have delinquent payments, and so on.
 

Beyond customer reports, the telephone company has become much more sophisticated in its use of the data. Previously when I would call for customer service, I would get to talk to a live person after a bit of a wait. They then improved their customer service by allowing me to punch in my 10-digit telephone number and look up my records. From there, I might eventually get to talk to a live person (if I didn’t select any of the common tasks on the voice-mail menu). The latest improvement is the use of caller identification to ask me whether I’m calling in regard to the number that I’m calling from. After more menus and prompts, I may be able to reach a live operator.
 

Behind the scenes during this process is a database that can look up my information when it is fed my 10-digit number. The telephone company database can then give me choices based on the current status of my account. I once had the misfortune of fraudulent charges on my telephone bill—about $650 worth. I immediately put that amount into dispute and was told to pay my normal $45 bill—but I still
ended up receiving a disconnection notice. When I called back to inquire into the
notice, I was forwarded automatically to the collections department (who, after
some discussion, handed me off to the regular customer service department). Moral: Databases can speed up only those aspects of a transaction that don’t require the use of common sense.

Content

1. Getting Started
2. Relational Database Management
3. Preparing for Installation
4. Linux Installation
5. Windows Installation
6. Macintosh Installation
7. Starting MySQL
8. Database Concepts and Design
9. SQL Essentials
10. Command Line Interface (CLI)
11. SQL According to MySQL
12. Database and Data
13.  Administration
14.  Server Configurations
15. Security
16. Debugging and Repairing Databases
17. Performance Tuning
18. Development
19. Perl Development
20. PHP Development
21. ODBC/JDBC
22.  Advanced Performance
23.  Replication
24. Integration of Internet Services
25. NuSphere Enhanced MySQL

Click here to download

 

Read more »

Download PDF Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larson

Sinopsis

Business Intelligence The first step in effective decision making is to set specific, measurable goals. Once these goals have been set, the objective is to get accurate, useful information to the appropriate decision makers to serve as a foundation for the decision and as feedback on the effectiveness of that decision. Having the foundation and feedback information available at the appropriate time is extremely important. The question becomes, How does an organization go about obtaining and distributing this information? As the title of this book suggests, the answer is, Through the use of business intelligence. In fact, this objective serves as our definition of business intelligence.

Definition Business intelligence is the delivery of accurate, useful information to the appropriate decision
makers within the necessary timeframe to support effective decision making.

Business intelligence is not simply facts and figures on a printed report or a computer screen. Rows upon rows of numbers showing detailed sales figures or production numbers may be extremely accurate, but they are not business intelligence until they are put in a format that can be easily understood by a decision maker who needs to use them. Concise summaries of customer satisfaction or assembly-line efficiency may be easily understood, but they are not business intelligence until they can be delivered in time to meaningfully affect daily decision making. We also discovered earlier in this chapter that effective decision making is important at all organizational levels. Timely foundation and feedback information is needed as part of that effective decision making. Therefore, we need to make business intelligence available throughout our organizations.

Content

1. Part I - Business Intelligence
2. Chapter 1 - Equipping the Organization for Effective Decision Making
3. Chapter 2 - Making the Most of What You've Got—Using Business Intelligence
4. Chapter 3 - Searching for the Source—The Source of Business Intelligence
5. Chapter 4 - One-Stop Shopping—The Unified Dimensional Model
6. Chapter 5 - First Steps—Beginning the Development of Business Intelligence
7. Part II - Defining Business Intelligence Structures
8. Chapter 6 - Building Foundations—Creating and Populating Data Marts
9. Chapter 7 - Fill'er Up—Using Integration Services for Populating Data Marts
10. Part III - Analyzing Cube Content
11. Chapter 8 - Cubism—Measures and Dimensions
12. Chapter 9 - Bells and Whistles—Special Features of OLAP Cubes
13. Chapter 10 - Writing a New Script—MDX Scripting
14. Chapter 11 - Pulling It Out and Building It Up—MDX Queries
15. Part IV - Mining
16. Chapter 12 - Panning for Gold—Introduction to Data Mining
17. Chapter 13 - Building the Mine—Working with the Data Mining Model
18. Chapter 14 - Spelunking—Exploration Using Data Mining
19. Part V - Delivering
20. Chapter 15 - On Report—Delivering Business Intelligence with Reporting Services
21. Chapter 16 - Let's Get Together—Integrating Olap with Your Applications
22. Chapter 17 - Another Point of View—Excel Pivot Tables and Pivot Charts

Click here to download

Read more »

Download PDF SAS Certification Prep Guide Advanced Programming For SAS 9

Sinopsis

PROC SQL is the SAS implementation of Structured Query Language (SQL), which is a standardized language that is widely used to retrieve and update data in tables and in views that are based on those tables.

Content

1. SQL Processing With SAS
2. Performing Queries Using PROC SQL
3. Performing Advanced Queries Using PROC SQL
4. Combining Tables Horizontally Using PROC SQL
5. Combining Tables Vertically Using PROC SQL
6. Creating and Managing Tables Using PROC SQL
7. Creating and Managing Indexes Using PROC SQL
8. Creating and Managing Views Using PROC SQL
9. Managing Processing Using PROC SQL
10. SAS Macro Language
11. Introducing Macro Variables
12. Processing Macro Variables at Execution Time
13. Creating and Using Macro Programs
14. Storing Macro Programs
15. Advanced SAS Programming Techniques
16. Creating Samples and Indexes
17. Combining Data Vertically
18. Combining Data Horizontally
19. Using Lookup Tables to Match Data
20. Formatting Data
21. Modifying SAS Data Sets and Tracking Changes
22. Optimizing SAS Programs
23. Introduction to Efficient SAS Programming
24. Controlling Memory Usage
25. Controlling Data Storage Space
26. Utilizing Best Practices
27. Selecting Efficient Sorting Strategies
28. Querying Data Efficiently

Click here to  download

Read more »

Download PDF Professional Microsoft SQL Server 2014 Integration Services by Brian Knight

Sinopsis

The most important business intelligence tool╇ in the Microsoft Swiss Army knife of tools is SQL Server Integration Services (SSIS). This is because the other tools would be nothing without the cleansing and movement of data into a presentable format. The product can extract, transform, and load (ETL) data astonishingly fast. A 2010 benchmark showed movement of more than a terabyte an hour with SSIS! If you’re new to SSIS, you’ve picked a fantastic field to become involved in. The one consistent skill needed in today’s technical job market is ETL. If a company wants to establish a partnership with another company, it’ll need to communicate data back and forth between the two companies. If your company wants to launch new products, it’ll need a way to integrate those products into its website and catalog. All of these types of tasks are going to require the skill set you are developing and will learn in this book.

Companies that had never used SQL Server before are now allowing it in their environment because SSIS is such an easy-to-use and cost-effective way to move data. SSIS competes with the largest ETL tools on the market like Informatica, DataStage, and Ab Initio at a tiny fraction of the price. SQL Server 2014 now offers more components that you use to make your life even easier and the performance scales to a level never seen on the SQL Server platform.

The best thing about SSIS is its price tag: free with your SQL Server purchase. Many ETL vendors charge hundreds of thousands of dollars, if not millions, for what you will see in this book. SSIS is also a great platform for you to expand and integrate into, which many ETL vendors do not offer. Once you get past the initial learning curve, you’ll be amazed with the power of the tool, and it can take weeks off your time to market. This author team has trained hundreds of people over the years, and you’ll find that the learning curve of SSIS is shallow relative to competing platforms. In SQL Server 2012, the product matured to its third major envisioning. In that release the focus was on scalability, management, and more advanced data cleansing. In SQL Server 2014 an incremental change has happened so new content focuses on patterns in SSIS.

Content

1. Welcome to SQL Server Integration Services
2. The SSIS Tools
3. SSIS Tasks
4. The Data Flow
5. Using Variables, Parameters, and Expressions
6. Containers
7. Joining Data
8. Creating an End-to-End Package
9. Scripting in SSIS
10. Advanced Data Cleansing in SSIS 
11. Incremental Loads in SSIS 
12. Loading a Data Warehouse
13. Using the Relational Engine
14. Accessing Heterogeneous Data
15. Reliability and Scalability
16. Understanding and Tuning the Data Flow Engine
17. SSIS Software Development Life Cycle
18. Error and Event Handling
19. Programming and Extending SSIS
20. Adding a User Interface to Your Component
21. External Management and WMI Task Implementation
22. Administering SSIS

Click here to download

Read more »

Download PDF Database Management System and Sql by Promita Maitra

Click here to download

Read more »

Download PDF A GUIDE TO SQL Eighth Edition by Philip J. Pratt

Sinopsis

Structured Query Language (or SQL, which is pronounced “se-quel,” or “ess-cue-ell”) is a popular computer language that is used by diverse groups such as home computer users, owners of small businesses, end users in large organizations, and programmers. Although this text uses the SQL implementation in the Oracle Database 10g Express Edition as a vehicle for teaching SQL, its chapter material, examples, and exercises can be completed using any SQL implementation. A Guide to SQL, Eighth Edition is written for a wide range of teaching levels, from students taking introductory computer science classes to those students in advanced information systems classes. This text can be used for a standalone course on SQL or in conjunction with a database concepts text where students are required to learn SQL.

The chapters in this text should be covered in order. Students should complete the end-ofchapter exercises and the examples within the chapters for maximum learning. Because the content of Chapter 8 assumes that the reader has had instruction or experience in at least one programming language, the instructor should determine whether students will understand its concepts. Students without a programming background will have difficulty understanding the topic of embedded SQL. Instructors can easily omit Chapter 8 from the text in situations where students are not comfortable with programming examples.

The Eighth Edition builds on the success of previous editions by presenting basic SQL commands in the context of a business that uses SQL to manage orders, parts, customers, and sales reps. Like in previous editions, this edition uses Oracle as the vehicle to present SQL commands. Like the last edition, this edition addresses SQL in Access™ by showing the Access versions of the same commands when they differ from the Oracle versions. This new edition also shows SQL Server commands when they differ from the Oracle versions. Differences for Access and SQL Server users are featured in “User” notes, which make it easy for students to identify differences for the SQL implementation they are using. Students can download the Oracle 10g Database Express Edition from the Oracle Web site for free and use it to complete this text without having to purchase or install the full Oracle program.

The Eighth Edition includes an entire chapter on database design, showing students how to create an appropriate design that satisfies a given set of requirements, and includes coverage of the important topics of stored procedures and triggers. The text also contains updated exercises for the Premiere Products, Henry Books, and Alexamara Marina Group cases.

Content

1. Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
2. Database Design Fundamentals
3. Creating Tables
4. Single-Table Queries
5. Multiple-Table Queries
6. Updating Data
7. Database Administration
8. SQL Functions and Procedures

Click here to download

Read more »

Download SQL Injection Attacks and Defense, 2nd Edition By Justin Clake

Sinopsis

People say they know what SQL injection is, but all they have heard about or experienced are trivial examples. SQL injection is one of the most devastating vulnerabilities that impact a business, as it can lead to exposure of all of the sensitive information stored in an application’s database, including handy information such as usernames, passwords, names, addresses, phone numbers, and credit card details.

So, what exactly is SQL injection? It is the vulnerability that results when you give an attacker the ability to influence the Structured Query Language (SQL) queries that an application passes to a back-end database. By being able to influence what is passed to the database, the attacker can leverage the syntax and capabilities of SQL itself, as well as the power and flexibility of supporting database functionality and operating system functionality available to the database. SQL injection is not a vulnerability that exclusively affects Web applications; any code that accepts input from an untrusted source and then uses that input to form dynamic SQL statements could be vulnerable (e.g. “fat client” applications in a client/server architecture). In the past, SQL injection was more typically leveraged against server side databases, however with the current HTML5 specification, an attacker could equally execute JavaScript or other codes in order to interact with a client-side database to steal data. Similarly with mobile applications (such as on the Android platform) malicious applications and/or client side script can be leveraged in similar ways (see labs.mwrinfosecurity.com/notices/webcontentresolver/ for more info).

SQL injection has probably existed since SQL databases were first connected to Web applications. However, Rain Forest Puppy is widely credited with its discovery or at least for bringing it to the public’s attention. On Christmas Day 1998, Rain Forest Puppy wrote an article titled “NT Web Technology Vulnerabilities” for Phrack (www.phrack.com/issues.html?issue=54&id=8#article), an e-zine written by and for hackers. Rain Forest Puppy also released an advisory on SQL injection (“How I hacked PacketStorm,” located at www.wiretrip.net/rfp/txt/rfp2k01.txt) in early 2000 that detailed how SQL injection was used to compromise a popular Web site. Since then, many researchers have developed and refined techniques for exploiting SQL injection. However, to this day many developers and security professionals still do not understand it well.

In this chapter, we will look at the causes of SQL injection. We will start with an overview

of how Web applications are commonly structured to provide some context for understanding

how SQL injection occurs. We will then look at what causes SQL injection in an application at

the code level, and what development practices and behaviors lead us to this.

Click here to download

Read more »

Free Download PDF SQL Server 2012 Integration Services Design Patterns By Andy Leonard Dkk.

Sinopsis

The first Integration Services design pattern we will cover is metadata collection. What do we mean by “metadata collection”? Good question. This chapter could also be called “Using SSIS to Save Time and Become an Awesome DBA.” Many DBAs spend a large portion of time on monitoring activities such as verifying backups, alerting on scheduled job failures, creating schema snapshots (“just in case”), examining space utilization, and logging database growth over time, to name just a very few. Most RDBMS systems provide metadata to help DBAs monitor their systems. If you’ve been a DBA for a few years, you may even have a “tool bag” of scripts that you use to interrogate metadata. Running these scripts manually is easy when you have just one or two servers; however, this can quickly become unwieldly and consume a large portion of your time as your enterprise grows and as the number of database servers increases. This chapter examines how to use Integration Services and the metadata that exists within SQL Server to automate some of these routine tasks.

Introducing SQL Server Data Tools

One of the major features of SQL Server 2012 is the introduction of SQL Server Data Tools (SSDT). SSDT replaces Business Intelligence Development Studio (BIDS) and leverages the maturity of the Visual Studio product to provide a unified development platform for SQL Server, Business Intelligence (BI), and .NET applications. This book is written using SSDT, although the appearance of the Integration Services designer interface is largely the same as BIDS 2008. SSDT provides backward compatibility for Integration Services 2008 packages via the SSIS Package Upgrade Wizard.

Click here to download

Read more »