We may earn an affiliate commission when you visit our partners.
Course image
365 Careers

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

Read more

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

How many people have these skills?

Not enough.  

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $103,400. That’s a lucrative career.   

How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.   

Worried that you have no previous experience? 

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.   

Why take this course in particular? Isn’t it like the rest of the SQL courses out there?  

We would like to think it isn’t. Our team worked hard to create a course that is: 

  • Easy to understand 

  • Time efficient and concise 

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

  • Comprehensive – it covers several topics not shown in other SQL courses   

  • Practical – it teaches you how to work with a real-life database   

  • Corresponds to professional best practices 

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

  • Contains plenty of downloadable exercises, course notes, and quiz questions   

Some of these aspects have been covered in other courses. Others haven’t. However, no one provides such a variety of topics in one place.    

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.   

We love teaching   

So far, over Teaching is what we do best, and we take pride in going the extra mile to create the most engaging content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.   

So, why do you need to enroll in this course and learn SQL? 

  1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how 

  2. Profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come 

  3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics  

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.  

Sounds awesome, right?   

So, what are you waiting for? Click the “Buy now” button, and let’s begin this journey together.  

Enroll now

What's inside

Learning objectives

  • Become an expert in sql
  • Learn how to code in sql
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with sql databases
  • Start using mysql – the #1 database management system
  • Prepare for sql developer, database administrator, business analyst, and business intelligence job opportunities
  • Adopt professionally tested sql best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient mysql workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using sql’s aggregate functions
  • Handle complex sql joins with ease
  • Approach more advanced topics in programming like sql’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient sql user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database
  • Show more
  • Show less

Syllabus

Introduction to databases, SQL, and MySQL

In this video we will discuss:

  • what this course is about
  • who it is for
  • the heterogeneous set of topics we have prepared for you in the course curriculum
Read more

Why study SQL?

Whether you are working in Business Intelligence (BI), data science, database administration, or back-end development, you will have to retrieve information from a server storing large amounts of data. To achieve this, you’ll need SQL.

Why SQL?

Why did we choose MySQL and not some other relational database management system?

Because it is:

  • reliable
  • mature
  • open-source
Why MySQL?

You will be much faster in learning and writing efficient queries if you go through a brief introduction to databases. It is the best thing to begin with, so in this video we will discover terms like:

  • record
  • field
  • data table
  • data entity
  • database
  • relation
  • and much more.
Introduction to databases
SQL theory

Although with some procedural elements, SQL is mainly regarded as a declarative programming language, it is nonprocedural. This means, while coding, you will not be interested in how you want the job done. The focus is on what result you want to obtain.

SQL as a declarative language

The Data Definition Language, DDL, is called a language, but you can think of it as a syntax, a set of statements that allow the user to define or modify data structures and objects, such as tables. Examples of the statements of the Data Definition Language are:

  • CREATE
  • ALTER
  • RENAME
  • TRUNCATE
Data definition language (DDL)

A brief explanation on what SQL keywords are about.

SQL keywords

We will learn about some DML statements that allow us to manipulate the data in the tables of a database:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
Data manipulation language (DML)

The Data Control Language is a syntax containing only two statements – GRANT and REVOKE. These statements allow us to manage the rights users have in a database.

Data control language (DCL)

A brief introduction the Transaction Control Language (TCL) and its application.

Transaction control language (TCL)
Basic database terminology

In this lesson, we will provide you with the tools that are essential for dealing with relational databases. They will help you maintain a database that can be characterized as:

  • compact
  • well-structured
  • efficient
Relational database essentials

In this lecture, we will focus on the differences between spreadsheets and databases. This exercise will be relevant not only for current Excel users. Those of you who do not use Excel regularly will still have the chance to understand the advantages and the disadvantages of using databases or spreadsheets. 

Databases vs spreadsheets

