Database Development Bundle

4.5 Value Rating*

If you’re just starting out, or are struggling to master some of the popular database development languages then this is a great bundle to get your hands on. Learn MongoDB, MySQL, Oracle and more.

$29

$20.30
6
COURSES
260
LESSONS
NEW
ENROLLED

LIFETIME ACCESS TO ALL THESE 6 COURSES
MySQL Database Development for Beginners
MySQL Database Development for Beginners

$99 Value

Introduction to Oracle SQL
Introduction to Oracle SQL                        

$10 Value

Relational Database Design
Relational Database Design                        

$10 Value

SQL Database for Beginners
SQL Database for Beginners                        

$99 Value

Mongo DB All About MongoDB
Mongo DB : All About MongoDB                        

$70 Value

Cosmos DB
Cosmos DB                                                            

$50 Value

DETAILS OF THE 6 COURSES IN THE BUNDLE
MySQL Database Development for Beginners

MySQL Database Development for Beginners

Instructor: EDUmobile Academy

OverviewDescriptionAbout

A Practical “how-to” Approach to Working with MySQL

MySQL is the fastest growing open-source relational database management system with 100 million downloads till date.
It is a popular choice of database for use in web applications and is currently used by many large websites, including Facebook, Twitter, Wikipedia, Flickr, YouTube, and a ton of other top sites!

MySQL is the fastest growing open-source relational database management system with 100 million downloads till date.

It is a popular choice of database for use in web applications and is currently used by many large websites, including Facebook, Twitter, Wikipedia, Flickr, YouTube, and a ton of other top sites!

MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications.

In this course, we’ll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.

Unlike traditional courses that concentrate mainly on theory, we’ll take a practical “how-to” approach to working with data.

Here’s what you’ll learn:

– Creating databases and tables

– Adding data to a table with INSERT

– Reading a table with SELECT

– How to use WHERE to filter data

– Using ORDER BY to sort data

– JOINs and how to use them to read from multiple tables

– Changing data in a table with UPDATE

– The DELETE query: removing one or more rows of data from a table

– Using a text file to load a database schema

These topics and many more will be covered. The concentration in this course is on MySQL itself… not on how to use it to for any particular purpose.

But this course makes a great introduction to our upcoming course about web databases using php and MySQL.

So why wait… sign up today!

EDUmobile Academy

EDUmobile Academy develops high quality video training courses around topics in mobile development including iPhone, Android, Windows Phone, Java, Responsive Web Design and other emerging technologies.

Every course is created by an expert developer AND a trained mentor in the area of expertise.

Each course undergoes a rigorous planning, review and an internal quality check phase – to ensure that the teaching is of highest standards available online.

EDUmobile Academy was founded in 2008 when smart phones were just emerging into the market. Founder Vishal Lamba is experienced in multiple areas of digital design, mobile development and design, web technologies and digital marketing. He has a mathematics and computer science degree from Lawrence University, USA.

Vishal works closely with content creators and teachers to ensure that every course released meets the internal rigorous quality standards.

All course creators and trainers are currently based in the USA. Support for each course on Udemy is provided with quick turn around by a small team of developers and trainers.

2  Hours

20 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction and Installation
Installing MySQL (5:33)
Showing, Creating, and Using Databases (2:46)
Creating Tables, Inserting and Showing Data (6:26)
MySQL Data Types (12:47)
Creating an Auto Incrementing Primary Key (8:06)
MySQL Basic Query Statements
Describe Table Syntax (3:58)
Loading SQL Files into MySQL (6:55)
Select Query Syntax Introduction (6:34)
Select Query Demo (5:16)
MySQL Advance Statements
Update Query Syntax (3:15)
Mathematical Operations (6:06)
Distinct, Count, and Group by (4:02)
Table Relationships (7:47)
Intro to Joins (5:55)
MySQL Advanaced Statements Part 2
The Delete Query (4:36)
Types of Joins (6:04)
Joins Demo (4:36)
Creating and Using Views (2:43)
Setting up a Many to Many Relationship (4:36)
Demo of Many to Many Relationship (6:32)

Introduction to Oracle SQL

Introduction to Oracle SQL

Instructor: Ben Brumm

OverviewDescriptionAbout

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

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.

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 environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The 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 hourswithout paying thousands of dollars for training. You can also study in your own time!

Ben Brumm

I’m a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I’d like to teach others about databases and database topics, such as SQL, database design, and performance.

4:17  Hours

37 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction and Setup
Introduction (2:09)
Tools and Concepts (7:40)
Oracle Client Download (1:46)
Oracle Client Install (1:24)
How To Install Oracle On A Mac
Java 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 Data
Viewing 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)
Functions
Functions – 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 Concepts
Table 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 Language
DML – Insert (7:15)
DML – Update (6:08)
DML – Delete and TRUNCATE (4:27)
Objects
DDL – Object Types (15:48)
DDL – Create Table and Constraints (20:28)
DDL – Alter and Drop Table (4:50)
Conclusion
Conclusion (1:10)

Relational Database Design

Relational Database Design

Instructor: Ben Brumm

OverviewDescriptionAbout

Learn how to create an effective relational database design to use in your IT career or even a personal project.

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier.

If you want to improve your software development career, get into database admin or design, or are just curious on this topic, this course is for you.

You don’t need to know SQL or have any programming experience to be able to take this course.

Almost three hours of video lessons and included PDF files of the database diagrams at keys steps will help you learn all about database design. The topics covered include normalisation and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships.

The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram. I also show you how to download and install the software that is being used for this.

We’ll walk through a sample database, starting with the reason or why the database is needed, some advantages of relational databases, identify entities for the tables and attributes, create tables and columns, and most importantly, reorganise them to make the layout and design more efficient.

If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you.

You’ll learn all you need to be able to design an effective database.

Ben Brumm

I’m a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I’d like to teach others about databases and database topics, such as SQL, database design, and performance.

3  Hours

31 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction
Welcome (3:55)
Things You Should Know Before Starting This Course (0:48)
Tools You Need For Database Design (2:24)
How To Set Up MySQL Workbench (3:30)
Database Basics
What Is A Database? (2:50)
Different Types of Databases? (2:30)
Relational Databases
Store Data for Each Component (2:30)
Removes Duplicate Information (2:50)
Ensure Records are Complete (1:52)
Prevent Inconsistent and Conflicting Data (4:43)
Combine Different Data Sets Easily (2:30)
Increased Security (2:12)
Data Modelling Process
What Is Data Modelling And The Design Process? (3:31)
Determine The Goal Of The Database (3:18)
Consider the Current System (3:34)
Gathering Requirements of the Database (4:10)
Finding Exceptions to the Rules (5:21)
Database Design
Identifying Entities (8:30)
Defining the Attributes (10:06)
Normalisation (2:40)
First Normal Form – Part 1 (9:31)
First Normal Form – Part 2 (9:34)
Relationships (3:26)
Second Normal Form – Part 1 (9:56)
Second Normal Form – Part 2 (12:55)
Third Normal Form (9:49)
Design Considerations
Data Types and Precision (6:38)
Integrity Constraints (2:53)
Naming Conventions (3:25)
Lookup Tables and Auditing (3:36)
Conclusion
Implementation and Next Steps (3:19)

SQL Database for Beginners

SQL Database for Beginners

Instructor: LearnToProgram, Inc.

OverviewDescriptionAbout

Master SQL Database Creation and Development with Guru Martin Holzke.

Have you started learning about SQL Databases, only to get stuck while trying to teach yourself? Or are you a developer whose never felt totally at ease with database work? Have you been looking for an easy and comprehensive way to go beyond the basics and start using SQL Databases in a professional and efficient way? Perhaps, you just want to get your SQL queries to work the first time!

Have you started learning about SQL Databases, only to get stuck while trying to teach yourself? Or are you a developer whose never felt totally at ease with database work? Have you been looking for an easy and comprehensive way to go beyond the basics and start using SQL Databases in a professional and efficient way? Perhaps, you just want to get your SQL queries to work the first time!

