SQL BootCamp – Learn MySQL for Data Analysis

Start using MySQL – the #1 Database Management SystemBoost your resume by learning an in-demand skillPrepare for SQL developer, Database administrator, Data Analyst, and Business Intelligence job opportunitiesDevelop business intuition while solving tasks with big dataTons of exercises that will solidify your knowledgeDo 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. Course Outline1. IntroductionIn this section we introduce SQL and what we are going to learn2. Environment SetupHere we install all the tools we will use (MySQL and all the sample databases)3. All about selectSelect is the backbone of SQL. Here we practice writing select queries and also different clauses in SQL4. FunctionsHere we discuss in detail MySQL in-built functions like Date Functions, Null functions etc5. JoinsWe discuss how you can join two different tables 6. Set OperatorsHere we talk about the different set operators SQL handles7. Advanced select statementsWe look in More detail at the SQL select statements8. Modifying DataWe talk about how you can modify existing data using SQL9. Creating Databases and TablesHere we look at how you can create your own Databases and Tables10. Other DDL commandsWe look into Other DML commands like Drop, Truncate etc11.Advanced SQLHere we look at Stored procedures, Indexes, views etc12. Bonus SectionHere 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. Cheers!SandraWho this course is for:Beginners Interested in Business IntelligenceAnyone interested in Learning SQLBeginners interested in Data Analysis