Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    Posted By: ParRus
    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)
    WEBRip | English | MP4 + Project Files | 1920 x 1080 | AVC ~420 kbps | 29.795 fps
    AAC | 62.4 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~22 hours | 7.98 GB
    Genre: eLearning Video / Development, Programming

    Become an expert with SQL and PostgreSQL! Store and fetch data, tune queries, and design efficient database structures!
    What you'll learn
    Learn and apply multiple database design patterns
    Optimize queries for superb read and write efficiency
    Understand how PostgreSQL stores information at the hardware level
    Connect PostgreSQL to front-end apps using an API
    Build common app features, such as a 'like' and 'mention' systems
    Handle complex concurrency issues and race conditions
    Advance your database designs using schema migrations
    See how to use PostgreSQL to speed up automated tests
    Practice all of these skills using a huge number of built-in exercises

    Requirements
    A Mac, PC, or Linux-based Computer

    Description
    Database structure design? It's here. Query tuning and optimization? You'll master it. Complex queries? Yes indeed!

    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!

    Every 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. 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 course will teach you everything you need to know about PostgreSQL to use it on your next big project!

    Don't know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you'll get practical, hands on experience working with realistic datasets. You will understand how to store, fetch, and update information with a series of powerful commands.

    After 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. You'll see many different scenarios with different types of data, and understand the pros and cons to several approaches.

    This course is packed with practice exercises and quizzes. 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.

    Besides getting practical hands-on experience, you'll also get a behind-the-scenes look at how PostgreSQL works internally. We'll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit. This knowledge is invaluable when it comes time to start tuning your queries for performance. 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.

    Here is a partial list of some of the topics that are covered in this course:

    Apply powerful SQL commands to store, update, and retrieve information

    Build relationships between records using foreign keys between tables

    Understand PostgreSQL's numerous data types, and when to use each

    Assemble reports of business data by using aggregation pipelines

    Work with millions of records to simulate real production queries

    Exercise your query logic skills through the use of sets and sorting operators

    Compose queries out of smaller reusable units using subqueries

    Use different design patterns to efficiently model your data

    See how to divide database objects into different schemas to maintain them more easily

    Validate your data using simple 'check' rules

    Construct perfect designs for common features such as 'like', 'follow', and 'tag' systems

    Speed up your queries with indexes - you'll see exactly how they work behind the scenes!

    Dive into some of the most complex queries around with recursive common table expressions

    Deal with concurrency issues easily by applying transactions

    I made this course to be the perfect resource for engineers just getting started with their first database. Master the database itself, and see how to apply it with real designs. Sign up today and master PostgreSQL!

    Who this course is for:
    Any developers looking to understand databases
    Application engineers seeking to expand their backend skillset

    also You can find my other helpful Programming-posts
    (if old file-links don't show activity, try copy-paste them to the address bar)

    General
    Complete name : lesson13.mp4
    Format : MPEG-4
    Format profile : Base Media
    Codec ID : isom (isom/iso2/avc1/mp41)
    File size : 19.1 MiB
    Duration : 5 min 26 s
    Overall bit rate mode : Variable
    Overall bit rate : 489 kb/s
    Writing application : Lavf56.30.100

    Video
    ID : 1
    Format : AVC
    Format/Info : Advanced Video Codec
    Format profile : Main@L4
    Format settings : CABAC / 4 Ref Frames
    Format settings, CABAC : Yes
    Format settings, RefFrames : 4 frames
    Codec ID : avc1
    Codec ID/Info : Advanced Video Coding
    Duration : 5 min 26 s
    Bit rate : 420 kb/s
    Nominal bit rate : 1 200 kb/s
    Width : 1 920 pixels
    Height : 1 080 pixels
    Display aspect ratio : 16:10
    Frame rate mode : Variable
    Frame rate : 29.795 FPS
    Minimum frame rate : 10.004 FPS
    Maximum frame rate : 30.000 FPS
    Color space : YUV
    Chroma subsampling : 4:2:0
    Bit depth : 8 bits
    Scan type : Progressive
    Bits/(Pixel*Frame) : 0.007
    Stream size : 16.4 MiB (86%)
    Writing library : x264 core 148
    Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=24 / lookahead_threads=4 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=1200 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1200 / vbv_bufsize=2400 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00

    Audio
    ID : 2
    Format : AAC
    Format/Info : Advanced Audio Codec
    Format profile : HE-AAC / LC
    Format settings : Implicit
    Codec ID : mp4a-40-2
    Duration : 5 min 26 s
    Bit rate mode : Variable
    Bit rate : 62.4 kb/s
    Maximum bit rate : 64.1 kb/s
    Channel(s) : 2 channels
    Channel positions : Front: L R
    Sampling rate : 44.1 kHz / 22.05 kHz
    Frame rate : 21.533 FPS (1024 SPF)
    Compression mode : Lossy
    Stream size : 2.43 MiB (13%)
    Default : Yes
    Alternate group : 1
    Screenshots

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)

    ✅ Exclusive eLearning Videos ParRus-blogadd to bookmarks
    Feel free to contact me PM
    when links are dead or want any repost

    SQL and PostgreSQL: The Complete Developer's Guide (10/2020)