Learning SQL: Master SQL Fundamentals (2nd Edition)

Learning SQL: Master SQL Fundamentals (2nd Edition)

AUTHOR: Alan Beaulieu

PUBLISHER: O'Reilly Media

PAGES: 338

ISBN-10: 9780596520830; ISBN-13: 978-0596520830

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:

* Move quickly through SQL basics and learn several advanced features
* Use SQL data statements to generate, manipulate, and retrieve data
* Create database objects, such as tables, indexes, and constraints, using SQL schema statements
* Learn how data sets interact with queries, and understand the importance of subqueries
* Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

About the Author
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

Disclaimer

Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.

Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.

HRMS & Payroll Web Application

Online HRMS & Payroll System Module Application

List of application module that currently available in Online HRMS & Payroll System to be used by designated user assigned by Web Administrator. read more »

Payroll System Web Application Process Flow

Payroll processing performs many tasks to ensure accurate deduction of tax, loans & mandatory contribution of SSS, Philhealth, Pagibig and others deduction. Pinoy Web Application designed for automation of process to avoid padding of time or eliminate fraud most of all the payroll output in a minutes. read more »

Generate Employee's Annual Income Tax Return (ITR)

Preparation of Annual Income Tax Return for all employee's BIR Form 2316 in manual process are so complicated and can caused a human errors in also take a lot of time to finished. read more »

Generate Timesheet from Daily Time Records (using finger scanner In/Out)

Using DTR Biometric Finger Scanner application system time-in/time-out we create module process to generate Timesheet for every employee. Before generating employee timesheet cut-off date make it sure that all pending approval of leave & overtime covered on that payroll cut-off date that filed by the employee’s should be approved by designated department. The report monitoring status of Leave & Overtime will help you to identify head department with pending approval to prompt them to approve. read more »

DTR Biometric Finger Scanner Time-In/Time-Out

Digital Persona U.are.U 4500 Finger Print Reader is my Software Development Kit (SDK) used in development of Daily Time Records (DTR) Attendance System which is designed to captures the time-in / time-out logs for every employee's and also we embed text to speech features... need speaker to prompt the user what is going on. Most of company today are now using Biometric fingerprint authentication to be used in time attendance that accurately and timely tracked for management reporting and also for accounting payroll processing. read more »