Knowledge in Databases

Finding Data

Finding Data Introduction Now we know what data is and the questions we’re interested in, we’re ready to go out and hunt for it online. In this tutorial, you will learn where to start looking for data. In this course, we will then look at different ways of getting hold of data, before setting you loose to find data yourselves! Data Sources There are three basic ways of getting hold of data: Finding data – this involves searching and finding data that has already been released Getting hold of more data – asking for ‘new’ data from official sources e.g. through Freedom of Information requests. Sometimes data is public on a website but there is not a download link to get hold of it in bulk – but don’t give up! This data can be liberated with what datawranglers call scraping. Collecting data yourself – This means gathering data and entering it into a database or a spreadsheet – whether you work alone or collaboratively. In this tutorial we’ll focus on finding data that already has been released. We will deal with getting more data and collecting data yourself in future courses. Step 1: Identify your Data Source Many sources frequently release data for public use. Some examples: Government In recent years governments have begun to release some of their data to the public. Many governments host special (open) government data platforms for the data they create. For example the UK government started data.gov.uk to release their datasets. Similar data portals exist in the US, Brazil and Kenya – and in many other countries! Does your country have an open data portal (Datacatalogs.org is a good starting point)? Organisations Other sources of data are large organisations. The World Bank and the World Health Organization for example regularly release reports and data sets. Science Scientific projects and institutions release data to the scientific community and the general public. Open data is produced by NASA for example, and many specific disciplines have their own data repositories, some of which are open. More and more initiatives exist trying to provide access to already published data (e.g. Dryad) To help people to find data, projects like the Open Access Directory’s data repository listor the Open Knowledge Foundation’s datahub.io have been started. They aim either to collect data sources, or collect together different data sets from various sources. Step 2: Getting data in the format you need it In the “What is Data” course, we talked briefly about the importance of machine-readabledata. You’ll save yourself a lot of trouble and time in working with the data if you get hold of data in the correct format initially. Here’s a handy tip for how to tell Google which format you are looking for. Using data to answer your question Now that you have an overview of some of the key concepts related to data, it’s time to start hunting for your own! Over the next courses in the Data Fundamentals series, we will be further exploring the question we posed ourselves in the What is Data Course? How does healthcare spending influence life expectancy?. To get the data for this course, please see our recipe on Getting Data from the World Bank. Task: If you found your own alternative data to answer this question, congratulations! Take a moment to upload it to the DataHub – and have a browse to see what other School of Data learners have found. Extension Task: Explore the web, and see what open data you can find. If you find something really interesting and think of an exciting question it could help to address, tweet it to @SchoolofData – or write a short post for the School of Data blog

Chapter-11-OODBMS

Chapter-11-OODBMS

BIG DATA - DBMS

This knowledge describe the Big Data which is the part of DBMS. Some important chapters which are explained are Introduction to Big Data, Big Data Technology Foundations, Big Data Tools, Data analysis through Exploring R, Frameworks and Visualisation.

Lecture2-Big data Life cycle

Lecture2-Big data Life cycle

Lecture3-Big data technology foundations

This knowledge includes some important topics like Big Data Stack, Big Data Architecture and their Stack of Layers such as Data Sources Layer, Ingestion Layer, Storage Layer, Physical Infrastructure Layer, Data Query Layer, Security Layer, Monitoring Layer, Analytics Engine, Visualisation Layer, Big Data Application and other. 

sql-sqlite-commands-cheat-sheet(1)

sql-sqlite-commands-cheat-sheet(1)

SQL

SQL PPT

Stallings Data & Computer Comm 8th ed

This knowledge consists Data Communications, Data Networking, and the Internet, Protocol Architecture,TCP/IP, and Internet-Based Applications, Data Transmission, Transmission Media, Signal Encoding Techniques, Digital Data Communication Techniques, Data Link Control Protocols, Multiplexing, Spread Spectrum, Circuit Switching and Packet Switching, Asynchronous Transfer Mode, Routing in Switched Networks, Congestion Control in Data Networks, Cellular Wireless Networks, Local Area Network Overview, High-Speed LANs, Wireless LANs, Internetwork Protocols, Internetwork Operation, Transport Protocols, Network Security, Internet Applications—Electronic Mail and Network Management, Internet Applications—Multimedia.

Database management systems

Amity University database management system question paper 2016

SQL Server 2012 T-SQL Recipes

This book have several topics/chapters like Getting Started with SELECT, Elementary Programming, NULLs and Other Pitfalls, Querying from Multiple Tables, Grouping and Summarizing, Advanced Select Techniques, Aggregations and Windowing, Working with Strings, Dates and Times, Numbers, Transactions, Locking, Blocking, and Deadlocking, User-Defined Functions and Types, Error Handling, XML and Securables, Permissions, and Auditing.

SQL Anywhere® Server SQL Reference

SQL Anywhere® Server SQL Reference

Microsoft SQL server 2008

Microsoft SQL server 2008