Learning storage in SQL 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 325:- Learning storage in SQL databases
In SQL databases, data is stored in tables. A table is made up of rows and columns. Each row represents a single record or item, while each column represents a specific property or attribute of that record.
To store data in SQL databases, we need to create a database schema. A schema is a blueprint of how the data will be organized in the database. It defines the tables, columns, data types, and relationships between tables.
Once the schema is defined, we can create tables and add data to them using SQL commands such as INSERT, UPDATE, and DELETE. We can also retrieve data using SELECT statements.
SQL databases are designed to handle structured data that fits into a predefined schema. They are widely used in applications where data consistency and integrity are crucial, such as financial transactions, healthcare records, and government systems. Popular SQL databases include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
- 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.