We may earn an affiliate commission when you visit our partners.
Sadie St. Lawrence
As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems.
Read more
As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems.
Read more
As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems.
This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables. You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results.
You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes.
Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in landing a job in the best occupation in the US and soon the world!
Register for this course and see more details by visiting:
OpenCourser.com/course/kaa6ak/sql
What's inside
Syllabus
Erste Schritte sowie Auswählen und Abrufen von Daten mit SQL
In diesem Modul lernen Sie, SQL zu definieren und zu diskutieren, wie sich SQL von anderen Computersprachen unterscheidet. Sie werden in der Lage sein, die Rollen eines Datenbankadministrators und eines Data Scientist zu vergleichen und die Unterschiede zwischen Eins-zu-eins-, Eins-zu-viele- und Viele-zu-viele-Beziehungen mit Datenbanken zu erklären. Sie werden in der Lage sein, die SELECT-Anweisung zu verwenden und einige grundlegende Syntaxregeln zu erläutern. Sie werden in der Lage sein, Kommentare in Ihren Code einzufügen und dessen Bedeutung zu erfassen.
Read more
Syllabus
Erste Schritte sowie Auswählen und Abrufen von Daten mit SQL
In diesem Modul lernen Sie, SQL zu definieren und zu diskutieren, wie sich SQL von anderen Computersprachen unterscheidet. Sie werden in der Lage sein, die Rollen eines Datenbankadministrators und eines Data Scientist zu vergleichen und die Unterschiede zwischen Eins-zu-eins-, Eins-zu-viele- und Viele-zu-viele-Beziehungen mit Datenbanken zu erklären. Sie werden in der Lage sein, die SELECT-Anweisung zu verwenden und einige grundlegende Syntaxregeln zu erläutern. Sie werden in der Lage sein, Kommentare in Ihren Code einzufügen und dessen Bedeutung zu erfassen.
Read more
Filtern, Sortieren und Berechnen von Daten mit SQL
In diesem Modul lernen Sie, mehrere neue Klauseln und Operatoren zu verwenden, darunter WHERE, BETWEEN, IN, OR, NOT, LIKE, ORDER BY und GROUP BY. Sie werden in der Lage sein, die Platzhalterfunktion zu nutzen, um nach spezifischeren Datensätzen oder Teilen von Datensätzen zu suchen, einschließlich ihrer Vor- und Nachteile, und wie man sie am besten einsetzt. Sie werden in der Lage sein, die Verwendung grundlegender mathematischer Operatoren sowie von Aggregatfunktionen wie AVERAGE, COUNT, MAX, MIN und anderen zu diskutieren, um mit der Analyse unserer Daten zu beginnen.
Unterabfragen und Verknüpfungen in SQL
In diesem Modul lernen Sie, Unterabfragen zu erörtern, einschließlich ihrer Vor- und Nachteile und wann sie zu verwenden sind. Sie können sich an das Konzept eines Schlüsselfeldes erinnern und erörtern, wie diese uns helfen, Daten mit Verknüpfungen zu verknüpfen. Sie werden in der Lage sein, verschiedene Arten von Verknüpfungen zu identifizieren und zu definieren, darunter die kartesische Verknüpfung, die innere Verknüpfung, linke und rechte Verknüpfungen, vollständige äußere Verknüpfungen und die Selbstverknüpfung. Sie werden in der Lage sein, Aliase und Präqualifikatoren zu verwenden, um Ihren SQL-Code ordentlicher und effizienter zu gestalten.
Ändern und Analysieren von Daten mit SQL
In diesem Modul werden Sie lernen, wie Sie Zeichenketten durch Verketten, Trimmen, Ändern der Groß- und Kleinschreibung und die Verwendung der Teilzeichenfolgen-Funktion verändern können. Sie werden in der Lage sein, die Datums- und Uhrzeitzeichenfolgen genau zu besprechen. Sie werden in der Lage sein, Case-Anweisungen zu verwenden und dieses Modul mit einer Diskussion über Daten-Governance und Profiling abzuschließen. Sie werden auch in der Lage sein, grundlegende Prinzipien bei der Verwendung von SQL für Data Science anzuwenden. Sie werden in der Lage sein, Tipps und Tricks zu nutzen, um SQL in einem Data-Science-Kontext anzuwenden.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Die Wichtigkeit von SQL wird im heutigen Datenzeitalter hervorgehoben
Der Kurs konzentriert sich auf die Grundlagen von SQL und ermöglicht den Teilnehmern den Einstieg in die Datenwissenschaft
Der Kursleiter Sadie St. Lawrence ist ein Experte auf diesem Gebiet mit einer ausgeprägten Leidenschaft für die Datenwissenschaft
Der Kurs bietet einen soliden Einstieg in SQL und Datenanalyse, wodurch er für Anfänger und Berufstätige, die ihre Fähigkeiten erweitern möchten, geeignet ist
Der Kurs vermittelt grundlegende SQL-Konzepte wie Abfragen, Filterung und Verknüpfungen
Die praktische Ausrichtung des Kurses ermöglicht es den Teilnehmern, ihr Verständnis durch praktische Übungen zu vertiefen
Save this course
Save SQL für Data Science to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL für Data Science with these
activities:
Organize Course Materials
Show steps
Organize and review the course materials to improve your understanding and retention.
Show steps
-
Gather course notes, assignments, quizzes, and exams.
-
Review the materials regularly to reinforce what you've learned.
-
Create summaries or concept maps for key topics.
Join a Study Group
Show steps
Engage with peers to discuss course topics, solve problems, and share insights.
Show steps
-
Find or form a study group with other students taking the course.
-
Set regular meeting times.
-
Review course materials together.
-
Collaborate on exercises and assignments.
Practice SQL Queries
Show steps
Sharpen your SQL querying skills and reinforce your understanding of SQL syntax and concepts.
Browse courses on
SQL Queries
Show steps
-
Find online SQL practice platforms, such as SQLZoo or W3Schools.
-
Complete a series of SQL queries, ranging from simple to complex.
-
Review your results and identify areas for improvement.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Build a Database Schema
Show steps
Apply your SQL knowledge to design and create a database schema for a specific problem or scenario.
Browse courses on
Database Modeling
Show steps
-
Identify the entities and relationships in the given problem or scenario.
-
Design the database tables and their attributes.
-
Create the database schema using SQL.
-
Validate your schema by inserting and querying data.
Explore Advanced SQL Techniques
Show steps
Expand your SQL knowledge by exploring advanced topics related to performance optimization, indexing, and window functions.
Browse courses on
Advanced SQL
Show steps
-
Identify online tutorials or courses on advanced SQL techniques.
-
Follow the tutorials and work through the exercises.
-
Experiment with your own SQL queries to apply what you've learned.
Tutor Other Students
Show steps
Reinforce your understanding of SQL concepts by helping other students.
Show steps
-
Identify opportunities to tutor students who are struggling with SQL.
-
Set up tutoring sessions.
-
Work with students to review course materials.
-
Help students solve problems and understand concepts.
Contribute to an Open-Source SQL Project
Show steps
Gain practical experience and contribute to the broader SQL community.
Browse courses on
Open Source
Show steps
-
Find an open-source SQL project that aligns with your interests.
-
Join the project and contribute according to their guidelines.
-
Work on bug fixes, feature enhancements, or documentation.
-
Review and discuss code with other contributors.
Organize Course Materials
Show steps
Organize and review the course materials to improve your understanding and retention.
Show steps
Show steps
Show steps
- Gather course notes, assignments, quizzes, and exams.
- Review the materials regularly to reinforce what you've learned.
- Create summaries or concept maps for key topics.
Join a Study Group
Show steps
Engage with peers to discuss course topics, solve problems, and share insights.
Show steps
Show steps
Show steps
- Find or form a study group with other students taking the course.
- Set regular meeting times.
- Review course materials together.
- Collaborate on exercises and assignments.
Practice SQL Queries
Show steps
Sharpen your SQL querying skills and reinforce your understanding of SQL syntax and concepts.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Find online SQL practice platforms, such as SQLZoo or W3Schools.
- Complete a series of SQL queries, ranging from simple to complex.
- Review your results and identify areas for improvement.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Build a Database Schema
Show steps
Apply your SQL knowledge to design and create a database schema for a specific problem or scenario.
Browse courses on
Database Modeling
Show steps
Show steps
Show steps
- Identify the entities and relationships in the given problem or scenario.
- Design the database tables and their attributes.
- Create the database schema using SQL.
- Validate your schema by inserting and querying data.
Explore Advanced SQL Techniques
Show steps
Expand your SQL knowledge by exploring advanced topics related to performance optimization, indexing, and window functions.
Browse courses on
Advanced SQL
Show steps
Show steps
Show steps
- Identify online tutorials or courses on advanced SQL techniques.
- Follow the tutorials and work through the exercises.
- Experiment with your own SQL queries to apply what you've learned.
Tutor Other Students
Show steps
Reinforce your understanding of SQL concepts by helping other students.
Show steps
Show steps
Show steps
- Identify opportunities to tutor students who are struggling with SQL.
- Set up tutoring sessions.
- Work with students to review course materials.
- Help students solve problems and understand concepts.
Contribute to an Open-Source SQL Project
Show steps
Gain practical experience and contribute to the broader SQL community.
Browse courses on
Open Source
Show steps
Show steps
Show steps
- Find an open-source SQL project that aligns with your interests.
- Join the project and contribute according to their guidelines.
- Work on bug fixes, feature enhancements, or documentation.
- Review and discuss code with other contributors.
Career center
Learners who complete SQL für Data Science will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst uses structured query language (SQL) to extract data from databases and communicate it to stakeholders. This course can help aspiring and current Data Analysts develop the foundational skills necessary to begin a successful career in the field and cultivate a competitive edge in the job market.
Database Administrator
Database Administrator
A Database Administrator (DBA) manages and maintains databases, including their backups, performance, security, and configuration, for optimum performance, availability, and recovery from failures. This course will give aspiring and current DBAs a primer in the fundamentals of SQL and working with data so they begin working with data from the get-go.
Data Scientist
Data Scientist
Data Scientists use SQL to prepare data, clean it, and get it ready for analysis, which is useful at nearly every stage of the data science process. A Data Scientist may also be responsible for developing and implementing solutions to help a business make better decisions and predict future trends. As such, this course may be useful for aspiring and current Data Scientists to make themselves more well-rounded and qualified candidates in their field.
Data Engineer
Data Engineer
A Data Engineer focuses on building, maintaining, and optimizing data pipelines. They ensure that data is collected, processed, and stored in a way that enables Data Scientists and others to do their jobs. This course can help aspiring and current Data Engineers get started or advance in their career by helping them build a foundation in using SQL to prepare and manage data.
Business Analyst
Business Analyst
Business Analysts serve as a liaison between the business and IT departments, translating business requirements into technical specifications. Business Analysts with a strong understanding of SQL can better communicate with database administrators and data engineers, building more effective data management systems for organizations. This course can help aspiring and current Business Analysts gain the SQL skills they need to succeed in their roles.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains computer software. While they do not typically specialize in SQL, it is a fundamental and valuable skill many employers seek. This course can help aspiring and current Software Engineers enhance their marketability by sharpening their SQL skills, making them more competitive in the job market.
IT Manager
IT Manager
An IT Manager plans and manages an organization's information technology resources, ensuring the efficient use of hardware and software and the maintenance of secure networks. This course can help aspiring and current IT Managers gain a deeper understanding of SQL, helping them lead and manage a team of Data Analysts and other IT professionals who are responsible for managing an organization's SQL-based databases.
Project Manager
Project Manager
A Project Manager plans, executes, and closes projects. They are responsible for keeping projects on track, within budget, and meeting stakeholder expectations. This course can be useful for aspiring and current Project Managers, providing them with a deeper understanding of SQL and how it can be utilized both in data and project management.
Web Developer
Web Developer
A Web Developer designs and builds websites. While they do not typically specialize in SQL, many modern web applications require an understanding of SQL to some extent. This course can be useful for aspiring and current Web Developers, helping them build a foundation in using SQL to interact with and manage databases.
Product Manager
Product Manager
A Product Manager manages the development and launch of new products. While they may not directly use SQL, having a basic understanding of the technology can help them communicate with their engineering team and understand the data that drives product decisions. This course can be useful for aspiring and current Product Managers, providing them with a basic foundation in SQL and its uses.
Systems Analyst
Systems Analyst
A Systems Analyst analyzes and designs computer systems. This often includes working with SQL to design database structures and write queries to retrieve and analyze data. This course can help aspiring and current Systems Analysts gain a deeper understanding of SQL, enabling them to perform these tasks more effectively and advance their careers.
Technical Writer
Technical Writer
A Technical Writer creates instruction manuals, technical reports, and other documentation. While they do not typically specialize in SQL, they may find a basic understanding helpful if they are expected to write documentation for software that uses it. This course can be useful for aspiring and current Technical Writers who want to expand their knowledge of the technology landscape and write more effective documentation.
Data Architect
Data Architect
A Data Architect designs, builds, and maintains an organization's data infrastructure. This includes designing data models, choosing appropriate technologies, and ensuring data quality. This course can provide aspiring and current Data Architects with a valuable foundation in SQL, enabling them to design and manage data architectures that meet the needs of modern businesses.
Database Designer
Database Designer
A Database Designer designs and creates databases that meet the needs of organizations and their users. This includes designing data models, choosing appropriate data types, and creating database objects. This course can provide aspiring and current Database Designers with a valuable foundation in SQL, enabling them to design and create databases that are efficient, scalable, and meet the needs of their users.
Information Security Analyst
Information Security Analyst
An Information Security Analyst protects an organization's computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This includes monitoring security logs, investigating security incidents, and implementing security measures. This course can provide aspiring and current Information Security Analysts with a valuable foundation in SQL, enabling them to analyze security data, identify threats, and protect their organizations from cyberattacks.
For more career information including salaries, visit:
OpenCourser.com/course/kaa6ak/sql
Reading list
We've selected ten books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL für Data Science.
Save
Dieses Buch bietet einen umfassenden Überblick über Computer Vision. Es deckt Themen wie Bildverarbeitung, Objekterkennung und Bildsegmentierung ab. Es ist eine wertvolle Ressource für diejenigen, die Computer Vision von Grund auf lernen möchten.
Save
Dieses Buch bietet einen umfassenden Überblick über Deep Learning. Es deckt Themen wie neuronale Netze, Convolutional Neural Networks und Recurrent Neural Networks ab. Es ist eine wertvolle Ressource für diejenigen, die Deep Learning von Grund auf lernen möchten.
Dieses Buch bietet einen umfassenden Überblick über Reinforcement Learning. Es deckt Themen wie Markov-Entscheidungsprozesse, dynamische Programmierung und Q-Learning ab. Es ist eine wertvolle Ressource für diejenigen, die Reinforcement Learning von Grund auf lernen möchten.
Dieses Buch bietet einen umfassenden Überblick über die Verarbeitung natürlicher Sprache. Es deckt Themen wie Tokenisierung, Part-of-Speech-Tagging und maschinelle Übersetzung ab. Es ist eine wertvolle Ressource für diejenigen, die die Verarbeitung natürlicher Sprache von Grund auf lernen möchten.
Dieses Buch bietet einen umfassenden Überblick über SQL für Data Scientists. Es deckt fortgeschrittene Themen wie Unterabfragen, Verknüpfungen und Datenmodifikation ab. Es ist eine wertvolle Ressource für diejenigen, die ihre SQL-Kenntnisse vertiefen möchten.
Dieses Buch bietet einen umfassenden Überblick über Data Science. Es deckt Themen wie Datenbereinigung, Datenanalyse und maschinelles Lernen ab. Es ist eine wertvolle Ressource für diejenigen, die Data Science von Grund auf lernen möchten.
Dieses Buch behandelt häufige Fehler, die bei der SQL-Programmierung gemacht werden. Es ist eine wertvolle Ressource für diejenigen, die ihre SQL-Kenntnisse verbessern und häufige Fehler vermeiden möchten.
Dieses Buch behandelt SQL-Injection-Angriffe und wie man sich davor schützt. Es ist eine wertvolle Ressource für diejenigen, die die Sicherheit ihrer SQL-Anwendungen verbessern möchten.
Dieses Buch enthält einen unkomplizierten Ansatz für SQL. Es deckt die Grundlagen von SQL ab und ist eine gute Wahl für diejenigen, die neu in SQL sind und es auf einfache Weise lernen möchten.
Save
Dieses Buch ist eine schnelle und einfache Einführung in SQL. Es deckt die Grundlagen von SQL ab und eignet sich für diejenigen, die schnell einsteigen möchten.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/kaa6ak/sql
Share
Similar courses
Here are nine courses similar to
SQL für Data Science.
SQL for Data Science
OpenCourser.com/course/r7yc6j/sql
SQL for Data Science
Most relevant
Python for Data Science and Machine Learning Bootcamp
OpenCourser.com/course/obiu77/python
Python for Data Science and Machine Learning Bootcamp
The Advanced SQL Server Masterclass For Data Analysis
OpenCourser.com/course/9g13xd/the
The Advanced SQL Server Masterclass For Data Analysis
R Data Science Capstone Project
OpenCourser.com/course/yna6j5/r
R Data Science Capstone Project
Migrating On-premises MySQL Using a Continuous Database Migration Service Job
OpenCourser.com/course/kcrad7/migrating
Migrating On-premises MySQL Using a Continuous Database...
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
OpenCourser.com/course/iy7771/sql
SQL & Database Design A-Z™: Learn MS SQL Server +...
Databases and SQL for Data Science with Python
OpenCourser.com/course/v5ecv3/databases
Databases and SQL for Data Science with Python
SQL for Data Science
OpenCourser.com/course/eoz1cw/sql
SQL for Data Science
The Data Science Course: Complete Data Science Bootcamp 2024
OpenCourser.com/course/9unb5g/the
The Data Science Course: Complete Data Science Bootcamp...
Effort
4 weeks of study, 3-5 hours/week
Level
Introductory
Via
Coursera
Institution
University of California, Davis
Instructor
Sadie St. Lawrence
Language
Deutsch
Transcripts
English
Español
Français
Português
Italiano
العربية
Pусский
tiếng Việt
Good to know
Die Wichtigkeit von SQL wird im heutigen Datenzeitalter hervorgehoben
Der Kurs konzentriert sich auf die Grundlagen von SQL und ermöglicht den Teilnehmern den Einstieg in die Datenwissenschaft
Der Kursleiter Sadie St. Lawrence ist ein Experte auf diesem Gebiet mit einer ausgeprägten Leidenschaft für die Datenwissenschaft
Der Kurs bietet einen soliden Einstieg in SQL und Datenanalyse, wodurch er für Anfänger und Berufstätige, die ihre Fähigkeiten erweitern möchten, geeignet ist
Der Kurs vermittelt grundlegende SQL-Konzepte wie Abfragen, Filterung und Verknüpfungen
Die praktische Ausrichtung des Kurses ermöglicht es den Teilnehmern, ihr Verständnis durch praktische Übungen zu vertiefen
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser