EssentialSQL: Data Modeling & Relational Data Architecture [9/2022, ENG] torrent

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

EssentialSQL: Data Modeling & Relational Data Architecture

Год выпуска: 9/2022
Производитель: Udemy
Сайт производителя: https://www.udemy.com/course/relational-database-design-sql/
Автор: Kris Wenzel, Essential Sql
Продолжительность: 3h 39m 25s
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субтитры: Английский
Описание:

Database Design | Data Model | Data Architecture | Relational Database Design | Database Normalization | Data Modeling

What you'll learn Understand the fundamental concepts of data architecture and principles of data modeling, including entities, attributes, relationships, and keys.
Understand the various types of data models, including conceptual models, logical models, and physical models.
Be able to choose the appropriate data model for a given situation.
Be able to analyze and design a database using the Entity-Relationship (ER) data model.
Know how to transform a conceptual data model into a logical data model using normalization.
Understand the principles of data modeling and database design to create a well-designed database.
Know how to use data modeling tools, such as ER (Entity Relationship) diagrams and data modeling software, to create and document data models.
Be able to communicate effectively about data modeling concepts and designs with both technical and non-technical audiences. Requirements No programming experience is needed.
No prior knowledge of MySQL, SQLServer, PostgreSQL or Oracle is required!
Appreciate basic database concepts such as knowing about columns, rows, and tables.
Interest in a class hyper-focused on database design and data architecture -- nothing else! Description

This course is perfect if you're looking for entry-level course to learn data modeling and relational database table design.

Its singular purpose is to teach you relational database logical design using simple to understand English. We'll walk though modeling requirements, building the conceptual data model, and logical database model. Finally we create scripts to create the physical tables. If you looking to understand data architecture, then you'll find this course very practical!

Join me as we work through Lou's, the owner of several pizza shops, to model, design and create a database he can use to track is business.

In this Course you will Learn to: Create a conceptual data model based on Lou's Pizza Shops' requirements.
Use ER (Entity-Relationship) diagrams to model and design database tables and relationships between one another.
Appreciate and design around data modification anomalies.
Identify a properly formed database table.
Answer common interview questions related to relational database normalization and data architecture.
Spot a poorly designed table.
Communicate with others about table design.
Finally understand those confounding normalization rules!
Identify database normalization issues within our design and know how to fix them.
Use an ERD (Entity Relationship Diagram) to create database scripts. Nothing is worse than Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use. Imagine Having... Knowledge - Knowing how to quickly understand database design to take your SQL to the next level.
Confidence - Feeling good that you’re on the right track.
Accomplishment - Having a sense of accomplishment that you've learned something most cannot.
Fun - Having fun learning databases! By the time you’ve completed this course you’ll be able to design and implement relational databases using tables, keys, relationships, and SQL commands in MySQL, PostgresSQL, and SQL Server to meet user and operational needs.

Who this course is for: Students baffled by their professor's database normalization explanations
DBAs seeking common sense definitions of database normal forms.
Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer.
People preparing for SQL related job interviews.
Anyone looking to take a class whose singular purpose is to teach you database design.
Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations. Формат видео: MP4
Видео: avc, 1280x720, 16:9, 30.000 к/с, 907 кб/с
Аудио: aac lc, 44.1 кгц, 128 кб/с, 2 аудио
[spoiler="MediaInfo"]
General
Complete name : D:\2_1\Udemy - EssentialSQL Data Modeling & Relational Data Architecture (9.2022)\7 - Relational Database Design In Practice\21 - ER Diagramming Initial Draft Part 3.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 58.0 MiB
Duration : 7 min 46 s
Overall bit rate : 1 043 kb/s
Frame rate : 30.000 FPS
Writing application : Lavf58.12.100

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 : 7 min 46 s
Bit rate : 907 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.033
Stream size : 50.4 MiB (87%)
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 : 7 min 46 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 : 7.12 MiB (12%)
Default : Yes
Alternate group : 1
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]