Description: In this course, you will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges. Students will learn how to connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report. This course also covers advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
(This is the 1st course of the Analytics Bootcamp)
# of Days:
Setting: