Querying Databases with SQL and NoSQL: PostgreSQL ,MongoDB
Querying Databases with SQL and NoSQL: PostgreSQL ,MongoDB, available at $49.99, has an average rating of 3.45, with 62 lectures, based on 13 reviews, and has 2050 subscribers.
You will learn about Install and Setup PostgreSQL Database Server Install and Setup MongoDB NoSQL Database Install Sample Database Query PostgreSQL Databases with SQL Query MongoDB with NoSQL Filter and sort data Grouping Data Query data with Table Joins Query data with Aggregate Functions This course is ideal for individuals who are Beginner Database Administrators or Beginner Data Analyst or Beginner Data Scientist It is particularly useful for Beginner Database Administrators or Beginner Data Analyst or Beginner Data Scientist.
Enroll now: Querying Databases with SQL and NoSQL: PostgreSQL ,MongoDB
Summary
Title: Querying Databases with SQL and NoSQL: PostgreSQL ,MongoDB
Price: $49.99
Average Rating: 3.45
Number of Lectures: 62
Number of Published Lectures: 62
Number of Curriculum Items: 62
Number of Published Curriculum Objects: 62
Original Price: $64.99
Quality Status: approved
Status: Live
What You Will Learn
- Install and Setup PostgreSQL Database Server
- Install and Setup MongoDB NoSQL Database
- Install Sample Database
- Query PostgreSQL Databases with SQL
- Query MongoDB with NoSQL
- Filter and sort data
- Grouping Data
- Query data with Table Joins
- Query data with Aggregate Functions
Who Should Attend
- Beginner Database Administrators
- Beginner Data Analyst
- Beginner Data Scientist
Target Audiences
- Beginner Database Administrators
- Beginner Data Analyst
- Beginner Data Scientist
Databases are crucial to building applications. They store data that make our applications work like they should. A database query is a request for a database’s data so we can retrieve or manipulate it.
At a very high level, a query is a question. When we talk about queries in relation to other people, we expect some sort of answer in return. This is no different for computers when we perform database queries.
A database query is a similar action that is most closely associated with some sort of CRUD (create, read, update, delete) function. A database query is a request to access data from a database to manipulate it or retrieve it. This allows us to perform logic with the information we get in response to the query.
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database.
Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data
SQL is a programming language used by nearly all relational databases to query, manipulate, and define data, and to provide access control. SQL was first developed at IBM in the 1970s with Oracle as a major contributor, which led to implementation of the SQL ANSI standard, SQL has spurred many extensions from companies such as IBM, Oracle, and Microsoft. Although SQL is still widely used today, new programming languages are beginning to appear.
Relational databases became dominant in the 1980s. Items in a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information.
A NoSQL, or nonrelational database, allows unstructured and semi structured data to be stored and manipulated (in contrast to a relational database, which defines how all data inserted into the database must be composed). NoSQL databases grew popular as web applications became more common and more complex.
PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
MongoDB is an open-source document database built on a horizontal scale-out architecture that uses a flexible schema for storing data.
SQL stands for Structured Query Language
SQL lets you access and manipulate databases.
Course Curriculum
Chapter 1: PostgreSQL Database Server Setup
Lecture 1: Introduction
Lecture 2: What is SQL
Lecture 3: What is PostgreSQL
Lecture 4: Installing PostgreSQL on Windows
Lecture 5: Installing PostgreSQL on MacOS
Lecture 6: Installing PgAdmin on MacOS
Lecture 7: Installing PostgreSQL on Linux (Ubuntu)
Lecture 8: Installing PgAdmin on Linux (Ubuntu)
Lecture 9: Connecting to PostgreSQL Server
Lecture 10: Installing Sample database
Lecture 11: Database Concepts
Chapter 2: Querying PostgreSQL Databases with SQL
Lecture 1: Getting all data from a table
Lecture 2: Getting data from specific table columns
Lecture 3: Filtering data from database
Lecture 4: Sorting data from database
Lecture 5: Grouping Data
Lecture 6: Filtering Groups
Lecture 7: Query database using comparison operators
Lecture 8: Query database using Between operators
Lecture 9: Query database using Not Between operators
Lecture 10: Query database using LIKE operators
Lecture 11: Query database using Not operators
Lecture 12: Query database using OR operators
Lecture 13: Query database using AND operators
Lecture 14: Query database using OR + AND operators
Lecture 15: Query database using Limit operators
Lecture 16: Query database using IN operators
Lecture 17: Query database using Union operators
Lecture 18: Query database using Union All operators
Lecture 19: Query database using Intersect operators
Lecture 20: Query database using Except operators
Lecture 21: Table Joins
Lecture 22: Query database using Inner Table Join
Lecture 23: Query database using Left Join Table Join
Lecture 24: Query database using Full Outer Table Join
Lecture 25: Query database using Cross Table Join
Lecture 26: Query database using Natural Table Join
Lecture 27: What are Aggregate Functions
Lecture 28: Query database using AVG Aggregate Functions
Lecture 29: Query database using COUNT Aggregate Functions
Lecture 30: Query database using MAX Aggregate Functions
Lecture 31: Query database using MIN Aggregate Functions
Lecture 32: Query database using SUM Aggregate Functions
Chapter 3: MongoDB Environment Setup
Lecture 1: What is MongoDB
Lecture 2: Installing MongoDB
Lecture 3: Installing MongoDB on Macs
Lecture 4: Modifying environment variables
Lecture 5: Creating a storage directory
Lecture 6: Starting and stopping mongoDB
Lecture 7: MongoDB Data Types
Lecture 8: Create a database
Lecture 9: Inserting documents into MongoDB
Chapter 4: Querying databases with NoSQL
Lecture 1: What is NoSQL
Lecture 2: Querying documents
Lecture 3: Updating documents
Lecture 4: Deleting documents
Lecture 5: Limiting data
Lecture 6: Indexes
Lecture 7: Creating CSV files
Lecture 8: Exploring dataset structures
Lecture 9: Using MongoDB Import Tool
Lecture 10: Joining collections
Instructors
-
Bluelime Learning Solutions
Making Learning Simple
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 2 votes
- 3 stars: 3 votes
- 4 stars: 1 votes
- 5 stars: 6 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024