In this thorough and easy-to-follow course, database expert Martin Holzke shows you how to achieve success. From the very first lesson, you’ll learn how to correctly structure your database, how to author efficient SQL statements and clauses, and how to manage your SQL database for scalable growth. This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications.

Martin will invite you to work along with him as he demonstrates the ins and outs of database management and database for application development. If you’re developing web or mobile apps or even games there is much to be learned about this important facet of development. If you’re brand new to SQL Database work, or a professional developer looking to learn the best practices, then SQL Database for Beginners is the perfect course for you!

LearnToProgram, Inc.

LearnToProgram Media is a leading publisher of web, mobile, and game development courses that are used by over 500,000 people in 65 countries. LearnToProgram’s valuable network of technical resources includes content on YouTube, iTunes, and Roku, as well as books, free tutorials, and online courses.

With a mission of “teaching the world to code” LearnToProgram instructors are teachers first and technical experts second. Their primary skill is relating complex technical information to nontechnical people learning web, mobile and game development. The entirely online, self-paced sales model allows students to learn at their own pace.

With over 40 courses on the market, LearnToProgram offers students flexible programs in web development, mobile application development and game development. Currently the company’s most popular online courses include Become a Certified Web Developer and 10 Apps in 10 Weeks.

7 Hours

55 Lessons

Lifetime Access

Course Curriculum

Preview Course

Relational Databases
What are Databases? (7:24)
What is the Role of Databases in Application Programming (7:56)
Tables and Relations (14:40)
Primary and Foreign Keys, and Other Constraints (12:00)
Chapter 1 Lab Exercise
SQL Querying
What is Querying (2:40)
The ANSI SQL Standard (3:59)
DML, DDL and More (5:07)
Common Query Tools (8:27)
Chapter 2 Lab Exercise
Your First Queries
The SELECT Statement (6:17)
Limiting Output Columns (4:57)
Formatting and Sorting Output (15:22)
Column Aliases (6:19)
Chapter 3 Lab Exercise
Filtering your Results
The WHERE Clause (4:57)
Creating a Filter Condition (7:19)
Multiple Filter Conditions (8:13)
More Filter Operations (11:21)
Chapter 4 Lab Exercise
Consolidating your Data
Counting Records (5:14)
Common Aggregate Functions: SUM, AVG, MIN, MAX (8:06)
Do’s and Don’ts when Consolidating (8:38)
Union and Other Multiset Consolidations (10:57)
Chapter 5 Lab Exercise
Grouping your Data
The GROUP BY Clause (9:59)
The HAVING Clause (5:36)
Do’s and Don’ts when Grouping (6:09)
Chapter 6 Lab Exercise
Joining Tables
Table Aliases (6:54)
Inner Joins (14:58)
Outer Joins (14:08)
Self Joins (8:00)
Complex Multi Table Joins (19:57)
Chapter 7 Lab Exercise
Subqueries
Filtering Using Subqueries (14:09)
The EXISTS Clause (6:49)
Subqueries as Alternatives to Joins (7:09)
Derived Tables (5:39)
Chapter 8 Lab Exercise
Manipulating your Data
The INSERT Statement (20:46)
The UPDATE Statement (12:50)
The DELETE Statement (6:26)
Chapter 9 Lab Exercise
Transaction Control
What are Transactions? (5:24)
Initiating a Transaction (4:17)
The COMMIT and ROLLBACK Commands (4:22)
Chapter 10 Lab Exercise
Creating Database Objects and Adding Business Logic
Creating Tables (16:39)
Creating and Using Views (9:15)
Developing and Calling Stored Procedures (10:41)
Implementing Triggers (9:25)
Chapter 11 Lab Exercise
Lab Solutions

Mongo DB All About MongoDB

Mongo DB : All About MongoDB

Instructor: SkillBakery Studios

OverviewDescriptionAbout

Learn MongoDB from scratch

What you’ll learn

Know all about MongoDB – be it administrative tasks like creating replica sets or developing web application using MongoDB
How to install MongoDB on various platforms

