PL/pgSQL comes with PostgreSQL by default.PL/pgSQL is easy to learn and simple to use.The following are reasons to learn PL/pgSQL: PL/pgSQL procedural language is similar to the Oracle PL/SQL. It allows you to develop complex functions and stored procedures in PostgreSQL that may not be possible using plain SQL. PL/pgSQL procedural language adds many procedural elements, e.g., control structures, loops, and complex computations, to extend standard SQL. Master the database itself, and see how to apply it with real designs.This section shows you step by step how to use the PL/pgSQL to develop PostgreSQL user-defined functions and stored procedures. I made this course to be the perfect resource for engineers just getting started with their first database. Speed up your queries with indexes - you'll see exactly how they work behind the scenes!ĭive into some of the most complex queries around with recursive common table expressionsĭeal with concurrency issues easily by applying transactions Validate your data using simple ' check' rulesĬonstruct perfect designs for common features such as 'like', 'follow', and 'tag' systems See how to divide database objects into different schemas to maintain them more easily Use different design patterns to efficiently model your data Work with millions of records to simulate real production queriesĮxercise your query logic skills through the use of sets and sorting operatorsĬompose queries out of smaller reusable units using subqueries Understand PostgreSQL's numerous data types, and when to use eachĪssemble reports of business data by using aggregation pipelines Here is a partial list of some of the topics that are covered in this course:Īpply powerful SQL commands to store, update, and retrieve informationīuild relationships between records using foreign keys between tables By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database. This knowledge is invaluable when it comes time to start tuning your queries for performance. We'll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit. You'll get immediate practice on all of the different topics and features that you learn! In addition, you'll understand exactly where to use each of these features in real and practical projects.īesides getting practical hands-on experience, you'll also get a behind-the-scenes look at how PostgreSQL works internally. This course is packed with practice exercises and quizzes. You'll see many different scenarios with different types of data, and understand the pros and cons to several approaches. You will understand how to store, fetch, and update information with a series of powerful commands.Īfter gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. Through an incredible number of exercises, you'll get practical, hands on experience working with realistic datasets. We begin with an overview of SQL, the language used to interact with PostgreSQL. This course will teach you everything you need to know about PostgreSQL to use it on your next big project!ĭon't know anything about databases at all? No problem. Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems. This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!Įvery app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database. Query tuning and optimization? You'll master it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |