Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Database Programming

Creating and Querying Databases with NoSQL and SQL

Create and interact with databases using NoSQL and SQL
Rating: 4.5 out of 54.5 (7 ratings)
4,427 students
Created by Bluelime Learning Solutions
Last updated 7/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

Course content

2 sections • 22 lectures • 1h 53m total length

  • Preview01:10
  • Preview03:34
  • Preview03:49
  • Categories of NoSQL Databases
    06:50
  • Downloading and Installing CouchDB
    05:26
  • Creating a database and storing Data
    08:38
  • Nesting Data
    07:38
  • Retrieving data
    03:39
  • Querying Data
    06:46
  • Defining Views
    05:05
  • Filtering Data with Reduce Function
    07:58

  • What is SQL
    03:38
  • What is T-SQL
    01:54
  • What is SQL Server
    02:57
  • Download SQL Server
    04:31
  • Install SQL Server
    09:43
  • Install SSMS
    05:48
  • Connecting to SQL Server
    02:16
  • Create a database
    03:20
  • Create a table
    06:27
  • Insert Records into table
    06:00
  • Query Database Table
    06:48

Requirements

  • Internet Access Required

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 CouchDB 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 couchDB 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.


Who this course is for:

  • Beginners to NoSQL Databases
  • Beginners to SQL

Instructor

Bluelime Learning Solutions
Learning made simple
Bluelime Learning Solutions
  • 4.2 Instructor Rating
  • 17,430 Reviews
  • 406,247 Students
  • 221 Courses

Bluelime is UK based and creates quality easy to understand  eLearning  solutions .All our courses are 100% video based. We teach hands –on- examples  that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.