Intermediate SQL

Intermediate SQL

Gain confidence using a wide range of advanced SQL techniques. This course will expand your SQL knowledge and provide skills for writing powerful queries that perform complicated searches and sorts of data.
6 weeks / 24 Course Hrs
SHARE
  • Details
  • Syllabus
  • Requirements
  • Instructor
  • Reviews

Details

When it comes to query language for relational database management systems, SQL is the industry benchmark. This hands-on course will help you advance your knowledge and keep pace with today's SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.

Enrollment Options:
Instructor-Led
6 weeks Access Course Code: ins
Start Dates*Nov 13 | Dec 11 | Jan 15 | Feb 12
*Choose start date in cart
$125.00
Self-Paced
3 Months Access Course Code: T9747
No Instructor, Start Anytime
$115.00

Syllabus

In this introductory lesson you will review SQL and database terms and concepts. You will also install SQL Server Express and SQL Server Management Studio (SSMS) to use throughout the course in the learn-by-doing practices. And, you will use SQL code scripts to create a practice database in SQL Server.
In this lesson you will learn about join statements and how join queries make it possible to retrieve data from more than one table. You'll also practice how to write well-designed join queries that retrieve result-sets that meet your requirements.

Databases can contain massive amounts of data. Learning how to filter the rows that will limit the result-set is extremely important. In this lesson, you will explore various ways to write SQL queries that retrieve a filtered result-set that meets defined criteria.

Because of the size of databases, it is important to design SQL queries that retrieve results-sets with data that is organized. In this lesson, you will practice designing queries that group similar data and summarize result-sets. You will explore aggregate functions and how they can be used in producing result-sets that can be used for data analysis.

Subqueries are SQL queries that are written inside another SQL query. Subqueries are used to perform intricate requirements on complex data subsets to retrieve specific data from the database. You will practice writing various subqueries using the practice database.

This lesson is about maintaining the database and data. You will practice using SQL code to modify and add table structures and add new data records. You will also learn about writing SQL queries to modify and delete tables structures and data. Understanding how to write queries to modify, add, and delete is important in order to maintain a database and data that are accurate and up to date.

Unions are used to retrieve data from more than one table. Instead of returning columns from different tables, a union SQL query combines rows for columns that are the same datatype. In this lesson, you will practice writing SQL queries that retrieve data from multiple tables with specific requirements.

SQL built-in functions are useful when applied in the right situations. In this lesson, you will work with string and date functions and write SQL queries to retrieve result-sets that manipulate and display data that may be easier to read and understand.

User-defined functions are called stored procedures. A stored procedure is a query that is written, saved, and ready to be reused whenever needed. In this lesson, you will practice defining, writing, saving, and executing stored procedures.

Indexes are important to database performance. Views are used to simplify access and to secure accessibility to the data. In this lesson, these concepts will be explored and examined as you practice defining and creating SQL queries.

A trigger is a user-defined stored procedure that is used for maintaining the database. Once a trigger has been defined and is implemented in the database, it is automatically executed when applicable. In this lesson, you will practice defining, writing, and saving triggers.

Understanding the database and its parts is a necessary component of learning SQL. It is difficult to develop and write efficient and well-designed queries without knowing the database and table structures. This last lesson presents SQL queries that retrieve database information. You will also explore the SSMS to make use of its functions as you continue your SQL journey.

Requirements

  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Email capabilities and access to a personal email account.

Requirements:

Hardware Requirements: 

  • This course must be taken on a PC. It is not suitable for Mac users.

Software Requirements: 

  • Windows 8 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites:

To be successful in this course, you should have a basic understanding of SQL and database systems prior to enrolling.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

  • SQL Server Express
  • SQL Server Management

Instructor

Cecelia Allison Cecelia Allison

Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.

Reviews

I enjoyed the class. Great writing! Things were explained very well. For me, some things were a review and I was challenged by several new things, so it was the perfect course for me. I feel the content was very practical and I can put it to use immediately in my job. Thank you!

This is my second course from this particular instructor. She definitely is an expert in her field and provided a learning environment that was conducive to learning and understanding. I appreciate that the information was understandable as I had no prior experience with SQL before her two classes. Thank you again.

I really like this instructor's teaching style. The lessons are the right length and always presented in a way which makes it easy to retain the information. Her teaching by example helps me apply what I learn and better understand how to approach similar problems.

I had last used MS Access in 2002. My new work assignment required the use of MSA 2010. The use of the MSA tool plus the SQL technique training helped me greatly to "get up to speed" on both SQL use with MSA and the new environment that MSA 2010 provides. The thorough explanations and comparisons in SQL, as I had been using SQL/89, and the options made available proved valuable.