Free Kindle Edition eBook: SQL Programming for Beginners & Intermediates, Step-By-Step Illustrated Guide @ Amazon AU

1420

Affiliate

Go to Deal

Cashback

cheapoguy on 11/08/2018 - 23:49 amazon.com.au (3695 clicks)

This post contains affiliate links. OzBargain might earn commissions when you click through and make purchases. Please see this page for more information.

AU link
US link

Taken from website:

In This Book You Will Learn:
- The fundamentals of SQL.
- The SQL Data Types.
- How to use SQL constraints.
- Data Query Statements.
- Data Manipulation Statements.
- The SQL Syntax.
- How to easily manage databases.

Do you feel overwhelmed by the complicated jargon and tech stuff that comes with SQL?
If so, this is the book you've been looking for. Each of the various commands and data types are explained thoroughly in an easy to understand way. In addition to that, every SQL statement has an example shown right after it to make the process of learning SQL as simple as possible. This book is not only to be used by beginners but also intermediates as a referencing tool when needed.

Become an Expert in 7 Chapters
You will learn:
- The basics of SQL - Chapter 1: Overview of SQL.
- The core fundamentals of SQL programming - Chapter 2: Fundamentsals of SQL
- What are databases - Chapter 3: Understanding databses.
- How to retrieve data - Chapter 4: SQL Syntax.
- How to use all data types in SQL - Chapter 5: Data Types.
- How to use the various SQL statements - Chapter 6: SQL Statements.
- How to apply SQL constraints - Chapter 7: Constraints in SQL.

Related Stores

Amazon AU

Marketplace

Amazon Cloud Reader

• 

  dojomojo on 12/08/2018 - 02:57

  +12

  SELECT * FROM OZBARGAIN WHERE ARSE = TIGHT AND…

  • 

    HeavenlyHammocks on 12/08/2018 - 03:29

    +1

    UPDATE Referral_Codes SET Code = 'mycode' WHERE User LIKE '%' AND Store LIKE '%Amazon%'

    Thanks for the commissions.

    • 

      browser on 12/08/2018 - 07:22

      +3

      User like ‘%’ is unnecessary.

      • 

        Ry009 on 12/08/2018 - 08:12

        https://lh5.googleusercontent.com/proxy/h_xjcoPc38YX3RuLQaQM…

    • 

      starburstyellow on 12/08/2018 - 12:09

      And user != 'browser';

  • 

    Usernames on 12/08/2018 - 08:28

    +3

    …WHERE ARSE = ‘TIGHT’…

• 

  browser on 12/08/2018 - 07:23

  -5

  NoSQL is taking over.

• 

  [Deactivated] on 12/08/2018 - 08:58

  -6

  SQL is a scripting language. You don't program it.

  • 

    Crocfreefree on 12/08/2018 - 09:25

    +6

    Yeah, everyone knows you incant it.

    But the distinction between languages is very blurred these days. Just what is a "scripting" language anymore? It used to be whether a language wasn't compiled or capable of heavy lifting, but with Python and JavaScript (node.js) running from the server and basically underpinning the entire web, it's not really a useful distinction any more.

    Anyway, SQL is not a scripting language, it's a structured query language for the domain specific task of talking to databases.

    And "programming" is still the appropriate verb whether it's for scripting, database, systems level, graphics, or machine code.

    • 

      [Deactivated] on 12/08/2018 - 09:37

      -3

      Keep up your SQL 'programming', haxxor, there are procedural extensions. Maybe Koding with Klossy is for you, if not tautology. SQL is 'a' structured query language? Wow. My insider tip is that NASA is a space agency located in North America. ;) Like you, I find that fact both self evident and fascinating.

    • 

      [Deactivated] on 12/08/2018 - 15:17

      +1

      Crocfreefree: "it's a structured query language"

      Quora: "Despite what some other responders have said, SQL does NOT stand for Structured Query Language. That is a moniker that was pasted on it after the fact. The language, which is a declarative language, and which in its current standard version supports looping and other features of procedural languages, was initially developed by IBM. It was called SEQUEL, which was an acronym for Structured English QUEry Language. The name was appropriate because the form of SQL statements is much like English sentence structure, but even more structured. It is Structured English, not a structured query language. It is not what computer scientists call a structured language at all because it supports the Go To function, which is the hallmark of unstructured languages, such as BASIC.

      When IBM’s in-house SEQUEL became a commercial product, because of a trademark problem, they dropped the vowels and called it SQL. Many people still pronounced it as sequel and that practice has stuck. The proper pronunciation is ess-queue-ell and it is not an acronym. As is the case with C, the letters do not “stand for” anything."

      "it is Structured English, not a structured query language".

