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

$14.50
10
COURSES
380
LESSONS
NEW
ENROLLED

LIFETIME ACCESS TO ALL THESE 10 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

MySQL - Become a Certified Database Engineer
MySQL - Become a Certified Database Engineer

$99 Value

Learn MongoDB from Scratch
Learn MongoDB from Scratch                        

$50 Value

MySQL Fundamentals
MySQL Fundamentals

$50 Value

MySQL For Beginners
MySQLi For Beginners

$50 Value

DETAILS OF THE 10 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)

MySQL - Become a Certified Database Engineer

MySQL - Become a Certified Database Engineer

Instructor: Total Training

OverviewDescriptionAbout

You will be introduced to database design and create your first database

MySQL is one of the most well-known systems for managing databases, and with this MySQL: Become a Certified Database Engineer course, you will get acquainted with with the basic concepts of databases and gain the knowledge needed to practically use MySQL servers.

MySQL is one of the most well-known systems for managing databases, and with this MySQL: Become a Certified Database Engineer course, you will get acquainted with with the basic concepts of databases and gain the knowledge needed to practically use MySQL servers.

Through the lessons, you’ll get an overview of SQL language syntaxes as well as the advanced functionalities of servers. This is an open code system, which means it’s available to everyone that wishes to use it and modify it according to their own specific needs. Apart from the fact this system enables you to manage your daily tasks quickly and efficiently, gaining skills and experience in MySQL will also provide you with a chance at building a successful and lucratively rewarding IT career. This course also prepares you for ORACLE certification, which can only further improve your chance at landing a great job.

What are the requirements?

  • No prior SQL Development experience required
  • Knowing some programming language would be helpful

What am I going to get from this course?

  • Gain the qualifications needed to apply for MySQL Development jobs
  • Gain the knowledge needed to prepare to take the ORACLE exam: Oracle Certified Professional, MySQL 5.6 Database Administrator

Total Training

Total Training is a pioneer in innovative online training for leading creative design, digital video, office productivity software programs, and more.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

HISTORY

Total Training was founded in 1996 to provide the highest quality instruction to users of creative software. Recognizing that printed instruction was tedious, and classroom training was hard to find and often prohibitively expensive, Brian Maffitt, Total Training CEO and President collaborated to create the first video series, Total AE. The response was overwhelming.

5  Hours

18 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction to databases
MySql Workbench (16:59)
Installation (17:27)
Creating the first database
Creating the first database (10:47)
Primary and foreign keys (29:50)
Introduction to SQL
Definition commands (14:54)
SELECT (16:51)
Connecting data (10:18)
INSERT, UPDATE, DELETE (18:32)
Indexes
Views (6:39)
Stored routines (25:43)
Built-in functions (24:28)
Cursors and triggers (25:20)
Transactions (9:07)
Users and access (11:50)
MySql Security (6:11)
Connections (6:42)
Replication (19:19)
Backup and Migration (10:40)
RESOURCES
Project Files – MySQL Become a Cert Database Engineer

Learn MongoDB from Scratch

Learn MongoDB from Scratch

Instructor: Total Training

OverviewDescriptionAbout

Work on detailed examples that will all fit together to form a complete, working web application that’s fully integrated with MongoDB

Data is a very popular buzzword in the technology industry right now.

Data is a very popular buzzword in the technology industry right now. As more and more people move their activities online, the data companies and websites collect on them will become even more relevant. And guess what that means? Programmers and developers who know their way around databases – and more importantly, who can actually interpret and build things from them – will be in high demand. MongoDB is one of the most dynamic databases out there, so getting to grips with it sooner rather than later means you’ll stay well ahead of the curve.

Become a MongoDB Master

  • Gain an in-depth understanding of MongoDB’s capabilities
  • Learn how MongoDB can be used for web app design, development, testing and more
  • Set up a powerful development environment with an online IDE
  • Explore the impressive MongoDB Aggregation Framework
  • Build a complete web application fully integrated with MongoDB
  • Approach Data in New Exciting Ways

This Learn MongoDB from Scratch online course has been designed for web developers, web designers, web architects, testers, site administrators, and pretty much anyone who already has a working knowledge of web development. Although it’s not vital, knowing how to build web UI components and a familiarity with NoSQL persistence will help. This course is absolutely not limited to developers only, however.

