皇家华人

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...


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...


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...


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...