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.
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.
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.
I started with https://www.w3schools.com/sql/ and
bought following book
https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073
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.
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) http://dev.mysql.com/doc/refman/4.1/en/macosx-installation.html 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.
http://www.amazon.com/SQL-Queries-Mere-Mortals-Hands-/dp/0321992474/ref=sr_1_1?ie=UTF8&qid=1426695830&sr=8-1&keywords=sql+for+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.
>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!
In this order:
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.
> 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!
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.
I really enjoyed this book: http://www.amazon.com/Sams-Teach-Yourself-Minutes-Edition/dp/0672336073/
Assuming MSSQL, two quick book tips:
https://www.amazon.de/T-SQL-Querying-Developer-Reference-Paperback/dp/0735685045
https://www.microsoftpressstore.com/store/t-sql-window-functions-for-data-analysis-and-beyond-9780135861448
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.
I’d have to say these were a great combo in my SQL class last year:
SQL Queries For Mere Mortals
and
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
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.
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.
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.
http://www.amazon.co.uk/Learning-MySQL-JavaScript-HTML5-Step/dp/1491949465
If you don't want to hunt down books, there are an infinite number of free resources for all skill levels.
http://www.w3schools.com/html/
https://www.codecademy.com/learn/web
Just out of curiously, why are you going the php route? Instead of rails, python (django) , node or asp.net mvc?
When buying books I normally check the Amazon reviews
http://www.amazon.com/Learning-MySQL-JavaScript-HTML5-Step/dp/1491949465
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.
where the fuck are you buying your books
Grab a decent book on the subject, I used PHP and MySQL Web Development years ago to get started.
Alternatively, Lynda.com has some basic PHP intro videos.
And you can find both of these options for free by searching around if you want.
> 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!
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.
Oh, this? https://smile.amazon.com/Learning-PHP-MySQL-JavaScript-Javascript/dp/1491918667/ref=sr_1_1?ie=UTF8&qid=1494675895&sr=8-1
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
If you want to get serious and take it to the next level you should check out Microsoft SQL certification.
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X/ref=mp_s_a_1_6?keywords=Microsoft+sql&qid=1558398701&s=gateway&sr=8-6
The author is amazing. He also has some good videos on MSDN or Microsoft Learning.
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.
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) https://www.amazon.com/dp/0134858336/ref=cm_sw_r_cp_api_i_DbC4CbV7QTS0Y
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*:
and grabbing a sample database for the system of your choice:
and then practice some of your chosen book on the sample db.
Notes and words of warning:
^((*I'm not affiliated w/ any of those books))
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.
Intro to PHP/MySQL: http://www.amazon.com/Head-First-MySQL-Lynn-Beighley/dp/0596006306
More advanced SQL knowledge: http://www.amazon.com/Head-First-SQL-Brain-Learners/dp/0596526849
More advanced PHP knowledge: http://www.amazon.com/PHP-Object-Oriented-Solutions-David-Powers/dp/1430210117
Go in that order, you'll be very comfortable in a few months.
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.
http://db-class.org 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.
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] (http://www.amazon.com/PHP-MySQL-Web-Development-4th/dp/0672329166/ref=sr_1_1?s=books&ie=UTF8&qid=1397851709&sr=1-1&keywords=php+and+mysql+web+development) 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.
> 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:
 
 
 
 
 
 
 
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:
 
 
 
 
 
 
 
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
This book seems to be the standard.
To learn SQL, start with this book:
http://www.amazon.com/Sams-Teach-Yourself-Minutes-Edition/dp/0672336073/ref=sr_1_1?ie=UTF8&qid=1407993921&sr=8-1&keywords=sql+in+10+minutes
Then once you need more ideas with SQL, go to this book:
http://www.amazon.com/gp/product/0596009763/ref=oh_aui_detailpage_o05_s00?ie=UTF8&psc=1
For Python, I would start with this book:
http://www.amazon.com/Python-Programming-Introduction-Computer-Science/dp/1590282418/ref=sr_1_1?s=books&ie=UTF8&qid=1407994104&sr=1-1&keywords=python+programming
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.
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 - https://www.hackerrank.com/domains/sql?filters%5Bsubdomains%5D%5B%5D=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 https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ has a chapter on query tuning. I'm not personally great at it because I don't use it a lot.
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.
Here are all the local Amazon links I could find:
amazon.com
amazon.co.uk
amazon.ca
amazon.com.au
amazon.in
amazon.com.mx
amazon.de
amazon.it
amazon.es
amazon.com.br
amazon.nl
amazon.co.jp
amazon.fr
Beep bloop. I'm a bot to convert Amazon ebook links to local Amazon sites.
I currently look here: amazon.com, amazon.co.uk, amazon.ca, amazon.com.au, amazon.in, amazon.com.mx, amazon.de, amazon.it, amazon.es, amazon.com.br, amazon.nl, amazon.co.jp, amazon.fr, if you would like your local version of Amazon adding please contact my creator.
Not SQLServer specific, but Joe Celko's "SQL For Smarties" is a great reference for all things SQL: http://www.amazon.com/Joe-Celkos-Smarties-Fourth-Edition/dp/0123820227
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.
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.
>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) https://www.amazon.com/dp/0132856204/ref=cm_sw_r_cp_awd_4Ev3wbE0EVGDH
Understanding and Deploying LDAP Directory Services, 2nd Edition https://www.amazon.com/dp/0672323168/ref=cm_sw_r_cp_awd_KFv3wbW3QNAGF
For future tracks:
Databases:
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) https://www.amazon.com/dp/0321992474/ref=cm_sw_r_cp_awd_SGv3wbGCZ24FA
Fundamentals of Database Systems (7th Edition) https://www.amazon.com/dp/0133970779/ref=cm_sw_r_cp_awd_qHv3wb1YC95NS
Security:
Computer Security: Principles and Practice (3rd Edition) https://www.amazon.com/dp/0133773922/ref=cm_sw_r_cp_awd_ZHv3wb7J1YJKC
Blue Team Handbook: Incident Response Edition: A condensed field guide for the Cyber Security Incident Responder. https://www.amazon.com/dp/1500734756/ref=cm_sw_r_cp_awd_uIv3wbK1361D2
Hardware:
Upgrading and Repairing PCs (22nd Edition) https://www.amazon.com/dp/0789756102/ref=cm_sw_r_cp_awd_gJv3wbCKGA502
Problem Solving:
The Thinker's Toolkit: 14 Powerful Techniques for Problem Solving https://www.amazon.com/dp/0812928083/ref=cm_sw_r_cp_awd_XKv3wbKQFJK6Q
Best of luck. I recommend learning Shell languages and the basics of shell navigation and data manipulation techniques for various operating systems as well.
I really love these two books.
https://www.amazon.com/Database-Design-Mere-Mortals-Hands/dp/0321884493/
https://www.amazon.com/SQL-Queries-Mere-Mortals-Hands/dp/0321992474/
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: http://www.amazon.com/Head-First-MySQL-Lynn-Beighley/dp/0596006306
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.
I would go with this:
http://www.amazon.com/Head-First-MySQL-Lynn-Beighley/dp/0596006306/ref=pd_sim_b_3
The Headfirst series really helped me get my jump start into programming, and I think this would be really helpful for you.
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
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:
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.
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 ;)
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.
A great book for beginners
Learning PHP, MySQL, and JavaScript
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.
http://www.amazon.com/Learning-C-3-0-Jesse-Liberty/dp/0596521065/ref=sr_1_2?s=books&ie=UTF8&qid=1333996025&sr=1-2
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.
[PHP and MySQL Web Development (4th Edition)]
(http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166/ref=sr_1_2?s=books&ie=UTF8&qid=1331621297&sr=1-2)
Super basic: http://ineasysteps.com/products-page/all_books/php-mysql-in-easy-steps/
If you want a better book: http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166
For PHP and MYSQL I really liked this book:
http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166/ref=sr_1_1?ie=UTF8&qid=1372691445&sr=8-1&keywords=php+and+mysql+web+development
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.
Add "" around free.This is an amazon link.I am short on money too but at least I will say it's pirated.
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 https://www.amazon.com/PHP-MySQL-Web-Development-4th/dp/0672329166/ref=pd_lpo_sbs_14_img_1?_encoding=UTF8&psc=1&refRID=MX0CNNA5F6P8BBSAD4J7
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.
This was the book that helped me learn a lot of what I know
http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166
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.
read this
then this
Build something you like while reading them.
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.
>
>http://www.reddit.com/r/webdev/comments/1eqaqo/best_books_or_online_resources_for_comprehensive/ca2w2dn?context=3
>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":
>
>http://teamtreehouse.com/
>
>http://www.codeschool.com/
>
>Bonus:
>
>http://hackdesign.org/
>
>
>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.
>
>Also;
>
>Hattip to /u/ndobie
>
>> CodeAcademy
> Team Treehouse
> CodeSchool. This is more programming but still very useful & has free stuff.
> Tuts+
> 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.
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.
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.
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:
Then there are books about programming. These books still remain fairly relevant even as technologies change.
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.
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.
http://www.amazon.com/Sams-Teach-Yourself-Minutes-Edition/dp/0672336073
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.
This is great, but a little dense as a beginner
T-SQL Querying (Developer Reference (Paperback)) https://www.amazon.co.uk/dp/0735685045/
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):
Try following the examples and then building things for yourself, building a reddit clone is a nice exercise.
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: http://www.amazon.ca/Beginning-PHP-MySQL-Professional-Edition/dp/1430231149/ref=pd_rhf_se_shvl1
PHP for Absolute Beginners might be good for you as well: http://www.amazon.ca/PHP-Absolute-Beginners-Jason-Lengstorf/dp/1430224738/ref=sr_1_1?ie=UTF8&qid=1343452516&sr=8-1
thenewboston.org 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.
http://www.amazon.com/Learning-MySQL-JavaScript-Step---Step/dp/1449319262/ref=sr_1_2?ie=UTF8&amp;qid=1343577123&amp;sr=8-2&amp;keywords=learning+php%2C+MySql%2C+and+JavaScript
Oh, and here is the one to the Head First HTML & CSS one
http://www.amazon.com/Head-First-HTML-Elisabeth-Robson/dp/0596159900
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!
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.
Most important: Go to github.com 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. https://www.amazon.com/Learning-PHP-MySQL-JavaScript-Javascript/dp/1491918667
It is a bit outdated but it is packed with good advice to get you started. The rest you can learn by googling.
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.
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:
HTML/CSS
Javascript
PHP/MySQL
Or look online for any good resources for whatever technology you want to get into.
Good luck :)
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!
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.
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".
https://www.amazon.com/Linux-Command-Line-Complete-Introduction/dp/1593273894/
For learning web development, you could read "
Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5"
https://www.amazon.com/Learning-PHP-MySQL-JavaScript-jQuery/dp/1491978910/
Codecademy would also really help you in here:
https://www.codecademy.com/
If you have any questions, feel free to PM me and I'll do my best to respond.
Check this one .
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:
https://www.amazon.com/Learning-PHP-MySQL-JavaScript-Javascript/dp/1491978910/
And just read it in order it recommends.
Start with this one: Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5) https://www.amazon.com/dp/1491978910/ref=cm_sw_r_cp_api_i_Duo0DbK8M9NZE
I'd recommend this as a starting place: https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X/
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.
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
https://www.amazon.com/Zero-SQL-20-Lessons-language-ebook/dp/B01MYORI53
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 edx.org
-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 edx.org class (free) you will be up and running.
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.
Hey u/grumpyyoshi, try this link. I just checked it and it’s showing up as free.
https://www.amazon.co.uk/Learn-SQL-Practical-Database-Fundamentals-ebook/dp/B07D5S2W4Y
Thanks man, had to hunt down the UK link but definitely appreciate it!
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.
For anyone who wants to go beyond 'this is a select... this is an insert... this is a join..' check out this book:
http://www.amazon.com/Joe-Celkos-Smarties-Fourth-Edition/dp/0123820227
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.
I started with this book: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (4th Edition) https://www.amazon.com/dp/0134858336/ref=cm_sw_r_cp_api_UIWLBbJZF1KBH
It’s very through but a bit slow at the start. I go back and reference it from time to time still.
You should check out PHP 6 and MySQL 5 for Dynamic Web Sites by Larry Ullman, http://www.amazon.com/PHP-MySQL-Dynamic-Web-Sites/dp/032152599X
Really a good book for an intro to dynamic web sites with PHP.
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 (http://www.amazon.com/PHP-MySQL-Dynamic-Web-Sites/dp/0321784073/) and then the third one (http://www.amazon.com/PHP-Advanced-Object-Oriented-Programming-QuickPro/dp/0321832183/).
Magento is a world in its own. If you can master it though, your value as webdev will increase significantly. Good luck!
>Link to the new curriculum here
Wrong link. This is the correct one. http://www.ryerson.ca/calendar/2015-2016/pg3622.html
I've always had high opinions of sql for mere mortals. I have the 1st edition kicking around somewhere...
SQL Queries for Mere Mortals
And
Database Design for Mere Mortals
This is a book I wish I read years earlier:
SQL Queries for Mere Mortals
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, php.net 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
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.
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!
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.
This is probably what you're looking for:
Head First PHP & MySQL
buy this book: http://www.amazon.com/Learning-MySQL-JavaScript-Step-Step/dp/0596157134
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.
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.
TL:DR but I agree with the headings. HTML, CSS, php, MySQL, js. In fact I highly recommend this book: http://www.amazon.com/gp/aw/d/0596157134. For some layout examples use Chromes Inpector to study other peoples sites and play with frameworks such as http://html5boilerplate.com/ and http://blueprintcss.org/. 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.
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.
http://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557/ref=pd_sim_b_3
http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/1558605762
http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/ref=pd_sim_b_4
http://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/0596523068/ref=pd_sim_b_7
And then read a book on whichever dialect of SQL you're using, because they're pretty different.
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.
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.
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.
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.
PHP and MySQL Web Development (4th edition)
I like PHP and MySQL Web Development, it explains everything step by step and with usage examples.
http://www.amazon.com/PHP-MySQL-Web-Development-4th/dp/0672329166/ref=sr_1_1?ie=UTF8&amp;qid=1289178511&amp;sr=8-1
You should also check out w3schools http://www.w3schools.com/php/default.asp
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.
I would suggest you reading some well written PHP books, although this is a bit old fashioned.
For example:
http://www.amazon.com/PHP-MySQL-Web-Development-4th/dp/0672329166/ref=sr_1_16?ie=UTF8&amp;qid=1427697951&amp;sr=8-16&amp;keywords=PHP+5
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:
https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073/ref=sr_1_4?ie=UTF8&amp;qid=1519240184&amp;sr=8-4&amp;keywords=beginning+SQL
https://www.amazon.com/SQL-Beginners-Learning-Programming-Course/dp/1532716958/ref=sr_1_14?ie=UTF8&amp;qid=1519240184&amp;sr=8-14&amp;keywords=beginning+SQL
https://www.amazon.com/SQL-Practice-Problems-learn-doing/dp/1520807635/ref=sr_1_7?ie=UTF8&amp;qid=1519239367&amp;sr=8-7&amp;keywords=beginning+SQL
Go get yourself this book:
SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
&#x200B;
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.
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.
Something totally utilitarian: Learning Python the Hard Way
Oh hell, who am I kidding. I only do utilitarian
May I recommend for SQL and Java
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:
https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073
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.
Is this the cover?
There is a list of training resources in the sidebar. I bought
https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073
and its pretty handy. I get most of my basics now from w3schools or stack overflow.
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:
5/22/18
5/23/18
Then if I have done any work / notations, I add them to a folder and upload them to my github.
If you are interested in other examples of how I did things, let me know specifically and I can get you a scrubbed / masked version. Here's my list of recommended resources that appears in my 762 study guide though:
Exam 70-762
Exam policies and FAQ
Course 20762B: Developing SQL Databases
https://www.mssqltips.com/sqlservertip/4690/study-materials-for-developing-sql-databases-exam-70762/
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=pd_lpo_sbs_14_t_0/138-3143892-2208566?_encoding=UTF8&amp;psc=1&amp;refRID=E5CA9HQ5WEXP7RPBE1B1
https://www.amazon.com/Pro-Server-Internals-Dmitri-Korotkevitch/dp/1484219635/ref=sr_1_1?s=books&amp;ie=UTF8&amp;qid=1520887778&amp;sr=1-1&amp;keywords=sql+server+internal+pro
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 http://www.php.net/manual/en/index.php!
Dintre cărţi ţi-aş recomanda:
Astea fiind spuse, îţi urez spor la treabă!
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.
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, ASP.net 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.
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.
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
HTML.net , Code Academy, this book is really good... http://www.amazon.com/Learning-MySQL-JavaScript-HTML5-Step-/dp/1491949465/ref=sr_1_5?s=books&amp;ie=UTF8&amp;qid=1420926437&amp;sr=1-5&amp;keywords=HTML+css+javascript
and the subreddit /r/webdev for help, more tutorials, discussions and all of that. gl!
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:
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!
This, and this.
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:
https://www.cathrinewilhelmsen.net/2015/01/28/preparing-for-and-taking-exam-70-461-querying-microsoft-sql-server-2012/
https://www.mssqltips.com/sqlservertip/4644/sql-server-exam-70761-study-material-for-querying-data-with-transactsql/
https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
https://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059/ref=sr_1_1?ie=UTF8&amp;qid=1513628070&amp;sr=8-1&amp;keywords=70%3D461
https://www.amazon.com/Exam-70-761-Querying-Data-Transact-SQL/dp/1509304339/ref=sr_1_1?s=books&amp;ie=UTF8&amp;qid=1513628083&amp;sr=1-1&amp;keywords=70-761
http://www.accelerated-ideas.com/70761-practice-test-questions.aspx#.WeeTWVtSypo
https://www.mssqltips.com/sqlservertip/4015/introducing-json-for-sql-server-2016/
https://www.mssqltips.com/sqlservertip/4073/sql-server-2016-advanced-json-techniques--part-1/
https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server
https://www.mssqltips.com/sqlservertip/3680/introduction-to-sql-server-2016-temporal-tables/
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql
https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/
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 :/
Great resources for learning:
http://www.w3schools.com/php/default.asp
Books:
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.
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. http://www.amazon.com/Head-First-MySQL-Lynn-Beighley/dp/0596006306