AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
You need a PC, Mac, or a Desktop Computer Make sure you have PostgreSQL Installed locally in your computer or in a docker image. Make sure to install tools such as pgAdmin, DBeaver, or Datagrip to help you write queries. This is a course intended for software engineers and data analysts that want to learn more about Relational Databases and SQL It covers both basic and advanced SQL concepts and theories. The course is intended for both Junior and Senior Level Engineers and is purely focused on SQL and writing queries.PostgreSQL will be used in this course. But the theories you learn can be applied in any Relational Database such as SQL Server or MySqlAll the sections are explained by one or more examples. I used a sample database that had students, courses, registrations and instructors records. Learning by doing examples is a much better technique than just studying a theory.This course contains quizzes and exercises. You'll get immediate practice on all of the different topics and features that you learn!You will learn аbout:Selecting DataAggregate FunctionsBuilt in FunctionsJoinsDatesSchema and DataCRUD OperationsTransactionsArrays in PostgresJSONs in PostgresAnd More!Data is the core of an application. Any application that you see on your phone or on your website uses some storage somewhere. Having a good database design and queries is very crucial for any application.
0 Comments
Read More
Leave a Reply. |