The goal is to provide a solid foundation of MongoDB knowledge. To get you up and running on building your own web apps with MongoDB at their core, and to help you understand the capabilities, functionality and limitations of what this database can do.

You’ll learn how to configure and run MongoDB, start importing data, and then quickly get stuck into creating new databases. You’ll pick up Mongo Query Language commands and dive into one of MongoDB’s most powerful features, the Aggregation Framework. You’ll work through detailed examples to gain an understanding of the various pieces of the puzzle, all the while learning about this database’s scaling, replication, and sharding abilities.

By the end of this course, those examples you’ve been working on will all fit together to form a complete, working web application that’s fully integrated with MongoDB. And not only that, you’ll have the confidence, knowledge and practice needed to start working on your own MongoDB projects straight away.

Your instructor, Brett Hooper, is a seasoned software engineer with a 20+ year IT career, which includes Fortune 200 clients and the US Dept. of Defense.

About MongoDB

MongoDB is an open source database with a document-oriented data model. It differs from a relational database in that instead of storing data in tables and rows, it stores JSON-like documents with dynamic schemas. Because of this, it lends developers the ability to create applications rooted in data in ways they never could before.

Total Training

Total Training is a pioneer in innovative online training for leading creative design, digital video, office productivity software programs, and more.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

HISTORY

Total Training was founded in 1996 to provide the highest quality instruction to users of creative software. Recognizing that printed instruction was tedious, and classroom training was hard to find and often prohibitively expensive, Brian Maffitt, Total Training CEO and President collaborated to create the first video series, Total AE. The response was overwhelming.

2:50  Hours

50 Lessons

Lifetime Access

Course Curriculum

Preview Course

Introduction to the Course
Welcome to MongoDB made easy! (0:43)
How this will go (7:03)
Our Hands-On Project (1:19)
Setup Our Tools (11:40)
Section Recap (0:38)
Setup Our Project
Section Introduction (0:40)
Import Data with MongoImport (2:46)
Use the Mongo Shell (5:33)
Javascript in the Mongo Shell (1:41)
Section Recap (1:23)
Start with Queries and Operations
Section Introduction (1:11)
Retrieve data with .find() (5:42)
Create data with .save() & .insert() (3:13)
Update data with .update() (4:16)
Deleting data with .remove() (2:41)
Display User Data in our App (5:58)
Section Recap (1:00)
Model New Entities
Section Introduction (0:49)
Rules for Modeling (3:10)
Simple & Complex Models (2:40)
Modeling ‘Event’ Data (5:52)
Modeling ‘Event Registration’ data (5:42)
Section recap (0:46)
Index MongoDB
Section Introduction (0:42)
Indexing in MongoDB (2:00)
Using Indexes (1:26)
Creating Indexes (3:32)
Section Recap (0:49)
MongoDB Aggregation Framework
Section Introduction (2:07)
Aggregation Concepts (1:30)
Pipeline Stages & Operators (2:25)
Aggregation in our Project (3:02)
Use our Aggregated Data (5:25)
Section Recap (1:40)
Replication and Sharding
Section Introduction (1:25)
What are Replica Sets? (2:09)
Automated Failover (1:47)
What is Sharding? (1:19)
Rules for Sharding data (3:38)
Section Recap (0:55)
Our Web App
Section Introduction (6:07)
Our Project’s State (4:59)
Our app.js file (5:14)
Our Aggregate Queries (2:56)
Section Recap (3:27)
Course Outro
Section Introduction (3:48)
Learning Objectives & Project Requirements Review (7:20)
Where to go from here (4:15)
Section Recap (1:05)
Appendix
Recovering MongoDB in Cloud9 (4:11)
RESOURCES
Project Files – Learn MongoDB from Scratch

MySQL Fundamentals

MySQL Fundamentals

Instructor: Total Training

OverviewDescriptionAbout

Learn the most popular free web database – MySQL!

This MySQL Fundamentals course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you’ll need to use MySQL in the real world.

This MySQL Fundamentals course will start at the very beginning, with lessons on what MySQL is and how it works, to installing MySQL, then moving on to all the basic skills you’ll need to use MySQL in the real world. You will also learn the popular new MySQLi framework. MySQLi is the next generation of MySQL, and if you know this now you will be ahead of the competition for a long time to come.

