SQL for Data Analysis - with SQL Server [4/2023, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL for Data Analysis - with SQL Server

Год выпуска: 4/2023
Производитель: Udemy
Сайт производителя: https://www.udemy.com/course/sql-basics-crash-course-with-sql-server/
Автор: Travis Cuzick
Продолжительность: 5h 30m 10s
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субтитры: Английский
Описание:

What you'll learn Use SQL to apply complex criteria and transformations to database data
Master SQL functions for sophisticated data manipulation
Leverage an understanding of relational database design to link together data stored across multiple tables
Use aggregate queries to produce summarized views and analysis
Be comfortable putting SQL and SQL Server on your resume
Gain experience with the kind of SQL coding problems you are likely to encounter in an interview Requirements Access to a Windows 10 operating system (SQL Server only runs on Windows); there are known compatibility issues between Windows 11 and SQL Server 2019, so I STRONGLY recommend Windows 10 for this course. If you only have access to a Windows 11 machine, you can install SQL Server 2022 instead.
Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup. Description

If you spend a lot of time extracting, transforming, or analyzing data from databases, - or you're aiming for one of the many highly paid career paths that rely heavily on this skill - then this course is for you.

Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst, but also provides a strong foundation for even more exotic roles like that of a Data Scientist. Experienced Data Scientists will tell you that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well.

In this course, I have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming. Instead, I carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional.

This enabled me to condense a complete course on SQL into just 36 instructional videos, averaging less than 10 minutes in length. So if you can commit to a video a day, in just over one month you’ll have added an extremely valuable and lucrative skill to your arsenal (and just as importantly, your resume!).

And to make sure all that knowledge sticks, I’ve included exercises...LOTS of exercises. Unlike most courses, which only feature sporadic opportunities to practice what you’ve learned, this course has practice problems after almost every video - so you can reinforce concepts right away.

Take it from someone who has built their career almost entirely on self-taught technical skills: it’s worth the effort. Several recent surveys have shown that SQL is actually the MOST in-demand tech skill sought after by recruiters!

In short, learning SQL can change your life, if you put in the work Let me be your guide to this next step in your career - I think you’ll find the journey a lot less daunting, and maybe even a little more fun, than you would have ever expected.

Who this course is for: Aspiring Data Analysts or Business Intelligence Analysts looking to break into these fields by learning SQL
Data Scientists trying to improve their data cleaning and transformation skills by learning SQL
Non-technical business professionals such as business analysts and project managers trying to gain a better understanding of the technical domains they interact with Формат видео: MP4
Видео: avc, 1280x720, 16:9, 30.000 к/с, 1092 кб/с
Аудио: aac lc, 44.1 кгц, 128 кб/с, 2 аудио
[spoiler="Изменения/Changes"]
Version 2023/4 compared to 2020/8 has increased the number of 30 lessons and the duration of 7 minutes.
[/spoiler]
[spoiler="MediaInfo"]
General
Complete name : D:\1\Udemy - SQL for Data Analysis - with SQL Server (4.2023)\6. BONUS Section - Summarizing Your Data With Aggregate Queries\5. Filtering Aggregate Calculations With HAVING.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 85.7 MiB
Duration : 9 min 45 s
Overall bit rate : 1 228 kb/s
Frame rate : 30.000 FPS
Writing application : Lavf58.12.100
Conformance errors : 2
read : Yes
General compliance : Element size 2065855584 is more than maximal permitted size 10232 (offset 0x55A75EB)
MPEG-4 : Yes
General compliance : File size 89824739 is less than expected size 2155670091 (offset 0x55A75EB)

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : [email protected]
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 : 9 min 44 s
Bit rate : 1 092 kb/s
Nominal 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.039
Stream size : 76.1 MiB (89%)
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=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
Codec configuration box : avcC

Audio
ID : 2
Format : AAC LC
Format/Info : Advanced Audio Codec Low Complexity
Codec ID : mp4a-40-2
Duration : 9 min 45 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 : 8.93 MiB (10%)
Default : Yes
Alternate group : 1
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]