4.3 out of 5
4.3
22 reviews on Udemy

SQL For Beginners: Learn to communicate with databases

Learn Practical Real World Enterprise SQL Skills
Instructor:
Bluelime Learning Solutions
4,150 students enrolled
English [Auto]
Create a Database
Create a Table
Insert data into a Table
Update data inside a Table
Delete data from a Database
Query and retrieve data from a Database
Sorting data retrieved from a Table
Grouping Data
Using Subqueries
Extract and join data from multiple Tables
Filter data using WHERE Clause
Query data with various Operators
Perform calculations on data using Aggregate Functions

Why Learn SQL?

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

Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.

SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.

In this  beginners course, you will learn the building blocks of SQL by interacting with a MySQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.

Topics include:

  • Creating database and tables

  • Retrieving data from database table

  • Updating data inside a table

  • Deleting data inside a database table

  • Filtering data returned from  a database table

  • Sorting data returned from a database table

  • Retrieving data using various operators

  • Combining data from multiple tables

  • Using aggregate functions to manipulate data.

  • Using subqueries

Take-Away Skills:

In this course, you’ll learn how to communicate with relational databases through SQL.

Setup Database and MySQL Workbench

1
Introduction
2
What is SQL
3
What is MySQL
4
Download and Install MySQL (Windows)
5
MySQL Installation ( Macs )
6
What is MySQL Workbench
7
Installing MySQL Workbench on Macs
8
Basic Database Concepts
9
What is a Schema
10
Setting up default database in MySQL
11
Showing existing database
12
Showing existing tables
13
Create your first database
14
Create your first table
15
Basic MySQL Commands

Data Manipulation

1
Create a database
2
SQL CREATE TABLE Statement
3
SQL INSERT Statement
4
SQL UPDATE Statement
5
SQL DELETE Statement
6
Primary Key
7
Foreign Key

SQL Queries

1
What is an SQL Statement | Query
2
SQL WHERE clause
3
SQL SELECT Statement
4
Removing duplicates with SQL DISTINCT
5
Sorting Data with ORDER BY clause
6
Grouping data with GROUP BY clause
7
SQL HAVING clause
8
SQL Subqueries
9
Nested subquery

SQL Operators

1
BETWEEN Operator in SQL
2
LIKE Operator in SQL
3
LIMIT Clause in SQL
4
IN Operator in SQL
5
SQL UNION Operator

Joining Data From Multiple Tables

1
INNER Join
2
LEFT JOIN
3
RIGHT JOIN
4
SELF JOIN

Aggregate Functions

1
What are Aggregate Functions
2
AVG Aggregate Function
3
COUNT Aggregate Functions
4
MAX Aggregate Functions
5
MIN Aggregate Functions
6
SUM Aggregate Functions
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
22 Ratings

Detailed Rating

Stars 5
11
Stars 4
6
Stars 3
3
Stars 2
0
Stars 1
2
3718e87afb3c588c1cf56717cc0bc2b7
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW