Share Description
In this course, you will learn :
- Introduction to SQL
- Introduction to Databases
- Connect to MySQL
- Introduction to MySQL
- Beginner's SQL
Syllabus :
1. Database Fundamentals
- Choosing a GUI
- Connecting to our Database
- Connection Properties
- Database Tables Explained
- Creating a Database Table
- 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
