Construct, Query & Retrieve Data from the Database
From database design to querying a database, there is only one universal language - SQL. This course is designed for absolute beginners who have never interacted with database. Each lecture is carefully crafted to make you speak with Oracle database smoothly. Writing efficient queries and retrieving data from the database tables is fun in itself.
What you will learn
- Database design, modeling and data normalization
- Query from single and multiple tables with filters
- Join multiple tables to retrieve common data
- Group, Sort, Filter, Merge, Select and query Oracle database
Course Contents
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- SQL Operators Precedence rule (4:51)
- Precedence rule example 1 (5:24)
- Precedence rule example 2 (4:09)
- Column Alias in Oracle (5:42)
- Table Alias in Oracle (2:53)
- ORDER BY clause - sorting data (6:30)
- ORDER BY clause example 1 (1:31)
- Ampersand substitution (7:25)
- Ampersand substitution example 1 (3:57)
- Double Ampersand substitution (5:37)
- Oracle DUAL table (3:31)
Available in
days
days
after you enroll
- Single Row Functions (2:32)
- Character functions (16:29)
- Numeric functions (6:15)
- Date functions (10:56)
- Group Functions (5:34)
- AVG function (0:59)
- COUNT function (2:17)
- MINIMUM and MAXIMUM functions (3:09)
- SUM function (0:38)
- GROUP BY clause (7:12)
- HAVING clause (5:06)
- Data type conversion functions
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- Introduction to SQL join (3:24)
- Types of SQL join (7:54)
- SQL joins article link (1:06)
- Join syntax (3:26)
- INNER join and NATURAL join (5:21)
- LEFT OUTER join and RIGHT OUTER join (9:51)
- FULL OUTER join (0:42)
- CARTESIAN join or CROSS join (0:51)
- INNER join and NATURAL join - lab practice (12:58)
- LEFT OUTER join - lab practice (6:11)
- RIGHT OUTER join - lab practice (5:53)
- FULL OUTER join - lab practice (2:13)
- CARTESIAN join or CROSS join - lab practice (1:14)
- LEFT and RIGHT OUTER join - Traditional join method (1:51)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- Table level constraints (10:07)
- CREATE table (8:59)
- CREATE table - lab practice (6:20)
- ALTER table (6:25)
- DROP and TRUNCATE table (3:28)
- RENAME table (0:28)
- COMMENT on table and column (3:56)
- CREATE table with constraints (14:24)
- Testing table constraints (7:55)
- Add table constraint using ALTER table command (2:25)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Meet Your Instructor!
Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.
Apart from database, I love swimming, filming and business automation!