Best Free Database Design & Development Courses

Find the best online Free Database Design & Development Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

Big Data and Hadoop Essentials

Essential Knowledge for everyone associated with Big Data & Hadoop

Created by Nitesh Jain - Hadoop and Data Analytics Instructor

"]

Students: 158982, Price: Free

Are you interested in the world of Big data technologies, but find it a little cryptic and see the whole thing as a big puzzle.

Are you looking to understand how Big Data impact large and small business and people like you and me?

Do you feel many people talk about Big Data and Hadoop, and even do not know the basics like history of Hadoop, major players and vendors of Hadoop. Then this is the course just for you!

This course builds a essential fundamental understanding of Big Data problems and Hadoop as a solution. This course takes you through:

  1. Understanding of Big Data problems with easy to understand examples.
  2. History and advent of Hadoop right from when Hadoop wasn’t even named Hadoop.
  3. What is Hadoop Magic which makes it so unique and powerful.
  4. Understanding the difference between Data science and data engineering, which is one of the big confusions in selecting a carrier or understanding a job role.
  5. And most importantly, demystifying Hadoop vendors like Cloudera, MapR and Hortonworks by understanding about them.

Unlock the world of Big Data!!!

Best part is that this course is Free of cost!!! (Best things is life are free :))

MongoDB Essentials – Understand the Basics of MongoDB

An introduction and overview of MongoDB as a NoSQL database solution.

Created by Patrick Schroeder - Software Developer

"]

Students: 101317, Price: Free

This is a beginners level course to understanding the basics of what mongoDB is.

The intention of this course is to provide a foundation for working with mongoDB so that you can start developing applications that require a database storage.

In this course we will cover:

  • How to install mongoDB.
  • How to create new collections that store documents.
  • You'll learn about the most used mongo shell commands to manage your documents.
  • We'll cover the different types of data that can be stored.
  • You will gain confidence in how to Create, Read, Update and Delete data.
  • Learn how to build models for the database in code using Mongoose Schemas.
  • Learn how to query for specific data your looking for using $in.

Course Format:

You will be presented with slides and command line examples. This will help you to learn how to use local instances of mongoDB.

There will be a quiz at the end to help reinforce what you've learned.

Database Design and Management

Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.

Created by Visual Paradigm - Design & Management Tool for Business IT System Development

"]

Students: 74819, Price: Free

Database Design and Management is tailor-made for software development teams who need to develop application or software system that require data persistence. There are altogether 14 lectures with more than 2 hours of quality videos. All lectures come with clear voice-over as well as demonstrations to walk you through different tools step by step. We are sure you can master database design and management skills with ease and learn most key features in Visual Paradigm after attending the lectures.

The lectures cover a wide range of contents. Firstly, you will start by an introduction of database design, with description of ERD, entity and column. After gaining a better knowledge about ERD, you can then jump to keys, relationships, database view, triggers and stored procedures. This course also covers database management skills like the generation of database from ERD, database patching and reverse engineering of ERD. Developers may want to study the lecture about ORM for system development with database. Last but not least, the training introduces some best practices in database design and management, as well as the usage of data specification.

Once you have completed this online training, you will know how to design database productively and effectively.

Oracle SQL – A Complete Introduction

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

Created by Ben Brumm - IT Software Consultant

"]

Students: 68457, Price: Free

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, 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 learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

The Ultimate Guide in Becoming a SQL Server DBA

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 61017, Price: Free

The primary purpose of this course is to give the student a sample of what the SQL Server administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real world IT industry.  These courses are SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, Learn T-SQL and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

Master MongoDB, the NOSQL leader with Clarity and Confidence

Learn MongoDB - Updated Every Week 100+interview Questions 100+Quizzes 60+Assignments mongobooster java C# nodejs php

Created by Gandhi Kumarasamy Sezhian - Sr.Architect ,Senior Solutions Developer , Entrepreneur

"]

Students: 41902, Price: Free

More than 80+ ***** 5 Star Reviews

