SQL Introduction / Intermediate for SQL Server

Level
Total time
Logo Aspect Training
Provider rating: starstarstarstarstar 9.8 Aspect Training has an average rating of 9.8 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Aspect Training offers their products as a default in the following regions: Surrey

Description

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Overview

Databases drive nearly every Internet and Intranet Web site. Aspect's Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.

Prerequisites:

Windows or equivalent knowledge

Introduction: Databases and the Web

Overview

The File System

Databases and the…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, Microsoft ProClarity, Client - Server, and Oracle.

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Overview

Databases drive nearly every Internet and Intranet Web site. Aspect's Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.

Prerequisites:

Windows or equivalent knowledge

Introduction: Databases and the Web

Overview

The File System

Databases and the ACID Test

An Overview of SQL

The Role of SQL

SQL History and Major DBMS Vendors

Relational Databases

Queries and Recordsets

Building a Simple SQL Query

More Parts of Relational Databases

Tables

Primary Keys, Foreign Keys, and

Relationships

Retrieving Data with SELECT

Comparison Operators for the WHERE

Clause

Apostrophes in Database Text

Calculated Columns: Doing Math in Select

Statements

Select Distinct

Selecting All Columns

Selecting Data from the Database

Data Manipulation: INSERT, UPDATE,

DELETE

INSERT Statements

UPDATE Statements

DELETE Statements

Data Retrieval: More about SELECT

ORDER BY

Practicing with ORDER BY

Practicing with Aggregate Functions

Extended WHERE Conditions

Practicing with Extended WHERE Clauses

Fine-Tuning Aggregate Functions

GROUP BY

The HAVING Clause

Using GROUP BY and HAVING to Analyze

Data

Querying Data Across Tables

Basic Joins

Selecting From Multiple Tables

Reusing Queries as Views

Creating Views

Query Within a Query

Subqueries

Subqueries vs. Joins

Database Definition SQL

CREATE TABLE

Creating a Table for a Guest Book

Database Design

Data Modeling

Handling More than One Phone Number

Adding Columns with ALTER TABLE

Establishing a Primary Key

Auto-numbered Columns

Relationships Between Tables

Normalization

Normalizing the Guestbook Table

Online Transaction Processing vs. Decision

Support

Restructuring Tables

Renaming Tables or Columns

Adding or Deleting Columns

Normalizing the Camp Sales Database

Data Integrity: Controlling What Goes

Into a Database

Default Values

Setting Default Values

Check Constraints

Checking Input

Creating Foreign Keys

Defining Primary and Foreign Keys

Many-to-Many Relationships

Introduction to Transactions

Major SQL Statements

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.