Best Database Design & Development Courses

Find the best online 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. We also have a separate page listing only the Free Database Design & Development Courses.

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Become an In-demand SQL Master by creating complex databases and building reports through real-world projects

Created by Colt Steele - Developer and Bootcamp Instructor

"]

Students: 252320, Price: $89.99

Students: 252320, Price:  Paid

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.  

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.  

In this course, you will:

  • Learn the ins and outs of SQL syntax

  • Generate reports using sales and user data

  • Analyze data using Aggregate Functions

  • Run complex queries using MySQL logical operators and string functions

  • Write all the common SQL joins

  • Work with large datasets containing thousands of entries

  • Build a web app using MySQL and NodeJS

  • Design and implement complex database schemas

  • Learn to navigate the treacherous world of storing dates and times

  • Clone the database structure of a photo sharing social network

  • Write Javascript code to generate fake data sets

  • And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Why This Course Is Different  

This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).

My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.   

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

So let’s do this! Enroll today and start learning SQL!

SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1

Master yourself in SQL, do practical projects with MySQL, PHP and Python

Created by Creative Online School - Creative & Engaging Online Courses

"]

Students: 221038, Price: $89.99

Students: 221038, Price:  Paid

=== Our students' reviews regarding this course ===

"it's good that the course focuses more on the application part rather than just giving some bookish theories or concepts which anyone can read for the plenty of textbooks." -- Deepanshu Kumar

"Very clear and straight forward." -- Chakri Muthyala

"really very explanatory and easy to understand" -- Sekh

"simply the best" -- Frederick Ekow

"Very Informative Course. Thank You" -- Subrata Debnath

"So far so good. The installation has a detailed guide every step of the way. This should be a benchmark for any other tutorials during the installation process of the software." -- Emilio Comiling

"Well based step-by-step information that is clearly understandable" -- Volodymyr Gorbachov

The programming language PHP is one of the most popular scripting languages. It is free, open-source, and server-side (the code is executed on the server). And MySQL is another one of the most popular Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). The combination of PHP and MySQL gives amazing and cool options to create amazing websites, APIs, web portals, and more.

By completing this course, you will be able to read and write basic and complex SQL queries using MySQL. This course gives you hands-on and practical experience on the world's most popular RDBMS databases like MySQL. These skills are also applicable to any other RDMBS  databases (Like Oracle, MS SQL Server, SQLite, etc). You will do several practical projects with MySQL, PHP & Python. 

Learning both SQL is one of the fastest ways to improve your career. Hope this course will be used as a helping hand for your prospective career. Please dig on free preview videos for more information.  

Practical Database Course for Beginners : 6 courses in 1

Become expert in RDBMS and NoSQL databases with hands on practical examples, exercises. MySQL, MongoDB, Redis, and more

Created by Creative Online School - Creative & Engaging Online Courses

"]

Students: 180809, Price: $89.99

Students: 180809, Price:  Paid

What our students says regarding this course! ---

"I am a beginner with Databases and SQL and this course has been very informative and easy to follow." -- Eve Grant

"The Course is very efficient i would highly recommend this course to all the newbies who are willing to learn Databases" -- Ikram Khizer

"Lovely! Compact course with proper guideline." -- Pensee Chouinard

"Good information to get started." -- Debashish Majumda

"Detailed explanation about installing XAMPP and MySQL Workbench" -- Samuel Omokhafe Yusuf

By completing this course, you will be able to read and write basic and complex queries using both RDBMS databases and NoSQL Databases. This course gives you hands-on and practical experience on the world most popular RDBMS databases like MySQL, and NoSQL databases like MongoDB,  Redis, more. This skills are also applicable to any other RDMBS  databases (Like Oracle, MS SQL Server, SQLite, etc) and NoSQL databases  (CouchDB, Amazon Dynamo DB, etc). 

Learning both SQL and NoSQL is one the fastest ways to improve your career. Hope this course  will be used as a helping hand for your prospective career. Please dig  on free preview videos for more information.    

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

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 :))

Apache Kafka Series – Learn Apache Kafka for Beginners v2

START HERE: Learn Apache Kafka 2.0 Ecosystem, Core Concepts, Real World Java Producers/Consumers & Big Data Architecture

Created by Stephane Maarek | AWS Certified Cloud Practitioner,Solutions Architect,Developer - Best Selling Instructor, Kafka Guru, 9x AWS Certified