its all in one for all level all roll if you DBA or developer iam
devops and work with mongo for about 4 years but these course help me to
make farther progress in the area
-Almaamon Rasool Abdali Hussain

Lots of hands-on demos and samples. -Michie Reigle 

Great teaching and good material so far -Nícolas Lima

good content and excellent explanations-Benjamin Abba

MongoDB is undeniably creating huge impact among enterprises , challenging oracle and other established vendors.

Do Search in the Google for - mongodb ranked 2nd next to oracle

Do Search in the Google for - DBRankings Mongodb

With a huge list of well known customers, its being used by top technological companies such as SAP, Expedia,EBAY, Craigslist, BOSCH,Amadeus, AOL, SAGE,CISCO, EA and many others in completely different Verticals. 

Do Search in the Google for - who uses MongoDB 

This course will provide you with greater information and confidence to explore mongoDB , without loosing interest and  its easiness.

The course is updated Every Week. It has 100+interview Questions 100+Quizzes 60+ Assignments with 5 tools, 4 languages.

 MongoDB when compared to traditional databases, is 10 times simpler in installation, management and in features. Its simply the Modern database,for the cloud era. 

The course is clearly organized into 4 sections, with  7 most important things to know about MongoD, Thinking about MongoDB topics,which will help the students to think and derive the MongoDB features ,before they get into the details of it.

In this Course I'm Covering the basics with JSON ,4 Useful tools to learn mongodb easily and  advanced topics such as sharding , replication, Mapreduce.

Two Very Useful MongoDB BONUS Sections

Bonus section 1 -Learn MongoDB < 50 Mts - Get a Quick Bootstrap on Key topics. A very useful one. 

Bonus Section 2 - Work with MongoDB using 4 programming Languages

  1.   Java
  2.   C#
  3.   PHP
  4.  NodeJS

The course contents are updated Every Week .

OrientDB – Getting Started with Graph and Document Databases

A full introductory course to OrientDB, the Document-Graph database. Learn about NoSQL's latest trend: GraphDBs!

Created by OrientDB Team - Free OrientDB Getting Started Training

"]

Students: 39726, Price: Free

  Graph databases are among the fastest growing trends in technology. Helping you effectively manage modern, highly connected data is the key benefit of a OrientDB. This course will provide you a comprehensive overview of the multiple models supported by OrientDB, with bigger focus on Graph and Document principles as well as walk you through hands on examples of working with the database and its API. 

Learn Power BI Fast

Build a professional Power BI report in less than 2 hours. Learn data visualization basics and advanced techniques.

Created by Parker Stevens - SQL/BI Developer

"]

Students: 33672, Price: Free

Microsoft Power BI is one of the most robust business intelligence software on the market and it so happens that it's one of the cheapest! Anyone can start building their own data visualizations for free. If you own your own business and want to harness the power of your data or if want to start a career in Business Intelligence, Power BI is a great tool to leverage.

This course will walk you through the entire process of making your first Power BI dashboard. By the end of the course, you will be able to create visualizations using your own data and add value to your company.

First, I walk you through how to download Power BI. Since there is no better practice than by doing it yourself, we will be using a publicly-available database called AdventureWorksDW2012. I will guide you in how to install SQL Server Management Studio and configure the database so that you can perform the lessons right alongside me.

Next, we take a tour of Power BI and create our first visualizations using data that we retrieve from the database. You'll learn about all of the different chart types and when to use them.

Later, we dive into some more advanced topics including how to calculate your own columns and measures and how to leverage DAX (Data Analysis Expressions) to perform complex calculations.

We then move on the styling your report. Arguably one of the most important parts of report building, you need to make sure it looks good or no one will want to use it. Take my word for it.

We finish up with how to share your reports. This involves setting up your workspace in Power BI Service, pushing your report up the cloud, and then publishing your hard work for others to see.

At this point, you will be proud of what you have built and you will hopefully see just how addictive building data visualizations in Power BI can be. Without further ado, let's get started!

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York

Created by Shivgan Joshi - Free Python Class Bootcamp Big Data Science NYC 312 285 6886

"]

Students: 29045, Price: Free

