SQL - MySQL for Data Analytics and Business Intelligence
- Descrição
- Currículo
- FAQ
- Revisões
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 $123,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 3,000,000 students have taken our courses here on Udemy. 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?
-
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
-
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
-
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!
-
1
What does the course cover?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
-
2
Why SQL?
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.
-
3
Why SQL? -
4
Why MySQL?
Why did we choose MySQL and not some other relational database management system?
Because it is:
- reliable
- mature
- open-source
-
5
Why MySQL?
-
6
Introduction to databases
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.
-
7
Introduction to databases
-
8
SQL as a declarative language
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.
-
9
SQL as a declarative language
-
10
Data definition language (DDL)
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
-
11
Data definition language (DDL)
-
12
SQL keywords
A brief explanation on what SQL keywords are about.
-
13
SQL keywords
-
14
Data manipulation language (DML)
We will learn about some DML statements that allow us to manipulate the data in the tables of a database:
- SELECT
- INSERT
- UPDATE
- DELETE
-
15
Data manipulation language (DML)
-
16
Data control language (DCL)
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.
-
17
Data control language (DCL)
-
18
Transaction control language (TCL)
A brief introduction the Transaction Control Language (TCL) and its application.
-
19
Transaction control language (TCL)
-
20
Relational database essentials
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
-
21
Relational database essentials
-
22
Databases vs spreadsheets
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.
-
23
Databases vs spreadsheets
-
24
Database terminology
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
-
25
Database terminology
-
26
Relational schemas - Primary key
In this video, we will introduce the concept of using primary keys in MySQL.
-
27
Relational schemas - Primary key
-
28
Relational schemas - Foreign key
In this lesson, we will present the concept of using foreign keys in MySQL, as well as their relation to primary keys.
-
29
Relational schemas - Foreign key
-
30
Relational schemas - Unique key and null values
Here, we will explain what unique keys are, and will introduce you to null values in SQL.
-
31
Relational Schemas - Unique key
-
32
Relationships
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.
-
33
Relational Schemas – Relationships
-
34
Installing MySQL
A guide for the installation of the MySQL server and MySQL Workbench.
-
35
Additional note – Installing – Visual C -
36
Installing MySQL on macOS and Unix systems
-
37
The Client-Server Model
This is a visualization that explains which MySQL features we must install and why.
-
38
Setting up a connection
A brief description of what it means to set up a connection between Workbench and the MySQL Server.
-
39
Read me!!!
-
40
New Authentication Plugin - Creating a New User
-
41
Introduction to the MySQL interface
The focus of this video is getting acquainted with the MySQL Workbench interface.
-
42
Creating a Database - Part I
In this lesson, we will show you how to create your own database, also called schema, starting from scratch.
-
43
SQL files
-
44
Creating a Database - Part I - exercise
-
45
Creating a Database - Part I - solution
-
46
Creating a Database - Part II
In this video, we will look at the MySQL Workbench interface in more detail as it can help us manage our database better.
-
47
Creating a Database - Part II - exercise
-
48
Creating a Database - Part II - solution
-
49
Introduction to data types
In this lecture, we will introduce you to the measures that characterize the various data types available in SQL.
-
50
Introduction to data types
-
51
String data types
The text format in SQL is called string. In this lecture, we will explore a few string data types in SQL.
-
52
String data types
-
53
Integers
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.
-
54
Integers
-
55
Fixed and floating-point data types
In this lesson, we will compare two numeric data types in SQL – the fixed-point and the floating-point data type.
-
56
Fixed and floating-point data types
-
57
Other useful 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.
-
58
Other useful data types
-
59
Creating a table
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.
-
60
Creating a table - exercise
-
61
Creating a table - solution
-
62
CODING EXERCISES - Browser-based coding
-
63
Creating a Table - Exercise #1
-
64
Creating a Table - Exercise #2
-
65
Creating a Table - Exercise #3
-
66
Creating a Table - Exercise #4
-
67
Using databases and tables
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.
-
68
Using databases and tables - exercise
-
69
Using databases and tables - solution
-
70
Using Databases and Tables - Exercise #1
-
71
Additional notes on using tables
Here we will share a few notes on using data tables in MySQL.
-
72
Additional notes on using tables
-
73
Additional notes on using tables - exercise
-
74
Additional Notes on Using Tables - Exercise #9
