Best sql books according to redditors

We found 487 Reddit comments discussing the best sql books. We ranked the 102 resulting products by number of redditors who mentioned them. Here are the top 20.

Next page

Top Reddit comments about SQL:

u/gfody · 84 pointsr/programming

First don't think of this as "DBA" stuff - you're a developer, you need to know database technology, period. Read this rant by Dennis Forbes in response to Digg's CTO's complaints about databases it's very reminiscent of TFA.

Read Data and Reality by the late William Kent (here's a free copy) and get a fundamental understanding of "information" vs. "data". Then read Information Modeling and Relational Databases to pickup a couple practical approaches to modeling (ER & OR). Now read The Datawarehouse Toolkit to learn dimensional modeling and when to use it. Practice designing effective models, build some production databases from scratch, inherit some, revisit your old designs, learn from your mistakes, write lots and lots and lots of SQL (if you want to get tricky with SQL I suggest to pickup Celko's SQL for smarties - it's like the Hacker's Delight for SQL).

Many strange models you may encounter in the wild are actually optimizations. Some are premature, some outright stupid, and some brilliant, if you want to be able to tell one from the other then you're going to dive deep into internals. Do this generically with Modern Information Retrieval and Managing Gigabytes then for specific RDBMSs Pro SQL Server Internals, PostgreSQL Internals, Oracle CORE, etc.

Reflect on how awesome practically every modern RDBMS is as a great technological achievement for mankind and how wonderful it is to be standing on the shoulders of giants. Roll your eyes a little bit whenever you overhear another twenty-something millenial fresh CS graduate who skipped every RDBMS elective bleat about NoSQL, Mongo, whatever. Try not to fly into murderous rage when another loud-mouthed know-nothing writes at length about how bad RDBMS technology is when they couldn't be bothered to learn the most basic requisite skills and knowledge to use one competently.

u/coffeecoffeecoffeee · 20 pointsr/statistics

You absolutely will need R and/or SAS to do any work beyond basic statistics. You'll have to know how to do data munging and how to reshape your data to get it in the right form. It's 2018. You have to know how to clean your own data. Additionally, you'll be asked to repeat complicated analyses, or questions like "How did you calculate this number in this analysis from six months ago?" A point-and-click interface doesn't give you a record that makes it easy to do these things. In a programming language, you can rerun complex procedures in the press of a button. Programming can be a little scary at first, but once you get the hang of it, you'll wonder how you lived without it.

Fear not though! There are a ton of fantastic resources to learn how to code. If you've never programmed before, my recommendation would be to go through the Codecademy intro Python tutorial. Even if you never want to use Python after this, you'll learn about variables, conditions, loops, data types, functions, and language-specific features. These are ideas that exist in every programming language (well SAS has macros, not functions, but you get my point.)

I also recommend using R for all of your statistics homework, even if the professor doesn't require it. That's how I learned R. It'll put you in a position where you have to learn how the language works and where the functions you want to use are. Once you have the basics of R down, check out R for Data Science. It's a very modern book on R that encourages you to use user-friendly packages to do data analysis. As for SAS, it's a terrible language that's losing market share to R and is popular because it's popular. It can help to know the basics, but it's a language I leave off my resume and LinkedIn because I never want to touch it again.

I'd also recommend learning SQL at some point. Most datasets will be in databases you'll have to query for the data you want. My favorite book for this is SQL in 10 Minutes, which is a book of 10-minute lessons, where each one is on a SQL concept. Don't worry about the specific SQL dialect since they're virtually all the same. Once you're comfortable with basic queries and joins you're in good shape.

u/YvesSoete · 17 pointsr/learnprogramming

Hello, I would suggest to get a good book on SQL basics, install an open source free database server like MySQL on your mac (via DMG) and just get the basic commands. Nothing to get certified in. The user side, you, are just going to perform basic commands. Database Administrators with bazillion years of experience (/s) will take care of the data servers for the users, you. Good luck.

A good book for you would probably be:
SQL Queries for mere mortals.

Any SQL certification for you, as a data analyst or a financial analyst, is completely useless. Just get the practical skills and show them on your interview.

u/BadassRipley · 12 pointsr/librarians

>With that said, are there any languages that you think would be particularly good for me to know?

SQL, and then Python if you're interested in working with databases. HTML and CSS might also be good if you're interested in working in an academic or public library in the future.

>Which language(s) would be most helpful to learn first?

Whichever really, HTML was easier for me to understand at first since I wanted to see how websites worked before trying to do my own thing.

>Lastly, are there any specific coding resources you would recommend?

Two great websites are General Assembly or codeacademy which have individual lessons and show you the code right alongside the instructions.

W3schools has a bunch of tutorials on the basics.

For SQL, you can't go wrong with Ben Forta's Teach Yourself SQL in 10 Minutes

Feel free to PM me if you have any more questions!

u/Bored2001 · 9 pointsr/consulting

SQL is insanely easy. Like, learn enough of it in a week to do real work easy. Everyone used to recommend this book But you can probably find better sources these days on youtube or something.

For python, you can find tons of resources online.

R is like SAS. It's a programming language geared specifically for doing statistics/data analysis.

u/[deleted] · 8 pointsr/programming

> And that's perfectly fine, because the relational model is not practical enough for real world uses.

You had me right up until this. Why do you say that it's not practical enough? I've lost count of the number of problems I've encountered in SQL databases that wouldn't have happened--couldn't have happened--had the database been truly relational. Whole classes of these kinds of issues, and their solutions, are found in SQL and Relational Theory: How to Write Accurate SQL Code. So this is not a troll; I'm genuinely curious as to what you mean. Thanks!

u/halifaxdatageek · 8 pointsr/SQL

Take an afternoon, read this book.

Read this blog post.

Get a copy of the Chinook database, start querying random shit to see what comes up.

That should get you 80% of the way there.

u/AustinCodingAcademy · 7 pointsr/learnprogramming
u/gthank · 5 pointsr/webdev

You may want to read SQL for Smarties.

It does a very good job of stressing the importance of adjusting your thinking when you're working with a relational DB. If you approach SQL as if it were a procedural language, you will hate it, your results will suck, and DBAs (and devs who are competent at SQL) will make fun of you.

u/DeadAlive55 · 5 pointsr/SQL

I’d have to say these were a great combo in my SQL class last year:

SQL Queries For Mere Mortals


Murach’s MySQL

Jon Duckett also has a MySQL & PHP book coming out next month that I’m looking forward to. Loved his books on HTML/CSS and Javascript/JQuery

PHP & MySQL: Server Side Web Development

u/jmarkman446 · 5 pointsr/learnprogramming

If you're looking for someone to go over the language one on one with you, you could try r/ProgrammingBuddies

Otherwise, you could buy SQL Queries for Mere Mortals which was incredible in understanding and writing queries in comparison to learning from the websites that I tried. You could probably get the book via "other means" if you want, as well. You can supplement the book with Google/StackOverflow searching.

If you want to try before you buy, you could use CodeAcademy's SQL course - I don't really like recommending CA to people but I found their SQL course to be useful for a general understanding.

u/Xpertbot · 5 pointsr/PHP

LOL, I am also a Junior PHP developer with a Java background ( I didn't want to work for a big corporation doing Java). I took a whole summer to read this and that was more than enough to get the basis of PHP. Its way easier than Java for sure. Good luck.

u/Leeham721 · 5 pointsr/unitedkingdom

tl:dr; make websites and learn Search Engine Optimisation

The context of my starting point is important, hence the detail:

I'm 26 now, and after leaving sixth-form I became the full time carer of my Dad and as a result haven't worked a normal job, now I'm trying to get in to work from basically step 0, and struggling massively to even get a rejection email/letter.

In that time I volunteered for a media charity that does hospital radio & internet radio, and I made 5 websites for them. When we launched an internet radio station from scratch, I made their website. Without me they would have needed to pay money we just can't spare. When you search "[Local area] radio" it's on the very first page of Google results, even ahead of 'radio directory' websites. Companies in our area are contacting us to work with us, they say they find us on Google. I learned everything I know in my free time without paying a penny. They tried to bring people on from a local college to assist me when my time was short and couldn't find anyone to do even basic tasks.

It's a great skill to have and it's in demand. It's easy to learn. There's pre-made software you can build upon such as WordPress. If you look in your local area it's very easy to find companies with shitty websites that can be convinced to pay you, and that is where I am currently heading. I picked up a huge book to finally formally learn PHP, JavaScript etc and next year I'll start my company. I already have a portfolio and proof my work is effective.

If you don't want to hunt down books, there are an infinite number of free resources for all skill levels.

u/YuleTideCamel · 5 pointsr/learnprogramming

Just out of curiously, why are you going the php route? Instead of rails, python (django) , node or mvc?

When buying books I normally check the Amazon reviews

I also try to buy directly from O'Reilly if I can. They often have great sales (50% off ebooks and such) and their ebooks are 100% DRM free so I can use them on any device.

I'm not familiar with the book you mentioned, but just though I'd provide insight on my book buying process.

u/the_real_farfetchd · 5 pointsr/softwaregore

where the fuck are you buying your books

u/cs2818 · 4 pointsr/PHP

Grab a decent book on the subject, I used PHP and MySQL Web Development years ago to get started.

Alternatively, has some basic PHP intro videos.

And you can find both of these options for free by searching around if you want.

u/CaptinShmit · 4 pointsr/PHP

> I'm trying to learn programming had have chosen as my language of choice.

What? What language have you chosen?! The suspense is killing me!

But seriously, this tutorial on Tizag was very helpful to me when I was first learning PHP a few years ago.

And the book PHP and MySQL Web Development is huge, and I never technically "finished" reading it, but it's certainly got some good stuff in it and I would recommend you check it out.

By and far, the best way to learn any kind of programming, is to just do it! Before I started reading programming books, I only knew exactly enough to do what I wanted to do. Choose a project to start with and keep Googling until you figure out how to make it a reality.

Let us know if you need any further help!

u/theguywithballs · 4 pointsr/SQL

I would be useful to find out which specific DBMS they use but in the meantime I would recommend getting SQL in 10 Minutes, Sams Teach Yourself.

The book teaches ASNI (American National Standards Institute) SQL - all the general main concepts like SELECT, UPDATE that all DBMS share.

It has 22 chapters that each take 10 mins to read (but you should spend more time after each chapter practicing examples). It was incredibly helpful for me when I started learning as i knew 0 about SQL. There's a reason that books it #1 Best Seller. Once you find out what database they use you can learn DBMS-specific functions in addition.

u/xperia3310 · 4 pointsr/web_design

Hey if you are starting to learn web design don't head towards random website and start learning randomly. Instead use books to properly grasp the concept and what web designing is all about.
If you are new to web designing don't read this book "HtmlandCssBook" which the user redditor3000 mentioned.

Start with this book instead --> Learning Web Design: A Beginner's Guide to HTML, CSS, JavaScript, and Web Graphics

After reading the very first chapter of that book most of the questions you asked should be answered.
Then I would suggest to read this book next - Learning PHP, MySQL, JavaScript, CSS & HTML5: A Step-by-Step Guide to Creating Dynamic Websites

u/datavirtue · 4 pointsr/learnprogramming

If you want to get serious and take it to the next level you should check out Microsoft SQL certification.

The author is amazing. He also has some good videos on MSDN or Microsoft Learning.

u/zzzeek · 3 pointsr/Python

for years I've recommended going through SQL for Smarties which in the years since I had it seems to have grown to be three times its size, but nevertheless describes relational databases and SQL querying from the classical DBA perspective. He also has SQL Puzzle books that are also great. If you go through Celko's books you'll really have a sense for how a relational database was really meant to be used, and when you see someone touting MongoDB queries you'll just laugh your ass off.

u/dsmsp · 3 pointsr/statistics

I recommend this one for people new to SQL. It's good to learn from and keep as a reference manual.

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (4th Edition)

u/jwfergus · 3 pointsr/dataengineering

Re-iterating what the previous posters said: the fundamentals are the same regardless of system. Learning how to get data out of a SQL system is all about learning how to write SQL.

To effectively learn how to write SQL for data engineering, I highly recommend grabbing a book like one of these*:

  1. SQL Quickstart Guide
  2. SQL Queries
  3. If you're an experience programmer maybe T-SQL Fundamentals (Microsoft flavor SQL)

    and grabbing a sample database for the system of your choice:

  4. MySQL sample Employee db
  5. PostgreSQL sample dbs
  6. SQL Server - stackoverflow db

    and then practice some of your chosen book on the sample db.

    Notes and words of warning:

  • Writing SQL for data engineering or programming is really different than "database administration." A lot of resources on the web are geared towards DBAs and it probably won't help you out much.
  • University courses on databases tend to be more theoretical than practical, for the sake of learning how to write SQL. University isn't a super efficient method of learning to write SQL.

    ^((*I'm not affiliated w/ any of those books))
u/theocarina · 3 pointsr/PHP

Hey, I briefed over some of the comments here, and while I feel a number of them are useful and necessary, I think you need an actual hard copy book to start with, rather than jumping right the hell into the manuals.

The book I started with, with absolute minimal programming experience (just some C++ classes in high school), is Larry Ullman's PHP book. I started on the second edition, and it was everything I needed to get started programming with PHP and making dynamic applications. It should cover basics of MySQL and top the book off with regular expressions, which are absolutely necessary to any serious web developer, and he makes everything feel very accessible.

After some months of that and programming, you would be ready to enhance your skills, and his follow up Advanced PHP book covers a lot of interesting and esoteric areas. It might be more than you need, but it does start off with some practical chapters in OOP and classes.

In-between the two, he wrote a MySQL and PHP combination book that sort of acts as a stepping stone between the beginner's book and the advanced book, and it might actually be the most you need to program in PHP, but I found the Advanced book handy to use, and the first book I linked you was my personal guide and reference for about a year and a half as I grew in my skill set.

u/jtreminio · 3 pointsr/PHP

Intro to PHP/MySQL:

More advanced SQL knowledge:

More advanced PHP knowledge:

Go in that order, you'll be very comfortable in a few months.

u/robbotic · 3 pointsr/programming

C# is a good language to get started with.

I recommend buying a book to get started, this will give your self-learning more structure.

Other great languages to start with are: Ruby and Python.

PHP is really easy to learn and get started with, but you're pretty much stuck doing only web applications then.

u/thethax · 3 pointsr/SQL is open this quarter, and covers the fundamental relational database concepts.

SQL and Relational Theory is a solid next step. (and available using the free 10 day Safari Books Online trial account)

For specific syntax, refer to Microsoft's own product documentation. The SQL Server Books Online should have been installed on your workstation along with the client tools if you're using SSMS. The T-SQL language reference begins here.

You might also want to install one of the SQL Server editions on a workstation as a playground so you don't need to worry about breaking your production servers. Developer Edition is under $50 a seat. Express is free. There's also a time-limited full evaluation copy available here.

u/warl0ck08 · 3 pointsr/androiddev

Depending on what you are looking to do, and how ambitious you are, you can use something like Parse if you wanted.

The cheapest way, and the most customizable is using JSON, PHP, and MySQL. You can calculate, do whatever, and give it back to the app. [This] ( is a good book on PHP and MySQL. A simple tutorial on how to use JSON in Android and PHP should get you on the right track.

u/mogwai512 · 3 pointsr/PHPhelp

> I want to return response in real time to javascript

I'm about to get really thorough with my response so, "hold on to your butts"


As /u/Mike312 hinted at, this is not how PHP and vanilla Javascript works, and as such you would have to seek alternative frameworks or languages(like Websockets, NodeJS) or you can keep reading for an alternate solution.

What you must understand is that PHP is code that lives on and is rendered on the back-end (server). That means that by the time the front-end (browser) has access to the page, the PHP code on the server has already executed.


Now that you better understand relationship between PHP & Javascript means you have two options, a simple one and a more complex one:


Simple Option: Abandon real-time

Since you seem to be a beginner when it comes to PHP, this is the option I recommend as it is the simplest and fastest. In this case, you would have something on the front-end, like a button, that would call a new page. This page will render the results of the function I provided you.

To break it down:

  1. You press a button in the browser.
  2. The button redirects you to a new page.
  3. The new page has the PHP function I provided you above, and runs it.
  4. A page is the rendered to the user saying something like "After X attempts, here are the results: "


    Complex Option: Explore AJAX

    AJAX or Asynchronous JavaScript and XML allows your browser(front-end) to make calls to your server (back-end) without reloading the page. This means that, as an example, you can create a button on the front-end that executes a javascript function. The javascript function would then make an AJAX call to your server, and you could return that server data WITHOUT having to reload your page. Please see the link I provided above for a very good example.

    I won't write up full on code for you that shows you how the HTML/JS/AJAX/PHP all interact but, here is an outline of how I would do it:

  5. Modify the fgcContents function I gave you above to only take in a URL, and only return results and data. Since you are using AJAX, your front-end should manage and return the number of attempts. This will be explained in more depth later

  6. Create an HTML page with a button.

  7. Have the button trigger a Javascript function

  8. Have the JS function define two variables, the number of attempts and the URL to hit (the url is where your PHP code will reside).

  9. With those variables defined, build out your AJAX request using the url variable, but do NOT call it yet. Instead, define a loop that will repeat X times, with X representing the variable you defined above as the "number of attempts".

  10. Inside the loop, make the AJAX call, but also add checks for whether or not the AJAX call failed or succeeded.

  • If the AJAX call succeeded: This means that the AJAX call was successful, it does NOT mean that your fgcContents function was successful, so you need to examine the results of the call (which should be the results of the "fgcContents" function) and use javascript to update your HMTL. For example, if "fgcContents" returns an array where "results" is TRUE, then you can update or add some HTML on your page that says "Attempts: 1 and Data: your_data_here". If results is "false" ("fgcContents" returns an array where "results" is FALSE), then you can update your HTML to list out the number of failed attempts, and with each failed attempt, the users page will update, thus providing you real-time results.

  • If the AJAX call failed: Again, this does NOT mean the fgcContents function failed, it just means the AJAX call did not go through. This can happen due to errors in your code, network issues, etc. Either way you will need to capture this and report it to the user somehow.


    I know this is a lot of info to take in, but it should help implement a simple solution, then as your knowledge grows you can implement the complex solution.

    As a side note, if you are really looking into learning front-end/back-end development, I recommend the following books:

    Web Design with HTML, CSS, JavaScript and jQuery Set

    PHP & MySQL Development
u/CharBram · 3 pointsr/excel

To learn SQL, start with this book:

Then once you need more ideas with SQL, go to this book:

For Python, I would start with this book:

SQL may come almost naturally to you. For me at least, the basics of SQL came rather easily. With Python, expect to be a little lost, not with the programming concepts but with setting up your computer and getting Python packages installed, etc... Once you get all that done though, you will be golden.

u/beer_kimono · 3 pointsr/SQL

Your code doesn't sound that bad. I once updated a series of reports (ie, vendor report, services report, etc.) that the previous guy made internally consistent by re-running the entire original base report (including select) in every other report because they were timing out. I honestly still wasn't too mad at him because he'd turned it from a 20+ step access db job into reports through SSRS.

I would focus on what you've identified.

For grouping, go through hackerrank's aggregation - and/or Itzik Ben-Gan's TSQL Querying books chapter on grouping.

Having is a filter (where clause) that's applied after the data is grouped. You might group together orders by customer and filter out customers whose max order-date is more than a year ago. Most of my aggregate or grouped queries don't have a 'having' clause.

For performance, I you might look at some of your longest running reports and re-factor them using the execution plan, etc. Itzik's has a chapter on query tuning. I'm not personally great at it because I don't use it a lot.

u/beyphy · 3 pointsr/excel

I started learning SQL by reading Itzik Ben-Gan's T-SQL Fundamentals. It's a fantastic text that I read cover to cover. One of the chapters on ACID was extremely boring (that's mostly DBA stuff) but other than that I thought it was very interesting. Microsoft also has an EdX course that's similar to the book if you'd prefer to use that.

As far as applying it goes, I set up multiple databases. So I had SQL Server, postgres, Access, and SQLite. I didn't get to apply it at my last job, but our DBA was comfortable enough with my knowledge to create a schema for me so that I could use postgres instead of having to use MS Access. I also personally found that employers were fairly impressed by it.

u/amazon-converter-bot · 3 pointsr/FreeEBOOKS

Here are all the local Amazon links I could find:

Beep bloop. I'm a bot to convert Amazon ebook links to local Amazon sites.
I currently look here:,,,,,,,,,,,,, if you would like your local version of Amazon adding please contact my creator.

u/fez_28 · 2 pointsr/SQLServer

Not SQLServer specific, but Joe Celko's "SQL For Smarties" is a great reference for all things SQL:

u/dinnerotast · 2 pointsr/PHP

I learnt by reading PHP and MySQL for Dynamic Web Sites
It is written for PHP 5.6 so it is outdated (unless they have updated it since)

The follow on book is also worth reading. It helped me understand how to use OOP in PHP

PHP Advanced and Object-Oriented Programming

When I read these books they were written for PHP 5.6. PHP is now on 7.2 and there has been a lot of features since then. It'll still help you get a practical grasp of PHP.

As cout112 suggested, PHP the right way is a really good resource too. I highly recommend going through some of the pages.

Best of luck with the new job.

u/Amicus22 · 2 pointsr/SQL

SQL Queries for Mere Mortals is an excellent beginner's read front to back. The same guy wrote a database design book, which I did not find as helpful.

As for software, it depends on what database system you end up using. I use SQL Server and a little MySQL, but I know PostgreSQL, SQLite, and many others are popular.

If you're learning indipendantly, I'd start with MySQL , as it is free (open source) and you will be able to learn the basics of SQL in any SQL database. It also has a good free GUI development tool, MySQL Workbench, and a robust online community.

Like any programming language, the best way to learn is to build something with it. So start thinking of something you want to build, so you'll have something to do once you know enough to play around.

u/Reptilian_Overlords · 2 pointsr/sysadmin

>But basically after that I have to decide soon whether or not to focus on a Cisco, or Microsoft track at my college.

Sounds like your "college" is a joke. You should be learning the fundamentals that are responsible for the underpinnings of these technologies, not vendor recommendations that can easily almost be called propaganda. Especially at your beginner level, you wouldn't even touch technologies as part of your responsibility at the level taught by an MCSE or CCNA unless you work for an absolute moron.

The world is larger than Cisco and Microsoft. I suggest you look for actual academic books on Networking and Server Architecture to learn more useful things.

Computer Networking: A Top-Down Approach (6th Edition)

Understanding and Deploying LDAP Directory Services, 2nd Edition

For future tracks:


SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition)

Fundamentals of Database Systems (7th Edition)


Computer Security: Principles and Practice (3rd Edition)

Blue Team Handbook: Incident Response Edition: A condensed field guide for the Cyber Security Incident Responder.


Upgrading and Repairing PCs (22nd Edition)

Problem Solving:

The Thinker's Toolkit: 14 Powerful Techniques for Problem Solving

Best of luck. I recommend learning Shell languages and the basics of shell navigation and data manipulation techniques for various operating systems as well.

u/24x7man · 2 pointsr/PHP

If you don't really know how to code, I would vote for PHP. There are tons of books, tons more examples, and is pretty easy to get started on with WAMP and LAMP stacks.

I personally started PHP using this book:

But, if you don't want to take a formal training after this, dive in. It'll take a bit, but you can search and read for the stuff directly what your after. I have built a couple applications this way, and was fun.

u/joeschmidt45 · 2 pointsr/AskReddit

I would go with this:

The Headfirst series really helped me get my jump start into programming, and I think this would be really helpful for you.

u/PatrickMorris · 2 pointsr/PHP

Head First PHP & Mysql

The Head First series is really good, they will walk you through the language using numerous mini projects and some bigger ones, giving you a little head start in the right direction for each one. The books in this series always get great review

u/ashenrose · 2 pointsr/webdev

I'm going to assume you're a complete newbie. I'm only a few steps ahead of you, really, but I can share some advice. I've always felt like 75% of the battle is figuring out what to learn when it comes to scripting or computer languages in general. And a lot of time, even cutting edge, comprehensive sources are outdated within a few years and, if you follow their advice, you may expose yourself to security concerns. Like leapyquacky said, the question is a bit vague, but I'm going to assume you want employees to access a page with user-specific credentials so no employee can impersonate another, etc:

  1. PDOs/prepared statements are the best way to connect to the DB. The PDO documentation will help immensely. It should be easy enough if you've ever done any OOP. The reason for this -- and this is really paramount, especially if it's on the internet -- is the risk of SQL injections.

  2. To maintain any semblance of security, you'd need to hash your users' passwords, and likely with something a little more secure than MD5. There's an excellent article on Openwall about this. You'd need a hash, a salt, and minimum length/complexity requirements for your passwords. This is just not good practice, it's essential if you store anything sensitive.

  3. You'd be using sessions to maintain state across your pages. The best videos I can think of on sessions are behind a paywall, but the documentation should get you pretty far. phpacedemy on YouTube has a few videos on sessions, if I recall. Just remember, if you're using YouTube to learn about sessions, a lot of those videos are dated and the security practices won't be ideal. If you see them connecting to their DB using mysql_connect, this is the case. Listen to the session advice, but don't use that function unless you care to get pretty technical about escaping user input.

  4. You're going to need levels of access on the page -- admin, general, etc., so you can protect information and actions that need to be secure. You'd probably also want a running log of all the changes your users made to the database.

  5. None of this stuff will make much sense unless you're familiar with PHP. The documentation is great, but I recommend reading a good book on it, bearing in mind that whatever you read could be out of date. (Hint: Argh, matey, thar be a website that may get yeh the book yeh want withou' yer payin'.)

    It's not hard but it requires a scattershot of understanding that may take a little while to really get. I know it did for me, anyway. Once you have that going on, you'll probably have more specific questions. Lookin' forward to it.
u/mdgm · 2 pointsr/AskReddit

I had the same problem as you, tried Drupal and Joomla but I found it was too difficult to tailor them to my needs (basically, creating an online catalog of pictures, an email form and some static pages). Finally I ended learning pure PHP+MySQL from a book and it worked pretty good for me.

PS: English is not my native language so... excuse me for any mistakes ;)

u/KSKWEM · 2 pointsr/webdev

If you have any experience with manipulating tables in general then learning how to use a (MySQL) database is relatively intuitive, provided that you aren't concerned with optimization issues such as normalizing tables, scaling problems down the road, or managing any fancy relationships. I'm sorry for how demoralizing this sounds but... based on the needs you've described you could probably teach yourself all you'd need for that project and how to interact with a MySQL database via PHP in less time than its taken you jump through all these hoops trying to use Google spreadsheets.

Here's a good and relatively cheap book on the matter.

I read that book as a CS undergrad before taking any database classes and it helped quite a bit; in particular the chapters on MySQL are very concise and easy to read. Even if you've never seen PHP before just seeing MySQL syntax for the first time hopefully leads to a "oh well duh that's all very intuitive" moment. Hopefully it will help give you a better understanding of the larger picture and how these languages interact with each other.

Note: There are tons of other great, free resources online that you can peruse at your leisure without paying for a book.

u/alexcp · 2 pointsr/learnprogramming

A great book for beginners

Learning PHP, MySQL, and JavaScript

u/Astrimedes · 2 pointsr/xna

I agree with CygnusX1's comment - it would be helpful to have a dedicated C# book to learn from to really get a handle on how to use the language. I think the "Learning C#" books are really good.

That book starts off really simple - as if you have no programming experience and no idea of what OOP is - and just keeps ramping up the complexity and depth. I learned C# from the "2.0" version of that book, and to be honest I'm not sure which version is used by XNA 4.0, or how that works exactly, but the fundamentals will be the same.

Work your way through that book from the beginning and keep going until you're lost. Do some programming work, and then use that book as a reference, or keep going further into it when you're feeling adventurous.

I've been working with XNA for a little over a year now, coming from some programming experience, but no game development or C# experience, and it's served me really well.

u/no_dice_grandma · 2 pointsr/learnprogramming

For PHP and MYSQL I really liked this book:

It doesn't have much in the way of JS, and it is not free, but the 20 dollar kindle version is worth it in my opinion. The high reviews are accurate, and the author doesn't spend much time with stuff like "this is a variable, a variable is blahblah!!"

I haven't made it all the way through yet, as I am currently picking up Java at the same time for work, but so far the book is great.

u/AjdinSamurai · 2 pointsr/learnprogramming

Add "" around free.This is an amazon link.I am short on money too but at least I will say it's pirated.

u/systematical · 2 pointsr/PHP

I grabbed a book from my local library 12 years ago and thats how I started. Went through half the book doing all the samples by hand, modifying them, even the dumb loop examples. It was this one

I'd start by rummaging through your local library. The book will act as a lecture, you can use google for the rest. It's best to have a project in mind that you will build. It was at least motivating for me knowing that once I got through enough of the book I could actually build what I wanted. Wasn't pretty to start, but it worked.

u/FurriesRuinEverythin · 2 pointsr/PHP

This was the book that helped me learn a lot of what I know

It's probably considered somewhat dated with all the current obsession with OO, MVC and "unzip and run" web apps. I'm not sure though as I had the first edition, years ago. But it is one of the best PHP books out there for beginners.

u/pisskidney · 2 pointsr/PHP

read this
then this

Build something you like while reading them.

u/U3011 · 2 pointsr/web_design

Here's a good list I keep posting because people often ask the same question - not like it's a bad thing.

In any case follow the below, but I really suggest for total newbies to first go through the course Codecademy offers. It won't teach you much in how to do things but the syntax education is good. Follow their HTML and CSS courses and when you're done, create a site using just HTML and CSS. Once done, try to emulate a few of your favorite sites using just these two languages.

Once done you should check out the free 30 day Tutsplus courses on HTML/CSS and jQuery. At some point you will want to go back to Codecademy and take their JS course. Syntax and method of doing or starting certain things is important. It's incredibly easy to pickup the actual methods of doing things once your head understands the syntax used.

Any form of education that follows a hierarchical format makes for easy learning.

Codecademy isn't bad. It won't teach you much in the way of doing things but it does teach you the way to type out code, the general process and stuff. I can't speak for myself because I work as a professional developer and have been tinkering with code for 10 years now, but I did give the first lesson to one of my brothers. He's not great with computers or the Internet, but he was able to follow the first two sections of the basic HTML/CSS course and able to make his own site albeit very basic in nature nearly a month later (3 week gap following him doing the lessons). He was able to do a rough basic site of his Facebook profile, and he nailed it. It should open doors for you in terms of having the basic knowledge of how to do things. It'll allow you to read more advanced stuff and pick it up much faster than if you hadn't.

Below is a list I sent to someone on here a while back.


>PHP and MySQL Web Development (4th Edition)
>Beginning PHP and MySQL: From Novice to Professional
>Read the second book, do all the examples, then go back to the first book. Pay a lot of attention toward array manipulation. When you're comfortable with that, get into OOP. Once you do and OOP clicks for you, you'll be able to go to town on anything. I've heard a lot of good about Jefferey Way's video lesson courses over at TutsPlus. I've never used them nor do I need to, but I've never heard a single bad thing about their video courses. Their Javascript and Jquery is a great starting point. This is great stuff too if you're willing to put in the time.
>Professional JavaScript for Web Developers
>JavaScript: The Definitive Guide: Activate Your Web Pages
>Responsive Web Design with HTML5 and CSS3
>The Node Beginner Book
> Professional Node.js: Building Javascript Based Scalable Software
>Paid online "schooling":
>I've got a shit ton (Excuse my French) of books in print and E-Format that I could recommend, but it would span a couple pages. Anything is easy to learn so as long is it's served in a hierarchical format that makes it easy to absorb the information. A year ago I started to learn Ruby and using ROR as a framework. I can say it's been quite fun and I feel confident that I could write a fully complete web app using it. I started node.JS a few months ago, but it's been on break due to being sick and some unexpected events.
>My knowledge is extensive only because I wanted it to be. I'm not gifted by any means nor am I special. Not by a longshot. Some people are gifted when it comes to dev and design, most are not. Most only know one or the other. I forced myself to learn and be good at both. I'm 23, I started when I was about 12. I'm only breathing more comfortably now. I know a load of people on here and other sites who make me look like complete shit.
>Also for what it's worth, sign up to StackOverflow. It's the bible and holy grail rolled up into one site. It's amazing.
>Hattip to /u/ndobie
>> CodeAcademy
Team Treehouse
> CodeSchool. This is more programming but still very useful & has free stuff.
> Google. Probably the best way to find out how to do something specific.
This subreddit. If you have any questions about how to do something, like parallax scrolling, try searching for it, then ask, make sure to include an example of what you want if you don't know what it is called.

u/SandyZoop · 2 pointsr/PHP

My company is working on an introductory PHP book, but I'm not sure when it'll be out (my hope is soon). It will be up to date, at least.

Until then, the most solid introductory one I've found is Luke Welling and Laura Thomson's book. It, too, is a bit long in the tooth now, but it's pretty solid. They are working on a new edition, apparently, which I'll recommend until my wallet says to trash it in favor of ours. ;)

For free resources, as always, I'll plug PHP the Right Way which really does cover up-to-date practices for developing with PHP and also covers lots of PHP 5.4 and 5.5 stuff.

u/shinigamiyuk · 2 pointsr/learnprogramming

I learn by doing: Become a PHP developer from Treehouse. I have found that treehouse is pretty basic for learning, but you are leaning by project based. They do keep adding stuff though, this is not apart of the learning adventure but they just finished using PHP with MYSQL. I like the flow and challenges and type everything out that they are doing. There is also this great PHP book, it was written in 2008 but I didn't have any trouble with the text, or project. You basically build a dynamic web app that you keep adding features to. First book I have picked up that kept me interested from chapter to chapter. I normally get programming books and never read them, or get super bored with them.

u/youlleatitandlikeit · 2 pointsr/webdev

Mastering Regular Expressions is a joy to read and makes you a better user of this powerful (and misunderstood) tool.

SQL in 10 Minutes is easily the best introduction to the most common SQL you'll need to use unless you're actually planning on being a full DBA. Anyone who ever needs to step outside of an ORM should have a basic understanding of SQL and this book is it. Short, understandable, and to the point.

A lot of the books that really helped me as a developer back in the late 90s and early 00s just aren't as relevant anymore:

  • JavaScript, the Definitive Guide by David Flanagan (just use online resources)
  • The ColdFusion Web Application Construction Kit — I don't do much ColdFusion development anymore, Ben Forta's book is way out-of-date, and again most of the info you need is now online.

    Then there are books about programming. These books still remain fairly relevant even as technologies change.

  • Code Complete & Rapid Development, both by Steve McConnel
  • Head First Design Patterns
  • Don't Make Me Think (more about interface design; an essential read for people who touch the front end)
u/beaverteeth92 · 2 pointsr/statistics

If they're that big, you might want to look at PortgreSQL. Especially if you aren't doing anything too complicated. To learn SQL, I highly recommend Sam's Teach Yourself SQL in Ten Minutes.

u/masterprtzl · 2 pointsr/todayilearned

Relational databases are definitely a lot better and scalable in the long run than excel spread sheets. I would recommend the book "Teach yourself SQL in 10 minutes" as a great way to familiarize yourself with the basics.

u/dangoodspeed · 2 pointsr/SQL

I bought the book "Sams Teach Yourself SQL in 10 Minutes", where each chapter teaches a new idea and should take about 10 minutes to read. I found it pretty handy and informative.

u/muchcake · 2 pointsr/SQLServer

This is great, but a little dense as a beginner

T-SQL Querying (Developer Reference (Paperback))

u/cesclaveria · 2 pointsr/learnprogramming

I was in your place a few years ago and what I did was to start picking up books on subjects I knew had a market. I usually started with the "for dummies" version, then moved to the "Wrox Beginning <something>" and then to the "Wrox professional <something>" another editorial I have read is "Apress"

For example how I first started with web development was with these books (well, different versions but the same line):

u/seanpotts · 2 pointsr/web_design

When I was trying to learn PHP a major deterrence was thinking of projects. When I would Google what to test my skills on, the list would go from something basic like a calculator to a full blown content management system. Pretty difficult in terms of skill gap. So I bought Beginning PHP and MYSQL when I was starting out and it's pretty straight forward:

PHP for Absolute Beginners might be good for you as well:

u/e1349b · 2 pointsr/webdev is a really good tutorial website. I like the Head Start HTML & CSS book, then the O'Reilly book, PHP,mySQL,JavaScript, and CSS (all in one book)

Here is the link to the book. I am on chapter 4 and so far it is pretty good. They explain everything like you have never touch it before, which is good.

Oh, and here is the one to the Head First HTML & CSS one

If you read both of these books, you will be well prepared to tackle web development projects. Then, when you want to learn more about a programming language (Like JavaScript) you can either buy the JavaScript book from O'Reilly, or watch the more advanced TheNewBoston tutorial videos.

Good luck!

u/vagara · 2 pointsr/learnjavascript

As far as training goes I am a trainee myself so I don't know how much help I can provide. Since you seem pretty new to all this (with the most positive meaning) here are some points I can give you and I hope others will correct me where I am wrong.

  • Learn the basics of each language. You need HTML, CSS3 and Javascript. Those cover the front end. Especially for Javascript I hear good words for this book That codewars site you using will help you cement the basics of the language but don't spend very long time in that.

  • For back end you seem to have chosen PHP. I would complement with some knowledge of SQL. Especially data relationships, database normalization, joins etc.

  • After you have the basics down then look for frameworks. Frameworks are essentially blueprints of web applications. The important decisions are made for you and you must fill your business logic. They will reduce a lot of work. These are what I know to be popular. Since I don't use them there might be other options

  • HTML + CSS -> Foundation, Bootstrap
  • Javascript -> JQuery, Angualar, React and an ocean of others. For now I think JQuery will suffice
  • PHP -> or maybe a CMS like drupal. I don't know which would be best. Lavarel would require more code from you but the result will be closer to your needs. Drupal is more point and clicky, maybe will get you there faster but it is a more out of the box solution. Both will abstract a lot of SQL for you.

  • Validation: You can do it in both Javascript and PHP. In Javascript validation will enhance your users experience while in the PHP it is essential for your site's security and your data integrity. In back end I would say validation is mandatory while in front end you can skip it for now, according to your needs.

    Most important: Go to and seek for projects doing what you want to do preferably with the frameworks you choose. Then read their code and try to understand what they do.

    PS: If you haven't done any serious reading so far I would recommend this book.
    It is a bit outdated but it is packed with good advice to get you started. The rest you can learn by googling.
u/PrivilegedGlimpse · 2 pointsr/PHP

this book and this:

hash('ripemd128', $salt1.$password.$salt2);

The previous edition from 2012 recommended md5.

I guess having a unique salt for each password using password_hash is better than applying the same to all of them. Not sure if ripemd128 is good or not.

u/Vinyls2264 · 2 pointsr/webdev

Work on your code/portfolio in your spare time and apply to any job that interests you.

In terms of how to improve your code, I'd take a look at these resources:


u/FantasticPhleb · 2 pointsr/webdev

You've chosen an interesting time to pick up web development! /u/GruntildaJr left an excellent guide on learning front end development, but as a back-end developer I wanted to chime in for the other half.

Learning back-end development without an internet connection will be a little more difficult, but certainly not impossible nor any more effort than a few hours of getting things configured. Nearly any web server can be hosted on your personal machine without an internet connection. Apache is my personal choice and likely one of the easiest to setup on Windows, but Nginx is a lot of fun and there's plenty of options.

Here is a fairly straight forward tutorial for setting up a local development environment on Windows. Although the writer suggests using Zend Eclipse as an editor and I would have to point you towards PHPStorm or Atom with a linter and autocomplete plugin. That said, Eclipse will serve you fine. After completing the tutorial you will have PHP, MySQL, PHPMyAdmin, and Apache set up and running. While not especially fancy, these are the basic tools to start learning the ins and outs of back-end development.

As for learning materials, I love Learning PHP, MySQL, and JavaScript and PHP The Right Way. If you want something very beginner friendly and a bit easier to read, PHP Pandas is a good option.

Of the three, PHP The Right Way will be the biggest challenge. It moves quickly and takes you the furtherest, if you haven't programmed before I wouldn't recommend starting with it but I would recommend going through it after you've gotten some experience under your belt. The O'Reilly book is good for walking through a stack of technologies and outlining how they interact to make a full website, while PHP Pandas is a more thorough dive into the language itself (and it's a lot less painful to slog through if you don't like textbooks). All three are excellent and stand well on their own. If you can only select a single one though, I'd highly recommend the O'Reilly book.

A good companion for any more formal book is the Learn X In Y Minutes PHP Page. It's a little one page cheat sheet to reference when you forget something like the syntax for a switch statement or why you should use double instead of single quotes. There's also a bunch of other languages including JavaScript and I've found them all incredibly helpful. Zeal, as mentioned by GruntildaJr is also a great asset, and it contains the pages for PHP.

There are back-end languages other than PHP along with plenty of frameworks and libraries to explore and learn. I don't want to make it sound as if PHP is your only choice, or the best choice for a back-end language. I do think that it is one of the best choices for a back-end language when you take the learning offline, though. There is a wealth of offline literature, I only linked a few books but the market is simply saturated with PHP texts. The language also stands easily on its own, and for the most part the texts treat it as such. You won't constantly be needing to "pip install" or "npm install" like you do with Python and Node.js.

I hope all of that was of some help, it can be a hump to get over that initial setup but afterwards the learning is much more rewarding. Happy developing and godspeed!

u/ihadisr · 2 pointsr/PHP

The book Learning PHP, MySQL, JavaScript, CSS & HTML5 was one of the most useful PHP books I read as a newcomer to PHP. It's very basic but it teaches how you can start using PHP to do useful and interesting things.

After making it though that book, I think PHP Objects, Patterns, and Practice is a really good next step. It will help you learn to design, organize, and write your code to a more professional standard. It will also help you better understand the workings of a PHP framework.

u/Lhopital_rules · 2 pointsr/IWantToLearn

Only about half of the programming industry has a degree directly related to IT or programming. Most have college degrees in something, but in the end the most valuable thing to someone hiring in IT is skills. Once you have the skills, you just need to get noticed.

I would recommend you learn Linux administration and web development. (Or you could learn Windows too - I don't know Windows well so I can't comment on it. Linux and Mac OS X are somewhat more popular in the programming world, but if you're looking to get into IT, not programming, then Windows administration might be more common.)

A good book to learn Linux is "The Linux Command Line".

For learning web development, you could read "
Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5"

Codecademy would also really help you in here:

If you have any questions, feel free to PM me and I'll do my best to respond.

u/liaguris · 2 pointsr/learnjavascript

Check this one .

u/cheapsexandfastfood · 2 pointsr/learnprogramming

Your idea of not wanting to study anything unnecessary is a bit unrealistic, it's like saying you just want to fix your Honda and not understand how cars work. You need to understand a huge amount of random tech that all will require some study or you will be perpetually lost.

I would recommend a book like this:

And just read it in order it recommends.

u/doodooz7 · 2 pointsr/PHPhelp

Start with this one: Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5)

u/dissss0 · 2 pointsr/sysadmin
u/alinroc · 2 pointsr/SQL

Itzik Ben-Gan has several books that come highly recommended. Carlos Chacon's Zero to SQL book is new and I've heard positive things.

u/321_kaboom · 2 pointsr/VirginiaTech

I'm in the process of learning SQL myself. I can write queries but I'm a beginner; taking Microsoft's 761 SQL exam at the end of the month...

I'm using two things to study for the exam:

-Free class in

-Book in T-SQL Fundamentals with exercises, $40 bucks

This is just what I've been using. T-SQL is the Microsoft flavor of SQL. I checked out the W3Schools website that someone suggested and it looks really good. Between that and the class (free) you will be up and running.

u/wernercd · 2 pointsr/learnprogramming

Relational DB Design - Here's a quick "MySQL Database Design Tutorial" result from Google.

Beginning PHP & MySQL - Here's a well rated book from Amazon. I've enjoyed the Apress books I've gotten in the past, and this one seems well reviewed. I assume, building a website, you are going to start with MySQL and PHP. I could be wrong in this assumption, and if so check out other Beginning and Introductory Database books for something more appropriate to your chosen starting point.

A look through Wikipedia Database Normalization would also be enlightening (with some interesting external links at the bottom for further learning as well).

The goal of database normalization is to remove duplication... so you'd have your "Person" table, with Person# (Unique ID of sorts), LName, FName, MI, etc.

Then you'd have your "Quotes" table: Person#, Quote#, Quote. Each Person# and Quote# is a unique combination that identifies the person and quote.

Add other tables for Video Links (Person#, Link#, Link, Description, etc), Snippets (Person#, Snippet#, Snippet)... etc.

The goal is such that when you update a persons Name (Sally gets married or corrects a typo in her name), you don't have to update every table.

u/metalmilitia980 · 2 pointsr/Database

Hey u/grumpyyoshi, try this link. I just checked it and it’s showing up as free.

u/Jealy · 2 pointsr/SQLServer

Thanks man, had to hunt down the UK link but definitely appreciate it!

u/Tofinochris · 1 pointr/Database

Agreed, OP, you're massively overcomplicating this. If you learn a bunch of math and theory to try and become a database professional you will just come across as an academic rather than someone who can get work done. Learn how to get work done. Check out books like SQL Cookbook and SQL For Smarties to learn stuff that will actually help you do what you need to do.

You do want to have normalization down and basically understand set theory, but you're already doing that.

u/chucky_z · 1 pointr/dailyprogrammer

For anyone who wants to go beyond 'this is a select... this is an insert... this is a join..' check out this book:

He always follows the SQL standard, but... some things don't implement it, so everything in this books is not guaranteed to work with all (or even any) RDBMS.

u/paulbelknap · 1 pointr/SQL

I started with this book: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (4th Edition)

It’s very through but a bit slow at the start. I go back and reference it from time to time still.

u/magentaplacenta · 1 pointr/web_design

You should check out PHP 6 and MySQL 5 for Dynamic Web Sites by Larry Ullman,

Really a good book for an intro to dynamic web sites with PHP.

u/yisroelg1 · 1 pointr/webdev

Well said.

To add to this, if you're looking for a good book on PHP, I'd highly recommend Larry Ullman's 3 book series, although since you're already familiar with programming in general, I'd start with the second one ( and then the third one (

Magento is a world in its own. If you can master it though, your value as webdev will increase significantly. Good luck!

u/solid7 · 1 pointr/learnprogramming

I've always had high opinions of sql for mere mortals. I have the 1st edition kicking around somewhere...

u/2Wrongs · 1 pointr/programming

This is a book I wish I read years earlier:

SQL Queries for Mere Mortals

u/growlzor · 1 pointr/PHP

I started with Head First PHP & MySQL when I started years ago. Two books I loved the most though were Beginning PHP and MySQL From Novice to Professional and PHP Solutions Dynamic Web Design Made Easy.

Later this book helped me immensely PHP Objects, Patterns, and Practice.

Ultimately, is your bible and you can learn everything from there alone. Post on forums and ask for help. Try something and stick with it, don't jump around creating dozens of projects but stick with one and expand it.

Also this

u/RamonaLittle · 1 pointr/learnprogramming

I'm currently reading Head First PHP & MySQL and think it's excellent. I started some other books, but this one seems to present everything in the most logical order.

I'm also reading sections of the official MySQL manual -- I downloaded the 3000+ pages into my Kindle so I can carry it around with me and bookmark pages. It has a lot of useful details that books don't seem to mention.

Probably the most useful learning tool is actually trying to do something with it. I came up with a couple little projects which eventually may be a useful website, so I'm working on that when I can.

Hope this helps.

u/RAPTOREXPLOSION · 1 pointr/IWantToLearn

PHP is a great language to start out with. It's super easy to learn because it's very forgiving, which means it's easy to write "bad" code.

Writing bad code is okay for a while, but when you learn what "good" code is, you'll be frustrated at yourself.

I'd really recommend learning at The Odin Project

It doesn't teach you PHP, but it is a guided course that kinda holds your hand and tells you where to go.

If you're genuinely interested in PHP, I'd recommend Head First PHP & MySql

The Head First books do an insanely good job of teaching. They're among the best in my opinion, and Head First Design Patterns is kind of an industry standard.

That should teach you the basics. Enough to get started and enough to be dangerous.

After that, PHP Objects, Patterns, and Practice is a really good book to go from "okay" to "pretty great".

Good luck!

u/MPair-E · 1 pointr/HTML

I know this isn't super helpful since you're using videos, but starting out, this book can be pretty handy.

What I like about Head First is that all of their lessons are built around real-world tasks, and they build off one another from lesson to lesson (as opposed to a bunch of random one-off projects). In the PHP book's case, the very first few chapters show you exactly how to get a database up and running, how to connect to it, and how to build pages to create a mailing list, 'unsubscribe' form, 'post to blog' form, etc.

I had zero PHP expertise when I started the book, and within a week or two I had built all that's described above, and was already figuring out ways to extend functionality, tweak, etc.

FWIW, I also think that starting out, it's worth just getting some hosting space through godaddy or any other cheap host that'll give you quick dashboard access to phpmyadmin. It'll make creating databases with mysql (which the aforementioned book also explains) a snap, and you won't have to deal with a bunch of Apache/OS-level headaches.

u/erimar77 · 1 pointr/IWantToLearn

This is probably what you're looking for:

Head First PHP & MySQL

u/tongpoe · 1 pointr/webdev

buy this book:
and never look back.
If you want to go beyond any basic template for wordpress or anything else, you should check out PHP a little bit. Its super fucking easy.

u/mp2146 · 1 pointr/webdesign

This book takes you through the basics of all the languages you need, and walks you through building a very basic social networking site. I highly recommend it. You'll need a basic understanding of html and css and a very basic understanding of programming languages.

u/g8trtim · 1 pointr/web_design

TL:DR but I agree with the headings. HTML, CSS, php, MySQL, js. In fact I highly recommend this book: For some layout examples use Chromes Inpector to study other peoples sites and play with frameworks such as and There are lots of great tutorials to get your feet wet with js and php scripts. In fact the book I suggested has awesome scripts you create that are reusable throughout lots of page designs.

u/not28 · 1 pointr/learnprogramming

I have O'reilly's Learning C# 3.0 and it goes into GUI programming. I'm no C# master by any means but I did find the book helpful.

u/dkubb · 1 pointr/programming

Actually C.J. Date updated that book and released it under the new name SQL and Relational Theory: How to Write Accurate SQL Code.

I read Database in Depth a few months ago, and my copy of SQL and Relational Theory just arrived. In the preface Date states that he wanted to provide similar information -- updated to match his current understanding -- but use SQL as a concrete example of his theories. It's definately worth a read though, because most developers use SQL in a way that is not compatible with Relational Theory.

u/junglizer · 1 pointr/IWantToLearn

That looks like a pretty solid book. I have used PHP and MySQL: The Developers Guide in the past and it has served me well. I used it in college and bought myself a copy a while back. However, I will caution that I know several versions of PHP or SQL, or specifically how it connects has changed since the release of the book. I have found that the PHP information is otherwise accurate and very helpful.

u/unconscionable · 1 pointr/Entrepreneur

It depends. Is it an idea for a shipping cart or a blog or something simple? There are drop in apps to do a lot of the repeatable stuff.

> should try to take the time to learn how to make a good website

Of course, this is wholly dependent on both the complexity of the site you want to create, and your ability / willingness to learn how to program. If you do decide to give it a shot, I'd recommend picking up this book.

u/SavageGoatToucher · 1 pointr/learnprogramming

I'd recommend this book. The examples start you off small, and in many chapters they build upon each other as well. They go over important concepts including things that you may not think about right off the bat, like Security. It's the book I used when I got started, and I just adapted the examples to my own needs as I was going through the book.

u/softwaredev · 1 pointr/learnprogramming

I like PHP and MySQL Web Development, it explains everything step by step and with usage examples.

You should also check out w3schools

u/ReconZeppelin · 1 pointr/PHP

Wow. Thanks for the list. Yep, that's pretty much what I had in mind - and I suppose I'm doing this to learn and to have a working system at the end of all of this. As for my knowledge, I'm NOT very smart in PHP or MySQL. I've been reading a book called PHP and MySQL Web Development it's long, but I hope to be familiar with the language as I take my time with it throughout my life.

u/appfiction · 1 pointr/PHP

I would suggest you reading some well written PHP books, although this is a bit old fashioned.

For example:

u/anevilpotatoe · 1 pointr/sysadmin

Let me clarify a little. It's helpful to find books that I can digest from the ground up on and compare with current standards or use creatively. Simple put I enjoy doing the homework on a book. What I am look to accomplish is to write SQL Queries for corporate finances and manufacturing. Working in the environment I am in currently allows me the opportunity to learn and practice it.

Here are a few I looked into:

u/eveningsand · 1 pointr/healthIT

Go get yourself this book:

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)


You can and will teach yourself practically most if not everything you'll ever need to know about SQL. You won't become a database engineer, but you'll know how to help yourself much more than you can today.

u/JustJeezy · 1 pointr/datascience

SQL in 10 Minutes

This was the book used in an introductory course I took. It did a pretty good job of explaining everything and was pretty easy to follow.

u/jemlibrarian · 1 pointr/Random_Acts_Of_Amazon

Something totally utilitarian: Learning Python the Hard Way

Oh hell, who am I kidding. I only do utilitarian

u/JeramieH · 1 pointr/IWantToLearn

May I recommend for SQL and Java

u/UnexceptionableHobby · 1 pointr/SQL

You don't need to have formal coursework or a certification.

Learn however much you need to so that you feel comfortable honestly putting it on your resume in some way. Even if this means that your resume includes something along the lines of 'light SQL experience'. If you get into an interview make sure you set the right expectation about any skills listed on your resume like this. From the mouth of a VP - "I know this job won't require (insert random skill here). I put that on there so that I have an HR friendly reason to reject any candidate."

All that being said, check out this book:

It should get you a good enough understanding to be able to talk about SQL in an interview (assuming you level set with them correctly) to demonstrate that you took the job seriously enough to start learning. It's not a lot by any means, but it can give you an opportunity to convince the person interviewing you that you can learn it if needed.

u/pikatruuu · 1 pointr/SQL

Is this the cover?

u/baineschile · 1 pointr/SQL

There is a list of training resources in the sidebar. I bought

and its pretty handy. I get most of my basics now from w3schools or stack overflow.

u/Rehd · 1 pointr/SQLServer

My blog is advertised on my stack overflow account and github, all three are circular and refer to each other. I've kept my reddit account separate on purpose for identifiable reasons.

I'm still toying with the idea of posting occasional blog posts or creating a reddit account to link to my other social medias to help build a base. At the moment, the blog is really intended for employers and myself and it is not based on trying to accumulate or direct web traffic.

So while I'm happy to share my information, I don't want to link it from this account.

> It's incredibly generous and secure of you to actually share your notes and progress.

The notes are usually pretty barebones. Here's an example of the kind of information in my google sheet:


u/nullrouteinroot · 1 pointr/Romania

Eu sunt în general împotriva tutorialelor, cel puţin pe partea de programare. E greu de urmărit şi nu prea are de-a face cu procesul de învăţare ci mai degrabă cu cel de înmagazinare a unor cunoştinţe.
Cel mai bine ar fi la început să începi să citeşti o carte/un articol despre concepte ale programării în general pentru ca apoi să te apuci de sintaxa unui anume limbaj. Plus că îţi trebuie determinare şi multă răbdare.

Odată ce ai prins basicul limbajului, recomandarea mea ar fi să te implici într-un proiect la care poţi contribui cu cod. Codul ăsta va suferi o grămadă de transformări pentru ca la final să nu mai semene deloc cu cel de la început. Ştiu, sună descurajator dar ăsta e procesul natural prin care îţi îmbunătăţeşti skillurile.

Dacă vrei neapărat tutorial video, singura mea recomandarea ar fi PHP with MySQL Essential Training
with Kevin Skoglund
, însă repet: nu mi se pare cea mai fericită metodă de a învăţa programare. Cele mai sfinte lucruri în PHP sunt: cărţile, practica şi!

Dintre cărţi ţi-aş recomanda:

u/elgatobailar · 1 pointr/learnprogramming

The only book I can think of that covers all of those technologies is Learning PHP, mySQL, and Javascript. Of course, since it is trying to cover a multitude of different topics it never really goes "in-depth" with any of them. But it could be a good place to start out.

u/pro-user · 1 pointr/webdev

Hhm. Well, first of all, I think you might have a hard time finding a book that will teach about both design and web development. Each of those are complicated enough to write separate books on. I think you'll be better off by finding two separate books (one on web dev, one on design) than finding one that combines both.

A kind of the same goes for Web. Dev. This is such a broad term, that you will hardly find any book that tries to cram in every possible aspect of web development. If you are a bit more specific and focus on a specific technology (like NodeJS, with Angular or just plain old PHP, MySQL and JavaScript ) you'll get more value for money. There are more generic books out there, but the technologies (especially for web dev) change almost daily and books simply can't keep up with that. If you'd ask me, I think you'll be much better off having a good understanding of JavaScript in general before you move on to a specific stack or framework.

u/DodgyMalay · 1 pointr/PHP

I am currently reading this which has been OK so far.

I previously read this O'Reilly book which I found helpful. It does cover some stuff you already know but I found it handy when explaining things like sanitising and salting etc. Plus it goes about making a basic social site.

u/ProgramngforAnalysis · 1 pointr/learnprogramming

Don't pay someone unless you can afford to hire them on Salary! Otherwise you will spend SO MUCH just trying to get it right. If you want to have a successful site you need to know how sites are built. That means learning PHP. Get a book, get determined, and go through the ENTIRE book.

I suggest this one

Shameless Self Promotion:
Programming for Analysis

u/iLoveJS · 1 pointr/GlobalOffensive , Code Academy, this book is really good...

and the subreddit /r/webdev for help, more tutorials, discussions and all of that. gl!

u/Osempu · 1 pointr/learnprogramming

Well it all depends on what language will you be using for Backend.

Assuming you use PHP i can recommend you a book i owe and it's quite good "Learning Php, MySQL & JavaScript: With Jquery, CSS & Html5" covers frontend basic that you can skip, but the main reason i recommend you this one is because you learn PHP which is a very famous language in all internet backen, covers javascript which you will need for sure, you learn Database development another needing in backend and the final project its a social website.

Now assuming you want to go on with JS to go full in just one language then a must is this udemy course: The Complete Node.js Developer Course (3rd Edition). On books side there are tons of options, so i will leave this collection of some of the best JS & NodeJS books:

  1. Best JavaScript Books (2019)
  2. Top 20 Node.JS books that you should read in 2018

    These are the ones i can recommend you, if you tell me which language you will be using i could help you a little bit more on forming a learning path(I love learning paths) to keep focused on what to study and when. Don't get discouraged by imposer syndrome, whenever you get to think about it get to code and the greatest advice i can give you is "Always read a book while coding" don't just read a book, code what you see and even do some projects related to the topic you are looking don't focus only in the book, "practice makes perfection". Keep it going bro!
u/americio · 1 pointr/SQL

This, and this.

u/FoCo_SQL · 1 pointr/SQLServer

I ran into a similar conundrum. If you read the 70-461 or T-SQL Fundamentals, they have practice problems that are related. The 70-761 does not contain practice testing material.

Apart from that, it's recommended to do the more official practice tests if you decide you need one. They are supposed to be more difficult than the real test, but I do not have any experience taking the practice tests. I am thinking of trying the 762 practice test though.

I did use one other resource that was a practice test and I'll list it below, but here's a copy from my site that lists my favorite resources from when I studied for my 761.

My favorite resources:

u/Ashex · 1 pointr/AskReddit

Thanks for the offer :) I may send you a message in the next week or so. I bought a couple books on PHP and Mysql (this one and this one) to get myself up to speed. I've got about 3 weeks to get this application hammered out :/

u/dan0189 · 0 pointsr/learnprogramming

Great resources for learning:
Head First PHP & MYSQL AND
PHP 6 and MYSQL 5.

The trick is to repeat the same things over and over and then you will begin to pick them up and remember them off by heart.

I had been idol for the past month until a couple of days ago when I started developing an old site and It took me a little while to remember basic things like creating a class or remembering certain queries.

It's a bit like riding a bike. Just hang in there.

u/greatredpie · -4 pointsr/PHP

The O'Reilly head first series of books are great. They offer an easy to understand and read book. These books go over the basics while teaching you PHP.