SQL Mastery & Data Analysis
- None At All.
Note: Since our Main Course on SQL Mastery is delayed by a few more days, I am uploading another lecture in this Free Teaser course, on Transactions. This topic will add tremendous value to your understanding of Database concepts.
There 'may be' a Million Jobs in Data Science.
There ARE MULTI MILLION number Jobs needing Strong SQL Skills !! For every Python resource needed, there are 10-20 SQL resources need.
SQL is one of THE BASIC needs of any IT professional (Software, Analyst, Engineering, Data Management , Reporting or anything !).
Anyone and Everyone - whether you are a Startup Enthusiast/Entrepeneur, Developer, Analyst, Call Center employee, Manager, Leader or just about ANYONE looking to tap the power of Software to scale up your business, career or launch your own startup, you MUST have strong SQL Skills.
MySQL is an opensource and ABSOLUTELY FREE Database system that pretty much is used by a MAJORITY of Startup companies (along with PhP).
This course is a Teaser for my upcoming course on SQL Mastery & Data Analysis, planned to publish by end of November.
This teaser will give a sneak preview of my main course. I have worked on Data Management multi-year projects for Credi Card (Providian, Amex etc.), Banking (Credit Suisse, Wells, BoFA etc.) and many other corporations and have crunched upto billions of rows in processing (for a SINGLE transaction table !). I am on a mission to prepare an Easy to Understand and Wholesome course on SQL Mastery that anyone (from the Smartest to the Dumbest in the room) can conquer easily. I want everyone to just Monkey their way to SQL Mastery without feeling confused or intimidated by it.
In this Course, I First attempt to explain Database and SQL concepts from a Layman's perspective or a Managerial view - without specific Tool or Language semantics. After the concepts, I move on to MySQL specific workings in the main course.
I plan to include plenty and plenty of working sql code for learning and practice.
Any FEEDBACK or SUGGESTIONS received, will be considered in the main course.
Who this course is for:
- My Goal is to Teach even that 'Monkey on the Tree' how to write complex queries !!
- Anyone from a Highschool student to a CIO can take this course !
- Students, Data Analysts, Excel and MS Access users, Developers, Managers, Business Persons
- The Smartest in the Room, the Dumbest in the Room.
- Just know basic math - What is Addition, What is Subtraction, Multiplication. Trigonometry, if you please.
- 11:40Goals & Objectives
- 09:22Why do We Need SQL?
- 23:39SQL Concepts
- 16:56Introduction to SELECT
- 11:34Sample Lecture: What is a Database System?
- 24:45Understanding Transactions
I am an experienced Data and Business Intelligence professional with tremendous exposure to business applications of BI using several BI tools - MicroStrategy, Cognos, Business Objects, Power BI. I have designed and architect ed several enterprise Datawarehouse and BI implementations for top companies in Networking, Manufacturing, Entertainment,BFSI, Healthcare industries. Have lead several Projects/Programs for major industry verticals.
I have designed Corporate Training programs to educate and empower analysts (from 500 up to 3000 analysts) for several Organizations.
I am a Key member of Maverick Learning* and also an Advisor to few starts-ups in Mobile, Communication and Data Intelligence space.
We also conduct live/personal coaching sessions for those who need additional help.
You can also check out my book: "A Practical Guide To Data Quality" by Sriharsha Nalkund on Amazon.
I have also designed revenue generating Web Applications, Client-Server Apps, Data Integration solutions for Financial, Networking, Entertainment, Corporate Service, Manufacturing and other Industry verticals.
I am also Consulting as an Advisor to a few startups. You can contact me for more information or to dicsuss further.
*Maverick Learning offer several courses on Data and Business Intelligence, Data Quality, Datawarehouse, Web Development, Mobile Application Development, Database Development and others.