categories: Technology, Science & Productivity
Level: General
Course Language: English
What's meant by a database, how it works, the different database types and differences between them, and what is the importance of the database.
Exploring the Relational Database Management Systems (RDMS), coding SQL, categorizing SQL commands into groups, and exploring what commands each category contains.
Creating a database from scratch with tables and users, controlling database users' privileges. Then, inserting, updating, deleting, and retrieving data from a table.
Free lessons
Course Introduction
Introduction to Database
Relational VS Non-Relational Databases
Relational Database Management Systems (RDBMS)
1. Getting Started
Course Introduction
Introduction to Database
Relational VS Non-Relational Databases
Relational Database Management Systems (RDBMS)
Introduction to SQL
2. Necessary Software (Download/Installation)
Important Note
PostgreSQL Download and Installation
How to Initiate PostgreSQL in Command Prompt
Ubuntu Download and Installation
PostgreSQL Package in Ubuntu
3. SQL | Data Definition Language
Create Database
Create table
Create User
SQL Constraints
Data Types in PostgreSQL
Practice Test 1
DROP
Drop User
TRUNCATE
ALTER
4. SQL | Data Control Language
GRANT
REVOKE
Practice Test 2
5. SQL | Data Manipulation Language
INSERT
DELETE
DROP - TRUNCATE - DELETE Summary
UPDATE
SELECT
Practice Test 3
ALIAS
Operators
Comparison Operators
Aggregate Functions
DISTINCT
LIMIT
GROUP BY and HAVING
JOINS INTUITION
INNER JOIN
OUTER JOIN (Left, Right and Full)
CREATE VIEW
Data analysis requires working with a large amount of data and performing manipulation on it. If you are interested in data science and want to pursue a career in it, SQL is listed as one of the most in-demand skills in the skill set for data analyst roles, it is an easy-to-learn and robust programming language. Therefore, this course was prepared to help you learn more about SQL coding, its principles from the beginning, how it works, and its different types.
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Data Analyst
1,929 Learners
2 Course