Beginner's Introduction to SQL and Databases

Building your SQL foundation in a short amount of time!

4.37 (356 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Beginner's Introduction to SQL and Databases
10,605
students
2 hours
content
Jan 2021
last update
FREE
regular price

What you will learn

Introduction to SQL

Introduction to Databases

Connect to MySQL

Introduction to MySQL

Beginner's SQL

Description

In this course, you'll create a foundation for data manipulation and analysis using SQL. If you are completely new to SQL and have an interest on how to work with large volumes of data in an efficient and sophisticated way, then you came to the right course.

This course contents consist of the following:

  • Installing a GUI / Software to connect to database

  • Connecting to a MySQL database

  • Tables Explained

  • Inserting Records

  • Dropping Tables

  • SELECT Statement

  • COUNT, MIN, MAX and other functions

  • WHERE clause (for filtering data)

  • String and comparison operators


Content

Database Fundamentals

Introduction
Choosing a GUI
Connecting to our Database
Connection Properties
Database Tables Explained
Creating a Database Table
Inserting Records
Exercise: Inserting Records
Data Types
Dropping a Table
Start Querying your data using SELECT
Counting Records
You have access to other databases! Check it out!
Previewing your records
Filtering records and numeric data types
Filtering records using Greater Than operator
Filtering records using Less Than operator
Using the BETWEEN condition
Counting a subset of records
Intro to AND
Solutions to Exercise
Using the OR condition
Sorting data with ORDER BY
Ordering by ordinal column
Solutions to Excercise
The LIKE operator
The NOT LIKE operator
THE IN operator
Solutions to Excercise
Using MIN and MAX
Rounding and other Arithmetic
Solution to Excercise
End of Part I

Reviews

Karolina
April 24, 2023
Everything is well explained but I was rather annoyed by a lot of technical ininaccuracies. At the beginning there is said we will use a Visual Code Studio but we ended up using beekeeper studio throughout the whole course. Also it is said that Beekeepeer studio is free but it only has 14 days trial for free. Also the database is not kept clean, there are a lot and lot of tables from different people which is bit confusing at the beginning. I was kind of surprised you used a name of person that you cannot spell and also the biggest problem for me was that there was an exercise in lesson 31 and then in lesson 32 there is a solution to a whole different exercise. I mean is it good course, well structured and well explained but it really need review of these things.
Dawid
January 29, 2023
Very practical and hands on, gave me a great idea of what the work would actualy lok like and covered very useful tools and insights. One constructive comment/ suggestion I would make that I would personally have found very useful would be to provide the actual written notes on the screen. The Ai voice to text function (captions) provides notes on the screen but instead of being helpful it is a quite confusing as it gets many words wrong and often it is quite hilarious but not really helpful. For example SQL has been named Ezekial, Escutial, school etc by the captions. Apart from that it is really very good in getting one to a quick practical understanding.
kassu
January 19, 2023
its realy awesome eventhogh it will be very nice if the same data attached or uploaded. it will help the learner to do more exercise ,
Kim
December 5, 2022
Thank you. I found the course easy to understand and examples were good. It was a little long for some of the explanations which did not add extra information so I fast forwarded a bit. It would be good to have a few more examples or exercises which show when the underlying query is not going to work as expected. Some more challenging examples would be good later in the course as well where you add in some earlier queries. This helps to see if you need to revise sections.
Sophie
November 3, 2022
Good introduction. I would have liked explanation on what is SQL and why you would use it. Also, more about best practices. But overall, good.
Keith
October 19, 2022
Very good concise course to get you started. I think it does what it was intended to do. I recommend it!
GregoryS
October 6, 2022
Yes, it has been a very good review of material from my university course on databases. And the instructor explains concepts clearly.
Claudia
September 26, 2022
the course y clear, I don't know anything about databases and I learned very much I suggest describing more vocabulary to understand better some terms.
Zoran
September 21, 2022
This course its really good to be watch in order to find out what is SQL. It would be nice if there are more examples for practicing but thanks to yours database we can make our own examples and to practice.
Mayra
June 5, 2022
This course made it SO easy to learn SQL! Thank you. I would just mention that you have to highlight the code before running it - this took me a while to figure out at the beginning.
Lawrence
May 22, 2022
I have alway had an interet in databases from a web or dev perspective but I really enjoyed using this new software as I plan on connecting with other db's and using beekeeper as a direct front end for control and manipulation - I have always found issues with workbench connection wise etc... great course look fwd to pt.2
Indrė
May 17, 2022
Everything was pretty cool. Just one thing - three is no exercise solution for 31 lesson. 32 lesson repeats twice.
Lydia
April 4, 2022
It was an informative course. However I was not able to link to the test database using the details provided
Arnold
March 18, 2022
The crash course is clear enough for a beginner like me. Apart from that, I can also catch up with his lectures. Well done Sir!
Beata
February 14, 2022
As a newbie in data analytics I found this course really easy and useful. I enjoyed it and learned a lot. I am looking forward to part two

Charts

Price

Beginner's Introduction to SQL and Databases - Price chart

Rating

Beginner's Introduction to SQL and Databases - Ratings chart

Enrollment distribution

Beginner's Introduction to SQL and Databases - Distribution chart
3765400
udemy ID
1/10/2021
course created date
1/29/2021
course indexed date
Bot
course submited by