Structured Query Language (SQL)

Dated: 19-05-2019

Description


Structured Query Language (SQL)


Topics

Inquiry Register

1.   1. Databases - An Overview:
·         Describe a Database
·         Define a Database Management System (DBMS)
·         List the Advantages of a DBMS
·         Define a Relational Database Management System (RDBMS)
·         Describe a Table
·         Explain Data Types
·         Describe Data Relationships
·         Explain Primary and Foreign Keys
·         Define Normalization

2.    SQL - An Overview:
·         Define what is SQL
·         Explain the Role of SQL
·         List the Functions of SQL
·         Understand SQL Components
-       Data Manipulation Language (DML)
-       Data Definition Language (DDL)
-       Data Control Language (DCL)

 3.    Retrieving data:
      Introduce the SELECT statement
      Use the SELECT statement
      Execute a query in Microsoft SQL Server
      Retrieve specific columns in a table
      Sorting Results with ORDER BY
      Filter rows with the WHERE clause
      Use operators to create conditions
      Retrieve unknown values from the database
      Understand the NULL keyword
      Sort the Result Set with the ORDER BY clause
      Use the DISTINCT keyword to suppress duplicate rows
      View top rows in a large result set
      Use the LIKE keyword with wildcards to retrieve data
      Work with calculated columns

 4.    Working with Multi-table Queries
      Understand what are Joins
      Use different types of Joins
- Inner Joins
- Outer Joins
      Creating Joins with the FROM Clause
      Using the WHERE clause to create a join
 5.    Grouping Data

      Understand the grouping of data
      Describing the GROUP BY clause
      Use the GROUP BY clause
      Describing the HAVING clause
      Use the HAVING clause
      Describing the ROLLUP and CUBE operators
      Use the ROLLUP and CUBE operators
      Add totals and subtotals to grouped data

 6.    Create, Modify and Delete Tables and Databases
·         Create a new table
·         Using the CREATE statement
·         Modify the structure of an existing table
·         Using the ALTER statement
·         Delete a table
·         Using the DROP statement
·         Create a database
·         Delete an existing database

 7.    Manipulating data in a Table
·         Insert rows into a table
·         Using the INSERT INTO statement
·         Update existing rows in a table
·         Using the UPDATE INTO statement
·         Delete rows from a table
·         Using the DELETE statement
·         Delete all rows from a table with the TRUNCATE statement

 8.     Managing Database Objects
·         Dropping Tables, Indexes and Views
·         ALTERing Tables, Indexes and Views
·         Enabling and Disabling Constraints
·         Managing Security

 9.     Working with Views
·         Understand and describe what is a View
·         Using the CREATE VIEW statement
·         Modifying a View with the ALTER VIEW statement
·         Deleting a View with the DROP VIEW statement
·         Understand and create an Indexed View

10.Working with sub queries 

·         Using Subqueries as Expressions
·      Including Subqueries as Lists Adding Subqueries as Derived
·        Tables Working with Correlated
·       Subqueries Solving for X with Relations Division

 11.Indexing for performance
·        Introducing Indexes
·      Creating Indexes

12.Using SQL Functions in Queries:
•     Understanding Functions and Function Arguments
•     Use Aggregate Functions:
-  SUM, AVG, MIN, MAX and COUNT
•     Use Mathematical Functions:
-   ROUND, CEILING, FLOOR, SQUARE, SQRT, and SIGN
     Use Date Functions:
- GETDATE, DAY, MONTH and YEAR
•    Use String Functions:
- LEN, SUBSTRING, REPLACE, LTRIM and RTRIM
 Use Conversion Functions:

 -  CAST, CONVERT, STR


Duration: 20 Hours | Cost: £20/Hr