Categories

 > Computers & Technology > Databases

3,901 results were found

Sort by:

Transitioning SQL to dplyr
by Djoni Darmawikarta

Language

English

Pages

Publication Date

March 29, 2017

Product Description
Customer Reviews
If you are an R user who wants to move away from SQL and instead wants to manipulate data within R, then this book is perfect for you. You will learn by examples, how to use the functions of dplyr package in place of SQL statements. The R’s dplyr provides functions for manipulating data, hence the SQL statements covered in this book are DML statements (Data Manipulation Language), which include SELECT, INSERT, UPDATE, and DELETE statements.
MongoDB per sviluppatori Node.js: appunti di un programmatore per...
by Christian Palazzo

Language

Italian

Pages

Publication Date

March 28, 2017

Product Description
Customer Reviews
MongoDB per sviluppatori Node.js è una raccolta di appunti scritti durante la frequenza a un corso di MongoDB per sviluppatori Node.js. MongoDB è uno dei più diffusi database non relazionali e si coniuga bene con applicazioni che utilizzano lo stack JavaScript come appunto Node.js. Gli appunti introducono i concetti fondamentali del database e spiegano al lettore, che ha una conoscenza di base di JavaScript e Node.js, come lavorare da shell per eseguire operazioni di CRUD, entra nel dettaglio della struttura del database, spiega come e quando normalizzare o denormalizzare i dati ed entra nel dettaglio di operazioni più complesse come i map-reduce, gli aggregation framework e altro acora.
SQL Server: Tips and Tricks - 1 (SQL Server Tips and Tricks)
by Priyanka Agarwal

Language

English

Pages

Publication Date

March 26, 2017

Product Description
Customer Reviews
SQL Server - Tips and Tricks book has solutions of some real time SQL Server problems that a developer face in most of the real time projects. All solutions are written with best practices and comes with complete to-the-point description and source code.<br />You know the basics of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications.<br />With SQL Server - Tips and Tricks, 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.<br />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.<br />It has data analysis and reporting oriented challenges that are designed to step you through introductory, intermediate and advanced SQL Select statements, with a learn-by-doing technique.<br />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 this 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.<br />Find out how to migrate databases, work with constraints, create stored procedures, triggers, functions, views and cursors and configure effective queries. Security, monitoring, and tuning techniques are also covered in this volume.<br />
On the Move to Meaningful Internet Systems: OTM 2016 Workshops: C...
by Springer

Language

English

Pages

342

Publication Date

April 28, 2017

Product Description
Customer Reviews
<p>This volume constitutes the refereed proceedings of the Confederated International  International Workshop on Enterprise Integration, Interoperability and Networking (EI2N ) , Fact Based Modeling ( FBM),  Industry Case Studies Program ( ICSP ), International Workshop on Methods, Evaluation, Tools and Applications for the Creation and  Consumption of Structured Data for the e-Society (Meta4eS), and OnTheMove Academy (OTMA 2016), held as part of OTM 2016 in October 2016 in Rhodes, Greece.</p><br /><br /><p> The 27 full papers presented together with 8 short papers were carefully reviewed and selected from 58 submissions. The OTM program every year covers data and Web semantics, distributed objects, Web services, databases, information systems, enterprise workflow and collaboration, ubiquity, interoperability, mobility, grid and high-performance computing. </p>
SQL: The Ultimate Guide From Beginner To Expert - Learn And Maste...
by Peter Adams

Language

English

Pages

236

Publication Date

November 11, 2016

