Introduction to Oracle SQL – Ben Brumm

Learn how to use Oracle SQL AND get a Certification of Completion when you finish.This course will teach you the basics of the SQL language on an Oracle database.It uses video lectures, covering database topics such as:Setting up your Oracle environmentBasic terminologyReading data using a SELECT statementWhat can be done using a SELECT statementFunctionsData typesJoins, set operators, subqueriesInserting, updating and deleting dataCreating tablesThe course materials run for approximately 4 hours and are split into multiple sessions.It’s structured into various sessions and lectures, grouped by functional areas to make it easier to lean.Why should you take this course?You can go from absolute beginner to capable of writing SQL statements in a matter of hours, without paying thousands of dollars for training. You can also study in your own time!Course CurriculumIntroduction and SetupIntroduction (2:09)Tools and Concepts (7:40)Oracle Client Download (1:46)Oracle Client Install (1:24)How To Install Oracle On A MacJava JDK Download (1:11)Java JDK Install (1:20)SQL Developer Download (2:47)SQL Developer Setup (2:16)SQL Developer Connection Setup (1:12)Viewing DataViewing Data – SELECT statement (Part 1) (2:53)SQL Developer – Create New User (2:36)SQL Developer – Create and Populate Tables (3:27)Viewing Data – SELECT statement (Part 2) (5:04)Viewing Data – Operators, DISTINCT and NULL (13:24)SQL Data Types (5:21)Viewing Data – Restricting and Sorting (Part 1) (13:19)Viewing Data – Restricting and Sorting (Part 2) (10:24)FunctionsFunctions – Strings (11:22)Functions – Numbers (6:14)Working with Dates and Times (5:29)Functions – Dates (4:25)Functions – Conversion (3:43)Aggregate Functions (11:41)More SELECT ConceptsTable Aliases and Joins (16:44)Joins Part 2 (8:44)Set Operators (6:35)Translate, Decode and Case (6:41)Subqueries – Single Row (13:21)Subqueries – Multiple Row (17:14)DML – Data Manipulation LanguageDML – Insert (7:15)DML – Update (6:08)DML – Delete and TRUNCATE (4:27)ObjectsDDL – Object Types (15:48)DDL – Create Table and Constraints (20:28)DDL – Alter and Drop Table (4:50)ConclusionConclusion (1:10)Get Introduction to Oracle SQL – Ben Brumm, Only Price $35Tag: Introduction to Oracle SQL – Ben Brumm Review. Introduction to Oracle SQL – Ben Brumm download. Introduction to Oracle SQL – Ben Brumm discount.