- 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
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
COUNT, MIN, MAX and other functions
WHERE clause (for filtering data)
String and comparison operators
How to blend images using Luminosity Masks.
About the instructors
- 4.58 Calificación
- 10789 Estudiantes
- 5 Cursos
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.
I am totally new and this is very easy to understand and follow so far
Loved it.. very informative
Nice course. It would have been even better if the code letters were a little bit bigger. Thanks for it. It was useful.