1Z0-171: Oracle Database 23ai SQL Associate
- Descrição
- Currículo
- FAQ
- Revisões
This course is the foundation for the Oracle Database SQL 1Z0-171 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access.
Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle.
-
We’ll install for free Oracle Express Edition and Oracle SQL Developer. Then we’ll take a look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
-
Then we’ll start creating tables, but find that we can’t get very far without understanding data types. We’ll then look at string, date and number types and functions, together with looking at functions converting between them.
-
We’ll revisit the SELECT statement and go into more detail. We’ll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.
-
We’ll then looking for missing data, and find out how to delete and update data. We’ll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.
-
We’ll start off by saving our queries in views. Then we’ll combine tables, not by adding additional columns using JOINS, but adding additional rows such Oracle SQL set operators such as UNION, INTERSECT and MERGE.
-
We’ll add totals to our SELECT queries. We’ll then look at subqueries, and how you can add them into the FROM, SELECT and WHERE clauses, and also into the WITH clause. We’ll also look at Oracle SQL self-joins, which are useful when you have hierarchies.
-
Finally, TIME ZONE and INTERVAL data types and functions. We’ll then have a look at SEQUENCEs and INDEXes, together with how these are shown in the Data Dictionary. We’ll then create new users, and assign privileges and roles to them, and we’ll finish with the last few requirements for the exam.
No prior knowledge is required – we’ll even install Oracle Database and Oracle SQL Developer on your computer for free!
Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in Oracle SQL.
-
105. The SELECT and FROM clausesVídeo Aula
-
114. Renaming fields (using column aliases), including using the AS keywordVídeo Aula
-
125. Semicolons and commentsVídeo Aula
-
135, 9. The WHERE clauseVídeo Aula
-
145, 6d. The GROUP BY clause and the DISTINCT keywordVídeo Aula
-
155, 21. The HAVING clause, and information about error messages.Vídeo Aula
-
1613a, 13c. The ORDER BY clauseVídeo Aula
-
17Remembering the order of the clausesVídeo Aula
-
18Practice Activity Number 1Texto
-
19Practice Activity Number 1 - The SolutionVídeo Aula
-
257, 8. Using the DUAL table, and rules of precedence for arithmetic expressionsVídeo Aula
-
26Practice Activity Number 3 - Writing mathematical queriesTexto
-
27Practice Activity Number 3 - The SolutionVídeo Aula
-
2840. Creating sample table; Run Script v Run StatementVídeo Aula
-
2941. The NUMBER data typeVídeo Aula
-
30Do you want to use the comma as a decimal point?Vídeo Aula
-
318a. FLOATing data typesVídeo Aula
-
32Practice Activity Number 4Texto
-
33Practice Activity Number 4 - The SolutionVídeo Aula
-
386. Using CHAR and VCHAR with concatenation operator, literal character stringsVídeo Aula
-
39NCHAR and NVARCHAR Character Data TypesVídeo Aula
-
4013. String FunctionsVídeo Aula
-
417b. NULL - an introductionVídeo Aula
-
427b, 17. Useful NULL functionsVídeo Aula
-
43Practice Activity Number 5Texto
-
44Practice Activity Number 5 - The SolutionVídeo Aula
-
4518. Joining a string to a number using implicit conversionsVídeo Aula
-
4619a, 20. Converting a number to a string - Part 1Vídeo Aula
-
4719a. Converting a number to a string - Part 2Vídeo Aula
-
4819b. Converting a string to a number, including the CAST functionVídeo Aula
-
495a, 14b. International conversionsVídeo Aula
-
50Practice Activity Number 6Texto
-
51Practice Activity Number 6 - The SolutionVídeo Aula
-
52DATE and TIMESTAMP() data typesVídeo Aula
-
5314, 16. Date extraction functionsVídeo Aula
-
5419a. Converting dates to stringsVídeo Aula
-
5519a. Converting times to stringsVídeo Aula
-
5619c. Converting strings to timestamps using the TO_DATE conversion functionVídeo Aula
-
57Practice Activity Number 7Texto
-
58Practice Activity Number 7 - The SolutionVídeo Aula
-
6440, 41. Practice Activity Number 8 - Creating TablesTexto
-
6540, 41. Practice Activity Number 8 - The SolutionVídeo Aula
-
66Populating the Practice Activity tablesTexto
-
67Populating the Practice Activity tables - The SolutionVídeo Aula
-
68Practice Activity Number 9Texto
-
69Practice Activity Number 9 - The SolutionVídeo Aula
-
705. Summarising and ordering dataVídeo Aula
-
715, 21. Revising all 6 clauses, including adding Criteria on summarised dataVídeo Aula
-
72Practice Activity 10Texto
-
73Practice Activity 10 - The SolutionVídeo Aula
-
7412. More about COUNT, and using ORDER BY NULLS FIRST/LASTVídeo Aula
-
75Practice Activity Number 11Texto
-
76Practice Activity Number 11 - The SolutionVídeo Aula
-
77Adding a second tableVídeo Aula
-
782. Importing data and showing tables graphicallyVídeo Aula
-
79Writing a JOIN queryVídeo Aula
-
8024, 26, 27. Different types of JOINVídeo Aula
-
8124, 26. Using NATURAL JOINsVídeo Aula
-
8224, 26. Old notation joinsVídeo Aula
-
83Practice Activity Number 12Texto
-
84Practice Activity Number 12 - The SolutionVídeo Aula