What you’ll learn

  • Know all about MongoDB – be it administrative tasks like creating replica sets or developing web application using MongoDB
  • How to install MongoDB on various platforms
  • How to create and drop databases
  • How to create collections
  • How to perform CRUD operations in MongoDB
  • How to connect to PHP
  • Much more….
Requirements
  • A basic understanding of Database concepts

Description

Learn the MongoDB from scratch. Covers the latest version 3.2

This course provides you with a practical approach to MongoDB. The main focus of this course is to get you familiar with MongoDB and ensure that you are ready to build cool new web applications using MongoDB in no time.

In this course we will be covering fundamentals of MongoDB first so that it becomes easier to understand the different concepts and syntax that one uses in MongoDB

In this course we will covering following topics

  1. Introduction to MongoDB
  2. Installing and Running MongoDB
  3. Understanding Replica Sets
  4. Exploring Mongo Shell
  5. NoSQL terminology
  6. Working with MongoDB Database
  7. Querying Collections
  8. Working with MongoDB Operators
  9. Exploring Count,Sort and Limit
  10. CRUD Operations
  11. Indexing
  12. Working with PHP and MongoDB

There’s only one thing that you have to do apart from watch the video and that is to type the queries on your own

So what are you waiting for let’s get started with MongoDB

Who this course is for:
  • Those who want to work on latest web technologies
  • Those who are into web development
  • Those who love databases
  • Those who want to learn MongoDB

SkillBakery Studios

SkillBakery is one of the fastest growing online education company.

Our vision is to provide high quality education which is affordable and accessible to everyone

We believe that every one has their own way of learning and grasping things and that’s why we provide self-paced HD quality contents,so you can learn what you love at your convinience

We currently offer courses in web development and will soon be publishing new courses in other categories as well

We are committed to bring courses on new topics and we try to release one new course every month

So keep visiting us, you will surely find something for yourself here.

3  Hours

71 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction
Introduction to MongoDB (1:23)
Introduction to NoSQL (2:07)
Advantages of MongoDB (1:46)
Installing and running MongoDB
Downloading MongoDB (1:41)
Installing MongoDB on Windows (1:38)
Installing MongoDB on MAC (2:48)
Running MongoDB (2:06)
Customizing MongoDB (3:04)
Installing MongoDB as a Service (2:53)
Connecting to MongoDB Database via Mongo Shell
Listing Databases using Mongo Shell
Looking for Help in Mongo Shell (2:20)
MongoDB Tools (2:15)
Replica Sets
Introduction to Replica sets (2:36)
How to configure a replica set (4:10)
Verifying a replica set (1:36)
replica set fail over (1:51)
Exploring Mongo Shell
Introduction to Mongo Shell (1:20)
Usage Scenarios (3:02)
Preventing Database Deletion (1:48)
Shortcut Keys (1:08)
Editing in external Editors (1:58)
Loading scripts within the Shell (1:50)
Making use of .mongorc.js file (1:20)
NoSQL Terminology
NoSQL Database Terms (1:30)
Working with MongoDB Database
Creating Databases (3:54)
Inserting Documents using JavaScript Way {Object Literals} (2:49)
Exploring Object ID datatype (3:46)
Exploring Relations in MongoDB (1:35)
Deleting a Collection (1:10)
Importing data from a file (1:45)
Pretty Print Collections Data (1:33)
Querying MongoDB Collections
Querying Collections – Selectors (2:06)
Querying Collections – Multiple Selectors (1:36)
Limiting fields via Selectors – Include / Exclude (1:32)
Difference between Find and FindOne (3:02)
Query inside of sub objects (2:32)
Querying Collections – Filtering sub collections (1:49)
Working with MongoDB Operators
The $in Operator (2:17)
The $all Operator and $in vs $all (3:12)
The $ne Opertaor (1:17)
Numeric Operators (4:06)
Boolean Operators (3:15)
Special Operators (4:53)
$nin Not in operator (0:42)
SQL Query Methods – Distinct,Like and GroupBy
Making use of distinct (0:53)
Making use of Regex – Like clause in SQL (1:57)
Group By (3:39)
Count,Sort and Limit Records
Count Records (1:41)
Sorting (2:08)
limiting records (2:28)
CRUD Operations
Updating One record at a time (7:19)
Updating Multiple records (3:20)
Exploring FindAndModify (4:26)
Updating array items – Push Operator (3:09)
Updating array fields – Adding Unique values to Array collections (2:59)
Removing array items – Pull Operator (2:04)
Removing array items – Pop Operator (2:17)
Positional Operator (2:50)
Rename Operator (1:23)
Deleting records and database (2:21)
Indexing
Introduction to Indexes (3:17)
Types of Indexes (1:16)
Creating a simple Index (4:51)
Creating a compound Index (1:55)
Creating a sparse Index (0:58)
Dropping an Index (1:24)
When an Index will be used (1:38)
User Management And Authentication
Creating and Authenticating Users – MongoDB (3:54)
Working with PHP and MongoDB
Working with PHP and MongoDB (6:52)
Conclusion
Conclusion and File Download (0:29)

