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.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

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 Filing of Overtime

Online Overtime module allows employee to enter the overtime worked on particular days and request authorization must be applied on their respective login account available for every employee's dashboard. read more »

Online Leave Management

Online leave management using Pinoy Web Application is the simple way to file a leave of absence with pay. By automating leave approval process can eliminate unexcused absences without filling of leave. Employee self-service dashboard account have an easy interface to apply and view leave request status. The online staff leave planner allows administrators to set up employee information and leave types and policies easily. read more »

Web Application Payroll Register

Pinoy web application payroll register is a data process that all lists of total information for every pay period upon approved by payroll approver before saving to the payroll register like total gross pay, total overtime, total allowances, total of each type of deduction, and total net pay. The computation for each individual employee like gross pay, net pay, withholding tax, overtime pay and other deduction amount seen in payslip report are stored in database table payroll register. read more »

Mortgage Loan Calculator

Calculate your Mortgage Loan using this mortgage calculator. It's important to calculate mortgage monthly amortization payment to know how much you can afford for investing house & lot, car or other loans. read more »

2018 TRAIN Law Tax Calculator

TRAIN Law Tax Calculator to allow individuals to have an idea on how much their monthly salary deduction of withholding tax, sss, pagibig, philhealth contribution and salary net pay. read more »