"]

Students: 110782, Price: $99.99

Students: 110782, Price:  Paid

UPDATE SEPTEMBER 2018: Course newly recorded with Kafka 2.0!

Welcome to the Apache Kafka Series! Join a community of 20,000+ students learning Kafka.

Apache Kafka has become the leading distributed data streaming enterprise  big data technology. Kafka is used in production by over 33% of the Fortune 500 companies such as Netflix, Airbnb, Uber, Walmart and LinkedIn.

To learn Kafka easily, step-by-step, you have come to the right place! No prior Kafka knowledge is required

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

If you look at the documentation, you can see that Apache Kafka is not easy to learn...

Thanks to my several years of experience in Kafka and Big Data, I wanted to make learning Kafka accessible to everyone.

We'll take a step-by-step approach to learn all the fundamentals of Apache Kafka.
At the end of this course, you'll be productive and you'll know the following:

  • The Apache Kafka Ecosystem Architecture

  • The Kafka Core Concepts: Topics, Partitions, Brokers, Replicas, Producers, Consumers, and more!

  • Launch your own Kafka cluster in no time using native Kafka binaries – Windows / MacOS X / Linux 

  • Learn and Practice using the Kafka Command Line Interface (CLI)

  • Code Producer and Consumers using the Java API 

  • Real world project using Twitter as a source of data for a producer and ElasticSearch as a sink for our consumer

  • Overview of Advanced APIs (Kafka Connect, Kafka Streams)

  • Real World Case Studies and Big  Use cases

  • Overview of Advanced Kafka for Administrators

  • Advanced Topic Configurations

  • Annexes (starting a Kafka cluster locally, using Docker, etc...)

Note: The hands-on section is based on Java, which is the native Kafka programming language. But, good news! Your learning in Java will be completely applicable to other programming languages, such as Python, C#, Node.js or Scala, and Big Data frameworks such as Spark, NiFi or Akka

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

The Kafka for Beginners course is the best place to start your Kafka learning journey... Ask other students!

  • 5 stars: "That's one of the most high-quality on-line courses I ever took" – Paul L.

  • 5 stars: "This training was awesome and learned many things about KAFKA though having 0 years of experience in this technology" – Puneet G.

  • 5 stars: "Outstanding on all fronts! I wish all courses were that well presented. I especially appreciate the hands-on sections. I was able to get everything up and running with ease. Highly recommend this course and this instructor!" – David G.   

You can take this course risk-free and if you don't like it, you can get a refund anytime in the first 30 days!

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

Instructor

Stephane Maarek is the instructor of this course. He is a Kafka Expert, guest author on the Confluent Blog and Speaker at the Kafka Summit SF 2018. He's the author of the highly-rated Apache Kafka Series on Udemy, having taught already to 40,000+ students and received 12,000+ reviews.

He shares all his Kafka knowledge on the platform, taking the time to explain every concept and provide students with both theoretical and practical dimensions. You are in good hands!

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

This Course Also Comes With:

  • Lifetime Access to All Future Updates

  • A responsive instructor in the Q&A Section

  • Links to interesting articles, and lots of good code to base your next applications onto

  • Udemy Certificate of Completion Ready for Download   

This is the course that could improve your career!  

Apache Kafka is a skill in high demand and there are not enough people to fulfill all the open positions. You can boost your income, take on new roles and fun challenges. Many of my students are now the Kafka experts of their companies!

I hope to see you inside the course!

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

Note: Looking for more advanced Kafka concepts? There are many volumes in the Apache Kafka Series:

  • Learn Kafka for Beginners v2 (this course - great to start)

  • Kafka Connect Hands On Learning

  • Kafka Streams for Data Processing

  • Kafka Cluster Setup & Administration

  • Confluent Schema Registry & Kafka REST Proxy

  • Kafka Security (SSL SASL ACL)

  • Kafka Monitoring and Operations

Happy learning!

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

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.

MongoDB – The Complete Developer’s Guide 2021

Master MongoDB Development for Web & Mobile Apps. CRUD Operations, Indexes, Aggregation Framework - All about MongoDB!

Created by Academind by Maximilian Schwarzmüller - Online Education

"]

Students: 96229, Price: $89.99

Students: 96229, Price:  Paid

