Tuition/Training Available For Structured Query Language(SQL)
Tuition/Training for Structured Query Language (SQL). Topics: 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. We charge 15 pounds/hr Admin Imperialtuitions Ad ID: Delivery Service Consumer Credit