- Course type: Self-paced
- Available Lessons: 99
- Average Lesson Length: 8 min
Eligible for Certificate:
Certificates show that you have completed the course. They do not provide credit.
Watch a preview:chapter 1 / lesson 1What are Data? - Types, Sources & Definition
Course SummaryIf you're looking for a helpful and easy-to-use way to learn more about analytics, check out this Analytics 103: Intro to Relational Databases & SQL course. The mobile-friendly chapters and lessons found here are accessible at any time for convenient study.
to start this course today
Try it risk-free for 30 days
Course Practice TestCheck your knowledge of this course with a 50-question practice test.
- Comprehensive test covering all topics
- Detailed video explanations for wrong answers
About This Course
We've created our Analytics 103: Intro to Relational Databases & SQL course to assist you in expanding your knowledge of this topic or reviewing the subjects you're already familiar with. Made up of easily accessible chapters and lessons, just a few of the topics covered here include SQL queries and syntax, modifying data in SQL databases, the purpose and use of joins in SQL and much more. To ensure that you've understood what you've reviewed, each lesson is accompanied by a multiple-choice quiz to test your knowledge. At the end of each chapter, you'll also find a comprehensive chapter test. Any questions that come up as you work your way through the course may be directed to one of our experts through the Dashboard, giving you assistance with any of the subjects you find more challenging. You can take your time as you complete this course, viewing as many lessons and chapters as you choose on any computer or mobile device.
Whether you're a student looking to study for a test, an industry professional developing your skills or a teacher looking to refresh your curriculum, this professionally written course can help.
|Introduction to General & Relational Databases||Introduces data, databases and database management, plus entities and attributes as they're used in databases and the hierarchal, flat file and relational database models.|
|Relational Database Management Systems||Covers MySQL usage, the practical applications of SQL, installing Oracle database Express Edition and the purpose of the Microsoft SQL server.|
|Relational Database Design Fundamentals||Explains database schema design, the conventions and design of database tables, relational database design and primary and foreign keys.|
|Introduction to SQL Syntax & Queries||Details T-SQL, the history of SQL, basic and advanced SQL query syntax and the differences between SQL and NoSQL databases.|
|Database Table Design & SQL Data Types||Outlines SQL constraints, how schemas are used in SQL, the definition and commands of DDL and SQL data types such as INT, REAL, BOOLEAN and NUMERIC.|
|Using SQL to Populate & Retrieve Data||Explores grouping data in databases using CUBE and ROLLUP, the SQL INSERT statement, examples of SQL functions and sorting the results of a SQL query.|
|Modifying Data in Databases With SQL||Discusses SQL TRUNCATE strings and tables, the uses for SET operators in database management, the UPDATE statement and the use of both PIVOT and UNPIVOT in SQL.|
|Using SQL to Remove Data||Provides tutorials for the SQL DROP constraint, DROP tables and DROP view ,and also covers DROP columns and rows, the DROP index and DROP databases.|
|Joins & Subqueries Using SQL||Explains the differences between UNION and JOIN, the definition of a SQL join, the functionality of complex queries and examples of SQL subqueries.|
|Using Views, Indexes, & Triggers in SQL||Outlines indexes in SQL, examples of SQL views, referential constraints and integrity in databases, and the syntax used for SQL triggers.|
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Research Schools, Degrees & Careers
Get the unbiased info you need to find the right school.
Browse Articles By Category
Browse an area of study or degree level.
- Biological and Biomedical Sciences
- Communications and Journalism
- Computer Sciences
- Culinary Arts and Personal Services
- Liberal Arts and Humanities
- Mechanic and Repair Technologies
- Medical and Health Professions
- Physical Sciences
- Transportation and Distribution
- Visual and Performing Arts
- Relational Database Design Course and Class Information
- Relational Database Fundamentals Online Course Overview
- Careers that Are Creative & Analytical
- Careers for Analytical Extroverts
- Careers for Analytical Introverts
- Analytical Essay Topics for Teachers
- Analytical Chemistry Master's Degree
- PhD in Analytical Chemistry Programs
- Business Analytics Graduate Programs
- Healthcare Analytics Certificate Programs
- Answers and detailed explanations to each question
- Video lessons to explain complicated concepts
Explore our library of over 79,000 lessons
- College Courses
- High School Courses
- Other Courses