SQL for NEWBS

Straightforward, clear, great pacing and patience in explaining and reassuring, thank you for kicking off a good start to learning SQL I love your brain busters I would like to see more.

I am totally new to SQL and now I feel I have logic and practical abilities and thinking on a paper and pen makes a lot out of brain busters The material is well covered, and while personally I'd like to have multiple exercises for each concept, it builds up reasonably well.

Besides, I love the idea of brain busters, which have pushed me to apply skills myself.

When organized, the lectures and the brain busters where great.

The instructors make this course entertaining and interesting, however some of the Brain Busters would have answers that included information that hadn't been taught yet, and that made almost all of my attempts at solving them incomplete.

I think this course could be amazing if the Brain Busters were better thought out ahead of time.

Some of the brain busters can be confusing since it is not always clear what the fields in the tables represent.

Beyond that, the course is easy to understand and the brain busters were a good method to study on your own.

Some good brain busters but the section on joining tables is really bad.

For example a number of brain busters for distinct or max and min I found this course very helpful as a first step into SQL databases.

One of the brain busters is presented wrong so you end up wasting time trying to join 3 tables when you really need to join 4.

Like the every day examples and the brain busters.

So far so good.

SO far so good but at times it was difficult to understand what to do next and why it was being done Easy to follow and very informative.

so far so good Perchè parte dalle basi e spiega bene i concetti Excellent so far...best part are the brain busters.. got stuck at ALTER USER root@localhost IDENTIFIED BY ‘password’; there was a lot of unanswered responses on the Q&A Breaks everything down nicely and makes it very easy to understand got me through the basics very fast!

So far so good!

Great so far :) it's awesome except the instructors move a little fast through the setup information so far so good Took me 3 hours to install the software, and still not able to do it properly But already stuck at the installation part as many others.

Easy, clear to follow So far so good.

so far so good.

Very detail instructions and thorough explanation So far so good.

good i am getting the desired knowledge So Far So Good!!

so far so good Easily digestible so far.

so far so good... not lost yet Very straightforward and concise great course!

So far so good sublime text is paid for linux.

Most other courses get set up out of the first rather than a last footnote in the appendix.. Definitely Starting to understand things more and see how they come together with this course, cohort Analysis lecture is really good and great addition and the video's are done well and don't bore you Funny tutors, sometimes a bit weird.

Cohort Analysis not explained properly and was too fast.

More specifically, I appreciate the cohort analysis, the installation of MySQL, the download of the sakila database and the installation of HeidiSQL!

it was a bit more confusing when it came to cohort analysis since temporary tables do not work in SQL Snack.

hasta ahorita si, pero quiero aprender sobre cohort analysis Very educational for SQL noobs and fun to watch is this course still supported?

Other than that, a great start to learning SQL New topic that was incorporated in a normal SQL training is about Cohort Analysis which can be useful in real world applications.

I really liked the cohort analysis bonus video.

Coming back after Cohort Analysis class.

The cohort analysis was good to know and explained in a step by step way.

Only criticism is the speed at which the Bonus Lecture on Cohort Analysis was delivered.

Also, the final bonus lecture on cohort analysis was confusing and very hard to follow.

The last exercise with cohort analysis has very little to do with what they taught throughout the course.

The instructors are great but there is extreme confusion not being answered for many asking, about installing/registering to sqlsnack + sublimetext versus what they actually start to use (sequel pro on a mac).

very handson, informative Interesting but I'm a little more advance, but I wanted to see if there is anything that I didn't know all good Skips from MySQL to SQLSnack, then to Sequel Pro.

Managed to get it to work after hours of trouble shooting by using MAMP to start the mysql server and then access it through Sequel Pro The course is very easy to follow when you don't know anything about sql.

Has already done more than most SQL courses do just by taking me through the install process and getting data into Sequel Pro.

I, however, had a hard time installing sequel pro and connecting to mysql(I assume a lot of other people had a hard time as well) so i resorted to just watching the course and mimicking the queries without actually logging on to sequel pro.

In order for the training to show as "Completed", I had to go through the Sequel Pro installation for Mac.

They talk way too fast, and seem to skip over important components, like they opened "Sequel Pro" to look at the table.

My first impression was bad as I rapidly found difficulties with Sequel Pro, but then I read the Q&A.

Using the sequel pro test build is the way to go the course and instructor are great.

Been wasting alot of time just setting up homebrew/sequel pro Very easy to understand and follow along.

Linux do not support homebrew or the sequel pro tools instead linuxbrew and Mysql can be used.

Just not sure how went to sublime + your website to sequel pro.

I highly recommend this course!

Highly recommend this course.

I highly recommend this course for beginners.

I highly recommend this course to anyone who is looking to learn the fundamentals of SQL from instructors who were able to help someone with minimal technical knowledge such as myself grasp the basics.

I would highly recommend this course to others.

Highly recommend this course!

