Join Barton Poulson for an in-depth discussion in this video Structured data, part of Big Data Foundations: Techniques and Concepts.
- Data is said to be structured…when it's placed in a file with fixed fields or variables.…The most familiar example of this kind of structured…database is a spreadsheet.…Where every column is a variable…and every row is a case or observation.…In the business world however,…large data sets are usually stored in databases.…Relational databases to be specific,…which share some characteristics with spreadsheets…such as rows and columns,…but allow for much larger data sets,…more flexibility, and more constancy.…A recent survey of database users found that…nearly 80 percent use some form of relational database…with Microsoft SQL server, MySQL, and Oracle…as the most common options.…
Now, before I say anymore,…I need to give you a very brief history of SQL databases.…In the early 70's researchers at IBM…wrote a paper describing the…Structured English Query Language…or SQL written as the word.…Name was later changed to SQL because of a copyright issue,…but it's still generally pronounced “sequel”.…IBM however did not commercially launch SQL.…
Author
Released
10/22/2014Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- What makes big data "big"
- Understanding how big data impacts consumers, businesses, and research
- Exploring the intersection of data science and big data
- Facing big data's ethical challenges
- Understanding the sources and structures of big data
- Storing big data
- Prepping big data for analysis
Skill Level Beginner
Duration
Views
Related Courses
-
Learning NoSQL Databases
with Joseph LeBlanc56m 53s Intermediate
-
Introduction
-
Welcome1m 13s
-
-
What Is Big Data?
-
2. How Is Big Data used?
-
3. Big Data and Data Science
-
4. Ethics in Big Data
-
Challenges with anonymity5m 51s
-
-
5. Sources and Structures of Big Data
-
Machine-generated data4m 20s
-
Structured data2m 47s
-
Unstructured data5m 50s
-
6. Storing Big Data
-
7. Preparing Data for Analysis
-
Challenges with data quality3m 38s
-
Additional Vs of big data4m 41s
-
-
8. Big Data Analysis
-
Predictive analytics5m 20s
-
Big Data Visualization4m 17s
-
Conclusion
-
Next steps1m 58s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Structured data