Adam Brazier joined the Cornell Center for Advanced Computing in 2014 and is a member of the Consulting Group. He has been working in research at Cornell since 2005, first as a Research Associate in the Astronomy Department, and then as an Astronomy Programmer at the National Astronomy and Ionosphere Center and latterly Science Software Architect for the CCAT Telescope project. With a focus on the computational and data-intensive aspects of research at all stages of the research life cycle, Adam is a member of the international North American Nanohertz Observatory for Gravitational Waves (NANOGrav) and the PALFA pulsar survey collaboration.
COURSE OVERVIEW
Relational databases are workhorses which form the backbone for much of the information we find at our fingertips on the internet. In this course, you will learn to create and modify databases using OmniDB and structured query language (SQL) to import data, create tables, and modify fields. You will also practice cleaning data to maintain your database and ensure that it provides accurate information. As the course progresses, you will identify questions you want answered and practice translating those questions into SQL. You will also examine different forms of outputting data from a database, including outputting to a program or text file and outputting CSV text.
KEY COURSE TAKEAWAYS
- Create a database with SQL
- Load a database and clean data
- Turn a question about data into an SQL query
- Output data
How It Works
Course Length
2 weeks
Effort
3-5 hours per week
Format
100% online, instructor-led
Course Author
Computational Scientist at Cornell University Center for Advanced Computing
Who Should Enroll
- Data scientists
- Business analysts
- Developers
- Professionals who work with databases or data warehouses
- Marketing analysts
- Career starters
GET IT DONE
100% ONLINE
100% ONLINE
Our programs are expressly designed to fit the lives of busy professionals like you.
LEARN FROM
CORNELL'S TOP MINDS
CORNELL'S TOP MINDS
Courses are personally developed by faculty experts to help you gain today's most in-demand skills.
POWER YOUR
CAREER
CAREER
Cornell's internationally recognized standard of excellence can set you apart.
Stack to a Certificate
Request Information Now
Act today—courses are filling fast.