SQL with MySQL Database for Beginners - Zero to Hero
What you'll learn
- Grasp fundamentals of Databases, MySQL
- Comfortably navigate MYSQL Workbench
- Manipulate data in MySQL using SQL
- Master common SQL commands in MySQL Database
- Import Data from Excel, CSV files into MySQL
- Export data from MySQL into Excel or CSV Files
- Use MySQL database with Tableau
Requirements
- Basic computer skills
Description
Cut the unnecessary jargon and learn SQL with MySQL in a simple and easy way.
Data is a critical part of any job these days. Having SQL skills will help you accomplish many of the data task that your job requires. Whether you are trying to add new skills to enhance your career or looking for a new job, this course will help you add a critical skill that many jobs and employers seek today. SQL skills help you succeed in a large number of careers that range from technical to business.
This course will teach you everything you need to start using SQL and practicing SQL with MySQL.
You don't need hours of lectures to learn SQL and MySQL, that's exactly how I approached this course. I synthesized the information so that it is quick and easy to understand.
In this course I have simplified the process without getting into all the complex technical speak out so that anybody can learn SQL. This course is designed to make each step very easy to understand. I used the same methods that I use to teach business analysts and marketing analysts in my own group.
The course should not take full day, you can learn during your work day and practice as you go.
This course uses MySQL but most of the commands can also be applied to SQL Server.
Note: This is a beginner level course. If you have prior knowledge of SQL than this course might serve as refresher but won't teach you many advanced concepts.
Why you should learn from me?
I have been in Digital Marketing and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts. I understand both the technology and marketing side of business. I have dealt with many analytics technologies way before Google Tag manager existed and know the inner working of Digital Analytics.
In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.
Who this course is for:
- This course is for anybody who deals with data in their job and has no SQL background, this course will help them gain a valuable skills required to do their job.
- New graduates who are trying to get a job. Data is an essential part of every job these days. This course will add a valuable skill to the resume.
- Anybody who wants to learn the fundamentals of SQL.
- Anybody who wants to learn MySQL workbench
- Anybody who wants to learn the fundamentals of MySQL
Instructor
Anil is a seasoned Digital Marketing and Analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to startups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.
Anil has taught and trained several Marketing and Analytics folks in past nine years of teaching at UBC, University of Washington and Bellevue College, and speaking engagements at various conferences as well as his blog. He teaches Digital Marketing, Digital Analytics, Google Analytics, Tableau and Social Media courses. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.
Anil is the founder of Global Analytics Academy and Optizent, a Digital Marketing and Analytics consulting company.