| 01 - Database management systems (DBMS).MP4 | 5.5 MB | ||
| 01 - Follow a naming convention.MP4 | 5.5 MB | ||
| 01 - Identify key fields.MP4 | 8.8 MB | ||
| 01 - Implement the plan.MP4 | 1.2 MB | ||
| 01 - Move from planning to construction.MP4 | 3.8 MB | ||
| 01 - Relational database advantages.MP4 | 1.5 MB | ||
| 01 - Understand entities and tables.MP4 | 4.1 MB | ||
| 01 - Understand the goal.MP4 | 3.6 MB | ||
| 01 - Welcome.MP4 | 2.4 MB | ||
| 02 - Create the tables in Access.MP4 | 11.9 MB | ||
| 02 - Data types and precision.MP4 | 6.3 MB | ||
| 02 - Develop relationships.MP4 | 6.3 MB | ||
| 02 - First normal form.MP4 | 4.9 MB | ||
| 02 - Next steps.MP4 | 1.1 MB | ||
| 02 - Relational structures.MP4 | 4.5 MB | ||
| 02 - Remove duplicate information.MP4 | 5.3 MB | ||
| 02 - Review the current system.MP4 | 3.3 MB | ||
| 02 - What you should know.MP4 | 1.7 MB | ||
| 03 - Create junction tables.MP4 | 4.7 MB | ||
| 03 - Develop subtypes and supertypes.MP4 | 3.5 MB | ||
| 03 - Discover actors and tasks.MP4 | 4.8 MB | ||
| 03 - Eliminate inconsistent data.MP4 | 5.9 MB | ||
| 03 - Establish relationships in Access.MP4 | 6.4 MB | ||
| 03 - Exercise files.MP4 | 1.1 MB | ||
| 03 - Get to know your RDBMS options.MP4 | 4.7 MB | ||
| 03 - Second normal form.MP4 | 4.8 MB | ||
| 04 - Apply integrity constraints.MP4 | 3.1 MB | ||
| 04 - Break data down into its components.MP4 | 5.2 MB | ||
| 04 - Interview the client.MP4 | 4.5 MB | ||
| 04 - The database development lifecycle.MP4 | 6.7 MB | ||
| 04 - Third normal form.MP4 | 4.8 MB | ||
| 04 - Utilize lookup tables.MP4 | 3.1 MB | ||
| 04 - Write queries in Access.MP4 | 5.6 MB | ||
| 05 - Create the tables in SQL Server.MP4 | 13.5 MB | ||
| 05 - Denormalization.MP4 | 3.6 MB | ||
| 05 - Draft the initial data model.MP4 | 1.2 MB | ||
| 05 - Enforce referential integrity.MP4 | 2.5 MB | ||
| 05 - Prevent data conflicts.MP4 | 3.7 MB | ||
| 05 - Work with historical values.MP4 | 2.3 MB | ||
| 06 - Build indexes.MP4 | 4.7 MB | ||
| 06 - Establish relationships in SQL Server.MP4 | 8.6 MB | ||
| 06 - Identify exceptions and irregularities.MP4 | 1.6 MB | ||
| 06 - Require complete information.MP4 | 5.1 MB | ||
| 07 - Create views in SQL Server.MP4 | 7.5 MB | ||
| 07 - Maintain a consistent structure.MP4 | 6 MB | ||
| LearningRelationalDatabases2017.pdf | 418.8 KB | ||
| ▲ 46 total files | |||
Released: 8/26/2017
Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles.
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
Topics include:
What is a database management system (DBMS)?
Moving through the database development cycle
Preventing duplicate, inconsistent, and conflicting data entries
Gathering requirements
Developing relationships
Identifying key fields
Following a naming convention
Developing the actual database
Lynda Official Tutorial Link
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 12.3 GB | SunRiseZone | 4 years | 1 | 4 | |
| 360.6 MB | notmrME | 5 years | 0 | 0 | |
| 371.9 MB | notmrME | 5 years | 0 | 0 | |
| 424.5 MB | notmrME | 5 years | 0 | 0 | |
| 599.2 MB | tutsnode | 5 years | 0 | 0 |
All Comments