SQL school training courses in Columbia, SC (public, in-house or online)

This advanced course on SQL provides critical information necessary for writing advanced database queries using complex databases. You will learn how to:
â—?Use advanced techniques for querying a database
â—?Design sub-queries
â—?Use data dictionaries
â—?Establish database security
â—?Create and manage sequences and indexes
â—?Create stored procedures

Structured Query Language (SQL) is a powerful way to organize and extract information from relational databases. This class will teach you how to write queries using SQL, and techniques for effective and efficient database design. In this course you will learn how to:
â—?Design relational databases
â—?Use the proper syntax for SQL statements
â—?Analyze and organize data
â—?Retrieve, insert, update, and delete data
â—?Use aggregate functions
â—?Write queries from multiple tables...

Full archival course description>>

Ready to upgrade your skill set from software developer to enterprise solutions developer? Exploring Massachusetts and Maryland programming certification programs? Our Enterprise Solutions Developer certificate program is designed for you.

You’ll explore the Microsoft .Net framework with concentration on C# as well as the J2EE environment. This intense program educates students on the architectural approaches used in enterprise projects and the technical skills needed to build, support an...

Full archival course description>>

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the Reporting Services management and administrative tools.

Objective :
After completing this course, students will be able to: - Describe SQL Server Reporting Services and its components. - Create a Reporting Services report. - Enhance a Reporting Services report. - Create and manipulate data sets. - U...

Full archival course description>>

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Objective :
After completing this course, students will be able to: - Describe SQL Server Integration Services and its tools. - Create an Integration Services package. - Implement control flow in an Integration Services package. - Implement data flow in an Integration Services package. - Implement log...

Full archival course description>>