How we do it?
How we do it?
About the Course
When working with computing systems, storing and accessing data in a structured fashion, is often required. Storing and retrieving client details, social media posts, messages within messaging applications, and streaming services (to name a few) all require a Database (DB) of some description.
Databases allow us to use the important information that is required for everyday use within the IT industry.
This course will outline how to work with both SQL and NoSQL databases, and how to effectively store and retrieve information.
This course will This course will be split in to two domains: SQL and NoSQL.
- How to install and setup MySQL
- Analyse and understand the structure of a MySQL database
- Learn basic MySQL Command Line Interface (CLI) syntax
- Use the MySQL CLI to make queries
- Design and Build SQL database
- Some advanced MySQL concepts
- Hot to install and setup MongoDB
- Analyse and understand the structure of a MongoDB databse
- Learn basic MongoDB Command Line Interface (CLI)
- Design and build a NoSQL Database
- Some advanced MongoDB concepts
Who should attend?
This course is well suited to any individual with little to no knowledge of Databases that have a desire to begin to bridge the technical skills gap, and add value to their skills set.
To anyone looking to bolster their current role, or those looking to move in to a role that would be well supported by database knowledge (researchers, analysts, students from all disciplines)
It would also act as an excellent refresher for those who have some exposure to database management before.
Introduction to Database Management Systems
Introduction to Structured Query Language (SQL)
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Data Retrieval Language (DRL)
- Data Control Language (DCL)
- Transaction Control Statements (TCS)
Create, Read, Update and Delete
- CREATE TABLE
- Constraints: Unique, Not Null, Check, Primary Key, Foreign Key
- INSERT INTO: Inserting records in to tables
- SELECT … WHERE: Select statement where [mathematical/relational/logical operators]
- DELETE: Deleting records
- UPDATE: Updating records
- ALTER TABLE: Add or remove columns from existing tables; Add or remove constraints from existing tables
Advanced Select Statements
- Clause, IN(), BETWEEN, LIKE()
- ORDER BY: sorting records
- Joining multiple tables together
- String, Date, Group functions
- GROUP BY
- Sub Queries
Performance & Indexing
Data Control Language (DCL)
- GRANT and REVOKE
- Introduction to privileges; System and Object
Introduction to NOSQL Databases
- What are NoSQL Databases?
- Common Database Features
- NoSQL Versus Relational Approach
- Types of NoSQL Databases
Data Modelling and Design
- Data Storage
- Working with Datatypes
- Document Datatypes
- Creating _id Fields
- Databases and Collections
- Querying Collections
- Working with Operators
- Referencing a Database
- Querying Dates
The Aggregation Framework
- Aggregating Results
- Single Purpose Functions
- The Aggregation Pipeline
- Data Aggregation Operators
- Inserting Data into Collections
- Atomic Operations
- Removing Data
- Capped Collections
High Performance Options
- Creating Indexes
- Index Properties
- Specialised Index Types