Tutorialspoint
Freedom Sales | Secure your Future with Latest Skills | Get 10% OFF on checkout, Use CODE "FREEDOM"
Sales End on 17th August

Ultimate Database Learning Pack

7 Best-Selling Courses & eBooks to become a Database Engineer

Tutorialspoint

SQL, Database Management, MySQL, PL/SQL

    • Video
      Relational Database Design Essentials
      • Introduction about the course
      • Oracle SQL Data Modeler
        • Oracle SQL Data Modeler 02:58
      • Data Modeling and Data Base Design
        • Importance of Data Modeling and Data base Design 04:24
        • Introduction to Data Modeling and Data base design 10:09
        • Navigation Overview of Oracle SQL Data Modeler 04:51
      • Process Model - Data Flow diagram using Oracle SQL Modeler
        • Dataflow Diagram - Overview Presentation 07:20 Preview
        • Process Model - Data flow diagram - Demonstration 1 12:26
        • Process Model - Dataflow Diagram - Demonstration 2 05:34
        • Case lite - Process model - Data flow diagram 02:35
        • Case lite - Process model - Data flow diagram - Solution 08:57
      • Logical Model - ERD using Oracle SQL Modeler
        • What is Entity Relationalship Diagram - Overview - Part 1 07:01
        • Whats Entity Relation Diagram - Overview Part 2 06:34
        • Logical Model - Navigation Overview : SQL Modeler 04:43
        • Logical Model - ERD using Oracle SQL Modeler - Part 1 13:04
        • Logical Model - ERD using Oracle SQL Modeler - Part 2 06:12
        • SQL Modeler - Subview ERD 06:14
      • Relational Database - Normalization Process
        • Database Design through Normalization - An overview 10:00
        • Normalization - First Form 04:16
        • Normalization - Second Form 06:13
        • Normalization - Third form 08:01
      • Logical to Relational Model with DDL scripts using Oracle SQL modeler
        • Engineer Logical to Relational Model through SQL Modeler 07:58
        • DDL script creation & script execution 04:11
        • Importing Database Datamodel structure 05:33
      • Other Important features of SQL modeler
        • Business Information 05:01
        • Design rules - validation 05:07
        • Other features in SQL Modeler 02:32
    • Video
      SQL Made Easy for Beginners
      • Introduction
        • Course Overview 03:17 Preview
        • Database Concepts (Database, DBMS, Data Models, RDBMS and SQL) 33:28 Preview
      • Practice different SQL Statements, Clauses, Keywords and Operators
        • How to Practice SQL without installing any Software? 11:42 Preview
        • Select Command 06:25 Preview
        • distinct keyword 06:43 Preview
        • SQL is not case sensitive 03:09
        • Semicolon 08:40
        • Where Clause 14:00
        • Using Relational Operators in Where Clause Condition 07:41
        • Using Logical Operators (AND, OR, NOT) 15:10
        • Between Operator 09:27
        • Order By Clause (ASC, DESC) 11:47
        • Using Between Operator with Text 11:25
        • In Operator 07:17
        • Like Operator and Wildcard Characters 19:20
        • Aliases for Table Column Names (AS Keyword) 11:15
        • Limit Keyword 09:18
        • Breaking the Lengthy SQL Statement into multiple lines 05:26
      • MySQL Built-in Functions
        • MySQL Built-in Functions 10:25
        • upper() MySQL String Function 08:50
        • lower() MySQL String Function 10:26
        • length() MySQL String Function 10:37
        • instr() MySQL String Function 12:03
        • substr() MySQL String Function 14:13
        • concat() MySQL String Function 12:23
        • trim() MySQL String Function 16:42
        • abs() MySQL Numeric Function 10:52
        • mod() MySQL Numeric Function 09:19
        • greatest() and least() MySQL Numeric Functions 05:23
        • truncate() MySQL Numeric Function 08:44
        • power() and sqrt() MySQL Numeric Functions 03:46
        • current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL 11:24
        • year(),month(),day,monthname(),dayname() MySQL Date Time Functions 08:24
        • avg(), max(), min(), count() and sum() MySQL Aggregate Functions 06:37
        • Arithmetic Operators 05:14
      • Practicing SQL on MySQL
        • Installing MySQL Server and Workbench Client for Practising SQL 34:45
        • Creating, Deleting, viewing and using Databases 18:12
        • Creating,Viewing, Describing and Deleting Tables 19:16
        • Insert Into Statements (For inserting data into Tables) 14:15
        • Data Types 35:45
        • Null Value, Is Null Operator and Is Not Null Operator 11:18
        • Delete Statement (For Deleting the Records from Table) 06:58
        • Update Statement and Set Keyword (For Updating the Table Records) 10:51
        • Rename statement and To Keyword (For Renaming Table Name) 03:39
        • Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords 09:57
        • Set Autocommit 11:46
        • Commit Statement 09:09
        • Rollback Statement 08:22
        • Truncate Statement 08:45
        • Single Line and Multi-Line Comments 12:46
        • Group By Clause 10:17
        • Having Clause 12:42
        • Sequence of using where, group by, having and order by clauses 08:28
      • Set Operators
        • Set Operators 14:15
        • Union Operator 49:27
        • Union All Operator 13:28
        • Intersect Operator 16:18
        • Minus Operator 13:37
      • Sub Queries and Other Advanced Concepts
        • Tables and Aliases 17:25
        • Joins (Inner Join, Left Join, Right Join, Full Join and Self Join) 47:41
        • Sub Query (Explaining Single Row Sub Query by solving different SQL problems) 18:56
        • In Operator 08:40
        • Using In Operator with Multi Row Sub Query 12:22
        • Using Any Operator in Multi Row Sub Query 13:18
        • Using All Operator in Multi Row Sub Query 06:42
        • Exists Operator 06:52
        • Using Sub Queries for retrieving the records from multiple tables 14:06
        • Using Multiple Sub Queries in a single SQL statement 10:13
      • Integrity Constraints and other advanced concepts
        • Integrity Constraints 09:26
        • Not Null (Integrity Constraint) 08:37
        • Unique (Integrity Constraint) 12:44
        • Primary Key (Integrity Constraint) 16:45
        • Foreign Key (Integrity Constraint) 34:50
        • Check (Integrity Constraint) 09:57
        • Default (Integrity Constraint) 10:24
        • auto_increment 12:36
        • Insert Into 16:09
        • AS Keyword 08:14
        • IfNull() function 07:41
        • Case, When,Then and End Keywords 22:37
        • Delimiter 07:26
        • Delimiter usage in Stored Procedures 15:08
        • Views 39:47
        • Indexes 30:03
      • JDBC and ODBC
        • JDBC (Conneting to MySQL Database from Java Programs) 02:05
        • ODBC 37:57
      • Client Tools and other topics
        • MySQL Shell Command Line Tool 12:13
        • MySQL Command Line Client 08:12
        • Using default Windows Command Prompt for connecting to MySQL Server 08:22
        • Types of SQL Statements 05:21
        • Grant and Revoke SQL Statements 18:56
        • Temporary Tables 08:16
        • Show Columns,Show Indexes,Show Privileges and Show Grants Statements 11:31
        • Inserting Null 05:05
        • Using trim() for trimming the corner characters of the specified Table values 12:19
        • Using wild-cards as normal characters 08:04
        • Database Objects 08:32
      • Using MySQL In Linux Machine and Putty Software
        • Creating Linux Virtual Machine 29:13
        • Installing MySQL Server in Linux Ubuntu Machine 21:41
        • Using Putty for Connecting to a Remote Machine having MySQL and performing SQL 37:41
      • Oracle SQL
        • Oracle Database, SQL Plus, SQL Developer and Executing SQL Queries 44:16
        • Oracle SQL Queries 59:32
        • Oracle SQL Built-in functions 48:27
        • Oracle SQL Queries (Part 2) 39:30
        • Oracle SQL Queries (Part 3) 22:08
        • Oracle SQL Queries (Part 4) 37:48
        • Oracle SQL Queries (Part 5) 07:35
      • Other Tools for SQL
        • DBeaver Universal DB Client Tool 16:23
        • XAMPP for Practicing SQL 17:07
      • Interview Questions
        • Question 1 05:55
        • Question 2 04:12
        • Question 3 04:42
        • Question 4 05:08
        • Question 5 04:45
        • Question 6 11:52
        • Question 7 01:12
        • Question 8 01:55
        • Question 9 05:19
        • Question 10 04:49
        • Question 11 18:28
        • Question 12 08:49
        • Question 13 12:17
        • Question 14 13:18
        • Question 15 04:45
        • Question 16 05:17
        • Question 17 08:27
        • Question 18 06:07
    • Video
      Oracle SQL Online Training
      • Oracle - SQL
        • Oracle - SQL - Introduction 13:32
        • Oracle - SQL - Environment Setup 03:35 Preview
        • Oracle - SQL - Getting Started 02:05
        • Oracle - SQL - DDL Statements 04:19
        • Oracle - SQL - Create Table 08:51
        • Oracle - SQL - Alter Table 09:01
        • Oracle - SQL - Drop Table 01:08
        • Oracle - SQL - Truncate Table 02:25
        • Oracle - SQL - Constraints 07:10
        • Oracle - SQL - Not Null Constraint 05:13
        • Oracle - SQL - Unique Constraint 07:49
        • Oracle - SQL - Primary Key Constraint 04:09
        • Oracle - SQL - Check Constraint 04:14 Preview
        • Oracle - SQL - Foreign Key Constraint 06:14
        • Oracle - SQL - Managing Constraints 05:59
        • Oracle - SQL - Data Manipulation Language 02:16
        • Oracle - SQL - Insert Statement 09:29
        • Oracle - SQL - Update Statement 03:44
        • Oracle - SQL - Delete Statement 01:46
        • Oracle - SQL - Merge Statement 07:25
        • Oracle - SQL - Managing Transactions 14:46
        • Oracle - SQL - Select Statement 11:46
        • Oracle - SQL - Sorting Data 07:04
        • Oracle - SQL - Filtering Data 20:53
        • Oracle - SQL - Functions 03:44 Preview
        • Oracle - SQL - Character Functions 08:45
        • Oracle - SQL - Number Functions 03:58
        • Oracle - SQL - Date Functions 07:55
        • Oracle - SQL - Conversion Functions 09:02
        • Oracle - SQL - General Functions 07:05
        • Oracle - SQL - Joins 27:39
        • Oracle - SQL - Group Functions 03:12
        • Oracle - SQL - Group By Clause 07:49
        • Oracle - SQL - Advanced Grouping 07:02
        • Oracle - SQL - Subqueries 13:26
        • Oracle - SQL - Advanced Subqueries 11:28
        • Oracle - SQL - Creating Sequences 07:29
        • Oracle - SQL - Creating Index 05:30 Preview
        • Oracle - SQL - Creating Synonyms 02:22
        • Oracle - SQL - Creating Users 01:39
        • Oracle - SQL - Managing User Access 07:42
        • Oracle - SQL - Managing Roles 02:24
    • Video
      Mastering PL/SQL
      • Basics of PL/SQL
        • PL/SQL Introduction 07:29 Preview
        • Architecture of PL/SQL 03:27
        • PL/SQL Language Elements 05:26
        • Structure of PL/SQL Block 02:54
        • Demonstartion of Live SQL (Software used for execution of code) 04:03 Preview
        • Reading Material for Section-1
      • Section2:
        • Variables in PL/SQL 06:01
        • Select into Statement 10:22
        • Constants in PL/SQL 01:49
        • Variable Attributes Part-1 06:34
        • Variable Attributes Part-2 08:33 Preview
        • Reading Material for Variable and Constants
      • Conditional, Looping and Sequential Statements.
        • Conditional Statements of PL/SQL 09:16
        • Simple Loop Statement of PL/SQL 07:04
        • While Loop Statement of PL/SQL 07:20
        • For Loop Statement of PL/SQL 09:03
        • Sequential Control Statements of PL/SQL 09:43
        • Assignment Based on For Loop 01:20
        • Solution of the Assignment 04:05
        • Reading Material for Section 3
      • Exception Handling
        • Concept of Exception Handling and Types of Exceptions 06:26
        • Implicit Exceptions: Trapping of Predefined Oracle Server Errors 12:16
        • Demonstration of Predefined Oracle Server Errors 14:53 Preview
        • Demonstration of Trapping of Non-Predefined Oracle Server Errors 08:20
        • Explicit or User Defined Exceptions 09:41
        • Demonstration of Explicit or User Defined Exceptions 07:04
        • Error Trapping Functions 10:47
        • Handing of Errors Raised in Declare Section and Propagation of Exceptions 09:30
        • Re-raising of Exceptions 04:41
        • Assignment on Exception Handling 02:50
        • Solution of Assignment on Exception Handling 07:45
        • Reading Material for Exceptional Handling Pending
      • Cursor Handling
        • Concept of Cursor 03:15
        • Concept of Implicit Cursor 07:22
        • Demonstration of Implicit Cursor 11:31
        • Concept of Explicit Cursor 06:14
        • Need and Usage of Explicit Cursor 08:19 Preview
        • Demonstration of Explicit Cursor 07:04
        • Cursor For Loop: Concept and Demonstration 10:48 Preview
        • Cursor with Parameters 08:37
        • Demonstration of Cursor with Parameters 06:04
        • Cursor Assignment-1 01:39
        • Solution of Cursor Assignment-1 11:55
        • Cursor Assignment-2 03:52
        • Solution of Cursor Assignment-2 13:02
        • Reading Material for Cursor Handling
      • Sub Programs
        • Sub Programs and and Its Types 06:22
        • Local Function: Concept and Usage 12:45
        • Demonstration of Local Functions 14:17
        • Local Procedures 04:15
        • Stored Functions 07:16
        • Demonstration of Stored Functions 14:50
        • Demonstration of Local Procedures 11:25
        • Stored Procedures 05:11
        • Demonstration of Stored Procedures 14:50 Preview
        • Sub Program Assignment-1 03:03
        • Solution of Sub Program Assignment-1 12:52
        • Sub Program Assignment-2 04:19
        • Solution Sub Program Assignment-2 Question-1 11:11
        • Solution of Sub Program Assignment-2 Question-2 07:45
        • Reading Material for Sub Programs, Functions and Procedures
      • Trigger
        • Concept of Trigger 05:32
        • Uses and Applications of Database Trigger 13:33
        • Types of Trigger 04:09
        • Before Statement Level and Row Level Trigger 11:13
        • After Statement Level and Row Level Trigger 09:29
        • Syntax of Trigger 10:59
        • Concept of Old and New Keywords 11:47
        • Trigger Demonstartion Session-1 12:54 Preview
        • Trigger Demonstartion Session-2 09:32
        • Trigger Demonstartion Session-3 12:16
        • Raising Application Errors with Triggers 10:15
        • Demonstartion of Raising Application Errors 07:41
        • Trigger Assignment-1 Pending
        • Solution of Trigger Assignment-1 13:41
        • Trigger Assignment-2 03:41
        • Reading Material for Trigger
    • Video
      SQL Masterclass: SQL for Data Analytics
      • Introduction
      • Installation and getting started
      • Case Study : Demo
        • Course Resources
        • Case Study Part 1 04:27 Preview
        • Case Study Part 2 06:17 Preview
      • Fundamental SQL statements
        • CREATE 11:46 Preview
        • Exercise 1: Create DB and Table 01:24
        • INSERT 09:07
        • Import data from File 04:59
        • Exercise 2: Inserting and Importing 00:57
        • SELECT statement 03:45
        • SELECT DISTINCT 06:05
        • WHERE 04:02
        • Logical Operators 06:10
        • Exercise 3: SELECT & WHERE 01:16
        • UPDATE 05:25
        • DELETE 04:11
        • ALTER 17:21
        • Exercise 4: Updating Table 01:03
      • Restore and Back-up
        • Restore and Back-up 07:38
        • Exercise 5: Restore and Back-up 00:51
      • Selection commands: Filtering
        • IN 04:24
        • BETWEEN 05:40
        • LIKE 08:52
        • Exercise 6: In, Like & Between 00:51
      • Selection commands: Ordering
        • Side Lecture: Commenting in SQL 01:20
        • ORDER BY 07:42
        • LIMIT 03:38
        • Exercise 7: Sorting 00:47
      • Alias
        • AS 03:33
      • Aggregate Commands
        • COUNT 05:13
        • SUM 03:24
        • AVERAGE 02:53
        • MIN & MAX 04:17
        • Exercise 8: Aggregate functions 01:19
      • Group By Commands
        • GROUP BY 11:52
        • HAVING 05:04
        • Exercise 9: Group By 01:13
      • Conditional Statement
        • CASE WHEN 05:18
      • Joins
        • Introduction to Joins 02:25
        • Inner Join 08:05
        • Left Join 07:32
        • Right Join 06:27
        • Full Outer Join 04:59
        • Cross Join 04:21
        • Except 03:00
        • Union 03:13
        • Exercise 10: Joins 01:18
      • Subqueries
        • Subqueries 14:35
        • Exercise 11: Subqueries 01:21
      • Views and Indexes
        • VIEWS 07:21
        • INDEXES 06:39
        • Exercise 12: Views 00:47
      • String Functions
        • LENGTH 03:31
        • UPPER LOWER 02:10
        • REPLACE 04:13
        • TRIM, LTRIM, RTRIM 06:56
        • CONCATENATION 02:56
        • SUBSTRING 06:01
        • LIST AGGREGATION 05:01
        • Exercise 13: String Functions 02:27
      • Mathematical Functions
        • CEIL & FLOOR 03:34
        • RANDOM 05:06
        • SETSEED 04:11
        • ROUND 02:27
        • POWER 02:25
        • Exercise 14: Mathematical Functions 01:33
      • Date-Time Functions
        • CURRENT DATE & TIME 04:31
        • AGE 03:50
        • EXTRACT 08:17
        • Exercise 15: Date-time functions 01:23
      • PATTERN (STRING) MATCHING
        • PATTERN MATCHING BASICS 07:44
        • ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 15:21
        • Exercise 16: Pattern Matching 01:42
      • Data Type conversion functions
        • Converting Numbers/ Date to String 10:52
        • Converting String to Numbers/ Date 05:53
      • User Access Control Functions
        • User Access Control 13:41
      • Bonus Section: Nail that Interview!
        • Tablespace 05:44
        • PRIMARY KEY & FOREIGN KEY 05:09
        • ACID compliance 05:57
        • Truncate 03:54
      • Performance tuning tips
        • TIP 1 (EXPLAIN) 11:26
        • TIP 2 01:17
        • TIP 3 02:32
        • TIP 4 (VACCUM) 00:34
        • TIP 5 01:59
        • TIP 6 (STRING FUNCTIONS) 02:20
        • TIP 7 (JOINS) 01:57
        • TIP 8 (SCHEMAS) 04:51
      • Bonus Section : Database Basics
        • What is SQL? 01:56
        • Tables and DBMS 03:10
        • Types of SQL commands 04:44
        • PostgreSQL 02:30
      • Attachement Files
        • Attachement Files
    • eBook
      SQL Tutorial
    • eBook
      Database Testing Tutorial
  • Description

    Overview:

    Get Hands on Experience on Oracle SQL Data Modeler, Mastering PL/SQL, SQL Database ( PostgreSQL ), SQL Course Covering Basic To Advanced SQL Topics For SQL Database ( PostgreSQL ). Elucidates SQL Database For Beginners.

    • 5 Modules
    • 367+ Lectures
    • 55+ Hrs HD Videos
    • Course Designed by Industry Experts
    • Up-to-Date Curriculum
    • 2 eBooks
    • Full Lifetime Access
    • 30 Days Refund Policy
    • Certificate on Completion


    About the Premium Pack:

    Welcome to our ultimate database learning pack. We will help you to understand and explore one of the most important databases in single pack Oracle SQL, MySQL, SQL, PostgreSQL, Elucidates SQL Database. 


    Scope of Database Management:

    • Database Management systems are widely used by companies and organizations to maintain their data information secure and informative.
    • After completion of course students should be able to work in automotive, banking, IT/ITES sector.
    • Database Administration Manager can earn as much as $115,000 a year.

    Goals

    • SQL from Basics to the Advanced Level
    • Learning SQL on both popular MySQL and Oracle RDBMS Software
    • Enhance the performance of your Database by using Views and Indexes
    • Increase your efficiency by learning the best practices while writing SQL queries
    • Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
    • Understand and develop business process models( data flow diagrams) through Oracle SQL modeler.
    • Database Normalization with Examples - 1st, 2nd and 3rd form of Normalization
    • Effective creation of Process models, Logical data models and Relational data model
    • Use of Relational Data model and auto generate DDL scripts

    Prerequist

    • Having some basic computer knowledge.
    • Basic knowledge of SQL
    • Just a PC with any web browser
Ultimate Database Learning Pack
This Prime Pack Includes :

56.5 hours

5 Video Courses

2 eBooks

Lifetime Access
Preview

Preview