Introduction to SQL For Business & Finance

A Virtual Bootcamp in Partnership with Women in Analytics

Attend Download Syllabus

COURSE OVERVIEW


According to an MIT Technology Review article, the amount of digital data being created globally is doubling every two years. Yet only about 0.5% of that data is ever analyzed.

Specifically, having a keen understanding of SQL is important as a great deal of corporate data is stored in tabular format. Being able to efficiently work with very large tables to access key information can help professionals add unprecedented value to their organizations as they can better answer various strategic questions after accessing such data. Such information can help organizations develop and sustain competitive advantages. As a result, employers often rank SQL skills as one of the most important skills for today's professional.

In this hands-on course, participants will learn introductory SQL concepts and queries, which will help them effectively work with relational databases.

Attendees can use either a Mac or Windows computer for this workshop. The workshop will be conducted through virtual conference software. Instructions on how to download and configure all software will be provided prior to the course.

place
Virtual Bootcamp
insert_invitation
Friday
December 11th, 2020
9:00AM - 5:00PM ET
terrain
Course Prerequisites
None

For any question, please contact us at info@cognitir.com.

This virtual bootcamp is hosted in partnership with Women in Analytics (WIA). Discount codes for both student and professional WIA members are available.

Already have a discount code?

Great! Please enter your discount code above to make use of our student or member rates for this event.

Are you a student and don't have a discount code?

Discount codes are available for both student and professional WIA members. Please get in touch at info@cognitir.com.

Note: Students may need to provide proof of current enrollment for both undergraduate and graduate studies. Cognitir may require additional information to confirm student status.

WHAT THIS COURSE OFFERS


home
Learn from the comfort of your own home

You'll be part of a virtual classroom. We will send out all the instructions prior to the course - you only have to make sure a stable broadband internet connection is available.

cloud
Understanding of Databases

An overview of relational and nonrelational databases and where SQL fits into the story.

insert_emoticon
Collaborate with others

You will have opportunities to interact with the instructor and other participants during and after the course. Our virtual classroom lets you chat and speak.

build
Hands-On SQL Experience

This classes use hands-on exercises to help students apply theory to practice. Students write their own SQL queries during the workshop.

lightbulb_outline
Problem Solving Strategies

Understanding of how to use SQL to answer key strategic questions.

timeline
Exposure to Database Management Systems

Understanding of what database management systems exist and how to pick one for your organization.

group
Collaborative Exercises

Participants will have opportunities to work with other attendees on in-class exercises & tap the expertise of his/her Cognitir instructor on individual SQL-related projects.

card_travel
Support Beyond the Classroom

All Cognitir participants receive course notes, a certificate of completion, instructions on how to add the course to their LinkedIn profiles, and post-seminar email support

WHO IS THIS FOR


This course is relevant for both business and nonbusiness students who work with relational databases. Students from corporate strategy, finance, consulting, medicine, law, public policy, sports analytcs, etc. have all benefited from taking this hands-on course.

No prior programming experience required.

Not sure if this is the right course for you? Contact us.

What Past Cognitir Participants Say


"Easy to jump in with little to no knowledge of topic, learned a lot."
– Andrew K.
"The training was great!"
– Amit S.
"Instructor was extremely helpful and patient."
– Grace M.
"Very informative & accessible; helpful for executing my research."
– Margaret S.

Course Specific Questions


Do I need experience with databases and/or computer programming to join this course?

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.

How is this course different from Cognitir's Introduction to Data Science?

This course focuses on helping professionals access information from relational (tabular) databases. This means that all information must be in table form in order to use SQL. We do not cover data science theories or nonrelational database querying in this class. Python can absolutely be used with SQL for advanced functionality, but we do not cover this specifically in the introductory course.

Do I have the right computer for this course? (Minimum system requirements)

You will need a PC (Windows Vista or newer), Mac (OS X 10.7 or newer), or Linux (Ubuntu, RedHat and others; CentOS 5+). Your computer will need a stable internet connection (see item below), speakers and microphone. We recommend at least a Dual Core 2Ghz or higher (i3/i5/i7 or AMD equivalent) processor with 4GB of RAM. Our software can be run from almost any browser (IE, Chrome, Safari) but we encourage participants to use Chrome for a seamless experience.

Please contact us if you are planning to use a different setup for this course.

What are the internet/bandwidth requirements for this course?

Participation in this virtual course requires a stable internet connection. You can test the speed of your internet connection here. It is recommended to have download and upload speeds of at least 3.0 Mbps.

Do I need to install software prior to the class?

Yes, you will need to download and install free SQL 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. The video conference and chat software that is used during the course can be accessed directly from your browser. We will send out detailed information on the download and installation procedures a few days before the course starts.

Visit our FAQs to see commonly asked questions from participants about our courses.

Download Syllabus


Get in touch directly:

Questions about this course? Enquiring about training availability? We'd love to hear from you!