SQL BootCamp - Learn MySQL for Data Analysis
What you'll learn
- Start using MySQL – the #1 Database Management System
- Boost your resume by learning an in-demand skill
- Prepare for SQL developer, Database administrator, Data Analyst, and Business Intelligence job opportunities
- Develop business intuition while solving tasks with big data
- Tons of exercises that will solidify your knowledge
- No Prerequisites.
Do you want to be able to gain insights from your data? Will you like to have a competitive advantage over your peers? Do you want to be work with Databases but do not know where to start? If your answer is Yes! then this course is for you.
This mega course offers over 14 hours of content and teaches you all you need to Land that SQL data analyst Job. SQL is one of the most in demand skills of Data analysts and with this course you will learn the foundations of SQL, Database concepts and practice writing SQL queries. I have also provided quizzes after every section to help you hone your skills.
In this section we introduce SQL and what we are going to learn
2. Environment Setup
Here we install all the tools we will use (MySQL and all the sample databases)
3. All about select
Select is the backbone of SQL. Here we practice writing select queries and also different clauses in SQL
Here we discuss in detail MySQL in-built functions like Date Functions, Null functions etc
We discuss how you can join two different tables
6. Set Operators
Here we talk about the different set operators SQL handles
7. Advanced select statements
We look in More detail at the SQL select statements
8. Modifying Data
We talk about how you can modify existing data using SQL
9. Creating Databases and Tables
Here we look at how you can create your own Databases and Tables
10. Other DDL commands
We look into Other DML commands like Drop, Truncate etc
Here we look at Stored procedures, Indexes, views etc
12. Bonus Section
Here I give any important information that has helped me in the field. I will always be updating this for your benefit.
This is an exciting Journey that I hope you take with me. I am not expecting you to know anything at all about SQL and will start from scratch.
Who this course is for:
- Beginners Interested in Business Intelligence
- Anyone interested in Learning SQL
- Beginners interested in Data Analysis
My name is Sandra and I am so happy that you are reading this.
A little bit about myself. Professionally, I hold a degree in Computer Science. During my degree, I fell in love with Data Science and went on to get an M.Sc in the field. I am proud to say I have now worked more than 5 years in the field of Data Analysis, Business Intelligence and Data Science.
I am passionate about Data Science and education. I Co-founded a platform called Orezime (this means "what I am passionate about" in my native language), where i provide training on Data Analytics to both individuals and corporate Clients many of which have gone on to gain full-time employment in the field of Data Analysis and Business Intelligence.
I look forward to sharing my Passions with you.
We are the Orezime Learning a team of highly trained individuals with a passion for knowledge and who hope to share whatever knowledge we have with you. You will be hearing from us when new courses are released and more!
We are here to help you stay on the cutting edge of Data Science, Software development and Technology.
See you in class,