Introducing SQL and Relational Databases

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size86.5 MB
  • Uploaded Bytutsnode
  • Downloads62
  • Last checkedNov. 08th '22
  • Date uploadedNov. 07th '22
  • Seeders 41
  • Leechers5

Infohash : AC23AE33B71CCAD0F0452FA5CB6D9643DFD73F96


Description

Start on the road to mastery of SQL and databases: two of the most important topics in IT. In this video, SQL expert Allen G Taylor covers the basics of SQL. Part 1 explains where SQL came from, why data should be organized, and the value of databases as a tool. Part 2 is an overview of the relational model, and explains the concept of functional dependencies and the role of keys in a database table. Part 3 explores the data processing chain and DBMS. Finally, Part 4 describes entity-relationship models and how they operate within existing business rules.

After watching Introducing SQL and Relational Databases, you will understand how SQL and databases work and be ready for Allen Taylor’s next video demonstrating how to build and maintain a basic database.
What You Will Learn

Discover the importance of the relational database model
Become comfortable with the terminology used by database practitioners
Work with the structure of relational databases
Avoid data anomalies using normalization

Who This Video Is For

Programmers who are new to databases, as well as non-programmers who must retrieve information from databases.

Files:

Introducing SQL and Relational Databases [TutsNode.net] - Introducing SQL and Relational Databases
  • 012. A Database is a Model of a Physical or Conceptual System.mp4 (20.2 MB)
  • 012. A Database is a Model of a Physical or Conceptual System en.srt (14.6 KB)
  • 009. Normalization en.srt (9.5 KB)
  • 002. Why Data is Stored in Databases en.srt (3.0 KB)
  • 014. Business Rules and Constraints en.srt (6.3 KB)
  • 001. SQL, An international Standard Database Language en.srt (5.0 KB)
  • 008. Modification Anomalies en.srt (5.0 KB)
  • 004. The Relational Model en.srt (2.7 KB)
  • 011. The Back End of the Chain en.srt (4.4 KB)
  • 007. Keys en.srt (4.2 KB)
  • 005. Nomenclature Confusion en.srt (4.2 KB)
  • 009. Normalization.mp4 (9.0 MB)
  • 013. Converting an E-R Model into a Relational Model en.srt (4.0 KB)
  • 010. The Front End of the Chain en.srt (3.4 KB)
  • 006. Functional Dependencies en.srt (3.2 KB)
  • 003. The Needle in a Haystack Problem en.srt (3.2 KB)
  • 001. SQL, An international Standard Database Language.mp4 (7.5 MB)
  • 004. The Relational Model.mp4 (6.5 MB)
  • 003. The Needle in a Haystack Problem.mp4 (6.1 MB)
  • 014. Business Rules and Constraints.mp4 (5.9 MB)
  • 008. Modification Anomalies.mp4 (4.8 MB)
  • 010. The Front End of the Chain.mp4 (4.6 MB)
  • 011. The Back End of the Chain.mp4 (4.5 MB)
  • 013. Converting an E-R Model into a Relational Model.mp4 (3.8 MB)
  • 007. Keys.mp4 (3.4 MB)
  • 002. Why Data is Stored in Databases.mp4 (3.4 MB)
  • 005. Nomenclature Confusion.mp4 (3.4 MB)
  • 006. Functional Dependencies.mp4 (2.8 MB)
  • TutsNode.net.txt (0.1 KB)
  • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)
  • .pad
    • 0 (1.8 KB)
    • 1 (113.7 KB)
    • 2 (87.5 KB)
    • 3 (23.5 KB)
    • 4 (76.1 KB)
    • 5 (63.5 KB)
    • 6 (39.4 KB)
    • 7 (15.5 KB)
    • 8 (112.7 KB)
    • 9 (79.9 KB)
    • 10 (3.5 KB)
    • 11 (18.0 KB)
    • 12 (19.5 KB)

Code:

  • udp://open.stealth.si:80/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://fasttracker.foreverpirates.co:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://opentracker.i2p.rocks:6969/announce
  • udp://tracker.birkenwald.de:6969/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.moeking.me:6969/announce
  • udp://tracker.dler.org:6969/announce
  • udp://9.rarbg.me:2970/announce