SQL Principles: An Essential Guide for Beginners

Description

SQL Structural Query Language.

RDBMS relational database management system.

• Interact with databases using SQL.

• Common day database Microsoft Access, Microsoft SQL Server, Oracle, MySQL.

• Get results from database. SELECT 

• Filter results from database. WHERE

• Sort data/results from database. ORDER BY

• Group data/results from database. GROUP BY

• HAVING

RDBMS. TABLES. ROWS. COLUMNS

Table examples

1. Orders

2. Orderdetails

3. Products

4. Customers

In this class, we assume that the database already exist and we are interacting with the database using the SQL.

We will see how to select records, filter records, group records, sort records from the database.

If you like to program and have interest in database then this course will guide you to utilize it.

Learning this could you could apply these skills as Data Science, Database Developer.

Database design and development is how you create databases vs. SQL is how you interact with database.

If you are a Marketing professional and would like to get your reports from a system then this course will help you how to do that...

SQL allows you slice and dice the data in different shape or form.

You can create dashboards, charts graphs using the SQL as the foundation.

good luck learning and hope you enjoy the course.

Who this course is for:

• Beginner