Getting started with the SQL Experience

 

Week Required (highly suggested stuff)

Oracle PowerPoints

Hands on Activities 1ZO-061
Certification Questions
Week 1

What is this weird SQL Experience course? Watch me!

Sql server download, sql server install, ssms install: https://youtu.be/4deS2uo6sog

SQL Server installing pubs database (script needed: instpubs)Video: https://youtu.be/b_vAiU2eB5s

sql server install northwind video

Alternate link for pubs and northwind scripts

Script to Install HR Schema: SQL_Experience_sql_server_v1 (optional)

Creating the database: https://youtu.be/VbBL_VVpTCI

Scripts: pubs database: instpubs

northwind database: instnwnd

D64258GC11_Les01 ActivityGuide  
Week 2

Retrieving Data Using the SQL Select Statement: https://youtu.be/1hmnNnegQE0
More Basic Selects: https://youtu.be/lA00sy6o0kI

Week2Challenge - part 1

D64258GC11_Les02 ActivityGuide 1Z0-061_Selects
Week 3

3. Restricting and Sorting Data

New script to run: SQL Experience: SQL_Experience_sql_server_v1

Video 1: WHERE clause part 1https://youtu.be/K5UhTedtnic
Video 2: WHERE clause part 2: https://youtu.be/4Nvt0ZgJYL0

Video 3: Certification options.

D64258GC11_Les03

ActivityGuide 1Z0-061_Restrict_Sort
Week 4

4. Using Single-Row Functions
String Functions: https://youtu.be/DdrUakRd9QI
String Functions part 2: https://www.youtube.com/watch?v=CW2Uz2_81sk&list=PLaqXpuulgcQOC0KswZgz0wJoqgYB8-ZtR&index=15

Numeric Functions: https://youtu.be/CW2Uz2_81sk

D64258GC11_Les04 ActivityGuide 1Z0-061_SingleRowFunctions
Week 5 5. Using Conversion Functions and conditional Expressions: https://youtu.be/iWntytqr5_U D64258GC11_Les05 ActivityGuide 1Z0-061_Conversion and Conditionals
Week 6

6. Reporting Aggregated Data using the group functions https://youtu.be/7yIkng1UpZY

D64258GC11_Les06 ActivityGuide 1Z0-061_Aggregate
Week 7 7. Displaying data from multiple tables using JOINS https://youtu.be/X5Mmlkxwqvo D64258GC11_Les07 ActivityGuide 1Z0-061_Joins
Week 8

8. Using Subqueries to Solve Queries https://www.youtube.com/watch?v=IE6gNBuwZLE&list=PLaqXpuulgcQOC0KswZgz0wJoqgYB8-ZtR&index=44

9. Using the Set Operators https://youtu.be/hvW0gA1Zdh0

D64258GC11_Les08

D64258GC11_Les09

ActivityGuide 1Z0-061_Subqueries
Week 9 10. Manipulating Data D64258GC11_Les10 ActivityGuide 1Z0-061_DML
Week 10

11. Using DDL Statements to Create and Manage Tables

12. Creating Other Schema Objects

D64258GC11_Les11

D64258GC11_Les12

ActivityGuide 1Z0-061_DDL
Extra  

Table Descriptions: D64258GC11_app_a
Using SQL Developer: D64258GC11_app_b
Using SQL*Plus: D64258GC11_app_c
Using JDeveloper: D64258GC11_app_d
Oracle Join Syntax: D64258GC11_app_e

ActivityGuide  

Schemas:
These are diagrams that help us visualize the tables and how they relate to one another.

https://docs.oracle.com/cd/B28359_01/server.111/b28328/diagrams.htm

We will be using the HR schema for this course:
hr schema

Please contact me anytime with anything (comments, concerns, questions, recipes): m.fenick@snhu.edu

 

Files: D64258GC11_labs

labs:

buildtab
buildvid
dropvid
lab_10_01
lab_apcs_7a

demo:

 

soluntions:

 

Certifications:

Oracle Database 11g: SQL Fundamentals

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-051

Oracle Database 12c: SQL Fundamentals

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-061