What you'll learn:
- Introduction to SQL
- Introduction to Databases
- Connect to MySQL
- Introduction to MySQL
- Beginner's SQL
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
-- Update --
Hi, recently I migrated over to a newer version of MySQL.
Please use the following credentials to connect to the database. The ones in the video are outdated. If you have any questions, please reach out to me here or via LinkedIn if you have any questions.
Host: 82.197.82.63
Username: u479841347_user
Password: LearnSQL123
Database: u479841347_sql_course
Port: 3306
Ialso welcome you to checkout my YouTube Channel Analyst's Corner
Thank you for taking this free course. All concepts and software shown in this video are free of cost with the intent of lowering the barrier to learning for everyone. Ihope you find it useful, gain new knowledge and are able to apply it in your existing or new career.
