SQL For Beginners: Introduction to SQL Vs. NoSQL

Focused View

Charles Smith

1:45:35

120 View

1. Introduction to SQL Vs. NoSQL

1.1 Types of SQL Commands.html

1. Prerequisiutes.html

2.1 SQL Injection Introduction For Beginners.html

2.2 Types of SQL Commands.html

2. Introduction to SQL Vs. NoSQL.mp4

01:27

3. What well use in this course.html

2. The Importance of Trade-offs

1. The Importance of Trade-offs.mp4

01:35

2. Career Usage.html

3. History of SQL vs NoSQL

1.1 SQL Injection Introduction For Beginners.html

1.2 Types of SQL Commands.html

1. History of SQL vs NoSQL.mp4

02:09

2.1 Types of SQL Commands.html

2. History of SQL vs NoSQL Overview.html

4. Pitfalls of Denormalized Data

1. Pitfalls of Denormalized Data.mp4

02:36

2. Denormalized data exhibits many issues.html

5. First Normal Form

1. First Normal Form.mp4

01:38

2. Going from denormalized to First Normal Form 1NF.html

3. First Normal Form Same Data Type in a Column.mp4

01:02

4. First Normal Form Single Value in a Cell.mp4

02:44

5. To keep a single value in a cell, you might need to do two things.html

6. First Normal Form No Repeating Columns.mp4

02:05

7. First Normal Form Identifying A Row.mp4

03:41

8. Candidate Key Vs Primary Key.html

6. Second Normal Form

1. Second Normal Form Dependencies & Primary Keys.mp4

04:54

2. Second Normal Form Recipe.html

3. Second Normal Form Eliminating Partial Dependencies.mp4

04:06

4. Converting From First Normal Form To Second Normal Form.html

7. Third Normal Form

1. Third Normal Form.mp4

05:02

2. Recipe for Third Normal Form.html

3. Third Normal Form Eliminating transitive dependecies.mp4

03:26

4. Before and after converting from Second Normal Form to Third Normal Form.html

5. Valid Repetition.mp4

08:36

6. Valid Repetition Overview.html

8. Data Definition Language (DDL)

1. Creating Tables.mp4

02:08

2. A few things to note.html

3. Demo Create Table.mp4

04:53

4. Numeric Data Types.mp4

01:16

5. Numeric Data Types Overview.html

6. Numeric Data Types Integers.mp4

03:26

7. Demo Integers.mp4

02:31

8. Demo Integers Part 2.mp4

01:57

9. Numeric Data Types Decimals.mp4

04:57

10. Demo Decimals.mp4

04:35

11. Demo Decimals Part 2.mp4

02:51

12. Text Data Types.mp4

04:15

13. Demo Text Data Types.mp4

04:37

14. Demo Text Data Types Part 2.mp4

03:02

15. DateTime Data Types.mp4

01:59

16. Modifying Table Structure with ALTER TABLE.mp4

02:01

17. Other DDL Commands.mp4

02:00

9. Data Manipulation Language (DML)

1. Inserting Data Form One.mp4

04:36

2. Inserting Data Form Two.mp4

03:26

3. Updating Data in Postgres.mp4

01:42

4. Deleting Data in Postgres.mp4

01:07

5. Data Manipulation Transactions.mp4

01:07

6. Data Manipulation Transactions Part 2.mp4

02:08

Description

SQL For Beginners: SQL Vs. NoSQL

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

Who is this for?

Data Engineers

Database Engineers

DataOps Engineers

Data Analysts

DevOps Engineers

Data Architects

Data Visualization Engineers

System Engineers

Solution Architects

Penetration Testers

Ethical Hackers

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Charles Smith

Instructor's Courses

Charles Smith, DevSecOps Engineer, Cyber Coastal- AWS Certified Solutions Architect- AWS Certified DevOps Engineer- AWS Certified Machine Learning Specialist- AWS Certified Security Specialist- AWS Certified Advanced Networking Specialist- AWS Certified Big Data Specialist- Cisco Certified Network Professional- Cisco Certified Network Professional, Security- Palo Alto Networks Certified Security Engineer- Juniper Networks Certified Professional, Security- Juniper Networks DevOps & Automation Specialist- CompTIA Advanced Security Practitioner- CompTIA Cybersecurity Analyst

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.