This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
You are here
You've gotten your feet wet with SQL - now it's time to move on to the next level. After taking this course, you should be able to say you're "Good at SQL." If someone asks you to pull some data from a database, or to perform some analysis, or to review their SQL query, you should feel confident that you can get the job done. We will spend half the first class reviewing material from "Introduction to SQL" (since it's easy to get rusty), then move onto newer and better things.
Setting the StageRecognizing the need for NoSQL data stores Justifying non-relational data stores Listing the categories of NoSQL Data Stores Focusing on MongoDB Defining the MongoDB architecture Reviewing the JSON standard Enumerating the MongoDB data types Interacting with MongoDB Querying at the Command Line Interface Running Scripts Manipulating MongoDB data from Python and Java Installing MongoDBSurveying Cluster Topology Creating a standalone mongod Achieving redundancy with replica sets Replicating data with the oplog Dissecting MongoDB Storage Strategies Identifying storage engines Imp
Managing Access and Storage Auditing and monitoring Tracking user activity and usage with CloudTrail Controlling access with IAM roles Monitoring RDS databases with RDS enhanced monitoring Managing data stored in the cloud Automatically change data storage class and archive data with S3 Lifecycle Mounting EFS volumes to multiple instances across availability zones Simplifying Your Infrastructure Deploying resources with CloudFormation Creating CloudFormation templates to define a collection of AWS resources Streamlining deployment of resources and any associated dependencies Executing cus
Present your data in a visually engaging way to maximize its effect. This class will introduce you to the design aspects of data visualization and the benefits of presenting your data in an engaging format. Programs such as Tableau will be used for hands on learning activities, and you will explore different styles in which data can be presented using previous project outcomes. Classroom location listings are also posted outside the CAPS office and the lobby of the 17 Lexington Avenue building.
In a world full of data, how do we know what's important? This course will help you begin to understand, synthesize, and interpret data from basic foundational theories, tools for analysis, and the pulling and interpreting of data you need to complete a project.
This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time.
Visualization of data is a key requirement for business decision makers. Tableau is one of the most popular software packages to achieve rich visualization to understand data patterns and create an engaging story. This hands-on course designed for the beginner Tableau user will guide you through the foundations of the software and you will begin to generate simple visualizations and interactive worksheets and dashboards.
Database Cleansing Training The utility of databases has skyrocketed over the years, for very good reason. Databases like SQL, Oracle, Excel and Access facilitate storage and analysis of data in ways never thought possible just a couple of years ago. Companies analyze data sets to make critical decisions that affect virtually every aspect of their businesses. If your analysis is as good as your data, how do you make sure you have the best data? Database Cleansing is a course that discusses how to maintain and protect the integrity of data to facilitate optimal analysis and decision making.