To complete our theoretical preparation, we will need to learn more database terminology. We will discuss the meaning of such terms as:

  • database designer
  • entity-relationship diagram
  • relational and database schema
  • database manipulation, management, and administration
Database terminology

In this video, we will introduce the concept of using primary keys in MySQL.

Relational schemas - Primary key

In this lesson, we will present the concept of using foreign keys in MySQL, as well as their relation to primary keys.

Relational schemas - Foreign key

Here, we will explain what unique keys are, and will introduce you to null values in SQL.

Relational Schemas - Unique key

This is a lecture in which we will try to illustrate that relationships between tables can be categorized. We will study the main types of relationships you will likely need in your workplace.

Relational Schemas – Relationships
Installing MySQL and getting acquainted with the interface

A guide for the installation of the MySQL server and MySQL Workbench.

Additional note – Installing – Visual C
Installing MySQL on macOS and Unix systems

This is a visualization that explains which MySQL features we must install and why.

A brief description of what it means to set up a connection between Workbench and the MySQL Server. 

Read me!!!
New Authentication Plugin - Creating a New User

The focus of this video is getting acquainted with the MySQL Workbench interface.

First steps in SQL

In this lesson, we will show you how to create your own database, also called schema, starting from scratch.

SQL files
Creating a Database - Part I - exercise
Creating a Database - Part I - solution

In this video, we will look at the MySQL Workbench interface in more detail as it can help us manage our database better. 

Creating a Database - Part II - exercise
Creating a Database - Part II - solution

In this lecture, we will introduce you to the measures that characterize the various data types available in SQL.

Introduction to data types

The text format in SQL is called string. In this lecture, we will explore a few string data types in SQL.

String data types

Numbers are stored in so-called numeric data types. We will go through the most notable types in MySQL – integer, fixed-point, and floating-point data types.

Integers

In this lesson, we will compare two numeric data types in SQL – the fixed-point and the floating-point data type. 

Fixed and floating-point data types

In addition to string and numeric data types, SQL allows you to store data that represents a date, time, binary, or list of options, amongst others. In this lesson, we will cover a few noteworthy data types that you will frequently see and work with.

Other useful data types

In this lecture, we will take our “first steps” into creating SQL tables. We will study in a bit more detail the rules allowing us to create a table. 

Creating a table - exercise
Creating a table - solution

In this video we will explain what the purpose of using queries is. As an example, we will use a query to set a default database.

Using databases and tables - exercise
Using databases and tables - solution

Here we will share a few notes on using data tables in MySQL.

Additional notes on using tables
Additional notes on using tables - exercise
MySQL constraints

In this section, we’ll learn how to assign constraints on tables. Our focus in this lesson will be on the primary key constraint.

PRIMARY KEY Constraint
PRIMARY KEY constraint - exercise
PRIMARY KEY constraint - solution

You know that relationships between the tables in a database are formed through the interaction between primary and foreign keys. We’ll learn how to work with the latter in this lecture.

In this video, we will execute the query we created during the previous lesson, and then we will present a few possible ways to add a foreign key constraint in SQL.

FOREIGN KEY constraint - Part II - exercise
FOREIGN KEY constraint - Part II - solution

Unique keys ensure that all values in a column (or a set of columns) are different. Just like primary and foreign keys, unique keys are implemented in SQL through a constraint – the Unique constraint.

UNIQUE Constraint - exercise

The DEFAULT constraint helps us assign a default value to every row of a column. In this lecture, we will go through a couple of examples that will best clarify the subject.

DEFAULT Constraint - exercise
DEFAULT Constraint - solution

The “not null” restriction in MySQL is applied through the NOT NULL constraint. It means that, when you insert values in the table, you cannot leave the respective field empty. And if you leave it empty, MySQL will signal an error.

NOT NULL Constraint - Part I - exercise
NOT NULL Constraint - Part I - solution

In this lesson we will explain the differences between the following three elements:

  • a NULL value
  • a “NONE” response
  • the number zero
