{"id":547,"external_id":null,"title":"Databases and SQL at UTS Online","subtitle":null,"url":"https://intersect.org.au/training/schedule","organizer":"Intersect Australia","description":"A relational database is an extremely efficient, fast and widespread means of storing structured data, and Structured Query Language (SQL) is the standard means for reading from and writing to databases. Databases use multiple tables, linked by well-defined relationships, to store large amounts of data without needless repetition while maintaining the integrity of your data.\n\nMoving from spreadsheets and text documents to a structured relational database can be a steep learning curve, but one that will reward you many times over in speed, efficiency and power.\n\nDeveloped using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.\n\n#### You'll learn:\n\n- Understand and compose a query using SQL\n- Use the SQL syntax to select, sort and filter data\n- Calculate new values from existing data\n- Aggregate data into sums, averages, and other operations\n- Combine data from multiple tables\n- Design and build your own relational databases\n\n#### Prerequisites:\n\nThe course has no prerequisites.\n\n  \n  \n  \n**For more information, please click [here](https://intersect.org.au/training/course/sql101).**","start":"2024-05-31T09:30:00.000Z","end":"2024-05-31T12:45:00.000Z","sponsors":[],"venue":"","city":"","country":"Australia","postcode":null,"latitude":null,"longitude":null,"created_at":"2024-05-02T14:00:23.527Z","updated_at":"2024-05-28T14:00:23.599Z","source":"tess","slug":"databases-and-sql-at-uts-online","content_provider_id":5,"user_id":43,"online":true,"last_scraped":"2024-05-28","scraper_record":true,"keywords":[],"event_types":[],"target_audience":[],"capacity":null,"eligibility":["host_institution"],"contact":"training@intersect.org.au","host_institutions":["UTS"],"cost_basis":null,"cost_value":null,"fields":[],"scientific_topics":[],"operations":[],"nodes":[]}