Introduction - New Relationships In Databases
Dear Sciaku Learner you are not logged in or not enrolled in this course.Please Click on login or enroll now button.
If you have any query feel free to chat us!
Happy Coding! Happy Learning!
Lecture 382:- Introduction - New Relationships In Databases
In databases, relationships define how tables are connected and interact with each other. The most common types of relationships in relational databases are:
- One-to-One Relationship: In a one-to-one relationship, one record in a table is linked to one record in another table. For example, each employee has only one Social Security number.
- One-to-Many Relationship: In a one-to-many relationship, one record in a table can be linked to many records in another table. For example, one customer can have many orders.
- Many-to-Many Relationship: In a many-to-many relationship, many records in one table can be linked to many records in another table. For example, one student can take many courses, and one course can be taken by many students.
To establish these relationships, we use primary and foreign keys. Primary keys are unique identifiers for each record in a table, while foreign keys are used to create links between tables.
Understanding how to create and manage relationships in databases is crucial for building complex and scalable applications.
- 1. Intro To Html
- 2. Creating First HTML Page
- 3. HTML Page Structure
- 4. What We Plan to Build
- 5. Title Tag
- 6. Basic HTML Tags
- 7. Unordered Lists
- 8. Ordered Lists
- 9. Adding Lists to Blog page
- 10. Adding Image to Blog Page
- 11. Adding Header To Blog Page
- 12. Learning Anchor Tag Part 1
- 13. Learning Anchor Tag Part 2
- 1. What are Frontend Frameworks
- 2. Getting Started with Bootstrap
- 3. Adding Bootstrap to your Project
- 4. Bootstrap Breakpoints
- 5. Bootstrap Grid System
- 6. Code Using Bootstrap Grid System
- 7. Margin and Display Utilities
- 8. Other Utility Classes
- 9. Bootstrap Components
- 10. Modals
- 11. Collapse Component
- 12. Nav
- 13. Navbar
- 14. Jumbotron Template
- 1. What is Git
- 2. Git Commits
- 3. Git Commits Part 2
- 4. Git Understanding Branches
- 5. Git Making Branches
- 6. Git Merging Branches
- 7. Git Conflicts in Branches
- 8. Git Understanding Workflows
- 9. Pushing to github.com
- 10. Github With a Team Member
- 11. Git - Multiple Teams - Forking
- 12. Completing with PR Open Source Contribution
- 13. Pull Requests and Workflows of Large Teams
- 1. Const
- 2. Let
- 3. Let vs Var
- 4. For of loop
- 5. Smooth Scroll Demo
- 6. Smooth Scroll Hint 1
- 7. Smooth Scroll Hint 2
- 8. Smooth Scroll Solution
- 9. Another Approach to Write Code
- 10. Skill Bar Demo
- 11. Moving Ahead with Skill Bar Auto Fill
- 12. Competing Skill Bar Auto Fill
- 13. Counter Demo
- 14. Counter Hint
- 1. Intro to Lecture
- 2. This Keyword
- 3. This in Strict Mode
- 4. Function to create Objects
- 5. Constructor
- 6. Adding Behaviour to Objects
- 7. What is a Prototype
- 8. Why Prototypes
- 9. More Properties around Prototype
- 10. Objects
- 11. object vs Object()
- 12. Class
- 13. Class Expressions and Hoisting
- 14. Inheritance Using Classes
- 1. Server - What & How
- 2. Setting Up Our First Node.js Server
- 3. Serving a Response to the Browser
- 4. Understanding Responses
- 5. Serving HTML!
- 6. Reading and Serving HTML From a File
- 7. Nodemon, Automatic Server Restarts
- 8. Extending to Multiple Pages
- 9. Linking Pages & Mini Assignment
- 10. Summarizing!
- 1. Web Frameworks - A Quick Introduction
- 2. Understanding MVC Models, Views, Controllers
- 3. Why Express.js
- 4. Setting Up Express Server
- 5. Returning Response From The Server
- 6. HTTP Requests
- 7. Template Engines - What
- 8. Template Engines - Some Examples
- 9. Setting Up A Template Engine
- 10. A Quick Revision
- 11. Debugging Basics
- 12. Rendering Our First Page
- 13. Playing With EJS
- 14. Locals In Views
- 15. Summarizing
- 1. Introduction
- 2. Creating A Contact List
- 3. Sending Data To The Server
- 4. Parsing Form Data - Introduction
- 5. Parsing Form Data - Storing The Contact
- 6. Middleware - What and How
- 7. Accessing Static Files
- 8. Styling Our App
- 9. A Quick Revision
- 10. Query & String Parameters - Beginning
- 11. Query & String Parameters - Details
- 12. Deleting A Contact
- 13. Summarizing
- 1. Introduction
- 2. Setting Up Directory Structure
- 3. Starting Express
- 4. Adding Git and NPM Start
- 5. Setup the Express Router
- 6. Create a Controller
- 7. Create Another Controller and Router
- 8. Assignment adding more routes and controllers
- 9. Install EJS and Setup View Engine
- 10. Create a view for home
- 11. Summary
- 1. Introduction
- 2. Glancing through and Installing Passportjs
- 3. Setting up Passport.js
- 4. Express sessions and using passport for Authentication
- 5. Setting current authenticated user
- 6. Passing User data to views and restricting page access
- 7. Setting up Mongo store for session cookies
- 8. Creating Sign out
- 9. Summarizing
- 1. Introduction
- 2. Node.js - Explaining 1-1 and 1-M
- 3. Creating Schema for Posts
- 4. Saving Posts to the DB
- 5. Display Posts and related User
- 6. Check Authentication on Creating Post
- 7. Creating Schema for Comments
- 8. Adding Comments to the DB
- 9. Nested Population - Display Comment and Related User
- 10. Learning storage in SQL databases
- 11. Summarizing
Frequently Asked Questions (FAQs)
How do I register on Sciaku.com?
How can I enroll in a course on Sciaku.com?
Are there free courses available on Sciaku.com?
How do I purchase a paid course on Sciaku.com?
What payment methods are accepted on Sciaku.com?
How will I access the course content after purchasing a course?
How long do I have access to a purchased course on Sciaku.com?
How do I contact the admin for assistance or support?
Can I get a refund for a course I've purchased?
How does the admin grant access to a course after payment?
Comments: 2
I am not able to access videos from second class and further. I have already completed first class
When will I get my course?
Now, Your query was resolved.