تبلیغات

آموزش پایگاه داده اوراکل 12c - مبانی SQL

دسته بندی ها: پایگاه داده ، آموزش های لیندا (Lynda) ، آموزش اس کیوال (SQL) ، آموزش اوراکل (Oracle)
آیا این نوشته را دوست داشتید؟
Oracle Database 12c: Basic SQL Publisher:Lynda Author:David Yahalom Duration:3h 12m Level:Beginner

Learn how to use SQL in an Oracle Database 12c environment. This beginner-level course shows how to query, select, filter, join, and manipulate Oracle data using SQL statements.
Released: 1/17/2018

Mastering the SQL language is an essential skill for any Oracle professional and is the first step in becoming a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, Oracle instructor and consultant David Yahalom covers the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions. David also provides an overview of advanced concepts, such as constraints and subqueries.

Note: This training course is appropriate for beginning database developers with no prior experience with SQL or Oracle.

Topics include:
Using Oracle SQL*Developer, the free development environment
Selecting data from tables
Filtering data
Using functions to manipulate data
Joining data from tables
Creating tables
Updating values
Truncating data
Grouping and ordering result sets
Working with primary keys
Checking constraints

Introduction
Welcome
1m 37s
What you need to know
1m
1. Introduction to SQL
What is SQL?
2m 30s
Database tables
2m 21s
Overview of table data types
4m 21s
SQL query structure
4m 38s
2. Preparing the Course Environment
Downloading the course VM
2m 16s
3. Using Oracle SQL Developer
Introduction to Oracle SQL Developer
1m 45s
Creating a connection to the database
4m 53s
Managing existing connections
50s
Exploring database objects
1m 29s
Filtering specific objects
1m 25s
Using SQL Developer tabs
2m 18s
Viewing query output
1m 18s
Case sensitivity of SQL commands
1m 24s
Viewing SQL execution history
55s
Query output as grid or script
46s
4. Basic SELECT Queries
Writing your first SELECT query
1m 56s
Selecting only specific columns
2m 22s
Using WHERE to filter specific rows
1m 55s
Using multiple WHERE conditions
3m 55s
Using WHERE to filter partial strings
3m 12s
Using WHERE to filter numeric ranges
1m 17s
Using WHERE IN and NOT IN for strings
1m 54s
Using WHERE IN and NOT IN for numbers
1m 35s
Using WHERE to filter dates
2m 42s
Using WHERE to filter exact strings
1m 55s
Using DISTINCT to eliminate duplicates
4m
Performing basic numeric calculations
2m 23s
Using column aliases
2m 18s
Describe the structure of a table
3m 16s
Using ORDER BY
3m 29s
5. String, Number, and Date Functions
Introduction to functions
1m 39s
Using SUBSTRING, LENGTH, and CONCAT
2m 50s
Using LENGTH
1m 4s
Using CONTACT
4m 48s
Using LOWER and UPPER
2m 44s
Using INSTR
4m 32s
Using RPAD and LPAD
3m 31s
Using TO_CHAR to convert numbers
1m 34s
Using TO_CHAR to format DATE values
2m 59s
Using TO_CHAR to filter DATE values
1m 57s
The special Oracle DUAL table
1m 18s
Using ROUND
1m 15s
Using TRUNC
1m 36s
Using SYSDATE
1m 59s
Using SYSTIMESTAMP
1m 37s
Using MONTHS_BETWEEN
3m 2s
Using ADD_MONTHS
1m 17s
6. Joining Table Data
Introduction to SQL joins
2m 8s
Joining data from tables
4m 12s
INNER JOIN
1m 17s
LEFT JOIN
2m 55s
RIGHT JOIN
1m 55s
FULL OUTER JOIN
1m 59s
Joins with table aliases
59s
Oracle join syntax vs. ANSI syntax
3m 2s
7. Manipulating Data
Introduction to DML and DDL commands
2m 7s
Creating a simple table
2m 1s
Inserting a new row to a table
3m 15s
COMMIT and ROLLBACK
2m 23s
Introduction to transactions
3m 43s
Deleting rows for a table
3m 23s
Updating values
2m 40s
Multiple-statement transactions
2m 41s
Adding and dropping columns from a table
2m 29s
Truncating all data from a table
3m 4s
8. Grouping Data
Introduction to aggregate functions
1m 57s
Using aggregate functions
2m 24s
Using GROUP BY
2m 45s
Using GROUP BY with MAX, MIN, and AVG
2m 55s
Using HAVING
3m
9. Advanced Topics
Primary keys
2m 47s
NOT NULL constraints
1m 36s
Check constraints
3m 2s
Foreign key constraints
6m 4s
Subqueries
4m 39s
Conclusion
Next steps
1m 33s

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 379.0MB Lynda Oracle Database 12c Basic SQL_git.ir.rar