Oreilly - Oracle SQL

Oreilly - Oracle SQL

by | Released August 2015 | ISBN: 013427704X

https://www.oreilly.com/library/view/oracle-sql/9780134277042/

OverviewOracle SQL LiveLessons covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database.DescriptionIn this LiveLessons course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples.Related FilesThe companion files for this LiveLesson can be downloaded from http://www.informit.com/title/9780134275741.About the InstructorDan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com.Skill LevelBeginnerLearn How ToUse the SQL query languageInterpret business questions into SQL codeUnderstand Oracle standard SQL and ANSI SQLWork with Where clauses, sub-queries, and complex table join conditionsCreate table objects and populate these tables with dataAccess Oracle from Microsoft products such as ExcelUse analytical SQL, useful for business analystsWho Should Take This CourseStudents who are new to SQL and want to learn Oracle SQLCourse RequirementsBasic knowledge of what is a database, especially RDBMS and what is a computer programming languageAbout LiveLessons Video TrainingThe LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons. Show and hide more

Introduction
- Oracle SQL: Introduction 00:06:20
Lesson 1: Oracle SQL Course Overview
- Learning objectives 00:00:32
- 1.1 Understand the course pre-requisites 00:00:49
- 1.2 Utilize the course download 00:01:36
- 1.3 Understand the course database objects 00:01:36
- 1.4 Introduce the Database Relational Model 00:07:10
- 1.5 Introduce the Oracle Architecture 00:08:10
- Put it all together 00:00:45
Lesson 2: Introduction to the Course Tools
- Learning objectives 00:00:55
- 2.1 Work with SQL*Plus 00:05:56
- 2.2 Utilize SQL*Developer 00:05:30
- 2.3 Explore Toad 00:05:00
- Put it all together 00:01:00
Lesson 3: Introduction to SQL
- Learning objectives 00:00:16
- 3.1 Understand Simple SQL queries 00:03:41
- 3.2 Work with Where clauses 00:05:46
- 3.3 Hands-on Lab 00:06:55
- Put it all together 00:00:21
Lesson 4: Table Joins
- Learning objectives 00:00:37
- 4.1 Discover available tables/columns 00:03:15
- 4.2 Use the tools to create SQL without typing 00:09:10
- 4.3 Understand multiple table joins 00:08:09
- 4.4 Work with ANSI syntax 00:03:01
- 4.5 Use Oracle12 new ANSI join syntax 00:00:59
- 4.6 Explore sorting options 00:01:47
- 4.7 Hands-on Lab 00:04:45
- Put it all together 00:00:56
Lesson 5: Functions and Pseudocolumns
- Learning objectives 00:00:43
- 5.1 Utilize pseudocolumns 00:02:37
- 5.2 Review character/string functions 00:02:19
- 5.3 Explore date functions 00:07:28
- 5.4 Understand number functions 00:02:11
- 5.5 Work with Decode/Case/regular expressions/pattern matching functions 00:03:34
- 5.6 Work with Group By functions 00:02:34
- 5.7 Use multiple functions 00:05:47
- 5.8 Use the functions from the tools 00:02:40
- 5.9 Hands-on Lab 00:06:15
- Put it all together 00:00:54
Lesson 6: Advanced Queries Using Sub-Queries
- Learning objectives 00:00:25
- 6.1 Understand sub-queries 00:09:33
- 6.2 Work with in-line views 00:04:12
- 6.3 Utilize SQL coding tips and techniques 00:02:35
- 6.4 Hands-on Lab 00:05:05
- Put it all together 00:00:35
Lesson 7: Oracle Data Manipulation and Definition Language
- Learning objectives 00:00:40
- 7.1 Understand how to create tables 00:14:19
- 7.2 Utilize subsets of tables 00:01:24
- 7.3 Work with inserting data 00:03:57
- 7.4 Explore updating data 00:01:57
- 7.5 Utilize deleting data 00:03:59
- 7.6 Use the MERGE command 00:00:45
- 7.7 Utilize the tools to perform DML and DDL operations 00:08:49
- 7.8 Hands-on Lab 00:10:15
- Put it all together 00:00:45
Lesson 8: Database Management
- Learning objectives 00:00:26
- 8.1 Work with sequences 00:05:12
- 8.2 Understand identity columns 00:01:58
- 8.3 Explore creating views 00:03:21
- 8.4 Understand permissions 00:06:00
- 8.5 Use indexes to increase SQL performance 00:08:55
- 8.6 Introduce SQL performance tuning 00:04:05
- 8.7 Hands-on Lab 00:04:26
- Put it all together 00:00:44
Lesson 9: Data Relationships
- Learning objectives 00:00:29
- 9.1 Learn what referential integrity is 00:02:27
- 9.2 Explore your data relationships 00:01:03
- 9.3 Use entity-relationship diagrams 00:03:35
- 9.4 View related data 00:01:21
- 9.5 Save related data (useful for test data/reports) 00:01:51
- 9.6 Live Demonstration 00:06:27
- Put it all together 00:00:32
Lesson 10: Analytical SQL
- Learning objectives 00:00:31
- 10.1 Introduce analytical SQL 00:02:29
- 10.2 Use analytical functions 00:02:47
- 10.3 Explore partitioning functions 00:04:04
- 10.4 Utilize windowing functions 00:02:35
- Put it all together 00:00:55
Lesson 11: Simple Reports Using SQL*Plus
- Learning objectives 00:00:29
- 11.1 Introduce SQL*Plus formatting commands 00:08:00
- 11.2 Build simple reports 00:05:59
- 11.3 Utilize HTML reports 00:02:38
- 11.4 Explore creating pivot tables 00:04:38
- 11.5 Introduce Oracle scripting 00:14:24
- 11.6 Hands-on Lab 00:03:43
- Put it all together 00:01:11
Lesson 12: Toad and SQL Developer Reports
- Learning objectives 00:00:19
- 12.1 Use the Toad Report Writer 00:03:26
- 12.2 Explore creating reports using SQL Developer 00:03:41
- 12.3 Hands-on Lab 00:07:37
- Put it all together 00:00:18
Lesson 13: Spreadsheets and Saving the Data Using the Tools
- Learning objectives 00:00:31
- 13.1 Explore saving data/creating spreadsheets using SQL*Plus 00:03:41
- 13.2 Utilize saving data/creating spreadsheets using SQL Developer 00:01:55
- 13.3 Work with saving data/creating spreadsheets/Access databases using Toad 00:01:44
- 13.4 Hands-on Lab 00:04:53
- Put it all together 00:00:22
Lesson 14: Microsoft Office Programs with Oracle SQL
- Learning objectives 00:00:25
- 14.1 Introduce ODBC drivers 00:01:01
- 14.2 Implement Oracle connections using ODBC 00:00:50
- 14.3 Explore SQL from Excel 00:01:24
- 14.4 Understand SQL from Access 00:00:57
- Put it all together 00:00:24
Summary
- Oracle SQL: Summary 00:01:37