The ultimate beginner´s guide to learning SQL - from retrieving data to creating databases! Structured query language, or SQL (pronounced ´´sequel´´ by many), is the most widely used programming language in database management and is the standard language for relational database management systems (RDBMS). SQL programming allows users to return, analyze, create, manage, and delete data within a database - all within a few commands. With more industries and organizations looking to the power of data, the need for an efficient, scalable solution for data management is required. More often than not, organizations implement a relational database management system in one form or another. These systems create long-term data ´´warehouses´´ that can be easily accessed to return and analyze results, such as, ´´Show me all of the clients from Canada that have purchased more than $20,000 in the last three years.´´ This ´´query´´, which would have taken an extensive amount of hands-on research to complete prior to the use of a database, can now be determined in seconds by executing a simple ´´SELECT SQL´´ statement on a database. SQL can seem daunting to those with little to zero programming knowledge and can even pose a challenge to those who have experience with other languages. Most resources jump right into the technical jargon and are not suited for someone to really grasp how SQL actually works. That´s why we created this book. Our goal here is simple: to show you exactly everything you need to know to utilize SQL in whatever capacity you may need in simple, easy-to-follow concepts. Our book provides multiple step-by-step examples of how to master these SQL concepts to ensure you know what you´re doing and why you´re doing it every step of the way. PLEASE NOTE: When you purchase this title, the accompanying reference material will be available in your My Library section along with the audio. 1. Language: English. Narrator: Dave Wright. Audio sample: http://samples.audible.de/bk/acx0/048167/bk_acx0_048167_sample.mp3. Digital audiobook in aax.
Microsoft Excel is one of the most widely used programs in the world and across all of the different business industries. Because of this, many people who use Microsoft Excel regularly don´t even know what it is fully capable of. This is the start to discovering the full potential. Excel: A Beginner´s Guide to Microsoft Excel will help guide you! Inside this guide, you will find an introduction into Microsoft Excel that is aimed at a beginner, or someone who wants to improve his or her Microsoft Excel skill. This is the best place to start if you have always been curious, but were too afraid to ask for help, for seeming like you were out of touch. Inside this guide, you will find many time-saving tips and shortcuts, like how to switch between relative and absolute cell references in less than a second. Excel is a must-have skill in the ever-growing data intensive business world. Do yourself a favor and put the time and the effort into learning the basics first, so that you have a good foundation in order to enter data more efficiently, manipulate cells or worksheets, and format to present data in an easier to understand fashion. Stop wondering and take action now! You will not regret the time you spend listening this book! Inside, you´ll learn how to: Get to know Excel Entering or editing data Entering text and numbers Entering data into multiple cells at once To copy data from one cell to another Entering time or a date How to enter a sequence of numbers Using basic formulas and functions Some useful functions Switching between absolute and relative cell references Manipulating cells Adjusting default settings To display more information in a cell at one time To create a drop-down list To insert columns and cells To delete rows, cells or columns l 1. Language: English. Narrator: Charissa Clark Howe. Audio sample: http://samples.audible.de/bk/acx0/062751/bk_acx0_062751_sample.mp3. Digital audiobook in aax.