UrbanPro
true

Find the best tutors and institutes for Database Training

Find Best Database Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Database Training Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 02 Apr Tuition/BTech Tuition IT Courses/Database Training IT Courses/Programming Languages/Python

DBMS - SQL - Any/All

Techprolog

Our Institute was started by IT professionals started 5 years back with an equitable working environment...

All - Operator SELECT empno, sal FROM emp WHERE sal > ALL (1999, 2999, 3999); Output of Above query is same as below query SELECT empno, sal FROM emp WHERE sal > 1999 AND sal > 2999 AND sal > 3999; ANY Operator: SELECT empno, sal FROM emp WHERE sal > ANY (1999,... read more

All - Operator

SELECT empno, sal

FROM   emp

WHERE  sal > ALL (1999, 2999, 3999);

Output of Above query is same as below query

SELECT empno, sal

FROM   emp

WHERE  sal > 1999 AND sal > 2999 AND sal > 3999;

 

ANY Operator: 

SELECT empno, sal

FROM   emp

WHERE  sal > ANY (1999, 2999, 3999);

Output of Above query is same as below query

SELECT empno, sal

FROM   emp

WHERE  sal > 1999 OR sal > 2999 OR sal > 3999;

 

read less
Comments
Dislike Bookmark

Lesson Posted on 15/04/2019 IT Courses/Database Training Tuition/BCA Tuition IT Courses/MS SQL/MS SQL Administration +1 IT Courses/RDBMS less

What is DBMS and RDBMS

Amit Patil

MSSQL DBA over 6 year's hands-on experience in managing large-scale databases (RDBMS). Worked on and...

Database Management Systems A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses a standard method to store and organize data. Types of Database Management Systems Hierarchical... read more

 Database Management Systems

A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses a standard method to store and organize data. 

 

 Types of Database Management Systems

  1. Hierarchical databases
  2. Network databases
  3. Relational databases
  4. Object-oriented databases
  5. Graph databases
  6. ER model databases.
  7. Document Databases. 

 

read less
Comments
Dislike Bookmark

Lesson Posted on 20/07/2018 IT Courses/Database Training IT Courses/SQL Programming IT Courses/IT Certifications/Oracle Certification +1 IT Courses/Data Modeling less

Database Origins

Manish Joshi

The need for a database originates from the fact that computers are dumb devices having batman like abilities which can be smartly be utilised by feeding it the right content. That is, for example, consider any live scenario or apps that exist today be it WhatsApp, Facebook or be it a 200 user based... read more

The need for a database originates from the fact that computers are dumb devices having batman like abilities which can be smartly be utilised by feeding it the right content. That is, for example, consider any live scenario or apps that exist today be it WhatsApp, Facebook or be it a 200 user based financial domain website - without a good data content, it is simply a well-built skeleton only.

So now that we know about the importance of data comes the question of how to store the database. This very same question came in the 70s also to earlier developers and researchers - then there were some like E.F.Codd who came up with a blueprint or design for storing data. This included 12 rules to have an effective database design.

Will elaborate that in a different lesson and take up from there Thank you.

read less
Comments
Dislike Bookmark

Looking for Database Training classes

Find best Database Training classes in your locality on UrbanPro.

FIND NOW

Answered on 25/04/2018 CBSE/Class 10/Mathematics/UNIT II: Algebra/Quadratic Equations/ Class 10 Relationship between discriminants and nature of roots Functional Training/Data Analytics IT Courses/Hadoop/Hadoop Testing +5 IT Courses/Database Training IT Courses/ETL Testing CBSE/Class 10/Mathematics CBSE/Class 10/Science/Unit I: Chemical Substances - Nature and Behaviour/Chemical Reactions and Equations CBSE/Class 6/Maths/algebra/Choosing the value of a variable to make a true statement less

Rakesh A.

12 year exp in JAVA/J2EE and working in IT company

if you are intrested on DBMS data base mangement system you can contact me . This will cover concept of database , normalization and SQL query
Answers 7 Comments
Dislike Bookmark

Lesson Posted on 15/12/2017 IT Courses/Database Training

Overview Of Database

Sandeep

A Database is a collection of related data organised in a way that data can be easily accessed, managed andupdated. Any piece of information can be a data, for example name of your school. Database is actualy a placewhere related piece of information is stored and various operations can be performed... read more

A Database is a collection of related data organised in a way that data can be easily accessed, managed and
updated. Any piece of information can be a data, for example name of your school. Database is actualy a place
where related piece of information is stored and various operations can be performed on it.

1. DBMS:

A DBMS is a software that allows creation, definition and manipulation of database. Dbms is actualy a tool used
to perform any kind of operation on data in database. Dbms also provides protection and security to database. It
maintains data consistency in case of multiple users. Here are some examples of popular dbms, MySql, Oracle,
Sybase, Microsoft Access and IBM DB2 etc.

2. Components of Database System:

The database system can be divided into four components.

i. Users: Users may be of various type such as DB administrator, System developer and End users.

ii. Database application: Database application may be Personal, Departmental, Enterprise and Internal

iii. DBMS: Software that allow users to define, create and manages database access, Ex: MySql, Oracle etc.

iv. Database: Collection of logical data.

3. Functions of DBMS:

i. Provides data Independence.

ii. Concurrency Control.

iii. Provides Recovery services.

iv. Provides Utility services.

v. Provides a clear and logical view of the process that manipulates data.

4. Advantages of DBMS:

i. Segregation of applicaion program.

ii. Minimal data duplicacy.

iii. Easy retrieval of data.Reduced development time and maintainance need.

5. Disadvantages of DBMS:

i. Complexity.

ii. Costly.

iii. Large in size.

read less
Comments
Dislike Bookmark

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

What Are Macros?

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost productivity manifold. ii. Modules: Modules is the area where the code is written. This is a new... read more

i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost productivity manifold.

ii. Modules: Modules is the area where the code is written. This is a new Workbook, hence there aren't any Modules.

To insert a Module, navigate to Insert → Module. Once a module is inserted 'module1' is created.

Within the modules, we can write VBA code and the code is written within a Procedure. A Procedure/Sub Procedure is a series of VBA statements instructing what to do.

iii. Procedure: Procedures are a group of statements executed as a whole, which instructs Excel how to perform a specific task. The task performed can be a very simple or a very complicated task. However, it is a good practice to break down complicated procedures into smaller ones.

The two main types of Procedures are Sub and Function:

i. Function: A function is a group of reusable code, which can be called anywhere in your program. This eliminates the need of writing the same code over and over again. This helps the programmers to divide a big program into a number of small and manageable functions.

Apart from inbuilt Functions, VBA allows to write user-defined functions as well and statements are written between Function and End Function.

ii. Sub-Procedures: Sub-procedures work similar to functions. While sub procedures DO NOT Return a value, functions may or may not return a value. Sub procedures CAN be called without call keyword. Sub procedures are always enclosed within Sub and End Sub statements.

read less
Comments
Dislike Bookmark

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Modeling IT Courses/Data Analysis IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

What Is Power Query?

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution. Power Query is an Excel add-in that can be used for data discovery,... read more

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

You can think of an ETL tool built into your familiar Excel to search or discover data from a wide variety of data sources (both from your enterprise as well as from online public data sources). Power Query has an intuitive and interactive user interface which can be used to search, discover, acquire, combine, refine, transform and enrich the data.

Getting Started with Power Query for Excel:

Power Query allows users to search or discover data across the enterprise or from valuable public data sources available online as well as from a variety of other data sources. It allows you to bring in data into Excel from virtually any type of data sources as listed below:

From the web:

i. From a file: Excel, CSV, XML, Text or Folder that contains files with metadata and links.

ii. From a database: SQL Server, Windows Azure SQL Database, Access, Oracle, IBM DB2, MySQL, PostgreSQL and Teradata.

iii. From other data sources: SharePoint List, OData feed, Windows Azure Marketplace, Hadoop Distributed File System - HDFS, Windows Azure Blob storage, Windows Azure Table storage, Active Directory and Facebook.

Apart from the above data sources, Power Query allows you to search data publicly available online or published data from your organization. This online search of data, along with data integration from the above types of data sources, makes it a real quick ETL tool built right inside your Excel.

read less
Comments
Dislike Bookmark

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

PowerPivot For Excel

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and... read more

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.

In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.

How the data is stored?

The data that you work on in Excel and in the Power Pivot window is stored in an analytical database inside the Excel workbook, and a powerful local engine loads, queries, and updates the data in that database. Because the data is in Excel, it is immediately available to PivotTables, PivotCharts, Power View, and other features in Excel that you use to aggregate and interact with data. All data presentation and interactivity are provided by Excel; and the data and Excel presentation objects are contained within the same workbook file. Power Pivot supports files up to 2GB in size and enables you to work with up to 4GB of data in memory.

Saving to SharePoint:

Workbooks that you modify with Power Pivot can be shared with others in all of the ways that you share other files. You get more benefits, though, by publishing your workbook to a SharePoint environment that has Excel Services enabled. On the SharePoint server, Excel Services processes and renders the data in a browser window where others can analyze the data.

On SharePoint, you can add Power Pivot for SharePoint to get additional collaboration and document management support, including Power Pivot Gallery, Power Pivot management dashboard in Central Administration, scheduled data refresh, and the ability to use a published workbook as an external data source from its location in SharePoint.

read less
Comments
Dislike Bookmark

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

Power View

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions. Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive... read more

Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010 and 2013 as part of the SQL Server 2012 Service Pack 1 Reporting Services Add-in for Microsoft SharePoint Server Enterprise Edition.

Power View has two versions:

i. Start Power View in Excel 2013. In Excel, Power View sheets are part of the Excel XLSX file.

ii. Create a Power View in SharePoint Server report. Power View reports in SharePoint Server are RDLX files

Both versions of Power View need Silverlight installed on the machine.

You can’t open a Power View RDLX file in Excel, or open an Excel XLSX file with Power View sheets in Power View in SharePoint. You also can’t copy charts or other visualizations from the RDLX file into the Excel workbook.

Data sources for Power View:

In Excel 2013, you can use data right in Excel as the basis for Power View in Excel and SharePoint. When you add tables and create relationships between them, Excel is creating a Data Model behind the scenes. A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes—for example, how Products relates to Inventory and Sales. You can continue modifying and enhancing that same data model in Power Pivot in Excel, to make a more sophisticated data model for Power View reports.

With Power View you can interact with data:

i. In the same Excel workbook as the Power View sheet.

ii. In data models in Excel workbooks published in a Power Pivot Gallery.

iii. In tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances.

iv. In multidimensional models on an SSAS server (if you’re using Power View in SharePoint Server).

Create charts and other visualizations:

In Power View, you can quickly create a variety of visualizations, from tables and matrices to pie, bar, and bubble charts and sets of multiple charts. For every visualization you want to create, start with a table, which you then convert easily to other visualizations to find one best illustrates your data. To create a table, click a table or field in the field list, or drag a field from the field list to the view. Power View draws the table in the view, displaying your actual data and automatically adding column headings.

To convert a table to other visualizations, click a visualization type on the Design tab. Power View only enables the charts and other visualizations that work best for that data in that table. For example, if Power View doesn’t detect any aggregated numeric values, then no charts are enabled.

Filter and highlight data:

Power View provides several ways to filter data. Power View uses the metadata in the underlying data model to understand the relationships between the different tables and fields in a workbook or report. Because of these relationships, you can use one visualization to filter and highlight all the visualizations in a sheet or view. Or you can display the filters area and define filters that apply to an individual visualization or to all the visualizations in a sheet or view. In Power View in SharePoint, you can leave the filter pane visible or hide it before switching to reading or full-screen mode.

Slicers:

Slicers in Excel enable you to compare and evaluate your data from different perspectives. Slicers in Power View are similar. When you have multiple slicers on a view and you select an entry in one slicer, that selection filters the other slicers in the view.

Sorting:

You can sort tables, matrices, bar and column charts, and sets of small multiples in Power View. You sort the columns in tables and matrices, the categories or numeric values in charts, and the multiple field or the numeric values in a set of multiples. In each case, you can sort ascending or descending either on attributes such as Product Name, or on numeric values such as Total Sales.

read less
Comments
Dislike Bookmark

Looking for Database Training classes

Find best Database Training classes in your locality on UrbanPro.

FIND NOW

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +10 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training less

What Are Olap, Molap, Rolap, Dolap, Holap?

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.2. MOLAP: Multidimensional OLAP: This term designates a cartesian data structure more specifically.... read more

1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

2. MOLAP: Multidimensional OLAP: This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request. Targeted at groups of users because it's a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

3. DOLAP: Desktop OLAP: Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects). Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It's like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

4. ROLAP: Relational OLAP: Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases. Used for large departments or groups because it supports large amounts of data and users.

5. HOLAP: Hybridization of OLAP, which can include any of the above.

read less
Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Database Training classes in India. Post Your Requirement today and get connected.

Overview

Lessons 54

Total Shares  

+ Follow 7,577 Followers

Top Contributors

Connect with Expert Tutors & Institutes for Database Training

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Database Training Classes?

Find best tutors for Database Training Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Database Training Classes?

Find best Database Training Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more