SQL 101 Bootcamp is build up based on the SQL classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Analytics in SQL  if you have never programmed.

This course will help you answer and critically think and implement:

  1. Create a DB design for your day to day work data that you use in Excel

  2. Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.

  3. Understand Data Wrangling using Group, Joins and UNION to get data in the format you need

  4. For any data that comes to you new tools get new insights

  5. Get Excel equivalent functions for SQL commands

  6. Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)

Other areas that will be introduced to are:

  1. Understand why SQL is needed as a solution to limitation of excel

  2. Connect to the SQL Server database and execute a simple query.

  3. Include a search condition in a simple query.

  4. Use various functions to perform calculations on data.

  5. Organize data obtained from a query before it is displayed on-screen.

  6. Use New York City data for running on SQL

SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

Created by Sagar Uppuluri - Software Architect and a passionate trainer

"]

Students: 28323, Price: Free

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant. 

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema. 

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features.  Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

Microsoft SQL Server – An Introduction (2018 edition)

A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 27199, Price: Free

This course is a brief presentation of SQL Server.

We will install a version of SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.

No prior knowledge is required - just a willingness to learn.

See you on the course.

Getting Started with Elasticsearch

Learn basics of Elasticsearch from scratch with this 101 course and become an Elasticsearch Padawan.

Created by Sezin Karli - Principal Software Engineer | Elasticsearch Instructor

"]

Students: 26349, Price: Free

From real-time search and event management to sophisticated analytics and logging at scale, Elasticsearch has a great number of uses. Getting Started with Elasticsearch course will help you learn the basics of Elasticsearch. If you already have a knowledge of Relational Databases and you are eager to learn Elasticsearch, then this course is for you. You will end your journey as a Elasticsearch Padawan.

Content and Overview

You will begin learning Elasticsearch with a gentle introduction where you can setup your environment and launch your node of Elasticsearch for the first time. After that, we will dive into Create/Read/Update/Delete operations where you will grasp basics of Elasticsearch. All lectures are up to date with Elasticsearch 2.0.

SQL Tutorial for Beginners – Learn SQL using 30 scenarios

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 26188, Price: Free

SQL Tutorial for Beginners in 2020- Learn SQL quickly using 30 Scenarios on Mac and Windows

A comprehensive course to teach you SQL on Mac and Windows.

If you are looking for a complete SQL tutorial for beginners, this tutorial is a great way to learn SQL using 30 real-time scenarios.

You will be able to write SQL queries confidently by just practicing the 30 scenarios in this SQL Tutorial.

You can learn SQL on Mac and Windows from this SQL Tutorial. This SQL Tutorial will cover all the topics of Structured Query Language(SQL) starting from scratch. This tutorial is great for beginners who want to learn SQL and for professionals who want to brush up their SQL Skills.

Structured Query Language(SQL) is supported by various database management systems(DBMS).

In this SQL Tutorial, we will be using SQL Server to learn SQL on both Mac and Windows.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.Even if you use a different DBMS like MySQL, you can benefit a lot from this SQL Tutorial as more than 90% of the SQL skills you learn in this tutorial is easily transferable to other database management systems(DBMS).

What you'll learn from this SQL Tutorial:

1.Start from scratch installing SQL Server on Mac and Windows in 2020.

2.Learn SQL quickly using 30 real world Scenarios

3.Learn SQL using Azure Data Studio on Mac and Windows

4.Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows

5.Download and Install Azure Data Studio on Mac and Windows

6.Model real-world scenarios and write SQL queries across multiple tables

This beginner's course is for you if you want to learn SQL Skills in Mac or Windows.

AWS Tutorials – DynamoDB and Database Migration Service

Hands on video showcasing AWS DynamoDB and Database Migration Service

Created by Namrata H Shah - Technology and Management Leader

"]

Students: 21041, Price: Free

AWS is one of the fastest growing cloud platform. I have specifically created these tutorials for folks who have the drive and want to learn more about AWS. In this course, you will find tutorials for DynamoDB and Database Migration Service.

You will learn with hands-on tutorials how to leverage --