MongoDB is one of the most important NoSQL databases you can work with these days. It's extremely popular and MongoDB developers are in high demand.

No matter if you're building web applications, mobile applications or any other kind of application or if you're a data scientist - you'll need to work with data. Storing data, querying it efficiently and minimizing complexities whilst optimizing performance are crucial tasks.

MongoDB makes working with data simple - it's built on a philosophy that prioritizes performance and efficiency.

In this course, you'll learn all about MongoDB from scratch. No prior MongoDB or database experience is required!

In detail, you'll learn:

  • ... how to install and use MongoDB locally and in the cloud (MongoDB Atlas)

  • ... how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases

  • ... how to filter for data efficiently

  • ... how to work with both the Mongo Shell and drivers (e.g. Node.js driver)

  • ... how to increase performance by using indexes (and how to use the right indexes!)

  • ... how to use the amazing "Aggregation Framework" that's built into MongoDB

  • ... what replica sets and sharding are

  • ... how to use MongoDB Atlas - the cloud solution offered by MongoDB

  • ... how to use the serverless platform (Stitch) offered by MongoDB

  • ... and much more!

This course is a hands-on course - you'll learn by writing code/ commands. We'll work on a wide variety of example data and use-cases and by the end of the course, you'll have all the knowledge you need to work with MongoDB in your next project!

This course is for you, no matter which programming language you plan on using, you'll learn a uniform way of interacting with MongoDB that can be easily applied to any language.

This course is for you:

  • ... if you're brand-new to MongoDB and databases in general

  • ... if you got some basic database or even MongoDB experience - in this course, there are different entry points you can choose from!

  • ... if you are a web or mobile app (or desktop app) developer who considers using MongoDB

  • ... if you're working in a team that considers using MongoDB (or already does use it)

  • ... if you are primarily using SQL-based databases so far and you want to explore the most popular NoSQL alternative

This course is NOT for you:

  • ... if you're looking for a guide on administrating MongoDB servers => This course focuses on the commands/ queries you write, it's NOT an administration course. I will show (in detail) how to deploy a ready-to-use cloud MongoDB solution that follows best practices though.

MySQL Database Development Mastery

Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench

Created by Trevoir Williams - Mr.

"]

Students: 93051, Price: $89.99

Students: 93051, Price:  Paid

Overview

This is a zero to hero course on MySQL Database Server and MySQL Workbench. There are no pre-requisites for this course. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.

Why Learn MySQL

MySQL is the world’s most popular open source database. With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter and YouTube.

We will explore best practices in database development using MySQL Database Server and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What you’ll learn

  • Install MySQL Server

  • Install MySQL Workbench

  • Connect to an Instance

  • Create a database

  • Reverse Engineer Database into Data Models

  • Forward Engineer Data Models into Databases

  • Create Tables

  • Run Queries against Tables

  • General use of the MySQL Workbench

  • Create Relationships

  • Use Aggregate functions to do quick mathematical operations

  • Export data to Excel using MySQL Workbench

  • Practical use of SQL

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience is database.

  • This course is for you if you are already comfortable with basic database operations.

  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.

  • This course is for you if you want to understand design principles in database development.

  • This course is for you if you are looking to learn a new Database Management System

Content and Overview

This is a complete course. Over 5 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer. I take you through various scenarios and techniques to write queries, build a database and further administrate.

By the time you have finished the course you will have moved around in MySQL Workbench so much, that it will become second nature for you when building a MySQL Database. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files and scripts, making it easy for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

It's time to take action! This deal will not be available forever!

Click the "Buy Now" button Today!

Every hour you delay is costing you money...

See you in the course!

Database Design

Learn relational database Design with practical concepts and examples. This series works with any database system!

Created by Caleb Curry - Educator, YouTube Partner.

"]

Students: 92586, Price: $34.99

Students: 92586, Price:  Paid

Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases:

  • MySQL
  • Oracle
  • Microsoft SQL Server
  • PostgreSQL
  • SQLite
  • MiariaDB
  • and MORE!

We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth.

Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish.

No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy.

After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!

Microsoft SQL Server Development for Everyone!

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

Created by Trevoir Williams - Mr.

"]

Students: 86276, Price: $129.99

Students: 86276, Price:  Paid

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started at a Database Developer or Junior Database Administrator.

