Welcome to Qurosity’s learn SQL series which will walk you through everything from learning the basics to becoming a SQL Pro!
SQL is one of the most in demand skills today as each and everything runs on data which is stored in database. SQL is used to read and query this data using SQL queries.
This series is divided in sections where we start from absolute basics and then gradually move towards understanding more complex topics.
By the end of this you will be able to work effortlessly with Oracle databases in the data-driven fields like data analysis, business intelligence, data science etc.
Section 1: Getting Started with Oracle
1.1 What is a Database? Introduction to Oracle SQL and MySQL
1.2 Install Oracle
1.3 Install SQL Developer
1.4 Create a New User and Connection
1.5 Operator Precedence
Section 2: Retrieve Data From Tables
2.1 Select (Selection, Projection, Operators, and Operator Precedence)
2.2 Select Distinct
2.3 Oracle Dual Table
2.4 WHERE
2.5 AND
2.6 OR
2.7 BETWEEN
2.8 IN
2.9 LIKE
2.10 IS NULL
2.11 ORDER BY
2.12 Table and Column Alias
2.13 DESC
Section 3: Single Row Functions
Case Manipulation Functions
3.1 LOWER
3.2 UPPER
3.3 INITCAP
Character Manipulation Functions
3.4 CONCAT
3.5 SUBSTR
3.6 LENGTH
3.7 INSTR
3.8 LPAD
3.9 RPAD
3.10 REPLACE
Number Functions
3.11 ROUND
3.12 TRUNC
3.13 MOD
Conversion Function ( Auto, TO DATE, TO CHAR)
Other Single Row Functions
3.16 NVL
3.17 NVL2
3.18 NULLIF
3.19 COALESCE
3.20 CASE
3.21 DECODE
Section 4: Group Functions
4.1 AVG
4.2 MAX
4.3 MIN
4.4 SUM
4.5 STDDEV
4.6 VARIANCE
4.7 COUNT
4.8 GROUP BY
4.9 HAVING
Section 5 : JOINS
5.1 Oracle Joins
5.2 Inner Join
5.3 Left Join
5.4 Right Join
5.5 Full Outer Join
5.6 Cross Join
5.7 Self Join
Section 6: DML Statements and Transactions in Oracle
6.1 Basics of Session and Transaction
6.2 INSERT Statement in Oracle
6.3 UPDATE Statement in Oracle
6.4 DELETE Statement in Oracle
Section 7: Data Definition Language(DDL) Statements
7.1 CREATE TABLE
7.2 ALTER TABLE
7.3 DROP TABLE
7.4 TRUNCATE TABLE
7.5 RENAME TABLE
7.6 ALTER TABLE MODIFY Column
7.7 ALTER TABLE ADD Column
Section 8: Constraints
8.1 Introduction to Constraints
8.2 PRIMARY KEY
8.3 UNIQUE KEY
8.4 FOREIGN KEY
8.5 NOT NULL
8.6 CHECK
Section 9: Views
9.1 Views in Oracle
9.2 Updatable Views
9.3 Inline Views
Section 10: Set Operators
10.1 UNION
10.2 INTERSECT
10.3 MINUS
Section 11: Sequences
Section 12: Subqueries
12.1 Subquery
12.2 Correlated Subquery
Section 13: Synonyms and Indexes
13.1 Simple Index
13.2 Data Dictionary for Indexes
13.3 Compound Index
13.4 Expression Based Index
13.5 Function Based Index
13.6 Unique Index
13.7 Bitmap Index