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