Intermediate SQL
Intermediate SQL
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.
Syllabus
- Lesson 1 – SQL Review
- Lesson 2 – Joining Multiple Tables
- Lesson 3 – Filtering Rows
- Lesson 4 – Grouping and Summarizing Rows
- Lesson 5 – Subqueries
- Lesson 6 – Tables and Data Maintenance
- Lesson 7 – Unions and Other Joins
- Lesson 8 – Using String and Date Functions
- Lesson 9 – Stored Procedures
- Lesson 10 – Indexes and Views
- Lesson 11 – Triggers
- Lesson 12 – SQL Server Management Studio
Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
- Adobe 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
<ul><li>6 Weeks Access</li>
<li>Course Code: ins</li>
<li>Start Dates* Jan 12 | Feb 09 | Mar 16 | Apr 13</li>
<li>$187.00 USD</li></ul><br><br>
<p><strong>Self-Paced</strong></p><br>
<ul><li>3 Months Access</li>
<li>Course Code: T9747</li>
<li>No Instructor, Start Anytime</li>
<li>$187.00 USD</li></ul>
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.
Be the first to add a review.
Related Courses
