Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)
In this video, we will explore the usage of table compression techniques. You will learn about basic compression and how to describe and apply it to optimize storage space. This clip is from the chapter "Managing Database Segments" of...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Deferred Segment Creation
In this practice video, we will gain hands-on experience with deferred segment creation in an Oracle database. You will examine the behavior of deferred segment creation and understand its impact on segment management. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Using Deferred Segment Creation
In this video, we will delve into the concept of deferred segment creation. You will understand how to leverage deferred segment creation to optimize space utilization and materialize database segments efficiently. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 4 of 4)
In this video, we will further discuss the management of tablespaces. You will learn how to alter tablespace availability, make tablespaces read-only or read-write, and assign specific quota on tablespaces to users. This clip is from the...
Curated Video
ChatGPT and Prompt Engineering With Advanced Data Analysis - Continuing with VLookUp
Continuing on the previous video, this video will provide advanced techniques for using VLookUp in Excel with the assistance of ChatGPT. We will apply VLookUp in more complex scenarios, such as nested and multiple criteria VLookUp, and...
Curated Video
Design Microservices Architecture with Patterns and Principles - Data Partitioning: Horizontal, Vertical, and Functional Data Partitioning
This video explores different types of data partitioning techniques; horizontal partitioning, dividing data based on rows or ranges; vertical partitioning, splitting data based on columns or attributes; and functional partitioning,...
Curated Video
Design Microservices Architecture with Patterns and Principles - Relational and NoSQL Databases - Document, Key-Value, Graph-Based, Column-Based
The video explores different types of databases commonly used in microservices architecture, including relational databases and NoSQL databases such as document databases, key-value stores, graph databases, and columnar databases and...
Curated Video
Understanding and Implementing JOINs
Get to grips with JOINs, a crucial aspect of relational databases. This SkillSprint covers various types of JOINs and their applications, enabling you to link data across multiple tables effectively.
Curated Video
Introduction to Databases and SQL
Dive into the essentials of databases and SQL. Learn the basic concepts and roles of databases in managing data, and get your first introduction to SQL and its significance in the tech world, specifically focusing on MySQL.
Curated Video
Hamlet 1.5 Word Nerd: Table
The term "table" originates from the Latin word "tabula," which referred to a writing tablet made of wood. This term evolved to signify a piece of furniture with legs, while still retaining its original sense in phrases like "table of...
Curated Video
Hamlet 1.5 Discussion: "My Table"
After the ghost departs, Hamlet engages in an odd act of writing in his notebook, penning the realization that one can smile and still be a villain, reflecting his insight into Claudius's deceit. This act suggests Hamlet views himself as...
Curated Video
AWS, JavaScript, React - Deploy Web Apps on the Cloud - SQL Versus NoSQL Databases
This video demonstrates the fundamental differences between SQL and NoSQL databases.
Curated Video
AWS, JavaScript, React - Deploy Web Apps on the Cloud - Introduction to JSON Server
This video will introduce the JSON server and its components and concepts. We will understand the need to use the JSON server in our project and how it functions.
Curated Video
AWS, JavaScript, React - Deploy Web Apps on the Cloud - Hosted Software Firewalls UFW
Learn how to use UFW (Uncomplicated Firewall) to manage your firewall on Ubuntu, Debian, or Arch Linux.
Curated Video
Function Tables
Identify math vocabulary by reading and defining the words function table, pattern, and rule. Find the rule and complete a function table by using knowledge of number patterns.
Curated Video
EXCEL DATA: Connecting to databases
Learn to connect to databases, opening doors to a world of live data interaction.
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - CRUD Products: Part 1
In this video, we will dive into the process of creating, reading, updating, and deleting products. We will gain a comprehensive understanding of how to interact with product data, enabling us to add, view, modify, and remove products...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Adding Custom Fonts
This video focuses on enhancing the visual aesthetics of our application by incorporating custom fonts. We will discover how to integrate and apply different fonts to your UI components, creating unique and engaging user experiences that...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Improve Workflow, Sorting
In this video, we will discover strategies to optimize the workflow for waiters. You will learn to implement features such as sorting orders based on priority or specific criteria, enabling waitstaff to handle orders more effectively and...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Implement State Transitions: Part 2
Continuing from the previous, this video completes the implementation of state transitions within the Kitchen View. You will learn how to handle additional scenarios and edge cases, refining the state machine to handle various order...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Implement Styling and Continue with State Machine
Building upon the previous video, this video focuses on implementing styling for the Kitchen View and continuing the development of the state machine. You will learn to apply appropriate styles and visual cues to enhance the user...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Using XState to Create a State Machine for Every Table
This video explores the use of XState, a powerful state management library, to create a state machine for each table in the Kitchen View. You will learn to define different states and transitions to represent the lifecycle of an order,...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - PouchDB Integration
In this video, we will dive into the integration of PouchDB, a JavaScript database library that enables offline data storage and synchronization. We will explore the PouchDB API, learn to create, read, update, and delete documents, and...
Curated Video
Offline-First Apps with Angular, Ionic, PouchDB, and CouchDB - Transition from Paid to Free
In this video, we will dive into the process of fixing the bug by implementing a smooth transition from the paid state to the free state for occupied tables. You will learn to properly manage and update the table's status, enabling users...