This course also includes two real life projects. After you’ve gained an understanding of how MySQL works, you’ll learn how this technology is used on real websites.

Total Training

Total Training is a pioneer in innovative online training for leading creative design, digital video, office productivity software programs, and more.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

HISTORY

Total Training was founded in 1996 to provide the highest quality instruction to users of creative software. Recognizing that printed instruction was tedious, and classroom training was hard to find and often prohibitively expensive, Brian Maffitt, Total Training CEO and President collaborated to create the first video series, Total AE. The response was overwhelming.

5:30  Hours

38 Lessons

Lifetime Access

Course Curriculum

Preview Course

1. Introduction to MySQL
What Is MySQL? (6:00) (6:00)
Installing MySQL (7:27) (7:27)
Accessing the MySQL Monitor (6:42) (6:42)
Using PHPmyAdmin (8:55) (8:55)
2. The Basics of MySQL
Creating Databases (6:40) (6:40)
Deleting Databases (4:33) (4:33)
Creating Tables (7:51) (7:51)
Listing and Describing Tables (4:38) (4:38)
Auto Increment IDs (10:02) (9:42)
Inserting Records (9:42) (7:05)
Selecting Records (7:05) (1:27)
Renaming Tables (1:27) (10:02)
Deleting Records (2:10) (9:11)
Updating Records (9:11) (2:10)
Limiting Records (8:27) (8:27)
Ordering Records (6:39) (6:39)
Joins (16:12) (16:12)
Like Clause (7:24) (7:24)
Counting Records (10:54) (10:54)
3. Introduction to MySQL and PHP
Introduction to MySQLi (5:46) (5:46)
Introduction to PHP Data Objects (5:16) (5:16)
4. MySQLi Basics
Getting Connected (8:58) (8:58)
Basic Queries (5:37) (5:37)
Getting Results (9:06) (9:06)
Getting Result Counts (3:43) (3:43)
Looping Through Results (8:24) (8:24)
SQL Injections (16:22) (8:43)
Variables in Queries (8:43) (16:22)
Escaping Values (6:54) (6:54)
Prepared Statements (9:45) (9:45)
5. Project – Creating a Database Wrapper
Introduction (4:46) (4:46)
Creating a Test Database (2:05) (2:05)
Basic Functionalities (18:28) (18:28)
Adding More Functionalities (21:51) (21:51)
6. Project – Building a Contact Form
Introduction (1:43) (1:43)
Creating the Table (1:07) (1:07)
Inserting Your Records (6:11) (6:11)
Outputting the Data (10:54) (10:54)
Project Files Included
Project Files – My SQL Fundamentals

MySQL For Beginners

MySQLi For Beginners

Instructor: Total Training

OverviewDescriptionAbout

Learn essential MySQLi concepts & best practices.

This MySQLi for Beginners training course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection.

This MySQLi for Beginners training course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.

Benefits of MySQLi:

  • An object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging support
  • Embedded server support

A knowledge of PHP and MySQL is recommended for this course.

Total Training

Total Training is a pioneer in innovative online training for leading creative design, digital video, office productivity software programs, and more.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

HISTORY

Total Training was founded in 1996 to provide the highest quality instruction to users of creative software. Recognizing that printed instruction was tedious, and classroom training was hard to find and often prohibitively expensive, Brian Maffitt, Total Training CEO and President collaborated to create the first video series, Total AE. The response was overwhelming.

1:50  Hours

14 Lessons

Lifetime Access

Course Curriculum

Preview Course

CHAPTER 1: INTRODUCTION
Introduction (5:21)
CHAPTER 2: GETTING STARTED WITH MYSQLI
Connecting To A Database (7:55)
Connecting Using PHP (9:42)
Creating a Database Table (3:38)
CHAPTER 3: FETCHING RESULTS
Pulling Single Records (4:43)
Pulling Multiple Records (9:11)
Different Result Types (5:26)
CHAPTER 4: GETTING RESULTS
Counting Results (9:25)
Updating and Seeing Affected Rows (4:46)
CHAPTER 5: SECURITY
Escaping (12:33)
Prepared Statements for Inserting (8:14)
Selecting Prepared Statements (5:42)
CHAPTER 6: FINISHING UP
Freeing Results (2:48)
Closing the Database Connection (2:14)
Project Files Included
Project Files – MySQLi for Beginners

$29

$14.50