Why Learn Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications

We will explore best practices in database development using SQL Server Express 2017 (Free Edition) and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What you’ll learn

  • Install SQL Server and SQL Server Management Studio

  • Connect to a Database Instance

  • Create a Database

  • Create Tables

  • Run Queries against Tables

  • General use of the Management Studio

  • Create Relationships (Normalization)

  • Use Aggregate functions to do quick mathematical operations

  • Export data to Excel using the Management Studio

  • Practical use of SQL

  • Creating and Managing Database Views

  • Creating and Managing Custom Functions; Table Triggers and Stored Procedures

  • How to Backup and Restore Databases

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience.

  • This course is for you if you are already comfortable with basic database operations.

  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.

  • This course is for you if you want to understand design principles in database development.

  • This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System

  • This course is for EVERYONE!

Content and Overview

This is a complete course. Over 6 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer and/or Administrator. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch more advanced topics that are in great demand in the workplace.

By the time you have finished the course you will have moved around in Microsoft SQL Manager Studio so much, that it will become second nature for you when interacting with your databases, found on different servers. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files and scripts, making it easy for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

It's time to take action! This deal will not be available forever!

See you in the course!

Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL

Created by Eduonix Learning Solutions - 1+ Million Students Worldwide | 200+ Courses

"]

Students: 76466, Price: $39.99

Students: 76466, Price:  Paid

Database design is one of the most important aspects of Web programming. Successful implementation of any system with Data Storage will always need proper database design. In order to create great database design you will not only have to master the Database technology but will have to master database design process and normalization.

This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design. This course will also teach you SQL and you will be a SQL power user by the end of this course.

You will start with basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and database design process. Database design , normalization, structure mapping, keys and junction tables comes next.

The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. So this complete Database course and will surely help you become a Database Design Guru.

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: 73776, Price: Free

Students: 73776, 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

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.

Database Design and MySQL

Database Design, MySQL Fundamentals and more advanced programming concepts. Learn how to program banks, libraries, etc.

Created by Caleb Curry - Educator, YouTube Partner.

"]

Students: 62880, Price: $69.99

Students: 62880, Price:  Paid

This course is offered to allow for download and anytime use as well as for anybody who wishes to support my YouTube channel.

About this course:

This is an introductory course that dives into the basics of many topics in databasing, including:

Database Design

Datatypes

Inserting and manipulating data

Joins

Character sets and collations

Storage engines

functions

and much more.

This master course has 3 sub-courses with a total of over 100 videos teaching the absolute basics, intermediate topics, and the start of many advanced databasing concepts that will have you programming databases in no time.

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

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.

SQL for Beginners: Learn SQL using MySQL and Database Design

Understand SQL using the MySQL database. Learn Database Design and Data Analysis with Normalization and Relationships

Created by Tim Buchalka's Learn Programming Academy - Professional Programmers and Teachers - 1.22M students

"]

Students: 58416, Price: $89.99

Students: 58416, Price:  Paid

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don't know where to start?

Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn.

Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases.

Whatever the reason you have arrived here, this course will...

Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities.

Key concepts you will learn and work with in this course.

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design
Data Analysis

The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy.  You will struggle to find another MySQL course that has a section on this.   This section alone, will give you a huge edge over other applicants for jobs.

Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section.

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases.

In addition there are installation videos covering MySQL on Windows, Mac or Linux.

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database.

Why enrolling in this course is the best decision you can make.

Become skilled as a database developer generally needs you to learn SQL, a database, and then database design.  Often this will require multiple courses.  However you learn all those topics, and data analysis in this one course.

Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday.  Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to  teach you how to become proficient with SQL, MySQL and Database design as quickly as possible.

If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you!

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.  

SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course.

Your new job or consulting opportunity awaits!  

Why not get started today?

Click the Signup button to sign up for the course!

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

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

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. 

The SQL MicroDegree 2021: From SQL Basics To MySQL Mastery

Complete MySQL Beginner Course To Teach You Everything You Need To Know About SQL Programming.

Created by Abhishek Pughazh - I'm a Python Freelancer, creating cool stuff.

"]

Students: 37753, Price: $89.99

Students: 37753, Price:  Paid

Learn SQL from absolute scratch!

