Overview: Dataquest's SQL Fundamentals course targets absolute beginners by teaching SQL through SQLite, a file-based RDBMS. Also good for those enrolled in a video-based course but are looking for more projects to complete. After going through that course's material, it looks like a good intro to Elasticsearch, a widely used technology, but the content could be completed in as little as a week.Īs a member of Coursera Plus ($39/month), you can enroll in this Specialization and receive a certificate from The University of Michigan, which ranks 36th in the QS Engineering & Technology Rankings.īest for: Complete beginners who prefer text-based, interactive learning, and are interested in data science. While this Specialization is well-organized, informative, and very helpful for learning SQL, the last course gets some lackluster reviews. How to use Elasticsearch with Postgres for querying textĪs you can probably tell from the syllabus, text data is a big focus in these courses.Intro to the problem of scaling databases.Database Architecture, Scale, and NoSQL with Elasticsearch More of a full treatment for text in PostgresĬourse 4.JSON and Natural Language Processing in PostgreSQL Table relationships, such as one-to-many and many-to-manyĬourse 3.Overall intro to Databases, SQL, and Postgres.Database Design and Basic SQL in PostgreSQL There are plenty of quizzes and projects to help you learn, as well as a highly active forum of students and TAs to help with any questions you may have.Ĭoursera estimates that this course takes approximately four hours over four months to complete, or roughly 64 hours total.Ĭourse 1. Overview: As a whole, the comprehensiveness and execution of this course series make it number one on this list for learning SQL and Postgres. Best for: Those who have some programming experience, want one place for a comprehensive SQL course series using Postgres, and are interested in storing/querying text data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |