Creating and Querying Databases with NoSQL and SQL

Create and interact with databases using NoSQL and SQL

3.95 (16 reviews)
Udemy
platform
English
language
Databases
category
Creating and Querying Databases with NoSQL and SQL
4,451
students
2 hours
content
Oct 2023
last update
$34.99
regular price

What you will learn

Install a NoSQL Database Server

Create a NoSQL Database

Store data in a NoSQL Database

Query Data in a NoSQL Database

Filter and reduce data queried from a NoSQL Database

Create views from queried NoSQL Database

Create Database using SQL | TSQL

Create a table with SQL | TSQL

Insert data into SQL Server Database with SQL | TSQL

Query Data with SQL | TSQL

Description

NoSQL (Non-SQL or Not-only-SQL) databases are increasing in popularity due to the growth of data as they can store non-relational data on a super large scale, and can solve problems regular databases can't handle. They are widely used in Big data operations. Their main advantage is the ability to handle large data sets  effectively  as well as scalability and flexibility issues for modern applications. There are different categories of NoSQL  databases and they are used in social media such as with Facebook  and search like Google and in other types of sectors like Health, Aviation, Education  and other areas.

In this course  we will Use the Couch DB NoSQL database. We will create a database, load data and  query a database. Learn techniques such as querying with JavaScript, working with nested data, and creating views. You will learn how to query a database without  SQL by using JavaScript Map and Reduce functions Using the couch DB database you will learn how to insert data into the database using Key -Value pairs where every data key will have a corresponding value. Security and integrity of a database is very important  .


The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL, MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way. We will learn to create a database, table and how to insert data into a database table as well as querying it.


Content

Creating and querying a database with NoSQL

Introduction
What is NoSQL
What is NoSQL Databases Can do
Categories of NoSQL Databases
Downloading and Installing CouchDB
Creating a database and storing Data
Nesting Data
Retrieving data
Querying Data
Defining Views
Filtering Data with Reduce Function

Creating and Querying Databases with SQL | T-SQL

What is SQL
What is T-SQL
What is SQL Server
Download SQL Server
Install SQL Server
Install SSMS
Connecting to SQL Server
Create a database
Create a table
Insert Records into table
Query Database Table

Reviews

Kirstin
November 4, 2023
This course is very out of date which is unfortunate. It is 2023 and the course refers to 2019 software. The CouchDB now works differently then in 2019. Glad I did not pay full price or I would be upset.

Coupons

DateDiscountStatus
12/28/2020100% OFF
expired

Charts

Price

Creating and Querying Databases with NoSQL and SQL - Price chart

Rating

Creating and Querying Databases with NoSQL and SQL - Ratings chart

Enrollment distribution

Creating and Querying Databases with NoSQL and SQL - Distribution chart
3313416
udemy ID
7/8/2020
course created date
7/14/2020
course indexed date
Bot
course submited by