SQL and Procedural SQL
59 resources created by 50 users
This SQL and Procedural SQL page on GoConqr gathers community-made quizzes, mind maps, flashcards, notes and slides, from SELECT statements, joins and DDL to cursors and PL/SQL. It's built for university students and professional candidates practising for exams such as Oracle 1Z0-071, and for teachers after ready-made material. There are over 260 resources here, including more than 120 quizzes, 50 mind maps and 60 flashcards. Pick a topic, try a quiz to find your gaps, then make your own set.
Top SQL and Procedural SQL resources
-
150 questionsOCA 1Z0-071 12C - Parte 2 Which statement is true about Data Manipulation Language (DML)?
-
180 questionsMidterm 2 (Chapter 5 - 13) Which of the following is a correct statement?
-
67 questionsSimulado Prova 1Z0-071: Oracle Database OCA 12c See the Exhibit and Examine the structure of the CUSTOMERS table: Using the CUSTOMERS table, you need to ge...
-
118 questions364 Practice Questions What command do you use to perform a query in SQL?
-
71 questionsOracle SQL Expert Certification - Part II dalsi otazky ze souboru
-
50 questionsAll Questions Correction question of my Oracle assessment
-
40 questionsChapter 7 (Multiple Choice CIS 3365)
-
23 questionsCorrections Correct of oracle assesment
Quizzes
See all 42 quizzes-
150 questionsOCA 1Z0-071 12C - Parte 2 Which statement is true about Data Manipulation Language (DML)?
-
180 questionsMidterm 2 (Chapter 5 - 13) Which of the following is a correct statement?
-
67 questionsSimulado Prova 1Z0-071: Oracle Database OCA 12c See the Exhibit and Examine the structure of the CUSTOMERS table: Using the CUSTOMERS table, you need to ge...
-
118 questions364 Practice Questions What command do you use to perform a query in SQL?
-
71 questionsOracle SQL Expert Certification - Part II dalsi otazky ze souboru
-
50 questionsAll Questions Correction question of my Oracle assessment
-
40 questionsChapter 7 (Multiple Choice CIS 3365)
-
23 questionsCorrections Correct of oracle assesment
Mind maps
-
MySQL -
PROTECTING ORACLE PL/SQL SOURCE CODE FROM A DBA USER -
Structured Query Language
-
SQL -
![ROUND & TRUNC [DATES]](https://images.goconqr.com/mind-map/12717561/oracle-date-round-and-trunc.webp)
ROUND & TRUNC [DATES] SQL 18c OCA - OBJ 3 : Using Single-Row Functions to Customize Output -
Single Row Functions As funções de uma linha retornam uma única linha de resultados para cada linha de uma tabela ou visualizaçã...
-
Manipulate metadata Part of the automation series
Flashcards
-
8 cardsSQL Flashcards What does SQL stand for?
-
5 cardsSQL Server What is SQL: Mean?
-
52 cardsMSSQL is probably the most used SQL command; used for retrieving rows from the database and enables the selection...
-
18 cardsIntroduction to mySQL Introduction to Structured Query Language (SQL)
-
7 cardsSQL What does an asterisk (*) do?
-
9 cardsQuery Criteria which Involve Dates This gives you the what you would enter and what would the result would be
-
3 cardsasd What is the logical query processing order of the followings clauses: SELECT, FROM, WHERE, GROUP BY, HAVING...
Notes
Slides
More Databases and data science topics
About SQL and Procedural SQL
GoConqr OriginalWhat the resources cover
The unit runs from first queries to advanced topics. Basics sit in the quiz Retrieving Data Using the SQL SELECT Statement, its matching mind map and the note Select statement. Data definition is covered by DDL Syntax, CONSTRAINTS and CHECK CONSTRAINTS mind maps. Data changes appear in Manipulating Data (Section 3), where a question tests whether TRUNCATE TABLE is valid on its own.
Further up, CHAPTER 8: ADVANCED SQL and Chapter 8 (True/False) look at joins, subqueries and set operators such as UNION, INTERSECT and MINUS. All Questions tests CUBE and GROUPING functions. For the procedural side, look at the mind map Cursor and the notes on cursors in PL/SQL.
Where to start
If SQL is new to you, begin with Introduction to SQL and the SQL Flashcards deck. Then move to SQL joins and the mind maps on joins and single-row functions. Once those feel comfortable, try Structured Query Language (SQL) (Section 1), which also touches on turning an ERD into a relational database.
Preparing for Oracle exams
Several quizzes are aimed at Oracle certification. OCA 1Z0-071 12C - Parte 2 uses exhibits, such as a PROMOTIONS table, and asks you to read a table structure before answering. Oracle SQL Expert Certification - Part II includes questions on ALTER TABLE with SET UNUSED. Older papers are here too, including a 1Z0-061 quiz and a 1Z0-047 quiz. Use 364 Practice Questions for wider practice.
Using quizzes and maps together
Take a quiz first, cold. Note the questions you miss, then open the mind map or flashcards on that topic and read them through. Retake the quiz a day later. Teachers can pull a quiz such as Chapter 7 (True/False) straight into a lesson, or use the slide sets for explanation.
Where it fits
This unit belongs to the strand SQL and Database Platforms in Databases and data science. Pick a quiz that matches your next topic and see how you get on.
Frequently asked questions
Which resource should I try first?
Start with the quiz Introduction to SQL or the SQL Flashcards deck if you are new. If you already know the basics, Retrieving Data Using the SQL SELECT Statement is a good checkpoint before you move on to joins, subqueries and the advanced quizzes.
Which Oracle exams do the resources mention?
The listed resources mention Oracle 1Z0-071, 1Z0-061 and 1Z0-047, as well as Oracle SQL certification in general. Examples include the OCA 1Z0-071 12C quiz, a 1Z0-061 quiz and a 1Z0-047 quiz with questions from a chapter on the exam.
Do the resources cover procedural SQL as well as queries?
Yes. Alongside the many SQL query quizzes, you will find a Cursor mind map, notes on cursors and record cursor FOR loops in PL/SQL, and a mind map on protecting Oracle PL/SQL source code from a DBA user. The procedural material is smaller than the query material.
Are the resources free, and who made them?
Every resource listed here is free to open, study and take, with no account needed. They were made by GoConqr users, not by GoConqr itself. A free account also saves your quiz scores and lets you create your own quizzes, mind maps, flashcards and notes.
Which database systems are included?
Most material is general SQL or Oracle SQL, but you will also find a MySQL mind map with data types, a MySQL Database Management System quiz, an MSSQL flashcard deck and an SQL Server deck. Choose the one that matches the system you are studying.
Who is this page for?
It mainly suits university students and professional candidates, for example those working through course chapters or Oracle practice papers. Teachers can use the quizzes, slide sets and notes as ready-made material, and a few resources may also help school students.