Posts Tagged ‘In Easy Steps’

Just released : SQL in easy steps ebook for Kindle, Apple Books, Google Play, Kobo and Nook

Written by In Easy Steps Team on . Posted in News

SQL and what is it used for?

SQL stands for Structured Query Language. It is the language used to communicate with a database. According to ANSI (American National Standards Institute) it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. While most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database.

The spread of dynamic websites on the World Wide Web today is largely due to the possibility for their content to be handled through databases. Database management is a complicated process, which has been considerably rationalized by the SQL programming language. As its full name (Structured Query Language) implies, SQL is responsible for querying and editing information stored in a certain database management system. The biggest uses of Structured Query Language (SQL) today have to do with using a long-established conventional language for relational databases with newly emerging enterprise IT environments, like cloud-native systems, virtual networks, etc. Essentially, SQL is used to retrieve data or otherwise interface with a relational database. As a standard, SQL is a popular way to get information out of relational database systems. Relational databases are set up with a particular structure — each record has a series of keys that are linked to one another in consistent ways and placed in a “table” represented visually in a grid. The SQL language is written to comb the contents of tables in a conventional database. SQL is widely used in business and in other types of database administration.

SQL in easy steps

SQL in easy steps, 4th edition, demonstrates SQL features using the current MySQL Relational Database Management System that is supported on both Windows and Linux operating systems. This fourth edition introduces and explores databases, creating database tables, inserting data into tables, data retrieval, data filtering, data manipulation, making complex queries, handling data tables, and more. The manual begins with instructions for how to install a free SQL database server onto your system, prior to describing what SQL is and proceeding to provide a comprehensive explanation of SQL’s application. Each chapter ends with a summary of the contents within the chapter to allow the reader to reflect on and retain the information provided. With its step-by-step approach, the In Easy Steps guide is perfect for anyone approaching SQL for the first time, from web-developers to students and hobbyists.

 SQL in easy steps now available in print, ebook and pdf formats.  Visit relevant ebook store for the ebook version.

The Raspberry Pi Zero

Written by In Easy Steps Team on . Posted in News

An In Easy Steps guide to the $5 computer, the Raspberry Pi Zero

From one of the best British homegrown computer manufacturers, comes the Raspberry Pi Zero. The $5 computer, available now in both the UK and the US, is the result of the company’s long standing and most important aim, to drive down the cost of computer hardware. This tiny piece of technology, small in both size and price is one huge step forward in bringing computer technology and programming knowledge to everyone.

Compared to the original Raspberry Pi Model B and its successors, priced around $20-$35, the new Raspberry Pi Zero comes in at a fraction of the price, and still secures its place as a fully-fledged member of the Raspberry Pi family.

Specifications include:

  • Broadcom BCM2835 application processor (1GHz ARM11 core – 40% faster than the Raspberry Pi 1)
  • 512MB of LPDDR2 SDRAM
  • Micro-SD card slot
  • Mini-HDMI socket for 1080p60 video output
  • Micro-USB sockets for data and power
  • Unpopulated 40-pin GPIO header (identical pinout to Model A+/B+/2B)
  • Unpopulated composite video header
  • Form factor of 65mm x 30mm x 5mm

Made in Wales, UK, the Raspberry Pi Zero runs Raspbian, and all of your favourite apps – Scratch, Minecraft and Sonic Pi to name a few. A full low-down is featured in the December issue of The MagPi, and you could also be in the running to win a FREE Raspberry Pi Zero with each copy!

For more information, visit or get your copy of Raspberry Pi in easy steps now!

A Quick Guide to the Festive Season – In Easy Steps!

Written by In Easy Steps Team on . Posted in News

Hello December!

The countdown has begun, it’s the 1st of December and there are only three more weeks to pack in all the decorations, present wrapping and family visits. Here’s our guide to the Festive Season, In Easy Steps!

  1. Have you discussed the plans for the big day itself? Home or away, it’s worthwhile planning travel arrangements, who is bringing what, and how many guests will be attending
  2. It’s now officially December, so it is acceptable to get the tree, Christmas songs, lights and general holiday decorations out and organised, to properly get in the festive spirit!
  3. Wrap up those gifts! Whether you are doing a Secret Santa, presents for the kids, or gestures of goodwill instead of another pair of socks, once they’re all ticked off and wrapped up, you’ll breath a sigh of relief. (Don’t forget to check out our Special Offers and Coming Soon titles!)
  4. Timing is everything, especially when it comes to the food prep. Make a list for when everything needs to be in the oven, or on the stove, and stick it on the fridge



