Course Details
Course Description:
A company?s success hinges on responsible and accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers, to setting financial goals. Data professionals like analysts, developers, and architects are tasked with creating, optimizing, managing, and analyzing data from databases, with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data.
This course explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work is ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Join us and learn the skills you need to develop, analyze, and maintain data in structured, modern, and secure databases.
Topics covered in the course include:
Join an engaging hands-on learning environment, where you?ll learn:
- Advanced Query Techniques
- Manipulating Table Data Using SQL's Data Manipulation Language (DML)
- User-Defined Functions
- Stored Procedures
- Triggers
This course has a 50% hands-on labs to 50% lecture ratio with engaging instruction, demos, group discussions, labs, and project work.
Target Student:This course is designed for the following students:
Experienced end users, Data Scientists, Business and Data Analysts, Developers, and Database Administrators.
Prerequisites: Students should possess the following experience before attending the course:
You should have basic SQL experience before attending this course.
?
You should have basic SQL experience before attending this course.
ÂÂÂ
Virtual Live Instructor
Free Training Materials
Convenient Scheduling
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private Artificial Intelligence group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Artificial Intelligence Private Group Training from Business Computer Skills can help your team.
