The course starts from scratch and doesn't require any previous programming skill or experience.
Learning SQL: Master SQL Fundamentals eBook: Alan Beaulieu: eywaapps.dk: Kindle Store
As the name suggests, the course is inspired by Bootcamps and focuses on intense learning. It is also a comprehensive course and explains every single concept by using slides as well as live coding. The author uses PostgreSQL for demonstration purposes, which is both free and open source.
Even though the author uses PostgreSQL, all the concepts you learn in this book are applicable to other major databases — e. Another plus of the course is an instructor who is very enthusiastic and detailed in his approach. Overall, this is a great course to start learning SQL from scratch, particularly for beginners. I really enjoyed watching this course, not just for content, but also for positive energy from both instructors, David and Pete.
It is really fun watching them discuss and explain SQL concepts.
Learn SQL: Best SQL tutorials & best SQL books 2018
I know SQL is interesting, but they make it even more interesting. It's like old college days with some friends always jumping and doing stuff, which makes you laugh, but at least it helps remove boredom from the class. As for the content, as the name suggests, it is a beginner course, but you will learn all the essential concepts — e. They use MySQL database in this course, which is the most popular open-source database, and you can download that for free. They have a section for downloading and installing the MySQL database as well.
After learning the basics, you will learn some non-trivial information — e. The best part, of course, is that it has brainbuster exercises to test your SQL knowledge, which is key in building data since you need to work with relational databases and SQL. It covers almost all the topics an application developer should know about SQL. In this course, you will learn about creating basic SQL queries and different types of joins — e.
This course also explains advanced concepts — e. You will also explore database design concepts — e. This course has an entire section that explains normalization and various normal forms — e. The course uses both Microsoft SQL Server and PostgreSQL, and the best part of the course is that its focus is on enhancing your data analytics skills with real-world data science exercises. If you are interested in Data Science and want to become a data scientist, then a good knowledge of SQL will go a long way, and this course is a great place to start.
There is no doubt that Oracle is the most popular relational database, and there is a huge demand for people with good Oracle Database skills and experience — e.
Whether or not you want to learn Oracle from an application development perspective or from a Database admin. In this course, you will not only learn to create databases, tables, and stored procedures but also how to write SQL queries. You will learn essential SQL concepts in Oracle database — e. The instructor is good, and it uses free tools like Oracle SQL Developer, which you can download from the web.
Overall, it is a good SQL course if you want to learn with Oracle database. If you are preparing for your first job interview or next job, you can expect a lot of SQL questions on the interview. It's an important skill, and that's why many interviews focus on SQL along with d ata structure and algorithms. By taking this course, you will not only be well prepared for your next interview, but you will also learn a lot about important SQL concepts. For example, if you just watch the preview of one chapter, which discusses how to tune SQL query or how to find and explain execution plan, you learn a lot.
I am a particular fan of learning from interview questions , as they encourage me more and peak my curiosity. If you are like me, you will find this course immensely helpful. It is an interesting SQL query and puzzle book, which is a must read if haven't read it already. Want to Read Currently Reading Read. Refresh and try again. Open Preview See a Problem? Thanks for telling us about the problem. Return to Book Page. Book by Beaulieu, Alan. Paperback , pages. Published September 1st by O'Reilly Media first published To see what your friends thought of this book, please sign up.
To ask other readers questions about Learning SQL , please sign up. Lists with This Book. This book is not yet featured on Listopia. Jan 15, Martha rated it really liked it Shelves: My only gripe is that even a beginner book should have at least one chapter on query optimization and performance tuning; it's a little too easy for beginners to knock over an entire database with one bad query. For query optimization, it's best to use a book specific to your RDBMS, as each has its own tricks and pitfalls.
Jun 04, Robert rated it it was amazing Shelves: At the time of reading this book SQL is new to me. The whole history, and explanation of how relational databases came about and work the way they At the time of reading this book SQL is new to me. The whole history, and explanation of how relational databases came about and work the way they do is rightly skipped over.
This is not something you need to worry about when starting out, but becomes more interesting to you once you know and use the product. So instead you get down and dirty with the real stuff you want to learn. It's a great book for introducing you to SQL, allowing you to decide which route you might take for specialising in one of the big branded database servers. It sets a sound foundation for more advanced techniques and I would recommend it to anyone wanting to learn SQL for the first time.
Dec 03, Kimbeattie marked it as unread Shelves: Oct 25, Keiry Ko rated it it was amazing Shelves: Oct 30, Cara rated it it was amazing Shelves: A valuable resource for anyone new to SQL plus a handy reference for the more proficient. Jul 09, Jaabberwocky rated it really liked it. Great book, does what it says on the cover: It is certainly structured well and the review questions at the end of the chapter are challenging enough to help reinforce concepts, but not too difficult that you feel like you are back in college.
That said, he frequently introduces new concepts, and says "not to worry about it until later".
This isn't good structuring as some, including myself, can't just "let things go" like that. That made me read the document Great book, does what it says on the cover: That made me read the documentation, which I guess makes it good? Aug 31, Oxana Udodova rated it really liked it. Jun 15, Arquero rated it it was amazing. Really nice intro with MySQL in mind. Contains useful exercises against fixture data.
Jun 10, Byrne rated it liked it. This will make your first month of SQL a lot easier, but it's very much a book for beginners. Apr 25, Dwarakanath Reddy rated it it was amazing. Best book for beginners in sql.
- Learning SQL, 2nd Edition?
- Best SQL tutorials.
- Klanten die dit item hebben gekocht, kochten ook;
- Reward Yourself.
- Wealth and Happiness.
- Learning SQL : Master SQL Fundamentals, 2nd Edition?
Must have for database programmers. Jan 21, Andriy Androsyuk rated it really liked it.
Books & Videos
Good start for beginners. Jul 21, Tom Mcshane rated it it was amazing. I already knew SQL and was able to write queries with joins, where clauses, etc. I also wanted to bring myself up to speed on improving the formats of my queries and use updated syntax such as using 'inner join tbl b on a. The chapters are short and the exercises do a good job of reinforcing the material covered in I already knew SQL and was able to write queries with joins, where clauses, etc.
- How Snow Falls?
- Join Kobo & start eReading today.
- Learning SQL;