Course Description

This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner.

Structured Query Language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. The role of database administrator includes several functions that you should know. You should know how to create and design tables, manipulate your data and run reports, create small programs (stored procedures) and use more advanced concepts such as transactional support and cursors.

This course provides a step-by-step overview and instructions that help you get started with the SQL language. We'll first get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.

Whether you're new to database administration or want to create customized, personal reports for your online business, this course shows you how to get started and helps you understand the SQL language from the ground up using very easy language, script examples, and HD Video demonstrations.

Course Lessons

 

Lesson 1: Introduction to SQL

Lesson 2: Retrieving Data

Lesson 3: Updating Data

Lesson 4: Inserting Data

Lesson 5: Deleting Data

Lesson 6: Sorting and Filtering Data

Lesson 7: Advanced Filtering

Lesson 8: Summarizing Data

Lesson 9: Grouping Data

Lesson 10: Using Subqueries

Lesson 11: Joining Tables

Lesson 12: Managing Tables

Lesson 13: Using Views

Lesson 14: Stored Procedures

Lesson 15: Using Cursors

Lesson 16: Using Transactions

 

*All registration must be completed in person.  Space is limited.

For more information please call +447864639037 or email ereed@deltawomen.org