SQL best practices

Throughout the course, we are strictly complying with coding style rules. There are many ways you can write your SQL code, but there are only a few that are considered to be professional.

Coding techniques and best practices – Part I

Here we’ll apply what we learned in the previous lecture in an exercise.

Coding techniques and best practices – Part II
Loading the 'employees' database

In the remaining part of the course, you’ll be manipulating data in MySQL. To help you achieve this goal, we have re-organized the huge ‘employees’ database script in an SQL file that you can download and run in Workbench. 

SQL SELECT statement

The statement you will be using almost all the time is SELECT. It is one of the most important statements in MySQL and SQL. When extracting information, SELECT goes with FROM. You are always selecting something from a certain table or other types of SQL objects. 

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops SQL coding skills, which are core for database management, database administration, and business analysis
Students can apply their learning to prepare for a variety of careers, including SQL developer, database administrator, business analyst, and business intelligence professional
Emphasizes the importance of database management in the age of big data and analytics
Teaches MySQL, the most popular SQL database management system
Provides plenty of downloadable exercises, course notes, and quiz questions
Covers several topics not shown in other SQL courses

Save this course

Save SQL - MySQL for Data Analytics and Business Intelligence to your list so you can find it easily later:
Save

Reviews summary

Positive sql experience

Learners say this is a positive course for beginners in SQL. It provides engaging assignments with their solutions. As a result, students are able to code simple and intermediate SQL queries.

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL - MySQL for Data Analytics and Business Intelligence with these activities:
Review MySQL Basics
Refresh your understanding of SQL basics to ensure a solid foundation for this course.
Browse courses on SQL
Show steps
  • Review SQL data types and their characteristics.
  • Practice writing basic SQL queries to select, insert, update, and delete data.
  • Create and modify tables, defining data types, constraints, and relationships.
Solve SQL Coding Challenges
Challenge yourself with SQL coding problems to improve your problem-solving and query-writing skills.
Show steps
  • Find online platforms or books that provide SQL coding challenges.
  • Attempt to solve the challenges on your own.
  • Review solutions and explanations to identify areas for improvement.
Show all two activities

Career center

