Sharing Is Caring:

Beginner’s Introduction to SQL and Databases

  • Building your SQL foundation in a short amount of time!
  • Free tutorial
  • Rating: 4.6 out of 54.6 (308 ratings)
  • 9,524 students
  • 1hr 56min of on-demand video
  • Created by Oscar Valles


What you’ll learn

  • Introduction to SQL
  • Introduction to Databases
  • Connect to MySQL
  • Introduction to MySQL
  • Beginner’s SQL


  • Internet Connection
  • Computer


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

Who this course is for:

  • Beginner Analysts
  • Aspiring Analysts
  • Product Owners
  • Product Manager
  • Data Professional
  • Students

Show less

Course content

1 section • 33 lectures • 1h 55m total length

Database Fundamentals33 lectures • 1hr 56min

  • Introduction03:02
  • Choosing a GUI01:30
  • Connecting to our Database02:59
  • Connection Properties00:54
  • Database Tables Explained03:35
  • Creating a Database Table03:17
  • Inserting Records02:34
  • Exercise: Inserting Records02:24
  • Data Types05:37
  • Dropping a Table03:24
  • Start Querying your data using SELECT01:59
  • Counting Records01:56
  • You have access to other databases! Check it out!03:57
  • Previewing your records03:22
  • Filtering records and numeric data types03:26
  • Filtering records using Greater Than operator02:04
  • Filtering records using Less Than operator01:05
  • Using the BETWEEN condition02:28
  • Counting a subset of records01:14
  • Intro to AND06:08
  • Solutions to Exercise03:29
  • Using the OR condition03:48
  • Sorting data with ORDER BY05:35
  • Ordering by ordinal column06:00
  • Solutions to Excercise03:39
  • The LIKE operator06:17
  • The NOT LIKE operator02:54
  • THE IN operator04:21
  • Solutions to Excercise03:46
  • Using MIN and MAX06:44
  • Rounding and other Arithmetic07:05
  • Solution to Excercise03:29
  • End of Part I01:48
Read Also -->   Free Devops Interview Questions and Answers

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock