SQL For Beginners: Introduction to SQL Vs. NoSQL

SQL For Beginners: Introduction to SQL Vs. NoSQL

SQL For Beginners: Introduction to SQL Vs. NoSQL

SQL For Beginners: SQL Vs. NoSQL

Language: english

Note: 0/5 (0 notes) 586 students  New course 

Instructor(s): Charles Smith

Last update: None

What you’ll learn

  • Create normalized data schemas by following the rules of “normal forms”
  • Bring these schemas to life in a relational database using the SQL Data Definition Language
  • Add and manipulate data in these schemas using the SQL Data Manipulation Language
  • Enable business rules at the level of the database using constraints
  • Keep your relational database running quickly and efficiently despite storing and querying large amounts of data
  • Use two non-relational databases, MongoDB and Redis

 

Requirements

  • To successfully undertake this course, you’ll need — in addition to general computer knowledge — to be familiar with SQL

 

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.


Who this course is for:

  • Beginners to NoSQL Databases

  • Beginners to SQL

 

Who this course is for

  • Data Engineers
  • Database Engineers
  • DataOps Engineers
  • Data Analysts
  • DevOps Engineers
  • Data Architects
  • Data Visualization Engineers
  • System Engineers
  • Solution Architects
  • Penetration Testers
  • Ethical Hackers

 

Course content

  • Introduction to SQL Vs. NoSQL
    • Prerequisiutes
    • Introduction to SQL Vs. NoSQL
    • What we’ll use in this course
  • The Importance of Trade-offs
    • The Importance of Trade-offs
    • Career Usage
  • History of “SQL vs NoSQL”
    • History of “SQL vs NoSQL”
    • History of “SQL vs NoSQL” Overview
  • Pitfalls of Denormalized Data
    • Pitfalls of Denormalized Data
    • Denormalized data exhibits many issues
  • First Normal Form
    • First Normal Form
    • Going from denormalized to First Normal Form — 1NF
    • First Normal Form: Same Data Type in a Column
    • First Normal Form: Single Value in a Cell
    • To keep a single value in a cell, you might need to do two things
    • First Normal Form: No Repeating Columns
    • First Normal Form: Identifying A Row
    • Candidate Key Vs Primary Key
  • Second Normal Form
    • Second Normal Form: Dependencies & Primary Keys
    • Second Normal Form Recipe
    • Second Normal Form: Eliminating Partial Dependencies
    • Converting From First Normal Form To Second Normal Form
  • Third Normal Form
    • Third Normal Form
    • Recipe for Third Normal Form
    • Third Normal Form: Eliminating transitive dependecies
    • Before and after converting from Second Normal Form to Third Normal Form
    • Valid Repetition
    • Valid Repetition Overview
  • Data Definition Language (DDL)
    • Creating Tables
    • A few things to note
    • Demo: Create Table
    • Numeric Data Types
    • Numeric Data Types Overview
    • Numeric Data Types: Integers
    • Demo: Integers
    • Demo: Integers Part 2
    • Numeric Data Types: Decimals
    • Demo: Decimals
    • Demo: Decimals Part 2
    • Text Data Types
    • Demo: Text Data Types
    • Demo: Text Data Types Part 2
    • Date/Time Data Types
    • Modifying Table Structure with ALTER TABLE
    • Other DDL Commands
  • Data Manipulation Language (DML)
    • Inserting Data: Form One
    • Inserting Data: Form Two
    • Updating Data in Postgres
    • Deleting Data in Postgres
    • Data Manipulation: Transactions
    • Data Manipulation: Transactions Part 2

 

SQL For Beginners: Introduction to SQL Vs. NoSQL

Google Data Analytics [Coursera]

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate