MongoDB

  • show dbs – show all dababases
  • show collections – show all collections in database.
  • use [db name] – switch to the specific database.
  • db.[collection].find() – find records in the collection.
  • db.[collection].find({email:”ints-ints@mail.ru”}) – find specific value
  • db.[collection].findOne() – find one record in the collection.
  • db.[collection].findOne({email:”ints-ints@mail.ru”},{password:”12345″}) – find specific values
  • db.[collection].countDocuments() – count all records in a table/collection
  • w3schools

Learnng resources

Keywords

  • Big data, Bigdata, Big-data, MongoDB, Mongo DB
  • NoSql, No sql, No-sql
  • Training, Train, Learning programming, learn, 
  • Programming languages

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool inMicrosoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors – Multidimensional and Tabular (from wikipedia).

Learn SSAS: PDF, Videos and Demo files:

01. Download SSAS Tutorials PDF file from Microsoft
02. Adventure Works for SQL Server 2012 from CodePlex
03. SSAS 11 Videos of PCTeach.me:
04http://pcteach.me/Series/microsoft-ssas/
05. 6 Lessons of SSAS MDX
06. 7 Videos of SSAS MDX

SSAS Videos at PCTeach.me:

01. Analysis Services - 01 Prerequisite Guide
02. Analysis Services - 02 Data Source Creation
03. Analysis Services - 03 Data Source Views
04. Analysis Services - 04 Cube Creation
05. Analysis Services - 05 Dimension Fundamentals
06. Analysis Services - 06 Dimension Hierarchies
07. Analysis Services - 07 Dimension Attribute Relationships
08. Analysis Services - 08 Dimension Storage
09. Analysis Services - 09 Dimension Discretization
10. Analysis Services - 10 Parent/Child Dimension Hierachies
11. Analysis Services - 11 Star and Snowflake Schemas