Make sure to rope in any little helpers for the vegetable peeling!



Less is often more when it comes to decorations, so find a theme and stick to it!




Check the weather forecast! Although a white Christmas is often reserved for the movies (at least here in Britain!), it’s handy to know whether you might need your wellies or not!


Seasons Greetings!

From, the In Easy Steps team!



Apple Tech Update – iOS 8.4

Written by In Easy Steps Team on . Posted in News

ios 8.4

Apple Tech Update – Apple Music, Audio Books and iOS bug fixes

The latest iOS firmware update – 8.4 – has just been released.

With the unveiling of Apple Music, now available to download through iOS 8.4, Apple has also made some vital bug fixes surrounding the watch, GPS systems and iBooks.

Apple’s new music streaming offering is generally receiving good reviews, being relatively easy to set up, it contains five different options of music indulgence to discover (For You, New, Radio, Connect and My Music). There are more comprehensive search facilities and tailor-made playlists based on the music you like to hear (check out our previous article to get the full down-low!). Like many others, we’ll wait and see how it performs against streaming giant Spotify once the three month trial ends.

Next on the roll-out is a key fix for the Apple watch, which has been updated to solve the issue of apps reinstalling after they had been deleted. GPS location services have also been improved helping devices and accessories provide fixed location data.

Finally, the update to iOS 8 includes an enhanced audio books feature. Apple has now made iBooks more intuitive, letting users browse, sample and download audio books all in one app. Previously, audio books were based within iTunes, which made it difficult to locate the downloads and sync with other devices. With iOS 8.4, everything is within iBooks, which also includes a newly designed ‘Now Playing’ feature specific to audio books, and a sleep timer. Audio books are also now filed alongside your eBooks and PDF documents, which will make it a lot easier accessing and reading your favourite In Easy Steps titles on your iPad or iPhone!

Will you be trying out Apple Music? Are you an Android fan or loyal to Apple?

Comment below – we’d love to hear your thoughts!

For all the info on iOS 8, go to

Apple Music, the new streaming service to rival Spotify?

Written by In Easy Steps Team on . Posted in Article

You may have noticed the term Apple Music in the media recently, due to some top musicians – most notably Taylor Swift – challenging the big guys at Apple to rightfully pay for the music they are selling, but what actually is it?

Apple Music is touted to be the Spotify of the Apple world. At WWDC 2015 Apple unveiled the new service; a mix of Beats Music and iTunes, with a 24-hour live radio broadcast, personalised playlists, recommendations and the whole vault of iTunes music ready and waiting for your listening pleasure. From BBC Radio 1 fame DJ Zane Lowe will headline station Beats 1, alongside a selection of expertly curated stations from world renowned DJ’s and artists. There will be industry insights, knowledge, news and reviews encompassing the whole music world.

Starting from the first setup, the technology behind Apple Music personally curates – Apple Music is all about ‘curating’ – results and suggestions from what you initially search, and over time learns all about all your likes and dislikes. There are innovative playlists curated by a worldwide team, which constantly update and change throughout the day so you’ll never listen to the same list of songs, unless you want to.

One of the top features of Apple Music is Connect. Here artists can post an array of exclusive media, behind the scenes photos, videos, unreleased demos, or stripped back versions of a favourite track, all at the mercy of their dedicated fan base. Apple Music’s own social-media hub if you like. You can view, comment, like, favourite and share all this exciting content, right at your fingertips.

In terms of membership, there are two main profiles once you have passed the three month free trial. Single membership, which is pretty self explanatory and family membership, which allows up to six people unlimited access on their devices. Both will have a price attached, but with membership your whole music library is in iCloud, so very little space is taken up on your devices.

Once released and all devices are up to date, Apple Music can be accessed (to a certain degree) on iPhones, iPads, iPod touch, the Watch, Macs, PCs and even Android in the near future. The great thing about Apple Music is that all of your music will be in one place regardless of where it came from. Tell Siri to play the greatest hits of the 80’s, or add a song to your favourite playlist and she will. There’s even a feature for offline use!

So there you have it. Apple Music. Coming soon to a device near you. Now with fully paid artists, labels and publishers alike.

Find out more at