AWS Database Migration Service (DMS) to -

1. Migrate data from MySQL to S3

2. Migrate data from S3   to MySQL       

3. MS SQL EC2 to MS SQL RDS   

AWS DynamoDB to -

1. Create Table

2. Insert Items

3. Scan and Query Table     

4. Calculate Read and Write Capacity Units

SQL Server Baby Step: Installation and Configuration

An absolute beginner’s tutorial to quickly learn how to setup Microsoft SQL Server practice environment on your machine.

Created by Rashid Khan - Microsoft Certified-Business Intelligence Consultant

"]

Students: 18786, Price: Free

Scope of this course is confined to the following learning objectives ONLY:

  • Start from scratch by installing Microsoft SQL Server Express edition

  • Requirements for installing Microsoft SQL Server

  • Discussion around some of the basic configuration option, including "sa" login

  • Making use of Adventure Works sample database

  • More in depth coverage of relational database in general, and Microsoft SQL Server in particular, in my another course

AWS RDS Databases – Fast Track

Fast-track training to work with relational databases on AWS Cloud using AWS Relational Database Service.

Created by Siddharth Mehta - Enterprise Cloud Architect, Published Author, Cloud Geek

"]

Students: 16849, Price: Free

Hi! Welcome to the AWS RDS Databases - Fast Track Training, the only comprehensive and most impactful course on AWS RDS that is available FREE of Cost. This is the only course you would need to get started with AWS RDS.

This course is taught by an Enterprise Cloud Architect, who leads large teams of junior architects in the real world, who has an industry experience of close to two decades in the IT industry, who is a published author, and leads technology architecture of XXX million dollar projects on cloud for multi-national clients.

This course teaches to work with the following AWS RDS Databases along with its related client tools like HeidiSQL, PgAdmin and Oracle SQL Developer. So if you are new to AWS RDS or are preparing for a quick technical discussion on AWS RDS with very limited time at hand, this is the perfect course for you.

  • MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Organizations like Wikipedia, WordPress and Google uses MariaDB. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data.

  • PostgreSQL is the one of the world’s most advanced open source and popular database. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. It is abbreviated as Postgres because of ubiquitous support for the SQL standard among relational databases.

  • Oracle is a proprietary multi-model database management system from Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads.

This course is composed of almost 90% labs and also covers the fundamental theory of important AWS RDS Concepts with some basic FAQs as well. After pursuing this course, if you have any questions related to the subject or need suggestions about pursuing the next course related to AWS data services, please do not hesitate to contact me.

I hope to see you soon in the class !

Develop Database Application with Minimal Coding – Kushal

Simple Software to Design, Develop Database Application with Minimal Coding

Created by Kotaa Krishna Kamath - Software Architect by Enthusiasm

"]

Students: 16162, Price: Free

         Coding an Application is not everyone's cup of tea. 

         Using Kushal you can develop a Database Application with Minimal Coding. 

         You just need to know about preparing Database and SQL 

         If you feel developing database applications take a lot of time, not to worry you are in right place. 

         This tutorial will help you understand how to create a simple database and develop a database application without manual coding. 

         At the end of this training you will be able to: 

         1. Understand how to Create a Database from Excel

         2. How to create Complete Software - Including Coding, Testing, Documentation, Installation Building using Kushal

         3. You will become familiar with Kushal registration and procurement. 

         Whether you are a student, database administrator, tester, graduate, application developer, excel expert or advanced computer user. 

         In 9 Sections of around 4 minutes each, we will go from scratch to develop fully functional contact management software. 

  Happy learning  !!! 

      _________________________________________________________________________________ 

  ERachana Technologies. 

   Like us on Facebook for updates regarding Kushal

       _________________________________________________________________________________ 

     

Filemaker Beginner Tutorial – contacts database

Get to know Filemaker by designing a simple contacts database with some fun features.

Created by Guy Stevens - Filemaker freak

"]

Students: 15933, Price: Free

In this course you will learn how to make a complete Filemaker database system for your company.

