An overview of relational and nonrelational databases and where SQL fits into the story.
This classes use hands-on exercises to help students apply theory to practice. Students write their own SQL queries during the workshop.
Understanding of how to use SQL to answer key strategic questions.
Understanding of what database management systems exist and how to pick one for your organization.
Coding projects and snippets to showcase if you are job-hunting.
All Cognitir participants receive a certificate of completion, and instructions on how to add the course to their LinkedIn profiles.
This class is relevant for professionals in FP&A, business intelligence, corporate strategy, corporate development, PE/VC, data analytics, and data science roles.
No prior programming or database experience required.
Not sure if this is the right course for you? Contact us.
No, you do not need any prior experience with databases or experience programming to take this course. While some exposure to databases might be helpful in internalizing the concepts, there are absolutely no prerequisites. Attendees with and without database experience have greatly benefited from taking this course.Do I have the right laptop for this course?
You will need a PC (Windows Vista or newer), Mac (OS X 10.7 or newer), or Linux (Ubuntu, RedHat and others; CentOS 5+). Please contact us if you are planning to use a different setup for this course.Do I need to install software for this course?
Yes, you will need to download and install free database software on your laptop. In case you are planning on using a company laptop, please make sure that you have the necessary rights to install the tools. You will receive detailed information on the download and installation procedures during the course and Cognitir will assist you with any setup issues.
Yu is currently a data scientist at Everyday Labs, an edtech firm, where he focuses on building data-driven products that help public school districts improve attendance and academic outcomes. He has built machine learning attrition models, financial data ETL pipelines, and natural language processing features for technology startups, financial services companies, global entertainment distributors, and large multinationals.
Yu is also an Adjunct Professor of Data Science and Operations at USC, where he teaches graduate courses on natural language processing and business analytics.
Yu received his MBA from UCLA Anderson and his Masters in Computer Science from Syracuse University.