I highly recommend this course.

I'd highly recommend this course to someone who has never worked with SQL before.

I highly recommend this course to anyone looking to learn SQL.

Always getting error : ER_CON_COUNT_ERROR: Too many connections.

So far everything is going well, with the exception that I keep getting a "ER_CON_COUNT_ERROR: Too many connections" when I try to run a "select * from actor limit #;" error when I run a query on sqlsnack.com.

I have tried on a PC and Mac and keep getting Error: ER_CON_COUNT_ERROR: Too many connections.

Very helpful info So far SQLsnack.com is retrieving an error when I followed along with Section 1, and I don't see where I am supposed to download Sequel Pro that you just used in Section 2 video 6. great lecture so far, except when I run the select * function in SQL snack, it is giving me an error message, saying that there are too many connections Very happy for step by step process Excellent.

Excellent SQLSNACK website is not working.While executing a query getting too many connections error Good, So far... Is definitely for newbs.

"Too many connections" error pending for a long time.

Having problems with SQLSnack saying error too many connections Examples are clear and presenters bring humour to the lessons.

Including usage of Sequel Pro and Sublime Text are really great tools for people to learn to use.

You will learn basic query operations (group by, order by, join and so on), very useful tips or shortcuts and technical support (HeidiSQL and Sublime Text are free but outstanding tools).

And i wanted to know why did we download such a number of software like .net ,sublime text,MySQL and heidisql (How are they all related).

Would be five stars but wish there were additional context of 'why' certain tools are used, downloaded, i.e., Sublime Text tool vs. Heidi SQL vs. mySQL, etc.

however, i would like to use Atom as text editor instead of sublime text - hope that is okay suggestion: you can suggest some other text editors for NEWBS... :) cheers!

Way to keep me engaged and the step-by-step for installing Sublime Text and the SQLSnack web interface is Brilliant!

so far, i've received errors connecting to the sqlsnack website, sublime text doesn't work well (and doesn't seem to overtly support sql) and you're using sequel pro which is a mac program and i'm on Windows.

We installed sublime text and signed into sqlsnack Thorough and engaging instruction...Some of the Brain Busters require knowledge and skills that aren't taught until the next section, making them difficult to complete and understand.

For example, when select stmt started with c.* then the group by said 1, you're asking it to group by everying in c.... didn't make any sense but the query ran successfully.

5.7.18), there were some errors w/ the GROUP BY function (ex.

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column).

The GROUP BY usage was different in my mySQL from what was in the video.

When I came back to 15 and 16, I had to remember why you used a shorthand number for something like "Group by".

Clearly they've memorized the fields in each table, so they often fly through the SELECT, FROM, WHERE, GROUP BY framework without going back to reference; and sometimes they forget to fully explain how a command works.

Courses not 100% accurate, in one lesson a missing condition for Group by was missing.

BTW - There are new Group By rules in current version of MYSQL - Had to do a little trouble shooting get queries to run without errors.

Overall good, but the frat boy "boooom" attitude is a little too much haha a little more professionalism would be also okay I did like the beginning of the course but stumble into a mistake related to the group by query and when I checked in the QA, I saw that someone else did have this issue and no one from the instructor took time to answer, that's disappointing... select title, rental_rate from film group by rental_rate; Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sakila.film.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Good hands on introduction to sql, where you can learn immediately the basic commands.

GROUP BY by query rank number not variable name) are NOT best practice - they may be time savers, but they produce less readable code.

The Group By function (in its introduction) doesn't work in the new version MySQL and one of the brainbusters required knowledge that hadn't been introduced (AND function).

More brainbusters needed Nice explanation good step by step instructions so environment is setup and functional to begin course Pretty easy to comprehend Great job guys They were a little quick with some of the basics, had to re-watch a couple times to make sure I was following along.

Thank You easy to follow step by step instructions very nice pace High level learning in an easy to understand format The course gives very easy steps to understand the terms in SQL Very helpful!!!

Helpful relatively easy to follow as a newby very good step by step instructions!!

Thanks to this class, I can now use SQL:) These guys are great.

If they inserted transitions like "now switch to the text editor and copy this line", then I wouldn't get lost shuffling between windows.

Also while examples are well and good, I personally would have liked to see a bit more written explanation rather than doing everything in sql/text editor.

They did a great job of breaking down each and every piece of learning SQL from downloading a text editor to running advanced queries.

maybe a picture in picture of the current text editor screen The setup instructions were very clear.

For instance, the 'password' string in the text editor actually pulls in some extra data when copy and pasted, thus giving an error.

The text editor charged me $80, and doesn't even work.

this course asks you to download content in the text editor section but doesn't tell you which versions to use for a PC only goes through Mac version.

Highly recommended for those wanting to learn SQL in a fun and interactive way.

Highly recommended for relative novices.

Highly recommended for people trying to get not only a quick but also a comprehensive introduction into the world of SQL!