SQL and PostgreSQL: A Practical Course
Год выпуска: 3/2025
Производитель: Udemy
Сайт производителя:
https://www.udemy.com/course/sql-postgresql-practical-course/
Автор: Denis Suchkov
Продолжительность: 2h 36m 52s
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субтитры: Английский
Описание:
What you'll learn
- Learn the fundamentals of relational databases using one of the most popular DBMSs - PostgreSQL
- Master writing fast and efficient SQL queries, from basic to advanced, using JOIN, GROUP BY, and window functions
- Apply your knowledge through hands-on practice with various quizzes and exercises
- Explore advanced topics, including transaction management and index building
Requirements
- No programming experience is required. The course covers everything you need for successful learning.
Description
Learn SQL Quickly and Effectively
This course is the English version of my original top-rated Russian course.
All lessons include full subtitles in:
English,
Español,
Português,
Français,
العربية,
हिन्दी,
Bahasa Indonesia,
Türkçe,
ภาษาไทย, and
Tiếng Việt — making it ideal for learners from around the world who prefer to follow along in their native language.
This version was created to make the content accessible for non-native English speakers, especially those who benefit from clear and accurate subtitles.
Whether you're just starting out or want to strengthen your SQL fundamentals, this course will help you master one of the most in-demand database systems — PostgreSQL.
What you'll learn in this course:
- Database fundamentals: Understand the structure of relational databases and learn the basics of database organization and management.
- Database creation and management with SQL and PostgreSQL: Master creating databases, tables, and managing them using the powerful tools and features of SQL and PostgreSQL.
- Efficient SQL queries for data manipulation: Learn how to write SQL queries to retrieve, sort, filter, and perform complex data operations.
- Transactions and indexing: Master the use of transactions to ensure data integrity and indexes to speed up query execution.
Why choose this course:
The course features practical demonstrations and numerous real-world examples to help you better understand the material. You’ll engage in hands-on exercises and quizzes to reinforce your knowledge and assess your understanding independently. The course provides market-relevant knowledge, making you a competitive professional in the field of databases. These skills will help you enhance your current professional opportunities and unlock new career paths.
Who this course is for:
- Beginners who want to learn SQL and PostgreSQL from scratch
- Developers and analysts seeking to deepen their knowledge
- Anyone interested in effectively managing and analyzing data
Join the course and start your journey to mastering SQL and PostgreSQL today!
Who this course is for:
- This course is designed for a broad audience seeking to learn the fundamentals of working with relational databases.
Формат видео: MP4
Видео: avc, 1280x720, 16:9, 30.000 к/с, 794 кб/с
Аудио: aac lc, 44.1 кгц, 128 кб/с, 2 аудио
MediaInfo
General
Complete name : D:\2\Udemy - SQL and PostgreSQL A Practical Course (3.2025)\5 - Data Definition Language (DDL)\5 -UNIQUE Constraint.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 7.12 MiB
Duration : 1 min 4 s
Overall bit rate : 927 kb/s
Frame rate : 30.000 FPS
Writing application : Lavf59.27.100
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, Reference frames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 1 min 4 s
Bit rate : 794 kb/s
Nominal bit rate : 3 000 kb/s
Maximum bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.029
Stream size : 6.09 MiB (86%)
Writing library : x264 core 164 r3095 baee400
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=22 / lookahead_threads=3 / 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=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709
Codec configuration box : avcC
Audio
ID : 2
Format : AAC LC
Format/Info : Advanced Audio Codec Low Complexity
Codec ID : mp4a-40-2
Duration : 1 min 2 s
Source duration : 1 min 2 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel layout : L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 980 KiB (13%)
Source stream size : 981 KiB (13%)
Default : Yes
Alternate group : 1
