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

Partner: Udemy
Affiliate Name:
Area:
Description: 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 UPSERT for 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 GROUP BY, conditional filter with HAVINGJoining Multiple Tables with various joins techniquesCombining Queries together with UNION, INTERSECT, and EXCEPTUnderstand and create PostgreSQL Schemas, ownership, security privilegesConstructing a
Category: Development > Database Design & Development > PostgreSQL
Partner ID:
Price: 89.99
Commission:
Source: Impact
Go to Course