Relational Database Design with FileMaker Pro
WEBRip | English | MP4 + Project files | 1280 x 720 | AVC ~634 kbps | 29.970 fps
AAC | 160 Kbps | 48.0 KHz | 2 channels | 2h 40mn | 447.8 MB
AAC | 160 Kbps | 48.0 KHz | 2 channels | 2h 40mn | 447.8 MB
Genre: Video Tutorial / Development, Programming
Let author Cris Ippolite show you how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. The course begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the Relationship Graph. Then, after demonstrating how to establish relationships in a database, the course concludes with a demonstration of some advanced modeling techniques, such as filtering, scripting, and the use of portals. The course applies to versions of FileMaker Pro from 7 through the most current version.Main topics covered:
Introduction
Welcome UPDATED
Why relational databases? UPDATED
Using the exercise files UPDATED
1. Reviewing Data Modeling
Introduction to data modeling UPDATED
Reviewing relationships types UPDATED
Diagramming relationships UPDATED
2. Resolving Many-to-Many Relationship
Understanding problems caused by many-to-many relationships UPDATED
Adding a join table UPDATED
3. Introducing Key Fields
Using primary and foreign key fields UPDATED
Determining which tables need keys UPDATED
4. Using the FileMaker Relationship Graph
Defining tables UPDATED
Defining key fields UPDATED
Introducing the Relationship Graph UPDATED
5. Working with Relationships
Understanding related fields UPDATED
Understanding portals UPDATED
Using relationship options to create related fields UPDATED
Using multiple match fields in one relationship UPDATED
6. Real-World Data Modeling Examples
Donations example UPDATED
Class enrollment example UPDATED
Personnel management example UPDATED
7. Advanced Relationship Techniques
Using global fields to filter portals UPDATED
Using global fields to create a date range filter UPDATED
Using relationships in a script to navigate UPDATED
Using portals to connect to data more than one table away UPDATED
Creating self-relationships UPDATED
Adding charts with related data to layouts NEW
8. Relationships in Calculation
Creating aggregate functions using relationships UPDATED
Using the List function UPDATED
Conclusion
Next steps UPDATED
also You can watch my other last: Programming-posts
General
Complete name :019 Class enrollment example.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42 (mp42/isom)
File size : 35.2 MiB
Duration : 6mn 9s
Overall bit rate mode : Variable
Overall bit rate : 800 Kbps
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.2
Format settings, CABAC : Yes
Format settings, ReFrames : 5 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 6mn 9s
Bit rate mode : Variable
Bit rate : 634 Kbps
Maximum bit rate : 1 000 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.023
Stream size : 27.9 MiB (79%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=5 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / 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=10 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=1 / b_pyramid=0 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=300 / keyint_min=29 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=22.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1000 / vbv_bufsize=14900 / crf_max=0.0 / nal_hrd=vbr / ip_ratio=3.00 / aq=1:1.00
Language : English
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 6mn 9s
Source duration : 6mn 9s
Bit rate mode : Constant
Bit rate : 160 Kbps
Nominal bit rate : 128 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Frame rate : 46.875 fps (1024 spf)
Compression mode : Lossy
Stream size : 7.05 MiB (20%)
Source stream size : 7.05 MiB (20%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Language : English
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Complete name :019 Class enrollment example.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42 (mp42/isom)
File size : 35.2 MiB
Duration : 6mn 9s
Overall bit rate mode : Variable
Overall bit rate : 800 Kbps
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.2
Format settings, CABAC : Yes
Format settings, ReFrames : 5 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 6mn 9s
Bit rate mode : Variable
Bit rate : 634 Kbps
Maximum bit rate : 1 000 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.023
Stream size : 27.9 MiB (79%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=5 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / 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=10 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=1 / b_pyramid=0 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=300 / keyint_min=29 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=22.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1000 / vbv_bufsize=14900 / crf_max=0.0 / nal_hrd=vbr / ip_ratio=3.00 / aq=1:1.00
Language : English
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 6mn 9s
Source duration : 6mn 9s
Bit rate mode : Constant
Bit rate : 160 Kbps
Nominal bit rate : 128 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Frame rate : 46.875 fps (1024 spf)
Compression mode : Lossy
Stream size : 7.05 MiB (20%)
Source stream size : 7.05 MiB (20%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Language : English
Encoded date : UTC 2015-05-11 11:34:49
Tagged date : UTC 2015-05-11 11:34:49
Screenshots
For more Exclusive material, Visit my AH-blog