Introduction to SQL (Self-Paced Tutorial)

Details

SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.

Enrollment Options:

Self-Paced
3 Months Access Course Code: T9864
No Instructor, Start Anytime

$129.99

USD

Enroll before 28th February and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.

Syllabus

Introduction to Database Design and SQL

In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database and collecting data is foundational to using SQL to write queries and retrieve data result-sets that are usable.

SQL Server

In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use a SQL code script to create one of the tables for the practice database in SQL Server.

Retrieving Data Result-Sets

SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meets a defined criteria.

Sorting Data

SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will explore and practice defining and writing queries to meet a defined criteria to retrieve the expected result-set.

Designing SQL Data Tables

This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in a RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.

Designing Data Rows

In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table, and you will also practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL code script to populate your tables with enough data rows to use in the learn-by-doing practices in this course.

Getting Data From Two Tables

SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN query statements that are defined to retrieve data result-sets from tables that have a relationship between their PKs and FKs.

Retrieving Data From Multiple Tables

In this lesson, you will continue writing JOIN statement that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.

Keeping the Database Up to Date

The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.

Aggregate Functions

In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.

SQL Views

SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.

Maximize Database Integrity and Performance

Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.

Requirements

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites

There are no prerequisites to take this course.

Reviews

About ExpertRating

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.

Company Timeline

Since 2001

Decades of excellence

800+ Skill Tests

World’s largest test inventory

2500+ Companies

Thousands depend on use

25 Million People Tested

10 tests every minute

35 Countries Serviced

Over 1500 clients in the US

86% Reorder Rate

Satisfied clients

We deliver over 3 million online certification tests and online courses annually.

Awards

ExpertRating is a winner of the Google SME Heroes award. This award has been instituted by Google to honor IT companies that have excelled in their domain and have leveraged the internet to grow and expand their businesses in innovative ways.


ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well-balanced, comprehensive and meaningful content.