Goldmansachs.safaribooksonline.com

Oracle SQL LiveLessons

Subscribe to Goldmansachs.safaribooksonline.com

2015-06-25

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.The source code repository for this LiveLesson can be downloaded from <a href="http://www.informit.com/content/images/9780134275741/downloads/Oracle_SQL_LiveLessons_File_Download.zip" target="_blank">www.informit.com/title/9780134275741</a>.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 <a href="http://www.DanHotka.com" target="_blank">www.DanHotka.com</a>.About Sneak PeekSneak Peek videos are available to Safari Books Online subscribers offering early access to the very latest information on a given topic. Sneak Peek videos do not include post-production editing and may include further revisions before the video is complete.Skill Level<ul><li><div>Beginner</div></li></ul>Learn How To<ul><li><div>Use the SQL query language</div></li><li><div>Interpret business questions into SQL code</div></li><li><div>Understand Oracle standard SQL and ANSI SQL</div></li><li><div>Work with Where clauses, sub-queries, and complex table join conditions</div></li><li><div>Create table objects and populate these tables with data</div></li><li><div>Access Oracle from Microsoft products such as Excel</div></li><li><div>Use analytical SQL, useful for business analysts</div></li></ul>Who Should Take This Course<ul><li><div>Students who are new to SQL and want to learn Oracle SQL</div></li></ul>Course Requirements<ul><li><div>Basic knowledge of what is a database, especially RDBMS and what is a computer programming language</div></li></ul>Table of ContentsIntroductionLesson 1: Oracle SQL Course OverviewLearning objectives1.1 Understand the course pre-requisites1.2 Utilize the course download1.3 Understand the course database objects1.4 Introduce the Database Relational Model1.5 Introduce the Oracle ArchitecturePut it all togetherLesson 2: Introduction to the Course ToolsLearning objectives2.1 Work with SQL*Plus2.2 Utilize SQL*Developer2.3 Explore ToadPut it all togetherLesson 3: Introduction to SQLLearning objectives3.1 Understand Simple SQL queries3.2 Work with Where clauses3.3 Hands-on LabPut it all togetherLesson 4: Table JoinsLearning objectives4.1 Discover available tables/columns4.2 Use the tools to create SQL without typing4.3 Understand multiple table joins4.4 Work with ANSI syntax4.5 Use Oracle12 new ANSI join syntax4.6 Explore sorting options4.7 Hands-on LabPut it all togetherLesson 5: Functions and PseudocolumnsLearning objectives5.1 Utilize pseudocolumns5.2 Review character/string functions5.3 Explore date functions5.4 Understand number functions5.5 Work with Decode/Case/regular expressions/pattern matching functions5.6 Work with Group By functions5.7 Use multiple functions5.8 Use the functions from the tools5.9 Hands-on LabPut it all togetherLesson 6: Advanced Queries Using Sub-QueriesLearning objectives6.1 Understand sub-queries6.2 Work with in-line views6.3 Utilize SQL coding tips and techniques6.4 Hands-on LabPut it all togetherLesson 7: Oracle Data Manipulation and Definition LanguageLearning objectives7.1 Understand how to create tables7.2 Utilize subsets of tables7.3 Work with inserting data7.4 Explore updating data7.5 Utilize deleting data7.6 Use the MERGE command7.7 Utilize the tools to perform DML and DDL operations7.8 Hands-on LabPut it all togetherLesson 8: Database ManagementLearning objectives8.1 Work with sequences 
8.2 Understand identity columns8.3 Explore creating views8.4 Understand permissions8.5 Use indexes to increase SQL performance8.6 Introduce SQL performance tuning8.7 Hands-on LabPut it all togetherLesson 9: Data RelationshipsLearning objectives9.1 Learn what referential integrity is9.2 Explore your data relationships9.3 Use entity-relationship diagrams9.4 View related data9.5 Save related data (useful for test data/reports)9.6 Live DemonstrationPut it all togetherLesson 10: Analytical SQLLearning objectives10.1 Introduce analytical SQL10.2 Use analytical functions10.3 Explore partitioning functions10.4 Utilize windowing functionsPut it all togetherLesson 11: Simple Reports Using SQL*PlusLearning objectives11.1 Introduce SQL*Plus formatting commands11.2 Build simple reports11.3 Utilize HTML reports11.4 Explore creating pivot tables11.5 Introduce Oracle scripting11.6 Hands-on LabPut it all togetherLesson 12: Toad and SQL Developer ReportsLearning objectives12.1 Use the Toad Report Writer12.2 Explore creating reports using SQL Developer12.3 Hands-on LabPut it all togetherLesson 13: Spreadsheets and Saving the Data Using the ToolsLearning objectives13.1 Explore saving data/creating spreadsheets using SQL*Plus13.2 Utilize saving data/creating spreadsheets using SQL Developer13.3 Work with saving data/creating spreadsheets/Access databases using Toad13.4 Hands-on LabPut it all togetherLesson 14: Microsoft Office Programs with Oracle SQLLearning objectives14.1 Introduce ODBC drivers14.2 Implement Oracle connections using ODBC14.3 Explore SQL from Excel14.4 Understand SQL from AccessPut it all togetherSummaryAbout 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: <a href="http://www.informit.com/livelessons" target="_blank">http://www.informit.com/livelessons</a>.