- 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
What you'll 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
Other Courses
How to conduct FEEDBACK in team? - Agile Retrospective
Retrospective - effective feedback at work, team building, developing agile mindset and ability to change and improve
How to Create Sales Funnels in 2024 at No Cost! 1 hr Course
Showing you how to build an effective Sales Funnel in 2024
Your Guide to Start Software Testing Career
Learn how to start a career in software testing
Graphic design: Designing 4 Advertisements in a series!
Graphic Design course, designing 4 full page AdverArt pieces using Adobe Photoshop and Adobe Illustrator. Professional.
About the instructors
- 4.45 Calificación
- 37831 Estudiantes
- 8 Cursos
Oscar Valles
Analytics and Business Intelligence Professional
As Analytics and Business Intelligence professional, I've had the privilege to apply analytical, technical and business expertise across a variety of domains such Marketing, Customer Success, Research and Development, Retail and Ecommerce.
Each course that I create will be aimed at helping you focus on the key aspects of the technical skills you desire to develop for the purpose of immediate application and personal acclimation.
I'm excited that you are here because it means that you want to grow your career and I want to be the there to help. I'm happy to share my experiences so that your track to success is better than mine! I've been in your shoes and together, we will get you where you want to be.
Student feedback
Course Rating
Reviews
A great start to the course. Everything is clear, to the point, fast and understandable. Thank you.
I LOVE IT! your work was simple and understandable , keep it up 😍
A very detailed and clearly outlined course, i recommend it to anyone new to SQL just as it opened my understanding about SQL and data analysis in general merely watching a few clips at the beginning of the course.
Bardzo fajnie przedstawione podstawowe zagadnienia zabawy z SQL. Przerobiłem dwa razy, bo taki dobry