SQL is not an optional skill anymore but a necessity. It's not crucial for data analysts but also for CS graduates who are looking for a job. Learning SQL is one of the fastest ways to improve your career possibilities as it is one of the most sought-after tech skills! Do you know that MySQL is the most preferred SQL interpreter out there? What you learn in this course would be enough to get yourself eligible for new career options. We will start from the very basics of SQL and gradually progress into teaching you everything you need to know about it. Step by step. With no steps skipped. This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.

What Will You Learn?

  • Learn the ins and outs of SQL syntax

  • Generate reports using sales and user data

  • Analyze data using Aggregate Functions

  • Run complex queries using MySQL logical operators and string functions

  • Write all the common SQL joins

  • Creating, Modifying and Deleting Tables in a Database (DDL)

  • Inserting, Updating and Deleting Data from Tables (DML)

Why Should You Choose This Course?

  • Easy to understand

  • Time-efficient and concise

  • Shows how SQL can be crucial for data analytics and business intelligence

  • Taught in MySQL – The most popular SQL database management system.

Relational Database Design

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

Created by Ben Brumm - IT Software Consultant

"]

Students: 36427, Price: $49.99

Students: 36427, Price:  Paid

Learn how to design a proper relational database with this course!

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 database 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 Relational Database Design course.

This course includes:

  • Almost three hours of video lessons
  • 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.

What topics are covered in this database design course?

The topics covered are:

  • We'll walk through a sample database
  • Reason or why the database is needed
  • Some advantages of relational databases
  • Identify entities for the tables and attributes
  • Create tables and columns
  • 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!

Introduction to Database Engineering

Learn ACID, Indexing, Partitioning, Sharding, Concurrency control, Replication, DB Engines, Best Practices and More!

Created by Hussein Nasser - Software Engineer, Author

"]

Students: 35631, Price: $99.99

Students: 35631, Price:  Paid

Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the right place. I have curated this course carefully to discuss one of the main concepts of database engineering.

This course will not teach you SQL or programming languages, however, it will teach you skillset and patterns that you can apply in database engineering. A few of the things that you will learn are Indexing, Partitioning, Sharding, Replication, Concurrency control, database engines and security, and much more.

Database engines or storage engines or sometimes even called embedded databases is a software library that a database management software uses to store data on disk and do CRUD (create update delete) Embedded means move everything in one software no network client-server. In this video course, I want to go through the few popular database engines, explain the differences between them and finally I want to spin up a database and change its engine and show the different features on each engine.

Complete Elasticsearch Masterclass with Logstash and Kibana

Learn how to build a search engine and break into big data by mastering Elasticsearch 6, Kibana and Logstash (ELK stack)

Created by Imtiaz Ahmad - Senior Software Engineer & Trainer @ Job Ready Programmer

"]

Students: 34714, Price: $109.99

Students: 34714, Price:  Paid

LAST UPDATED: November 2020 - Elasticsearch Version 6

Elasticsearch is the biggest player in the big-data space since Hadoop. I would actually vouch that it's the Hadoop killer!

It's just now beginning to gain recognition and wider adoption in the no-sql big-data space and Elasticsearch has come a long way since it's first release. I'm sure that by just adding Elasticsearch on your linkedin profile your going to gain the attention of various companies investing in this technology. So get excited about Elasticsearch because it is a big deal. The average salary for an Elasticsearch engineer is over $100,000 and the demand for engineers is high.

This course is most suited for people that want to not only power-up their resume with this new and exciting technology but also powerup their applications to be blazing fast by implementing Elasticsearch correctly. I've designed this course to be practical and easy to follow by repeating key concepts with step by step instructions and best practices for building a search Engine from scratch.

By the end of this course you'll know everything there is to know about how to build a search engine using the most recent and popular version of Elasticsearch 6 for your application as well as how to perform powerful realtime analytics on your data.

With over 20,000 student and a 4.4 star rating, this is a Udemy best seller course with thousands of students who have benefitted from the content.

Don’t just take it from me, take it from the students that have taken this course.

★★★★★ Here’s reviews from real students that took this course ★★★★★

★★★★★ This is an awesome Masterclass. It provides all the basics to work with the ELK-Stack and gives a deep look in how the core Elasticsearch is working and how to use it. Thanks to some sketches he explains the structure behind the programs. Here he might use a tablet to make his drawings as professional as the rest of the course. Thanks for the great help.

★★★★★ Instructor explains topics concisely and in depth. He provides resources that you can visit while watching the lectures to get better understanding of the topics he discusses. In addition, he encourages students to do some examples (challenges) that will solidify their understanding of the topics discussed in the course so far.

★★★★★ The teacher is very clear and he explains with simplicity easy and difficult concepts

★★★★★ Walked me through step by step in one lesson. I now have Kibana and Elasticsearch running locally. Awesome..

★★★★★ The instructor is very detailed and goes at pace that is easy to manage and follow along without adding excessive length to the course.

★★★★★ Highly recommended for the people who wants to understand the eleastic seach . I am very happy with the course. When I started I had no idea about the subject but now i'm feeling confident about it. Imtiaz teaching style is great. You will simply love it.

Topics covered in this course:

  • Setting up Elaticsearch and Kibana

  • Downloading and Configuring Logstash

  • Logstash

  • Kibana

  • Indexing, Retrieving and Deleting Documents

  • Text Analysis

  • Index Settings

  • Index Mapping

  • Searching DSL Query Context

  • Searching DSL Filter Context

  • Aggregations DSL

  • Indexing Apache Application Logs

  • Kibana Visualizations

  • Using Filebeat

  • Older Elasticsearch 5 Material

 There is a 30 day money back guarantee, so if you're not satisfied for any reason, you get your money back no questions asked!

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

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!

The Agile Samurai Bootcamp

Everything you need to setup, execute, and successfully deliver your own Agile project.

Created by Jonathan Rasmusson - Ex-Spotify Engineer, The Agile Samurai

"]

Students: 32786, Price: $129.99

Students: 32786, Price:  Paid

  Get ready to kick some software project butt. 

                  Enter the world of the Agile Samurai, where the most dire of software projects are dispatched with ease and grace. By learning the ways of the Agile Samurai you will discover: 

  • What Agile is, how it works, and the mindset necessary for working iteratively

  • Common myths and pitfalls and how to choose the right Agile method for you

  • How to build a good Agile team

  • How from traditional waterfall roles (like developer, analyst, tester, and project manager) change on Agile project

  • How to create a plan you and your customer can believe in

  • How to gather requirements in a fraction of the time using Agile User Stories

  • How to deliver something of value every week

  • What to do when the schedule is wrong, and how to look like a pro correcting it, and

  • The four essential Agile Engineering practices and why they are so important for Agility.

  By the end of this course you’ll have everything you need to successfully set up, execute, and deliver your own Agile project. 

Course Outline

Agile In a Nutshell

  • What Agile is, how it works, and how to choose the right Agile method for you.

Agile Teams

  • What makes the Agile team tick. Characteristics of good Agile teams. And how to find quality players.

User Stories

  • In this session we break down what user stories are, how they work, what effective user stories look like for your project, and how to host great story gathering work shops.

Estimation

  • By learning how to estimate the Agile way, you’ll stop trying to get something your up-front estimates can’t give (precision and accuracy) and instead focus on what really matters—building a plan you and your customer can believe in.

Planning

  • In this session, you’re going to learn how to create plans you can believe in and follow through on commitments you and your team make.

Iteration Mechanics

  • This session shows teams how to set the iterations up for success, breaks down what actually occurs during an iteration, and how to setup an agile communication plan for you and your team.

Visible Workspaces

  • By learning how to create a visual workspace, you and the team will never be at a loss for what to do next or where you can add the greatest value.

       

Engineering

  • Agile doesn’t work on planning alone. That would be wishful thinking. Only by apply these core software engineering practices can you reduce the time it takes to test, ensure you always have a good design, and confidently make necessary changes with speed.

              Unit Testing - Automated tests proving your software works 

              Refactoring - Paying down technical debt, while continuously improving your design 

              Test-Driven Development - Write the tests first to help improve your design 

              Continuous Integration - Maintaining a culture of production readiness, and deploying at a moments notice 

Intended Audience

  • This is an introductory level course on Agile software delivery.

Course Requirements

  • No previous experience with Agile expected or necessary.

Instructional Level

  • All Levels

Update NEW FAQ Section April 2017

  • New FAQ section added answering most commonly asked questions

  • New templates section added containing downloadable examples of burn down charts

Update NEW Cheat Sheet Section August 2018

  • New section summarizing key concepts in downloadable pdf

