SQL and Procedural SQL notes
27 notes by 22 users
This GoConqr page gathers SQL and Procedural SQL notes, from SELECT queries and joins to functions and cursors. Its over 10 community-made notes are for university students and professional candidates practising SQL, and teachers looking for study material. Pick a note to begin.
Notes
-
Select statement Capabilities SQL statement Projection: Select the columns in a table that a returned by a query Selection: Select the rows in a table that are returned by a query Join: Bring together data that is stored in different ...
-
Untitled Analytic Functions: Databases for Developers An introduction to analytic functions. Execute Prerequisite SQL Modules Introduction Partition By Try it! Order By Try it! Partition By + Order By Windowing Clause Sl...
-
DBMS Code
-
Untitled DBMS Commands: 1.Data Definition Language(DDL): 2.Data Manipulation Language(DML): 3.Data Control Language(DCL): 4.Transaction Control Language(TCL): DDL Commands for Tables: 1.Create table : creat...
-
4. Let's Learn About SQL! 4. Let's Learn About SQL! Searching for data using a SELECT statement If specifies which column from which table (FROM) and matching which conditions (WHERE) Creat...
-
SQL Aggregate and Scalar Functions
-
sql SQL3DDL -Data Definition LanguageCommandDescriptionCREATECreates a new table, a view of a table, or other object in the database.ALTERModifies an existing database object, such as a table.DROPDeletes an entire table, ...
-
SQL- Relational Databases SQL- Relational Databases Joining the tables • When we use SQL to query related tables, we first need to list all tables that we are using in the FROM section • We also have to include details of how the two tables ar...
-
Untitled
-
Identify proper SELECT query structure Logical Processing Order of the SELECT statement The following steps show the logical processing order, or binding order, for a SELECT statement. This order determines when the objects defined in one step are made ava...
-
SQL- Edit SQL – Edit Using SQL to change data on a database • We need the keywords ‘UPDATE’, ‘SET’ and ‘WHERE’ UPDATE TableName SET field1=value, field2=value… WHERE fieldX=value Example • Using the PetsAndOwners database: • We...
-
Untitled
-
date- 23 feb
-
SQL VIEWS: To make complex query into simple. insert update delete can happen in base table WITH READ ONLY INSERT operation if u handle with check option.if where clause have not null..insert never allows null value...
-
Note FOR JOINS INNER VS OUTER JOIN WE have to tables " Product table " And "Category Table"We want To make Joins Between ThemBut Their Is many Diffrents ways To join :JOINRIGHT OUTER JOINLEFT OUTER JOIN-------AS you see prd and cty ...
-
cursor-plsql
-
SQL
-
cursor and record_cursor for loop_passing cursor btw procedures and function
-
Untitled ...
-
SQL Fundamentals
-
Untitled
-
Outer Joins Definition Outer joins give all data from 1 table and common data from other table. Types
-
Capítulo 11 - Utilizando Declarações DDL para Criar e Gerenciar Tabelas 1 - D OK 2 - A OK 3 - D, E OK 4 - A, C OK 5 - A, C, D, E, F OK 6 - D OK 7 - D OK 8 - C OK 9 - C ERRADO 10 - C, D OK 11 - E ERRADO
-
Capítulo 8 - Utilizando subconsultas para resolver problemas 1 - A, B, C, E, F ERRADO 2 - D OK 3 - A OK 4 - D OK 5 - A, D OK 6 - A, B OK 7 - E OK 8 - C OK 9 - A, B OK 10 - C OK
-
Basic SQL commands SELECT- Choose which columns to display FROM- Choose which table(s) to access data from WHERE- Condition(s)
-
Untitled CREATE DATABASE cadastro; CREATE TABLE pessoas ( nome varchar(30), idade tinyint(3) );
-
Untitled What is the difference between an equi join and inner join? An equi join Retrieve all the columns form both the table
More SQL and Procedural SQL resources
About sql and procedural sql notes
GoConqr OriginalUsing SQL and Procedural SQL notes
Start with Select statement for an introduction to choosing columns and rows and bringing data from tables together. For a closer look at query structure, Identify proper SELECT query structure describes the logical processing order of a SELECT statement.
The notes also cover other parts of SQL. SQL Aggregate and Scalar Functions includes examples of functions such as AVG and COUNT. DBMS Code shows a table definition using a default value, while the notes on PL/SQL cursors include cursor attributes and examples.
Revise with notes
Read a note alongside a query and trace what each part does. Then try writing a similar query without looking at the example. If you want to check your understanding, switch to a quiz on the unit page; a mind map can help you review how topics connect.
Choose a note and work through an example.
Frequently asked questions
Which note is a good place to start?
Start with Select statement if you want to review how a query chooses columns and rows and brings data from tables together. For more detail on the order in which a SELECT statement is processed, the note on proper SELECT query structure is a useful next read.
What topics do these notes cover?
The notes cover SELECT queries, joins, aggregate functions and changes to data. DBMS Code includes a table definition with a default value. There are also notes on PL/SQL cursors, including cursor attributes and examples, for readers working on the procedural side of the unit.
Are the notes free to use?
Yes. Every note listed here is free to open and study without an account. The resources were made by GoConqr users, so you can compare different notes on a topic, such as SELECT queries, to find an explanation that suits your study or teaching.