Mastering Introductory SQL Made Easy Training Tutorial

Learn the basics of the SQL language as well as databases and tables in this introductory course.

4.20 (18 reviews)
Udemy
platform
English
language
Programming Languages
category
Mastering Introductory SQL Made Easy Training Tutorial
99
students
4.5 hours
content
Apr 2014
last update
$44.99
regular price

What you will learn

Understand the basics of the SQL language

Extract, add, update, and delete data within a database

Understand the core or essential statements within SQL

Use Microsoft Access or SQLite to practice the concepts discussed in the tutorial

Use the provided classroom manuals for additional images and practice exercises

Description

Learn SQL with this video training course from TeachUcomp, Inc. Mastering Introductory SQL Made Easy features 43 video lessons with over 3 hours of expert instruction. SQL is a standardized programming language that is used to create, edit and delete databases and database objects. It is also the language that is used to extract, add, update, and delete data within a database. SQL is used in nearly every aspect of database interactions. Watch, listen and learn as your instructor guides you through the “core,” or essential, statements within SQL. Variations of the core statements for the specific database systems of MySQL 5.7, SQL Server 2012, and Access 2013 will also be referenced by hyperlinks to the associated online documentation for each system. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises.

Whether you are completely new to SQL or are simply in need of a refresher or excellent reference source, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch the easy-to-use interface, click to start a video lesson or open the manual and you are on your way to mastering SQL.

Content

Course Introduction

Course Introduction

Introduction to Databases and SQL

Overview of a Database
The ‘Flat-File’ Method of Data Storage
The Relational Model of Data Storage
Tips for Creating a Relational Database
What is SQL?
Using SQL in Access 2013

Data Definition Language

The CREATE Statement
The CREATE DATABASE Statement
The CREATE TABLE Statement
The CREATE INDEX Statement
SQL Constraints
The DROP Statement
The ALTER TABLE Statement
NULL Values in SQL
Data Types in SQL
Auto-Increment in SQL

Data Manipulation Language

The INSERT Statement
The UPDATE Statement
The DELETE Statement
The SELECT Statement
The WHERE Clause
Criteria Notation & Wildcard Characters in WHERE Clause
The ORDER BY Clause
The GROUP BY Clause and Aggregate Functions
The JOIN Clause
The UNION Operator
The SELECT INTO Statement
The INSERT INTO SELECT Statement
Subqueries

Data Control Language

The CREATE USER and CREATE ROLE Statements
Privileges
The GRANT Statement
The REVOKE Statement
The ALTER USER and ALTER ROLE Statements
The DROP USER and DROP ROLE Statements

Transaction Control Language

The TRANSACTION Statement

SQL Functions and Aliases

Understanding SQL Functions
Calculated Fields and Column Aliases
Table Aliases

Views

About Views
The CREATE VIEW Statement
The ALTER VIEW Statement
The DROP VIEW Statement

Conclusion

Course Conclusion

Instruction Manual

Introductory SQL Manual

Charts

Price

Mastering Introductory SQL Made Easy Training Tutorial - Price chart

Rating

Mastering Introductory SQL Made Easy Training Tutorial - Ratings chart

Enrollment distribution

Mastering Introductory SQL Made Easy Training Tutorial - Distribution chart

Related Topics

197504
udemy ID
4/11/2014
course created date
11/22/2019
course indexed date
Bot
course submited by