Curated Video
Master SQL for Data Analysis - Database Dictionary
We will explore the data-storing area called the dictionary, which stores constraints, filters, functions, lists, and so on. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Grouping Rows (GROUP BY and HAVING)
Let's learn how to group rows based on values in specific columns and then apply different actions on the groups, such as applying filters using GROUP BY and HAVING. This clip is from the chapter "SQL - Retrieving Data with Queries" of...
Curated Video
Master SQL for Data Analysis - Query Data (SELECT)
Let's learn to query data using the SELECT option that determines the columns to include in the result set. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data Analysis".This section...
Curated Video
Master SQL for Data Analysis - Update and Delete
Here, you will learn to update a table's fields and delete erroneous or redundant information. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves...
Curated Video
Master SQL for Data Analysis - Inserting Data
In this lesson, we will look at inserting data into tables and learn to use commands to insert single and multiple rows of data. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for...
Curated Video
Master SQL for Data Analysis - Creating Tables - Introduction
Let's explore how to organize data better by building tables in a database. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves deep into creating...
Curated Video
Master SQL for Data Analysis - Schema, Metadata, Data Dictionary
Let's learn how to create multiple relational database instances and define the needed table for each entity type. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses...
Curated Video
Master SQL for Data Analysis - Cross-Join
In this lesson, you will learn about combining datasets and tables with very little or no common factors among them. This clip is from the chapter "SQL - Combining Data from Multiple Tables" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Overview-3
This video provides an overview of the combination of data from multiple datasets from multiple tables using operators. This clip is from the chapter "SQL - Combining Data from Multiple Tables" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Overview-1
This video outlines creating entire databases and building schemas and tables in detail. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves deep...
Curated Video
Master SQL for Data Analysis - Relational Model, ER Diagram
Here, we will explore the three main building blocks of a relational database: entity, attribute, and relationship. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses...
Curated Video
Master SQL for Data Analysis - Primary and Foreign Keys
In this video, we will look at a primary key used to identify a row in a table and a foreign key used to navigate from one table to another. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Tables, Columns, Rows
In this lesson, we will explore tables in a database, and the two-dimensional rows and columns of a table. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses on...
Curated Video
Master SQL for Data Analysis - Overview - Database, DBMS, SQL
In this video, the author discusses the key terms used when talking about SQL and relational databases. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses on...
Curated Video
Master SQL for Data Analysis - DB Installation
This video demonstrates how to install PostgreSQL, the most advanced RDBMS that we have currently. This clip is from the chapter "Getting Started!" of the series "Master SQL for Data Analysis".This section focuses on a general...
Curated Video
Master SQL for Data Analysis - Our Learning Objectives-1
This video looks at the learning objectives from this course and the general training roadmap. This clip is from the chapter "Getting Started!" of the series "Master SQL for Data Analysis".This section focuses on a general introduction...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating a CDB Database
In this practice video, you will gain hands-on experience by dropping the database in srv1 and creating a Container Database (CDB) in its place. You will learn the practical steps involved in setting up a CDB environment. This clip is...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Querying Data Dictionary
In this Practice video, you will learn how to retrieve specific information about an Oracle database by querying dynamic performance views and data dictionary views. You will gain hands-on experience in extracting meaningful insights...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Data Dictionary
In this video, we will introduce the concept of the data dictionary in Oracle Database. You will learn about dynamic performance views and data dictionary views, and how to query them to retrieve valuable information about the database....
Curated Video
Oracle Database Administration from Zero to Hero - Overview of RDBMS (Part 1 of 2)
In this video, you will learn about the basics of RDBMS, including its features, SQL, and the different RDBMS products available in the market. This clip is from the chapter "Introduction to RDBMS" of the series "Oracle Database...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - ChatGPT for Power BI Desktop
ChatGPT chatbot technology with Power BI Desktop integration allows users to interact with data and reports through NLP queries. The video provides step-by-step guidance on setting up the integration and use of ChatGPT to enhance...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Circular Dependency Errors in Relationships Between Tables and How to Fix Them
This video delves deeper into circular dependency errors in Power BI and guides on identifying and fixing errors in the context of table relationships. We will gain valuable insights into best practices for structuring tables and...
Curated Video
ChatGPT 101 - Supercharge Your Work and Life with ChatGPT - Prompt Formats and Output Options
This video explores different prompt formats and output options for working with ChatGPT. You will learn about the benefits and limitations of different prompt formats and approaches for selecting the right format for a particular task....
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Table Compression
In this practice video, we will deepen our understanding of table compression by examining scenarios where basic compression and advanced compression techniques are effective. You will gain practical experience in applying compression to...