SQL Programming with MariaDB: Analyzing Relational Data

To query data with SQL you need to know which queries and keywords to use for which operations. In this course youll learn to query data using the classic SQL syntax construct the SELECT-FROM-WHERE query and how keywords such as LIKE can be used to filter data based on a condition and using wildcards. Youll learn how to carry out different aspects of inserting updating and deleting data – such operations along with querying are collectively known as CRUD operations an acronym for Create-Read-Update-Delete. Finally youll learn how to take advantage of another important aspect of relational database usage – the ability to impose constraints upon data. Youll work with UNIQUE NOT NULL and FOREIGN KEY constraints.