SQL and NoSQL Fundamentals

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

SQL and NoSQL Fundamentals

BD-105

SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others.
The sheer volume and complexity of data is overwhelming traditional database software and is demanding a new approach to data analysis that can deal with Big Data. The shift to a new method for storing data empowers the rise of the NoSQL ecosystem with numerous software offerings appearing under the NoSQL umbrella.

This course starts from the basics of databases and SQL, teaches the technical skills required to write basic SQL queries. The second part of the course deals with Big Data and NoSQL. Unstructured data that traditional RDBMS database solutions can not handle. The course teaches the concepts of NoSQL through the MongoDB perspective.

Audience

Target Audience:
This course is intended for System Adminis, IT professionals, DBAs, and individuals who wish to learn the basics of SQL and NoSQL.

Prerequisites:
Participants should be experienced with Windows OS and be familiar with any programming language.

Course Topics

Part 1 – SQL Fundamentals

Module 1 – Introduction to SQL

  • A Brief History of Databases
  • Structured Query Language (SQL)
  • Database Creation
  • Creating, Altering, and Deleting Tables
  • Good Database Design
  • Creating the Example Database
  • Summary
  • Exercises

Module 2 – Entering Information

  • Inserting New Data
  • Inserting Data into the Case Study Database
  • Updating Data
  • Deleting Data
  • Summary
  • Exercises

Module 3 – Extracting Information

  • The SELECT Statement
  • Logical Operators and Operator Precedence
  • Ordering Results with ORDER BY
  • Selecting Data from More Than One Table
  • Introducing NULL Data
  • Summary
  • Exercises

Module 4 – Manipulating Data

  • Understanding SQL Arithmetic
  • Introducing String Functions
  • Converting Different Data Types
  • Re-examining NULL
  • Using INSERT INTO with the SELECT Statement
  • Summary
  • Exercises

Module 5 – Grouping and Aggregating Data

  • Grouping Results
  • Summarizing and Aggregating Data
  • Using the HAVING Clause with GROUP BY Statements
  • Summary
  • Exercises

Module 6 – Selecting Data from Different Tables

  • Joins Revisited
  • Combining Results Sets with the UNION Operator
  • Summary
  • Exercises

Module 7 – Queries within Queries

  • Subquery Terminology
  • Subqueries in a SELECT List
  • Subqueries in the WHERE Clause
  • Operators in Subqueries
  • Correlated Subquery
  • Subqueries Used with Other Statements
  • Summary
  • Exercises

Part 2 – NoSQL Fundamentals

Module 8 – Introducing NoSQL and MongoDB

  • What Is NoSQL?
  • Choosing RDBMS, NoSQL, or Both
  • Understanding MongoDB
  • MongoDB Data Types
  • Planning Your Data Model
  • Summary
  • Exercises

Module 9 – Installing and Configuring MongoDB

  • Building the MongoDB Environment
  • Accessing the MongoDB HTTP Interface
  • Accessing MongoDB from the Shell Client
  • Scripting the MongoDB Shell
  • Summary
  • Exercises
© Copyright - Skilit - Site by Dweb