SQL Structured query language is used to work with database
SQL Structural Query Language.
What you’ll learn
- SQL.
- Database.
- Data.
- Information.
Course Content
- Introduction –> 5 lectures • 14min.
- RDBMS relational database management system –> 3 lectures • 11min.
- SQL Operators –> 1 lecture • 14min.
- SQL tools –> 4 lectures • 9min.
Requirements
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
- Orders
- Orderdetails
- Products
- 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.