Product Description
Customer Reviews
<h1><b>Learn SQL in 100 pages</b></h1><br /><h2><b>✓✓✓ Revised Edition Updated 2/25/17 – Download NOW!</b></h2><br /><p><strong>Structured query language (SQL) is one of the most in-demand skills in the job market today and adding it to your toolkit is essential.</strong></p><br /><p>Whether you’re a beginner or a professional developer, knowing your way around databases is essential. From airlines to hospitals and banks to retailers, nearly every organization relies on databases to run their businesses. SQL is the primary language for managing and interacting with those databases making it essential for database administrators, programmers, and many back-end developers.</p><br /><p>With <em>SQL: The Ultimate Guide From Beginner To Expert - Learn And Master SQL In No Time!</em>, you get everything you need to master SQL including:</p><br /><ul><br /><li>A basic understanding of standard query language</li><br /><li>A wealth of convenient reference tables and quick guides</li><br /><li>Detailed explanations of statements, syntax, and more</li><br /><li>Examples of code for a wide variety of data and scalar functions</li><br /><li>Instructions for building tables using SQL</li><br /><li>Expert recommendations from an industry insider</li><br /></ul><br /><p>With this quick guide, Peter Adams will take you from beginner to expert in a flash. Each chapter covers all the key concepts you need to master to become a database ninja. You’ll work through all the fundamentals and get detailed examples, but the book doesn’t stop there. You also get an entire chapter of expert recommendations on working in the tech industry from staying healthy and organized to fixing or building a computer.</p><br /><p><strong>Stop missing out on high-paying positions and learn SQL today with <em>SQL: The Ultimate Guide From Beginner To Expert - Learn And Master SQL In No Time!</em></strong></p><br /><p>Scroll up to get your copy today.</p>
SQL: Simple and Effective Strategies to learn SQL Programming( SQ...
by Daniel Jones

Language

English

Pages

54

Publication Date

March 14, 2017

Product Description
Customer Reviews
SQL is a program that you are able to use to make work easier. But, what are some of the things that you can do to make it even easier? <br /><br />Have you ever thought of the security on your server? <br /><br />Getting rid of data that you may not need to use anymore? <br /><br />These are some of the things that you are going to learn about in this book plus so much more. <br /><br />The more that you know about SQL the easier it is going to be for you to use SQL. <br />
SQL: The Ultimate Beginners Guide: Learn SQL Today
by Steve Tale

Language

English

Pages

199

Publication Date

June 02, 2016

Product Description
Customer Reviews
<h2>SQL: The Ultimate Beginners Guide - Learn SQL Today</h2><br /><br />Learning the SQL language can be laborious and tedious, but if you have genuine interest in learning a new language and updating your skills, it could be relatively easy.<br />In this book, all the basic information that you need to learn as a beginner are presented. All you have to do is to apply them.<br /><br />This book will serve as an essential guide for you, as a SQL beginner. In addition, the concepts of SQL are laid out in a simple, concise language and instructions to help you learn the steps properly. <br />Specific examples and sample tables is showcased to help you practice most of the SQL queries. <br /><br /><b>Download your copy today!</b>
SQL in 10 Minutes, Sams Teach Yourself
by Ben Forta

Language

English

Pages

287

Publication Date

October 25, 2012

Product Description
Customer Reviews
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
SQL Practice Problems: 57 beginning, intermediate, and advanced c...
by Sylvia Moestl Vasilik

Language

English

Pages

147

Publication Date

November 16, 2016

Product Description
Customer Reviews
<h1>Do you need to learn SQL for your job?</h1><br /><h2>The ability to write SQL and work with data is one of the most in-demand job skills. Are you prepared?</h2><br />It's easy to find basic SQL syntax and keyword information online. What's hard to find is <strong>challenging, well-designed, real-world problems</strong>—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.<p></p><br />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 <strong>the most common problems you encounter</strong> when you deal with data.<br /><br />You will get real world practice, with real world data. I'll teach you <strong>how to "think" in SQL</strong>, 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.<br /><br /><h2>What do you get when you buy SQL Practice Problems?</h2><ul><li><strong>Setup instructions</strong> for MS SQL Server Express Edition 2016 and SQL Server Management Studio 2016 (Microsoft Windows required). Both are free downloads.</li><li><strong>A customized sample database</strong>, with a video walk-through on setting it up.</li><li><strong>Practice problems</strong>  - 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.</li><li><strong>Answers and a short, targeted discussion</strong> section on each question, with alternative answers and tips on usage and good programming practice.</li></ul><br /><h2>What does SQL Practice Problems <i>not</i> contain?</h2><ul><li>Complex descriptions of syntax. There’s just what you need, and no more.</li><li>A discussion of differences between every single SQL variant (MS SQL Server, Oracle, MySQL). That information takes just a few seconds to find online.</li><li>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.</li></ul><br /><h2>What kind of problems are there in SQL Practice Problems?</h2><br />SQL Practice Problems has data analysis and reporting oriented challenges that are designed to step you through introductory, intermediate and advanced SQL Select statements, with a learn-by-doing technique.<br /><br />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.
SQL for Beginners: The No BS Introduction
by Sarah Stevens

Language

English

Pages

Publication Date

March 21, 2017

Product Description
Customer Reviews
Learning SQL doesn't have to be a painful experience. So why do so many resources for "Beginners" make things so complicated?<br /><br />If you are new to SQL, trying to get through a 500 page encyclopedia-style book full of every existing detail on the subject can be a daunting task. How can you be expected to remember details when you don’t even have a solid foundation of the basics yet? That's like trying to teach someone to ride a 10 speed mountain bike before they've mastered training wheels.<br /><br />The goal of "SQL For Beginners: The No BS Introduction" is to give you a crash course on entry level SQL fundamentals. This book does not use unnecessary amounts of technical jargon, require you to download a sample database to follow along, or expose you to an overwhelming amount of information that you won't actually use yet. It will provide you with easy to follow examples and detailed explanations on the concepts that are most important to know when starting your journey to learn SQL.<br />This book was written from my own perspective as a Microsoft SQL Server user, but developers on any platform can benefit from its content on the basics of relational databases, table structures, and query syntax.<br />

Enter the Kind Reader Monthly Drawing

Kind Reader Monthly Drawing (March 2017)

Congratulations to February 2017's winner Henry H. of New York, USA.