The Ultimate MySQL Bootcamp

So far so good!

CREATE DATABASE experience; ->USE experience; -> CREATE TABLE ratings( comments VARCHAR (15), rate INT ); So far so good.

SO FAR SO GOOD I LIKE THIS PERSON HE IS LIKE MY BIG BROTHER LIKE HE SHARED A SO MUCH KNOWLEDGE THAT EVEN I DONOT GET THIS KNOWLEDGE FROM MY OWN HOMETOWN WITH A CHEAPEST PRICE AS THIS PERSON GIVE US .........

Wonderful course it's amazing, easy understanding So far so good, I'm using the Windows version and it's going well.

So far so good, I like learning new stuff Course is simple, well structured and it's easy to understand the main points.

SO FAR SO GOOD Not the first course I've studied from him.

So far so good.

A bit soon to tell, but so far so good.

So far so good - I am beginner to SQL but as an advanced user in recent version of Excel Very informative so far.

so far so good!

This course is good, nice pace So far so good.

The node.js bit i didn;t think was relevant though.Please load on more content or perhaps another course for intermediate/expert users to do more things like reporting , analysis, functions etc., so far so good I have no experience on MySQL or SQL, but i think this good course so far.

Also, how Stored Procedures work in MySQL.

Things that I found were missing were: how to read in and export data (eg in CSV), views and stored procedures.

The only reason it gets 4 and an half start is, that i wish it had covered Transactions, triggers and stored procedures or just an explaning what it is ect.

But, maybe, with more real exampes would be 'the greatest' :) Yes this course was excellent for a beginner like me it would had been great to have stored procedures and functions topics and a better explanation of triggers Great for learning the broad fundamentals and logic behind building and querying databases with MySQL.

I also want to request that, if he can teach us about stored procedures (MS SQL) in detail like with proper excercises.

Also as the course is very basic, bar triggers, maybe include stored procedures | functions ...etc or make students aware?

More topics like composite key, stored procedures should be included.

Maybe, you could also consider creating a separate course on Cursors, views, triggers, stored procedures and so on.

Missing important concepts like triggers, functions and stored procedures It is an absolutely amazing course.

What about stored procedures, views, functions ????

It's not what I expected, the course title is misleading because it doesn't teach the advanced features of MySQL such as stored procedures, security, etc.

Great course overall for a beginner but some more advanced concepts like Indexes, Transactions and Stored Procedures are missing.

I took his Web Developer Bootcamp and instantly got hooked on his engaging teaching style and how he easily explains difficult concepts.

(A course made by just you, I know you have the Advanced Web Developer Bootcamp but most of it is taught by other people) This was a great match.

Also, check out Colt's course "The Web Developer Bootcamp" it's a beauty!

(I'll be doing Colt's Web Developer Bootcamp next...) It also appears that there's a good team supporting Colt with this course, so thanks to all of you for your work :) Course is broken up into small sections making it easier to understand step by step.

Probably not much -- the Web application part is a bit superficial and "magic" but I understand why since I just finished the "Web Developer Bootcamp" and it took a very long time to cover all of that magic.

This course starts off slowly - Colt even refers to the fact that we haven't started yet several times - but I had watched his "Web Developer Bootcamp" and trusted that the output would be similar.

If you've watched Colt's Web Developer Bootcamp and are looking for more Colt Steele courses, this course is a fantastic sequel with highly applicable and useful knowledge.

I have also bought 'The Web Developer Bootcamp ' (completed) and 'The Advanced Web Developer Bootcamp' (still working on it) by the same people and regard these courses as among the absolute best courses you can buy on udemy/top notch.

I did the web developer bootcamp in parallel with this one and the two courses go well together.

I'd suggest going through the web developer bootcamp first to learn about Nodejs and routing.

I'm excited to build the database back end and then start your Web Developer Bootcamp once I have all my tables, relationships, queries, and TRIGGERS (this was so amazing to see that SQL has a validation setup) all built and ready to use with a front end!!!!!

Now moving on to his "The Web Developer Bootcamp".

I wish he would come up with an 'Advanced SQL boot camp'!

Th I teach at a statistics summer boot camp for social scientists and the format of this course is very similar to what we do at the bootcamp.

I am in Lambda School right now, and I feel like I have learned more in these courses than I have through my huge online boot camp like Lambda School.

His real-world experience with face-to-face webdev boot camps shows.

Enjoyed learning the content, enjoyed Colt's teaching style, appreciated the Q&A section, and plan on attacking his web development boot camp soon.

I loved his course "The Web Developer Boot Camp", and had to try out his others.

I would recommend doing this course in tandem with Colt's Beginning and Advanced Web Developer boot camps.

Well, the 2nd point led me to consider to web development as an extra skill and I enrolled in one of the instructor's web development boot camp course and I'm hoping for a similar learning which this course offered.

The materials are still too easy, but this is a boot camp anyway.

For instance, during the ultimate MySQL boot camp go from SQL beginner to expert, he regularly tries to make learning about databases fun, but then immediately undermines himself by saying well I tried databases are boring ho-hum.

Me ha parecido una excelente elección, facil de entender y bien explicado Love the humor in this boot camp !!

I was really just needing a refresher course, having just recently completed a 6 month coding boot camp.

What i did learn in addition to my prior knowledge is how GROUP BY and JOIN works, which, of course, can be learned else where.

I learned a lot of keywords from simple SELECT and UPDATE all the way to the complex LEFT JOIN and GROUP BY.

This makes GROUP BY difficult to understand (hence the lower rating for the course).

For instance his explanation of the weird GROUP BY was great.

Group by was always a mystery to me as well and feel better about it now.

if person have totally blank on sql command he/she will be very confuse on the syntax given such as : Count (*) should be followed by Group by, what is LIMIT?, what is inner join, what is left join, sql data structure, table structure... hopefully can seen those kind of explanation one by one in the next slides Great on-line course for beginners and out-of-date.

Why best practices were used, or why use nodejs instead of php...these types of things help get a sense of the bigger picture.

This course not only teaches the language itself but also the bigger picture and I loved how all the pieces fit together towards the end while building the web app.

I took a university course on relational databases but we used MS Access (barf).

Honestly, I'm feeling really confident I can learn through this 'video classes' Thanks for being a nice teacher, the way you speak makes it become more simple to understand :) Have a nice day :) Good so far, some experience with MS Access SQL so understanding the ideas behind queries.

The SQL command was: SELECT customerName, COUNT(*) AS 'number of orders' FROM customers INNER JOIN orders ON orders.customerID = customers.customerID GROUP BY customers.customerID; and the error was: You tried to execute a query that does not include the specified expression 'CustomerName' as part of an aggregate function.

This one: SELECT customerName, COUNT(*) AS 'number of orders' FROM customers INNER JOIN orders ON orders.customerID = customers.customerID GROUP BY customers.customerID; Excellent information.