- 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
English
What you’ll learn
- Introduction to SQL
- Introduction to Databases
- Connect to MySQL
- Introduction to MySQL
- Beginner’s SQL
Requirements
- Internet Connection
- Computer
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
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