The Complete Oracle SQL Bootcamp (2021)

Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 30585, Price: $109.99

Students: 30585, Price:  Paid

Last Course Updates:

(May, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

(Apr, 2021): New Lectures and Quiz Questions are added!

(Feb, 2021): Closed-Captions are updated!

Important Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL.

Are you a student ready to learn SQL for your lessons?

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Do you think you know SQL, but you cannot write SQL codes?

Are you looking for a really professional course?

Then this is the course you are looking for.

You have come to the right place!

In this course, all the subjects are explained in a professional order.

   If you are new to SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.

   After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.

   Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

So come on, what are you waiting for?

Get this course, and go get a better job!

Benefits of Taking This SQL Course:

Knowing SQL can get you a better job or improve the one you have and it can earn you $80-100k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and thinking analytically against the problem in your company.

Student Reviews Prove This Course's Worth:

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)

Important Notice:

Knowing SQL is "mandatory" for any IT Professionals and having good SQL knowledge will be a "GREAT PLUS" for you!

If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!

So let’s do this! I'll see you in the first lecture!

Database Engineer/DBA – (PostgreSQL, IBM-DB2, MariaDB,NoSQL)

Practical Database Engineering | Administration

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 29100, Price: $74.99

Students: 29100, Price:  Paid

Database engineers design new databases based on company needs, data storage needs, and the number of users accessing the database. Monitor Databases and Programs. Database engineers continuously monitor databases and related systems to ensure high functionality.

Database administrator ensures that data is available, protected from loss and corruption, and easily accessible as needed. Also they oversee the creation, maintenance and security of your databases. manages, backs up and ensures the availability of the data.

PostgreSQL is commonly known as Postgres and it is also  open source database.  PostgreSQL is a powerful, open source object-relational database system.

IBM Db2 is a family of related data management products,including relational database servers, developed and marketed by IBM.

MariaDB is great for its open-source innovation and enterprise-grade reliability, as well as its modern relational database.

SQL -Structured Query Language is an internationally recognized language used to communicate and manipulate various database systems.

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media applications like Facebook and Instagram..

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

NoSQL (Non-SQL or Not-only-SQL) databases are increasing in popularity due to the growth of data as they can store non-relational data on a super large scale, and can solve problems regular databases can't handle. They are widely used in Big data operations. Their main advantage is the ability to handle large data sets  effectively  as well as scalability and flexibility issues for modern applications.

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

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

The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL”

A Full-Real Guide to Make You a Job-Ready PL/SQL Developer &Also covers "Oracle 1Z0-144 and 1Z0-149" PL SQL Exam Topics!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 27949, Price: $129.99

Students: 27949, Price:  Paid

Last Course Updates:

(Nov, 2020): "Oracle-Supplied PL/SQL Packages" section is added!

(Oct, 2020): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

(Sep, 2020): Closed-Captions are added!

(Jul, 2020): New Quiz Questions are added!

☞ Become an "Oracle Database PL/SQL Developer Certified Professional"!

This PL/SQL course is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a hero in PL/SQL will find everything that they are looking for. 

Students will learn and improve their:

  • PL/SQL Coding Skills

  • SQL & PL/SQL Performance

  • PL/SQL Scalability

  • Portability and Security about Database and PL/SQL

And also students will be prepared for:

  • Exam Number: 1Z0-149 | Oracle Database 19c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-148 | Oracle Database 12c: Advanced PL/SQL        | Oracle Certification Exam

  • Exam Number: 1Z0-144 | Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 | Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

SQL for Data Analysis: Beginner MySQL Business Intelligence

Learn SQL database querying w/ MySQL Workbench. Perfect for SQL beginners and first-time coders.

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 27830, Price: $139.99

Students: 27830, Price:  Paid

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"

- Maggi M.

"I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"

- Steven M.

______________________________

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.

In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    We’ll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

  • SQL Database Fundamentals (Part 1)

    Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

  • Analyzing Data from Single Tables with MySQL

    In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.

    [MID-COURSE MYSQL PROJECT]

  • SQL Database Fundamentals (Part 2)

    The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.

  • Analyzing Multiple Tables via MySQL JOINS

    In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.

    [FINAL MYSQL PROJECT]

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

______________________________

Enroll today and get LIFETIME access to:

  • 5+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

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

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.