In this case it will be a contact database. We will be storing contacts, creating notes and seeing their address on a map. We will be creating tasks to keep track of the things we need to do and see which tasks are already done.

This is a course for people who own a small business and can’t afford to buy expensive software packages to manage their administration. For people who don’t want to spend hours each week doing boring, monotonous paperwork that can be automated and be made fun and professional looking.

I included the Filemaker file in the course for download so you can easily look at my file if you get lost somewhere or if there is something you want to look at more closely in detail.

At the end of this course you will be able to start your own FIlemaker projects and build them exactly the way you want them so they work for your company and not the other way around.

Introduction to SQL Using TeamSQL

Learn the basics of SQL using TeamSQL

Created by Can Abacigil - Co-founder @ TeamSQL

"]

Students: 15748, Price: Free

In this course, we will cover the basics of working with SQL using TeamSQL. After a quick intro on how to use TeamSQL, which is the data management tool we'll use for this course, we will cover basic queries, including how to return and filter data, SQL joins, and writing complex queries (including operators and subqueries). We will also cover the basics of data table management. We end this course with coverage of TeamSQL's features that are designed to help manage your data. These features include working with snippets, data grid filtering, table structure previews, and exporting data from TeamSQL.

New in Big Data: Apache HiveMall – Machine Learning with SQL

HiveMall SQL on Spark, MapReduce and Tez. Leverage your knowledge of SQL to enter Machine Learning and Big Data space.

Created by Elena Akhmatova - Data Scientist

"]

Students: 14129, Price: Free

It is widely accepted that applying Machine Learning techniques to data is a complex task that requires knowledge of a variety of programming languages and means hours of coding, compiling and debugging.  

Not any longer!

Apache HiveMall is a Machine Learning library that allows anyone with basic knowledge of SQL to run Machine Learning algorithms. 

  • No coding
  • No compiling
  • No debugging

Apache HiveMall algorithms are hidden behind Hive UDFs. This allows end user to use SQL and only SQL to apply Machine Learning algorithms to a very large volume of training data.

Apache HiveMall Machine Learning Library makes training, testing, and model evaluation easy and accessible to a much wider community of business experts than ever before.

Oracle SQL: An Introduction to the most popular database

A quick tour of the six principal clauses of the SELECT statement.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 11359, Price: Free

This course is a brief presentation of Oracle SQL.

We will install a version of Oracle Express Edition and Oracle SQL Developer for free.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it..

No prior knowledge is required - just a willingness to learn.

See you on the course.

Learn Basic DB2 on Mainframe for Beginners

Understand the DDL and DML operations on DB2.

Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor

"]

Students: 10327, Price: Free

Note:

This Course is NOT a DB2 DBA COURSE and is not related to Database administration. 

The Course provides the basic introduction to DB2 and trains on the DML operations on 

Mainframe. Most of the DDL operations on DB2 are carried out by DB2 DBA and this course 

gives a brief introduction of DDL operations which Mainframe Developer should be aware of.

Why should I Learn DB2  on Mainframe?

  • Most of the projects on IBM Mainframe requires DB2 Knowledge.
  • Most of the Projects uses COBOL DB2 Programs.
  • If you know DB2 , it adds value to your career and resume.

Is this Course for DB2 DBA?

No, this Course is for Developers who work on IBM Mainframe. This Course covers major DDL operations from developers point of view(not DBA's Point of view). Major DML operations are also covered. Please do not worry, if you do not know what is DDL and what is DML. This is covered in the course.

Which topics are covered in this Course?

  • This Course Covers all DML operations  for Mainframe Developers.
  • Students will get trained on how to create a table, view and index.
  • The Course teaches you - How to Insert records into table, update records, select the records from the table

Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

Created by Tarang B. Patel - Web Developer and CEO at ValsadMarket

"]

Students: 9304, Price: Free

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

  • General knowledge of what a Database is.

  • Different versions of SQL Server 2014

  • How to install SQL Server Express 2014

  • Create a database in SQL Server

  • Create tables in SQL Server

  • Add data into tables in SQL Server

  • Set foreign key relationships between tables

  • Delete data from tables

  • Update data in tables.

  • backup and restore database

SQL Server For Beginners – Part 1

Sql Server querying essentials and concepts

Created by Bytescout Academy - Bytescout Learning Academy

"]

Students: 8019, Price: Free

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. Introduction and Essentials

    • Introduction - Part 1

    • Introduction - Part 2

    • Introduction - Part 3

    • Introduction - Part 4

Getting Started with ArangoDB

ArangoDB: One engine. One query language. Multiple models.

Created by Christopher Woodward - Developer Relations Engineer

"]

Students: 7611, Price: Free

Note: Udemy has recently changed its policy on free courses and no longer provides completion certificates for free courses. 

However, you can now take your skills to the next level and become an ArangoDB Certified Professional by taking our FREE official exam! Visit the official ArangoDB website for more information on the FREE certification exam.

This course will provide everything you need to get up and running with ArangoDB.

This course introduces you to

  • A brief history of databases

  • The basic AQL syntax

  • Performing CRUD operations with AQL

  • Data modeling

  • Indexing

  • Joins

  • Grouping and Aggregation

  • Graphs

  • An intro to the Foxx Microservices Framework

The second section (coming soon) of this course covers some more advanced and enterprise features including:

  • Smart Joins

  • Smart Graphs

  • Setting up a cluster environment

  • Deployment

  • And more

We hope by the end of this course you will have a better understanding of everything ArangoDB has to offer, what a native multi-model database is, and have the confidence to know when ArangoDB is the best solution for your product.

SQL 101: A Beginners Guide to SQL

A gentle introduction to the world of SQL

Created by Sean Coyne - Manager, Data Engineer, Nerd

"]

Students: 7433, Price: Free

Why Learn SQL?

We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.

Take-Away Skills:

In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice hands on—how to manipulate data and build queries that communicate with more than one table.

Learn MongoDB in 2 hours

Learn MongoDB in simple fastest manner using this beginner's tutorial containing basic to advanced knowledge

Created by Navdeep Kaur - TechnoAvengers.com (Founder)

"]

Students: 7310, Price: $19.99

MongoDB is one of the most popular NoSQL document oriented database written in C++.

This tutorial will help you get started quickly to use MongoDB with lots of hands-on exercises. This tutorial is intended for students and new developers who are eager to learn MongoDB Database in easy and fastest possible manner.

This tutorial will provide you MongoDB concepts which will help you to get started with MongoDB quickly. It will starts with Mongo Introduction and then we will use MongoDB Atlas (Free cloud cluster provided by MongoDB) to setup our environment. We will continue our course by deep diving into various CRUD operations such as inserting, reading, applying filter, updating, deleting and using projections. Then we will work with various relevant operators that can be used with MongoDB on day to day basis. Then we will do a lots of hands on exercise to work with complex data types such as Array i.e performing CRUD with complex types along with projections.

I am just bootstrapping this course but next coming days , this course will get updated with more advance topics such as Working with Indexes, using Aggregation Framework, moving from shell to drivers and start using MongoDB GUI

So let's get started with this exciting course!!!!!

Microsoft SQL Crash Course for Absolute Beginners

This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.

Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor

"]

Students: 7238, Price: Free

'This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.

"Welcome to the most popular Quality crash Course on Microsoft SQL Server(MS SQL Server)"

  • Covers different forms of SELECT Statements

  • Explains how to filter the Records

  • All the Arithmetic operators are explained

  • NULL Values are explained

  • Beautiful examples of all the operators

  • ORDER BY, GROUP BY, HAVING clauses has examples in detail

  • The course covers all the Aggregate Functions and other Functions

  • UNION and JOINs are explained with real-life examples

  • I have explained all types of Joins

  • Data types used in Microsoft SQL

======================================================================================

Join this course which is the best "Microsoft SQL" course. I will share all the syntax of SQL with multiple examples along the way!!!

Want to start learning SQL from scratch with no previous coding experience?

You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?

  • I have shared all the codes which are used in this course

  • Is the Course taught by a real-time expert? I have more than 15  years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.

  • Is the Course content clear and Precise? The content is short, crisp, and clear.

  • The course assumes no prior knowledge of MS SQL(Microsoft SQL Server) and teaches you from scratch to an advanced level

  • Once you Enroll in this Course, you get lifetime access to this course and you will get all the future updates.

  • The course does not cover T-SQL directly but it will help you to learn T-SQL also.

  • This will also help you to get Microsoft certification.

  • This Course is not for DBA(Database Administration) but certainly, helps you to become better.

  • If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.

  • If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.

Do you want to start on SQL but have no experience with SQL? 
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.

There’s no risk involved in taking this Course!
I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.

What if you are stuck?

I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.

Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.

Once you enroll for this course-

1) Selecting Records from Table - SELECT statement in SQL

