1. SQL (Database Programming) (2014)
2015 Edition. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You’ll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author’s examples.
- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.
- Learn the core language for standard SQL, and variations for the most widely used database systems.
- Organize your database in terms of the relational model.
- Master tables, columns, rows, and keys.
- Retrieve, sort, and format data.
- Filter the data that you don’t want to see.
- Convert and manipulate data with SQL’s built-in functions and operators.
- Use aggregate functions to summarize data.
- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.
- Create, alter, and drop tables, indexes, and views.
- Insert, update, delete, and merge data.
- Execute transactions to maintain the integrity of your data.
- Avoid common pitfalls involving nulls.
- Troubleshoot and optimize queries.
- Plenty of tips, tricks, and timesavers.
- Fully indexed and cross-referenced.
1. Running SQL Programs
2. The Relational Model
3. SQL Basics
4. Retrieving Data from a Table
5. Operators and Functions
6. Summarizing and Grouping Data
9. Set Operations
10. Inserting, Updating, and Deleting Rows
11. Creating, Altering, and Dropping Tables
About the Author
Chris Fehily is a statistician and author based in San Francisco.
Author(s): Chris Fehily
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.
Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
- Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
- Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
- Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
- Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
- Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers
Author(s): Steven Feuerstein, Bill Pribyl
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition
New full-color code examples help you see how SQL statements are structured
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.
Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.
You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.
With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.
10 minutes is all you need to learn how to…
- Use the major SQL statements
- Construct complex SQL statements using multiple clauses and operators
- Retrieve, sort, and format database contents
- Pinpoint the data you need using a variety of filtering techniques
- Use aggregate functions to summarize data
- Join two or more related tables
- Insert, update, and delete data
- Create and alter database tables
- Work with views, stored procedures, and more
Table of Contents
1 Understanding SQL
2 Retrieving Data
3 Sorting Retrieved Data
4 Filtering Data
5 Advanced Data Filtering
6 Using Wildcard Filtering
7 Creating Calculated Fields
8 Using Data Manipulation Functions
9 Summarizing Data
10 Grouping Data
11 Working with Subqueries
12 Joining Tables
13 Creating Advanced Joins
14 Combining Queries
15 Inserting Data
16 Updating and Deleting Data
17 Creating and Manipulating Tables
18 Using Views
19 Working with Stored Procedures
20 Managing Transaction Processing
21 Using Cursors
22 Understanding Advanced SQL Features
Appendix A: Sample Table Scripts
Appendix B: Working in Popular Applications
Appendix C : SQL Statement Syntax
Appendix D: Using SQL Datatypes
Appendix E: SQL Reserved Words
Author(s): Ben Forta
SQL Made Easy – a Step by Step Guide
Are you curious to learn SQL? Does the thought of SQL rattle your brain? Do you need to learn how to use SQL in order to properly manage a database? Let this book settle your nerves and successfully guide you through the basics of learning SQL.
This book serves to be used not only as a beginner’s guide, but also as a cheat sheet. Finding a command, keyword, or function is simple in this clearly laid-out book. Functions and various commands are outlined in an easy to read format for quick referencing. Along with each stetement is an example in order to easily understand how to implement it.
Take time to successfully learn SQL today! Learn SQL the right way with a guidebook that will help you understand what each and every symbol and text mean. With a complicated subject, this book will offer a simple solution!
What You Will Learn Inside
- The basic workings of SQL.
- Detailed keywords, statements, commands and functions, and how to put them to use in specific or altered ways.
- How to use each formula in a real life situation.
- Terminology, syntax and expressions.
- Data types used by each of the four main databases.
- And much, much more.
Get Your Copy Today!
Author(s): Nathan Clark
5. SQL: Learn SQL in 24 Hours or Less – A Beginner’s Guide To Learning SQL Programming Now (SQL, SQL Programming, SQL Course) (2016)
Learn SQL In 24 Hours Or Less!
In this book you will find practical tips and detailed instructions on how to learn the SQL language in just one day.
This eBook will teach you the most important aspects of SQL. It will give you theoretical explanations, realistic examples, actual syntax and lots of codes. If you’re looking for a comprehensive guide about the SQL language, this is the material you’re looking for.
By reading this book, you’ll learn about a wide range of SQL-related topics:
- The different types of databases
- How to use SQL for a relational database
- The different types of SQL commands
- How to create a database
- How to give/revoke account privileges to users
- How to create tables and columns
- How to customize columns
- The different data types in SQL
- How to apply constraints on tables and columns
- How to work with related tables
- How to enter new information into a database
You can certainly benefit from this eBook even if you have never programmed anything before. This eBook will teach you the basics of SQL programming and give you the syntax of important SQL commands. If you want to become a skilled SQL programmer in just 24 hours, get this eBook now and read it carefully.
In addition you will find inside:
- Fundamental Concepts Regarding SQL And Databases
- OThe Environment Of The SQL Language
- How To Generate And Modify Tables
- How To Ensure Data Integrity
- How To Create An SQL View
- Database Security
- And Much, Much More…
Get Your Copy Right Now!
Author(s): Robert Dwight
6. SQL: Easy SQL Programming & Database Management For Beginners, Your Step-By-Step Guide To Learning The SQL Database (SQL Series) (2016)
Learn SQL Programming And Database Management Today With This Easy Step-By-Step Guide!- SQL Ultimate Beginner’s Guide 2017
Updated & Improved: June 2017
Do you want learn SQL Programming?
Do you want to understand how to manage databases without getting overwhelmed by complicated jargon?
If so, “Easy SQL Programming & Database Management For Beginners. Your Step-By-Step Guide To Learning The SQL Database” by Felix Alvaro is the book for you! It breaks down the fundamental elements that are essential to make you a confident SQL programmer and proficient in Database Management.
SQL is a software language that is powerful yet simple, flexible, portable and, most of all, integrated into numerous database applications. The current trend now is to become more digital in managing databases.
Deciding to become a database professional can benefit you when working on your own projects, explode your intrinsic value that will land you high-paying jobs or well-paid freelance work. The demand for database analysts is steadily growing and entry-level analysts in the US earn an annual salary of around $92,000 USD.
What Separates This Book From The Rest?
What makes this book unique is how easy it makes it for you to learn. The author brings you a guide that takes you through a natural sequence of lessons, step-by-step, carefully explaining each concept and staying away from unnecessary technical jargon whilst defining the terms you need to learn. This one-step-at-a-time approach allows anyone from an absolute beginner to a more knowledgeable programmer, to easily grasp each lesson and become more proficient as they progress through the book.
In addition to that, this guide also contains images, examples and other tools to give you the assurance you are going in the right direction, as well as exercises that will allow you to retain up to 400% more of what you learn by practicing your exciting new skills!
You Will Learn The Following:
- The history of SQL and its uses
- The fundamentals of Relational Databases and Database Management Systems
- The SQL Structure
- The SQL Data Types
- Data Definition Language Statements
- Data Manipulation Language Statements
- Data Query Language Statements
- Transactional Control Commands
- Working with Database Views
- Enhancing Database Designs Using Primary and Foreign Keys, Index and Normalization
- Understanding Cursors, Triggers and Errors
- And much more!
You have made the best choice by choosing to learn SQL programming and Database Management. Whether you are looking to land a high-paying job, want to delve into freelancing or want to work on your own projects, you have found the right book. Take the first step in the right direction by ordering your copy now!
See you inside!
Author(s): Felix Alvaro
Ready for a career in computer programming but not sure where to begin?
Learn three of the most important programming languages: Java, SQL, and C++.
With Programming: Computer Programming for Beginners Learn the Basics of Java, SQL & C++ 4th edition, by Joseph Conner, you’ll learn the coding skills you need to build a broad range of apps for PCs and mobile devices. This 2017 Edition, is fully updated with all the current information. It’s not just a great place for beginners to get started, it’s also a handy reference and useful tool for experienced programmers who haven’t used Java, SQL, or C++ for a few years.
You get everything beginners, and pros need including:
• The basics of computer programming and programming languages
• A guide to setting up a programming environment on your PC
• The Pros and Cons of coding with Java, SQL, and C++
• Basic syntax and easy exercises
• All the basic functions and skills you’ll need
• Advanced Java, SQL, and C++ programming
• Expert tips for programmers
• Solutions to common beginner programming mistakes
• Glossary of common terms
• Helpful reference tables and lists
Programming: Computer Programming for Beginners Learn the Basics of Java, SQL & C++ 4th edition, by Joseph Conner is a quick guide designed to get you up and running fast. You’ll start by learning all the basics, so you have a solid foundation for more advanced skills. Before you’ve finished your journey, you’ll start seeing results right on your screen with helpful exercises, and after you’re done, you’ll have a useful reference to go to when you need it.
Launch your computer programming career today with Programming: Computer Programming for Beginners Learn the Basics of Java, SQL & C++ 4th edition, by Joseph Conner.
Author(s): Joseph Connor
The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.
You’ll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.
- Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements
- Addresses essential topics including managing keys, writing scripts, and working with store procedures
- Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services
Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.
Author(s): Paul Atkinson, Robert Vieira
9. Oracle Database 12c PL/SQL Programming (2014)
Master Oracle Database 12c PL/SQL Application Development
Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.
- Explore new SQL and PL/SQL features in Oracle Database 12c
- Build control structures, cursors, and loop statements
- Work with collections, varrays, tables, and associative array collections
- Locate and repair errors and employ exception handlers
- Execute black box, white box, and integration tests
- Configure and manage stored packages and libraries
- Handle security with authentication and encryption
- Use LOBs to store text and multimedia content
- Write and implement PL/SQL and Java triggers
- Extend functionality using dynamic SQL statements
- Understand object types, nested tables, and unnesting queries
Author(s): Michael McLaughlin
Author(s): Os Swift
11. Oracle Database 10g PL/SQL Programming (2004)
Author(s): Scott Urman, Ron Hardman
12. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach (2017)
The ability to write SQL and work with data is one of the most in-demand job skills. Are you prepared?
It's easy to find basic SQL syntax and keyword information online. What's hard to find is challenging, well-designed, real-world problems–the type of problems that come up all the time when you're dealing with data. Learning how to solve these problems will give you the skill and confidence to step up in your career.
With SQL Practice Problems, you can get that level of experience by solving sets of targeted problems. These aren't just problems designed to give an example of specific syntax. These are the most common problems you encounter when you deal with data.
You will get real world practice, with real world data. I'll teach you how to "think" in SQL, how to analyze data problems, figure out the fundamentals, and work towards a solution that you can be proud of. It contains challenging problems, which develop your ability to write high quality SQL code.
What do you get when you buy SQL Practice Problems?
- Setup instructions for MS SQL Server Express Edition 2016 and SQL Server Management Studio 2016 (Microsoft Windows required). Both are free downloads.
- A customized sample database, with a video walk-through on setting it up.
- Practice problems – 57 problems that you work through step-by-step. There are targeted hints if you need them, which help guide you through the question. For the more complex questions, there are multiple levels of hints.
- Answers and a short, targeted discussion section on each question, with alternative answers and tips on usage and good programming practice.
What does SQL Practice Problems not contain?
- Complex descriptions of syntax. There's just what you need, and no more.
- A discussion of differences between every single SQL variant (MS SQL Server, Oracle, MySQL). That information takes just a few seconds to find online.
- Details on Insert, Update and Delete statements. That's important to know eventually, but first you need experience writing intermediate and advanced Select statements to return the data you want from a relational database.
What kind of problems are there in SQL Practice Problems?
The problems in SQL Practice Problems are oriented towards data analysis and reporting. They are designed to step you through introductory, intermediate and advanced SQL Select statements, with a learn-by-doing technique.
Most textbooks and courses have some practice problems. But most often, they're used just to illustrate a particular syntax. There's no filtering on what's most useful, and what the most common issues are. What you'll get with SQL Practice Problems is the problems that illustrate some the most common challenges you'll run into with data, and the best, most useful techniques to solve them.
Author(s): Sylvia Moestl Vasilik