PostgreSQL Bootcamp: Go From Beginner to Advanced, 60+hours | Database Design & Development Online Course by Udemy

Development Online Course by Udemy, On Sale Here

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions.

An excellent training about Database Design & Development

PostgreSQL Bootcamp: Go From Beginner to Advanced, 60+hours

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more.I’ve design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+hours of this course: Apply powerful SQL commands to store, update and retrieve informationStep-by-step walkthrough to perform simple to complex SQL queriesHow to create a database from the scratch, Creating and modifying tablesUsing UPSERTfor INSERT and UPDATE at the same timeQuery data with ORDER BY, Logical operators, and filters Understand PostgreSQL various data types with examplesData type conversions with CAST, and conversion functionsCreate your own user-defined data types Explore table and column constraints, create multiple composite constraints, see data integrity operationsCreate your own custom sequencesParsing data with queries using string functionsAggregate data with aggregate functionsDate/Time data types, Intervals, and handling timezonesGrouping Data with GROUPBY, conditional filter with HAVINGJoining Multiple Tables with various joins techniquesCombining Queries together with UNION, INTERSECT, and EXCEPTUnderstand and create PostgreSQL Schemas, ownership, security privilegesConstructing arrays and ranges, query array data with conditional filtersStoring data with JSONB objects and Indexing Query performance optimization with indexes, understanding indexes nodes and outputsCreate and update regular and materialize viewsSimple to advances step-by-step Subqueries Creating Common Table Expressions (CTEs), and recursive CTEs queriesMaking data into group setsSimple to advanced Windows FunctionsUsing regular expressions for text patternsPowerful text searches in PostgreSQLCreate and exploring table partitioning techniquesServer programming with SQL and PL/pqSQLCreating Stores ProceduresExtending PostgreSQL echosystem with custom indexes, and aggregate functionsCreating, and executing TriggersUsing Cursorspqsql Utility CommandsCreating Crosstab reportsMaking our database for storing global language data – InternationalizationRunning queries with PostgreSQL transactions Crating, and Managing PostgreSQL SecurityAll about PostgreSQL internals on how data gets stored and much moreRunning hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database This comprehensive course will teach you everything about PostgreSQL to use in your next big project! Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE