Course ,

SQL for Beginners

SQL is the most used database query language. SQL is used in many job roles like Data Scientists, Back-End Developers, and programmers and is one of the must skills to learn.
Course
Curriculum

What will you learn?

This is a complete course for beginners and will cover all the topics required to get started. It will cover the following:

  1. Basics database and schema understanding
  2. DBMS architecture
  3. Entity relation model and relationship
  4. DDL commands – Create, Alter, Rename, Drop and Truncate
  5. DML commands – Insert, Update, Delete
  6. Data types
  7. Integrity constraints – primary key, foreign key, NOT NULL, etc.
  8. Operators
  9. Built-in functions
  10. Grouping the queries
  11. Joining the tables
  12. Subqueries
  13. Special operators
  14. TCL commands – Commit, Rollback, Savepoint
  15. Grant, Revoke, Pseudo Columns – Rowid, Rownum, currentval, nextval
  16. Views, Synonym, Sequence, Index

Pre-requisite for the Course

There is no pre-requisite for this course. We will start with the very basic and then will build steps by step on top of that.

Description

A warm welcome to this SQL course!

SQL is a mostly used database query language used to access data from the relational database. It can only work with data which is relational means stored in form of tables.

The course is hands-on specific and contains a lot of demos. You will also be getting the lab to practice immediately what you are learning in the course.

SQL is comparatively easy to learn, and you can get started with it real fast. It is very much like the English language which makes it even easier to learn.

We will be using following tools:

Server – Oracle Database Server 21C

Client – PL/SQL Developer tool

Who this course is for?

  1. Back-end developer
  2. Full-stack developer
  3. Data engineer, Data scientist and Data analyst

Course Content

Expand All
+1 enrolled
Not Enrolled
or 299₹ 2999
91% off

Course Includes

  • 7 Hours
  • 10 Lessons
  • 85 Topics
  • 00 demos
  • 10 labs
  • 10 Questions
  • 10 Exam Simulators
  • Course Certificate
Share with Friends and earn points!!

Price Based Country test mode enabled for testing United States (US). You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari