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.
Completion Time
24 hours
Access Time
42 Days
Outcome
Individual Skill Course
Language
English
Training Level
Intermediate
Delivery Information:
Online
Asynchronous
Self-paced
Description
Learning Outcomes
What you will learn:
- Learn how to write complex SQL queries to execute on a SQL Server database
- Design and write SQL queries to filter, group, and summarize complex data subsets to retrieve specific data
- Design and write SQL sub- queries and queries using functions, joins, and unions
- Explore the benefit of stored procedures as you practice writing SQL user- defined stored procedures and trigger queries
- Expand your knowledge of SQL, the standard database query language
- Become more confident in your ability to understand and write SQL queries
- Open the door to new career opportunities as a SQL developer
Requirements
Technology Requirements
Hardware Requirements: This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements: Software must be installed and fully operational before the course begins.
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible. Cookies and JavaScript must be enabled
- The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )
- Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
- Reliable internet connection. Broadband cable or highspeed DSL is recommended for optimal experience.
- E-mail account (to be able to register and to receive e-mail from the course system regarding registration, course status, etc.)
Prerequisites
To be successful in this course, you should have a basic understanding of SQL and database systems prior to enrolling.
Enroll My Team
Are you looking to enroll your team in this training Course? You Can: