FreeCoursesOnline Us Lynda Oracle Database 12c Basic SQL | 0A0EA5B66582B5AC6D5787516BB515C08F681801

FreeCoursesOnline Us Lynda Oracle Database 12c Basic SQL

Name	[FreeCoursesOnline.Us] Lynda - Oracle Database 12c_ Basic SQL	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	424.0 MB
Total Files	160
Hash	0A0EA5B66582B5AC6D5787516BB515C08F681801

/01 Introduction/
001 Welcome-en.srt	2.7 KB
001 Welcome.mp4	6.1 MB
002 What you need to know-en.srt	1.7 KB
002 What you need to know.mp4	2.2 MB
/02 Introduction to SQL/
001 What is SQL_-en.srt	3.4 KB
001 What is SQL_.mp4	3.9 MB
002 Database tables-en.srt	3.8 KB
002 Database tables.mp4	3.9 MB
003 Overview of table data types-en.srt	6.7 KB
003 Overview of table data types.mp4	5.7 MB
004 SQL query structure-en.srt	6.8 KB
004 SQL query structure.mp4	7.2 MB
/03 Preparing the Course Environment/
001 Downloading the course VM-en.srt	3.9 KB
001 Downloading the course VM.mp4	6.4 MB
/04 Using Oracle SQL Developer/
001 Introduction to Oracle SQL Developer-en.srt	2.9 KB
001 Introduction to Oracle SQL Developer.mp4	4.3 MB
002 Creating a connection to the database-en.srt	8.8 KB
002 Creating a connection to the database.mp4	10.1 MB
003 Managing existing connections-en.srt	1.6 KB
003 Managing existing connections.mp4	1.7 MB
004 Exploring database objects-en.srt	2.7 KB
004 Exploring database objects.mp4	5.0 MB
005 Filtering specific objects-en.srt	2.5 KB
005 Filtering specific objects.mp4	2.8 MB
006 Using SQL Developer tabs-en.srt	3.7 KB
006 Using SQL Developer tabs.mp4	5.6 MB
007 Viewing query output-en.srt	2.3 KB
007 Viewing query output.mp4	4.0 MB
008 Case sensitivity of SQL commands-en.srt	2.4 KB
008 Case sensitivity of SQL commands.mp4	3.5 MB
009 Viewing SQL execution history-en.srt	1.6 KB
009 Viewing SQL execution history.mp4	2.3 MB
010 Query output as grid or script-en.srt	1.3 KB
010 Query output as grid or script.mp4	2.5 MB
/05 Basic SELECT Queries/
001 Writing your first SELECT query-en.srt	3.0 KB
001 Writing your first SELECT query.mp4	4.6 MB
002 Selecting only specific columns-en.srt	3.6 KB
002 Selecting only specific columns.mp4	6.3 MB
003 Using WHERE to filter specific rows-en.srt	2.4 KB
003 Using WHERE to filter specific rows.mp4	4.6 MB
004 Using multiple WHERE conditions-en.srt	6.1 KB
004 Using multiple WHERE conditions.mp4	9.3 MB
005 Using WHERE to filter partial strings-en.srt	4.6 KB
005 Using WHERE to filter partial strings.mp4	7.4 MB
006 Using WHERE to filter numeric ranges-en.srt	1.6 KB
006 Using WHERE to filter numeric ranges.mp4	3.4 MB
007 Using WHERE IN and NOT IN for strings-en.srt	2.5 KB
007 Using WHERE IN and NOT IN for strings.mp4	4.2 MB
008 Using WHERE IN and NOT IN for numbers-en.srt	2.2 KB
008 Using WHERE IN and NOT IN for numbers.mp4	3.5 MB
009 Using WHERE to filter dates-en.srt	4.1 KB
009 Using WHERE to filter dates.mp4	6.7 MB
010 Using WHERE to filter exact strings-en.srt	2.9 KB
010 Using WHERE to filter exact strings.mp4	4.3 MB
011 Using DISTINCT to eliminate duplicates-en.srt	5.8 KB
011 Using DISTINCT to eliminate duplicates.mp4	8.8 MB
012 Performing basic numeric calculations-en.srt	3.5 KB
012 Performing basic numeric calculations.mp4	5.9 MB
013 Using column aliases-en.srt	3.1 KB
013 Using column aliases.mp4	6.0 MB
014 Describe the structure of a table-en.srt	5.0 KB
014 Describe the structure of a table.mp4	9.0 MB
015 Using ORDER BY-en.srt	4.9 KB
015 Using ORDER BY.mp4	8.3 MB
/06 String Number and Date Functions/
001 Introduction to functions-en.srt	2.7 KB
001 Introduction to functions.mp4	3.4 MB
002 Using SUBSTRING LENGTH and CONCAT-en.srt	4.5 KB
002 Using SUBSTRING LENGTH and CONCAT.mp4	6.2 MB
003 Using LENGTH-en.srt	1.6 KB
003 Using LENGTH.mp4	2.3 MB
004 Using CONCAT-en.srt	6.6 KB
004 Using CONCAT.mp4	10.4 MB
005 Using LOWER and UPPER-en.srt	4.0 KB
005 Using LOWER and UPPER.mp4	5.8 MB
006 Using INSTR-en.srt	6.4 KB
006 Using INSTR.mp4	10.7 MB
007 Using RPAD and LPAD-en.srt	5.6 KB
007 Using RPAD and LPAD.mp4	7.4 MB
008 Using TO_CHAR to convert numbers-en.srt	2.4 KB
008 Using TO_CHAR to convert numbers.mp4	3.2 MB
009 Using TO_CHAR to format DATE values-en.srt	4.2 KB
009 Using TO_CHAR to format DATE values.mp4	6.4 MB
010 Using TO_CHAR to filter DATE values-en.srt	3.2 KB
010 Using TO_CHAR to filter DATE values.mp4	4.3 MB
011 The special Oracle DUAL table-en.srt	2.1 KB
011 The special Oracle DUAL table.mp4	2.6 MB
012 Using ROUND-en.srt	1.6 KB
012 Using ROUND.mp4	2.5 MB
013 Using TRUNC-en.srt	2.3 KB
013 Using TRUNC.mp4	3.1 MB
014 Using SYSDATE-en.srt	2.8 KB
014 Using SYSDATE.mp4	3.9 MB
015 Using SYSTIMESTAMP-en.srt	2.4 KB
015 Using SYSTIMESTAMP.mp4	3.3 MB
016 Using MONTHS_BETWEEN-en.srt	4.5 KB
016 Using MONTHS_BETWEEN.mp4	7.0 MB
017 Using ADD_MONTHS-en.srt	2.0 KB
017 Using ADD_MONTHS.mp4	2.6 MB
/07 Joining Table Data/
001 Introduction to SQL joins-en.srt	3.4 KB
001 Introduction to SQL joins.mp4	3.3 MB
002 Joining data from tables-en.srt	6.6 KB
002 Joining data from tables.mp4	9.1 MB
003 INNER JOIN-en.srt	1.7 KB
003 INNER JOIN.mp4	2.6 MB
004 LEFT JOIN-en.srt	4.5 KB
004 LEFT JOIN.mp4	6.5 MB
005 RIGHT JOIN-en.srt	3.4 KB
005 RIGHT JOIN.mp4	4.3 MB
006 FULL OUTER JOIN-en.srt	3.2 KB
006 FULL OUTER JOIN.mp4	4.4 MB
007 Joins with table aliases-en.srt	1.4 KB
007 Joins with table aliases.mp4	2.3 MB
008 Oracle join syntax vs. ANSI syntax-en.srt	4.6 KB
008 Oracle join syntax vs. ANSI syntax.mp4	7.3 MB
/08 Manipulating Data/
001 Introduction to DML and DDL commands-en.srt	2.9 KB
001 Introduction to DML and DDL commands.mp4	3.5 MB
002 Creating a simple table-en.srt	2.8 KB
002 Creating a simple table.mp4	3.9 MB
003 Inserting a new row to a table-en.srt	4.7 KB
003 Inserting a new row to a table.mp4	6.5 MB
004 COMMIT and ROLLBACK-en.srt	3.4 KB
004 COMMIT and ROLLBACK.mp4	4.8 MB
005 Introduction to transactions-en.srt	5.2 KB
005 Introduction to transactions.mp4	7.8 MB
006 Deleting rows for a table-en.srt	5.0 KB
006 Deleting rows for a table.mp4	7.1 MB
007 Updating values-en.srt	3.7 KB
007 Updating values.mp4	5.4 MB
008 Multiple-statement transactions-en.srt	3.9 KB
008 Multiple-statement transactions.mp4	5.6 MB
009 Adding and dropping columns from a table-en.srt	3.8 KB
009 Adding and dropping columns from a table.mp4	4.9 MB
010 Truncating all data from a table-en.srt	4.7 KB
010 Truncating all data from a table.mp4	6.2 MB
/09 Grouping Data/
001 Introduction to aggregate functions-en.srt	3.0 KB
001 Introduction to aggregate functions.mp4	3.9 MB
002 Using aggregate functions-en.srt	3.4 KB
002 Using aggregate functions.mp4	5.4 MB
003 Using GROUP BY-en.srt	5.0 KB
003 Using GROUP BY.mp4	6.1 MB
004 Using GROUP BY with MAX MIN and AVG-en.srt	4.1 KB
004 Using GROUP BY with MAX MIN and AVG.mp4	7.3 MB
005 Using HAVING-en.srt	4.2 KB
005 Using HAVING.mp4	6.9 MB
/10 Advanced Topics/
001 Primary keys-en.srt	4.1 KB
001 Primary keys.mp4	5.7 MB
002 NOT NULL constraints-en.srt	2.4 KB
002 NOT NULL constraints.mp4	3.6 MB
003 Check constraints-en.srt	4.9 KB
003 Check constraints.mp4	6.4 MB
004 Foreign key constraints-en.srt	10.2 KB
004 Foreign key constraints.mp4	13.7 MB
005 Subqueries-en.srt	6.6 KB
005 Subqueries.mp4	10.1 MB
/11 Conclusion/
001 Next steps-en.srt	2.7 KB
001 Next steps.mp4	4.6 MB
/
[Discuss.FreeTutorials.us].url	0.3 KB
[FreeCoursesOnline.Us].url	0.1 KB
[FreeTutorials.Us].url	0.1 KB
Oracle Database 12c_ Basic SQL-description.txt	0.0 KB
Total files 160