Learners who complete SQL - MySQL for Data Analytics and Business Intelligence will develop knowledge and skills that may be useful to these careers:
Data Analyst
When someone works as a Data Analyst they collect, analyze, interpret, and present data. As a Data Analyst, you will use specialized applications and often collaborate with other professionals to help make data-driven decisions. For a Data Analyst, an understanding of SQL can help facilitate these collaborative efforts and empower you to contribute to the success of data-driven decisions.
Database Administrator
A Database Administrator is in charge of the installation, configuration, and maintenance of a database management system. The Database Administrator must plan for the storage, retrieval, and security of data, and ensuring that the data is available, reliable, and secure. With the knowledge you will gain from this course, you can start working as a Database Administrator.
Business Analyst
A Business Analyst identifies and documents the business requirements for a new or modified software application or system. Business Analysts will work with stakeholders and users to understand their needs. They will then create documentation that describes the new system and how it will meet the needs of the business. This course will help you gain the skills you need to be successful as a Business Analyst.
Business Intelligence Analyst
A Business Intelligence Analyst is responsible for collecting, analyzing, and interpreting data to help organizations make better decisions. Business Intelligence Analysts use a variety of techniques to analyze data, including data mining, statistical analysis, and visualization. Completing this course will set you on the path to be a successful Business Intelligence Analyst.
Data Scientist
A Data Scientist is responsible for developing and implementing data-driven solutions to business problems. Data Scientists use a variety of techniques to analyze data, including machine learning, artificial intelligence, and statistical analysis. A successful Data Scientist has a strong foundation in SQL and can leverage that knowledge to excel in their career.
Software Developer
Software Developers design, develop, and implement software applications and systems. Software Developers use a variety of programming languages and technologies to create software that meets the needs of users. This course teaches in-demand skills that can help you become a proficient Software Developer.
Information Security Analyst
An Information Security Analyst is responsible for protecting an organization's computer systems and data from unauthorized access, use, disclosure, disruption, modification, or destruction. Information Security Analysts use a variety of techniques to protect data, including encryption, firewalls, and intrusion detection systems. This course can help you gain the knowledge you need to be successful as an Information Security Analyst.
IT Consultant
An IT Consultant provides advice and guidance to organizations on how to use information technology to meet their business needs. IT Consultants may work on a variety of projects, including system design, implementation, and management. The knowledge and skills you will gain from this course can help you become a successful IT Consultant.
Data Engineer
A Data Engineer is responsible for designing, building, and maintaining data pipelines. Data Engineers use a variety of tools and technologies to move data from one system to another. Building data pipelines can be a complex task, but this course will help you gain the skills you need to be successful as a Data Engineer.
Database Designer
A Database Designer is responsible for designing and maintaining databases. Database Designers use a variety of tools and technologies to create databases that meet the needs of users. You will gain the knowledge and skills needed to be a successful Database Designer by completing this course.
Systems Analyst
A Systems Analyst is responsible for analyzing and designing computer systems. Systems Analysts work with users to understand their needs and then design systems that meet those needs. You can begin to build a strong foundation in Systems Analysis by enrolling in this course.
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. Project Managers work with a team of people to achieve a common goal. This course will provide you with an introduction to project management and help you gain some of the hard and soft skills you need to be a successful Project Manager.
Quality Assurance Analyst
A Quality Assurance Analyst is responsible for testing software applications and systems to ensure that they meet quality standards. Quality Assurance Analysts use a variety of techniques to test software, including functional testing, performance testing, and security testing. This course may be useful for someone working as a Quality Assurance Analyst.
Technical Writer
A Technical Writer is responsible for writing documentation for software applications and systems. Technical Writers work with a team of people to create documentation that is clear, concise, and accurate. This course may be useful for someone working as a Technical Writer.
Computer Programmer
A Computer Programmer is responsible for writing and maintaining code for software applications and systems. Computer Programmers use a variety of programming languages and technologies to create software that meets the needs of users. Enrolling in this course can be a useful first step towards becoming a Computer Programmer.

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in SQL - MySQL for Data Analytics and Business Intelligence.
Provides a comprehensive overview of pattern recognition and machine learning, making it a valuable resource for those who want to learn more about the subject.
Good reference guide for those who want to use SQL. It covers the basics of SQL and provides numerous examples and exercises.
This book, intended for experienced SQL users, covers advanced features of SQL, including object-relational features, and useful reference.
Provides a comprehensive overview of deep learning, including both theoretical and practical aspects, making it a valuable resource for those who want to learn more about the subject.
Provides a comprehensive overview of statistical learning, including supervised and unsupervised learning, and great choice for those who want to learn more about the subject.
Useful reference for those who want to use MySQL. It provides numerous examples and exercises.
Provides an introduction to the fundamental concepts and techniques of data mining, making it a useful resource for those who want to learn more about the subject.
Provides a clear and concise introduction to machine learning, making it a great choice for beginners who want to learn more about the subject.
Is written for non-programmers and beginners who want to learn about SQL. It covers the basics of SQL and provides numerous examples and exercises.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SQL - MySQL for Data Analytics and Business Intelligence.
The Business Intelligence Analyst Course 2024
SQL for Data Analysis: Beginner MySQL Business...
Retrieve Data using Single-Table SQL Queries
Introduction to SQL and relational databases
SQL for Beginners: Querying Data
SQL Deep Dive
Database Administration and SQL Language Basics
SQL-MySQL: 2021 Complete Master Bootcamp | Beginner-Expert
Complete SQL + Databases Bootcamp: Zero to Mastery [2021]
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser