INFORMAT statement is used to define default input format for a variable or a number of variables in sequence at once. See an Example below: Here, two sequential variables FirstName and LastName have the informat parameter of $10 meaning Alphanumeric 10 character length. n1 and n2 are nuleric variables which have been defined to have… Continue reading INFORMAT Statement in SAS
Microsoft DataBase Admin Exam Resources
To Become A Microsoft Certified DataBase Administrator or Earn A Microsoft Certified Solutions Associate, you need to Pass these Two Exams. Listed here are the resources for preparation. Exam 70-764: Securing Data in Azure and SQL Server (DAT243x) Recovering Data in Azure and SQL Server (DAT244x) Managing SQL Server Operations (DAT247x) Exam 70-765 Provisioning Databases… Continue reading Microsoft DataBase Admin Exam Resources
Model Building & Effect Selection
When you have large number of variable, you can use one of the two methods for automatic variable selection: Either All Possible Regressions Method or the Step-wise Selection Method.
SQL DataBase Admin X-Series
Microsoft’s X-Series program on Edx.org for Database Administration has 4 courses. Currently available courses are related to provisioning and securing data, while two courses regarding Managing and Recovering Data are not currently available. Link to the X-Series program is https://courses.edx.org/dashboard/programs/75fdd839-3246-4afb-a279-a68bdd4c3228/
R Programming
Here is an example to compute Area of a Rectangle in R.
AWS Certified Solution Architect
Learning for AWS CSA-Associate – Exam Study Notes – Divided in Sections Introduction Overview Identity Access Management: IAM AWS Object Storage and CDN – S3 (Simple Storage System) , Glacier and CloudFront EC2 – The Backbone of AWS Route53 Databases on AWS Virtual Private Cloud: VPC Application Services The Real World – Creating a fault tolerant… Continue reading AWS Certified Solution Architect
Microsoft SQL Server: ETL with SQL Server Integration Services
This Archived course on Edx can be accessed here: https://courses.edx.org/courses/course-v1:Microsoft+DAT217x+1T2018a/course/ It’s been divided into 6 modules, last one is just assessment and 1st one is introduction to ETL Processing. Module 2: ETL with SQL Programming Module 3: ETL Processing with SSIS Module 4: SSIS Data Flows Module 5: Deployment and Troubleshooting
JavaScript, HTML and CSS Web Development
This course on edX by Microsoft has 2 Modules for HTML and 1 each for CSS and JavaScript. The Last modules teaches how to add external libraries to enhance HTML Applications. Course content can be accessed at this link https://courses.edx.org/courses/course-v1:Microsoft+DEV211.1x+1T2016/course/