As companies utilize big data concepts to stay competitive, the role of the data analyst is key. Since the amount of data to be analyzed is growing exponentially, the data analyst must use software and reporting tools to analyze and report the data patterns. In this free information session, learn h...


View Details

Gain hands-on experience in the design, creation and programming of SQL Server databases as they exist in business settings. After completing the certificate you will be able to create entity relationship models, design and create a working database model in SQL, normalize data, and translate busine...

View Details

In today's big data world, managing data efficiently requires analytical skills and the ability to use relational databases. This course introduces you to basic relational database concepts, terminology of relational databases and simple database design. Learn to design efficient relational data...


View Details

Microsoft SQL Server has evolved to become a true, enterprise information platform. In this course you'll learn the fundamental elements of T-SQL, including the definition of DML, DDL, DCL and TCL; use control of flow statements like IF and WHILE; work with NULLs; practice T-SQL programming cons...


View Details

Learn to streamline and extract relevant information and execute more advanced SQL features. Topics include implementing complex queries; utilizing sub queries and derived tables; designing views and inline functions; building stored procedures, user-defined functions, and triggers; implementing tra...


View Details

Demonstrate your SQL Server knowledge in this Capstone course. Use SQL Server Management Studio (SSMS) to build a database schema based on a "real-world" scenario. Then, develop a database solution that supports your proposed plan. Next, implement the solution, and test the results using SQL...


View Details