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 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 |
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 3: Certification options. |
ActivityGuide | 1Z0-061_Restrict_Sort | |
Week 4 | 4. Using Single-Row Functions 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 |
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 |
ActivityGuide | 1Z0-061_DDL | |
Extra | Table Descriptions: D64258GC11_app_a |
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:
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
Oracle Database 12c: SQL Fundamentals