Cosmos DB

Cosmos DB

Instructor: SkillBakery Studios

OverviewDescriptionAbout

Learn the bit and bones of Cosmos DB

What you’ll learn

Learn the concepts of Cosmos DB
Using Cosmos DB in ASP .Net web applications
Managing Collections and Items with in the Cosmos DB

What you’ll learn

  • Learn the concepts of Cosmos DB
  • Using Cosmos DB in ASP .Net web applications
  • Managing Collections and Items with in the Cosmos DB
Requirements
  • Azure Subscription
  • Visual Studio 2015 onwards
  • Knowledge of C#
  • Knowledge of ASP. Net

Description

If you are a web developer then the understanding of cloud platforms has become a necessity.

Azure Cosmos DB gives you the edge when it comes to NoSQL Databases on Cloud

In this course we will be exploring the nitty gritty of Cosmos DB

In this course we will learn

1. What is Cosmos DB

2. How to Create Cosmos DB Database

3. How to do Data Import

4. How to to Data Manipulation

5. How to Update Collections

6. How to do Querying

7. Deleting a Collection/Item

8. Indexing

So let’s start learning Cosmos DB

Who this course is for:
  • Aspiring Web Developers
  • Aspiring Database Developers
  • Web Developers
  • Database Developers

SkillBakery Studios

SkillBakery is one of the fastest growing online education company.

Our vision is to provide high quality education which is affordable and accessible to everyone

We believe that every one has their own way of learning and grasping things and that’s why we provide self-paced HD quality contents,so you can learn what you love at your convinience

We currently offer courses in web development and will soon be publishing new courses in other categories as well

We are committed to bring courses on new topics and we try to release one new course every month

So keep visiting us, you will surely find something for yourself here.

1:05  Hours

30 Lessons

Lifetime Access

Course Curriculum

Preview Course

Azure Cosmos DB
Introduction (0:41)
Prerequisites (0:56)
Data import
Create Azure Cosmos DB (3:31)
Create Database and Collection (10:41)
Create Collection with custom indexing (4:53)
Change Collection Throghput (2:48)
Add an Item to a Collection (3:10)
Exporting JSON data to a Collection (2:55)
Data Manipulation
Read data from a collection (3:20)
Read selected data from a collection (3:12)
Creating a stored procedure (4:26)
Calling a stored procedure
Creating a parameterized stored procedure and calling it via Azure API (2:14)
User Defined Functions (3:28)
Triggers (3:07)
Updating Collections
Updating items in a Collection (2:32)
Querying
Multiple ways to select all (3:43)
Parallel Query (3:34)
Query with SQL Parameters (3:07)
Query with filter and projection (1:48)
Query with equality and inequality (2:15)
Range Operations (2:07)
Deletion
Deleting an item from Collection (2:07)
Indexing
Setting up Indexing at Document Level (2:01)
Setting up Indexing at Collection Level (2:16)
Exclude Path – Manage Indexing in nested level items (2:28)
Range Indexing (2:38)
Range Index on Strings (2:52)
Alter Indexing dynamically (1:27)
Conclusion and Code Download
Conclusion (0:20)

$29

$20.30