• 

  Frayin on 12/08/2018 - 09:01

  =IF "tight", arse, loose,

  But no for real, thanks op. Doing a cert 4 in programming next year so hopefully this gives me a headstart.

  • 

    harro112 on 12/08/2018 - 12:36

    IFF*

• 

  testeagles on 12/08/2018 - 09:23

  +5

  DELETE FROM user
  WHERE user.username = 'jv'

  • 

    starburstyellow on 12/08/2018 - 12:10

    Commit;

• 

  bryans on 12/08/2018 - 09:52

  +1

  I prefer INNER JOINS to OUTER JOINS

  • 

    kevsta on 12/08/2018 - 15:05

    I prefer cartesian joins.

    • 

      lancedefrance on 12/08/2018 - 20:08

      I prefer joints

• 

  Callandor on 12/08/2018 - 10:16

  Is this a good way to learn SQL? I'm currently using sololearn but it seems like it'll only take me so far

  • 

    dm01 on 12/08/2018 - 11:28

    Most likely not. This appears to be a self-published book, so of questionable quality and/or accuracy, and the two other titles the "author" has credited to their name are on the topics of cryptocurrency and hemp oil respectively.

    Best find yourself an SQL title from a reputable author - there's a good reason why many eBooks are frequently given away for free.

    • 

      Frayin on 12/08/2018 - 11:59

      My lecturer hates 90% of the information on the internet. He's incredibly well versed in everything ICT. So i asked why doesn't he issue articles and information on the many sectors. He's yet to give me a response lol.

      • 

        dm01 on 12/08/2018 - 12:15

        Has your lecturer read all the information of the internet?

      • 

        ozhunter on 12/08/2018 - 12:20

        +5

        @dm01:

        He only read 90%, but he hates all of it.

      • 

        Frayin on 12/08/2018 - 12:26

        @ozhunter: hates 100% of 90% of it. My other lecturer holds PhDs in chemical sciences and strongly believes climate change is not an issue. Soooo…. ya.

      • 

        dm01 on 12/08/2018 - 13:24

        @Frayin: PhDs don't count for all that much anyway, in my opinion. As for climate change, it most certainly is an issue, but it's the cause of it that's debatable.

    • 

      Polde on 12/08/2018 - 12:26

      Can you recommend some good online courses/books?

      I've recently started a job where I feel having SQL knowledge would help me greatly.

      • 

        BigLeviathan on 12/08/2018 - 17:22

        +1

        Subscribe to local library and get access to lynda.com to learn sql

• 

  Master Haggler on 12/08/2018 - 11:30

  +1

  My left join is bigger than my right join

  • 

    starburstyellow on 12/08/2018 - 12:11

    +1

    You should go see a doctor about that.

• 

  grips on 12/08/2018 - 11:55

  +1

  All of that in only 64 pages? There are better introductions available.

• 

  cdaddy on 12/08/2018 - 12:39

  +1

  DELETE from users WHERE user_name = 'jv';

  UPDATE users SET admin = '1' WHERE user_name = 'cdaddy';

• 

  Baa on 12/08/2018 - 20:55

  Sad I missed the chance come make some a smartass ozbargain SQL statement first.

  When people ask me how to learned I just tell them to google it - worked out ok for me!

• 

  tik tok on 13/08/2018 - 08:41

  Free, no longer.