2) Filtering the Records - Using WHERE clause in SQL

3) Sorting Records - Using ORDER BY clause

5) Grouping data - using GROUP BY clause

6) complete guide with examples of all the Functions - All aggregate functions covered

7) Creating simple and advanced Tables - with constraints and without constraints

8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX

9) Inserting records(loading) - with INSERT Statement

10) Updating the records of a Table - Using UPDATE statement

11) Combining multiple tables - Using UNIONS

12) Joining multiple columns of different tables - Using JOINs

13) Modify table properties - ALTER statement

14) Deleting records from the table - DELETE statement

15) Removing tables from the database permanently - DROP statement

Note: This course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.

Microsoft SQL Server- Getting Started on Mac and Windows

SQL for beginners 2020 - How to install SQL Server on Mac and Windows with sample database- Installation Tutorial (FREE)

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 6715, Price: Free

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

In this course, we will teach you how to install SQL Server 2017 Express edition for free on both Mac and Windows.

Then will teach how to connect to the SQL Server that you installed using Azure Data Studio.

And finally, will teach how to download and install a sample database(AdventureWorks) from the official Microsoft website for free which you can use in our next FREE course to learn SQL programming using real scenarios.

This course will be your first and most important step towards learning SQL programming on Microsoft SQL Server.

No prior knowledge is required - just a willingness to learn.

Real World MYSQL Database Design & Management Projects 2021

Master SQL by creating complex databases & building reports through real-world projects-MySQL, PHP, HTML, CSS, Bootstrap

Created by TheMachineLearning.Org . - Machine Learning Engineer

"]

Students: 6645, Price: Free

  1. Easy to use: As it supports SQL language, users don’t need to be technically expert to access the database. It can be easily accessed by users with basic SQL knowledge and experience on other relational databases.

  2. Cost Free: Another benefit of using this database is that the user doesn’t have to spend money to pay the license fee, as it is free of cost and available on the official website for download.

  3. Customizable Code: As it is available as an open-source tool, software developers have an option to customize the source code as per their own applications and use it. The source code is freely available to web users. The do’s and don’ts of the software are defined in GPL i.e. GNU General Public License.

  4. Secured: It offers one of the most secured databases in the world and hence used by well-established web applications like Facebook, Twitter, Instagram, etc. Its various security features like Firewall, Encryption, and User Authentication are the helping hands in protecting sensitive user information from intruders.

  5. Better Performance: It supports the multi-engine storage feature which facilitates database administrators to configure the database in a way to balance the workload. Hence, it makes the database flawless in terms of performance.

  6. High Availability: It offers 24*7 hours availability and offers solutions like Master/Slave Replication and specialized Cluster Servers.

  7. Scalability: It offers very good scalability to web applications through MySQL Thread Pool provided by MySQL Enterprise Edition. A thread pool provides a model that is used for managing threads (or processes), like the multi-user connections overhead and execution requests, in a hassle freeway.

  8. Platform-Friendly: It is a platform-friendly database supporting a number of platforms like Microsoft Windows, Oracle Solaris, AIX, Symbian, Linux, MAC OS, etc.

  9. Friendly Interface: It has a user-friendly interface with a lot of self-management features and different automated processes like configuration and administration-related tasks, which allows users to do the job effectively from Day 1.