Questions tagged [learning]
How to best attain knowledge or skill.
34
questions
0
votes
2
answers
159
views
Why are scalar functions special? A case study of trying to understand database terminology as a beginner
I am trying to learn the basics of databases, but I am finding the terminology especially impenetrable compared to other things I have learned. Most of the database tutorials and documentation I have ...
- 125
1
vote
2
answers
43
views
Best way to study a new type of database if you are experienced in another type
Does anyone have a good approach to learning a new type of database when they already are proficient in another one? I have thought about writing notes to myself about how to do various tasks that I ...
- 221
0
votes
1
answer
60
views
What dataset(s) is Marcus Winand using in his book "SQL Performance Explained"?
I am currently reading SQL Perfrmance Explained by Marcus Winand. I would like to follow along with the queries and examples he used to explain database tuning. It would greatly allow me to understand ...
- 103
-2
votes
1
answer
37
views
How to read the select statement to understand the result [closed]
I am convinced that it is a very basic question, but I still have to ask it, making queries on the Oracle HR schema I notice that the result of these two queries is different:
Expected result:
I ...
- 149
1
vote
1
answer
221
views
Understanding aggregate window functions
Consider the following table:
CREATE TABLE T1
(
keycol INT NOT NULL CONSTRAINT PK_T1 PRIMARY KEY,
col1 VARCHAR(10) NOT NULL
);
INSERT INTO T1 VALUES
(2, 'A'),(3, 'A'),
(5, 'B'),(7, ...
- 75
0
votes
1
answer
32
views
Efficient method of inserting a column into a table based on another table
Consider the following tables
CREATE TABLE Main (
id INT PRIMARY KEY,
state VARCHAR(255) DEFAULT NULL
)
CREATE TABLE ColorTable (
color VARCHAR(255),
state VARCHAR(255)
)
INSERT ...
- 75
2
votes
1
answer
70
views
When creating a database using an ERD, what do the entities and relationships become (in database terms)?
MIS student, here. Learning about ERDs (entity relationship diagrams). ERDs are supposedly used for the purpose of later constructing a database. My question is this:
What will an entity (and, ...
3
votes
2
answers
2k
views
Microsoft Certification - 70-764 Administering a SQL Database Infrastructure [closed]
Firstly, I apologise if this is not necessarily the best place to post such a question.
I am currently preparing for my 70-764 exam. I have purchased the following book:
70-764
I have a few ...
- 191
3
votes
2
answers
454
views
SQL Server MCSA Certification
I want to take MCSA: Sql Server 2016 Database Administration certification.
I checked this link :
https://www.microsoft.com/en-us/learning/mcsa-sql2016-database-administration-certification.aspx
It ...
- 329
1
vote
1
answer
84
views
MCSE: Data Management and Analytics requirements overlap with MCSA: SQL Server 2016 Database Development
I've been reviewing the requirements to get the MCSE: Data Management and Analytics certification, and was thinking of going the path of the MCSA: SQL 2016 Database Development pre-req. The thing is ...
- 125
1
vote
1
answer
738
views
Design feedback on my first database [closed]
Couldn't find a newbie forum; hope this is in the right place.
In my quest to learn more about databases, analytics, and creating service APIs to work with them, I decided to scrape an online archive ...
- 11
2
votes
1
answer
278
views
What are the most relevant similarities between T-SQL and MDX?
I have used T-SQL (CTEs, windowed functions, recursive CTEs, large data, table-valued functions, APPLY, PIVOT, stored procedures, etc.), but have never queried a Microsoft SSAS cube.
Are there ...
- 703
0
votes
1
answer
721
views
Oracle Unified Auditing Update Table
I am trying to audit when a user UPDATEs a table in Oracle. The script I am running is below. All of the other auditing works fine, but not the UPDATE policies. I created two policies to try two ...
- 3
11
votes
2
answers
8k
views
What are the practical reasons behind learning relational algebra?
Learning how to formulate query-like expressions in relational algebra is a traditional part of many, perhaps most, "Introduction to Databases" courses.
This is usually justified by the assertion ...
- 213
5
votes
1
answer
1k
views
Compound Primary Key - Index both fields?
I have a many-to-many join table between users and roles.
CREATE TABLE AppUserRole
(
UserId INT NOT NULL,
RoleId INT NOT NULL,
CONSTRAINT PK_AppUserRole PRIMARY KEY (UserId, RoleId),
...
- 153
12
votes
2
answers
338
views
Is it ever ok to not test a feature?
Is there any point at which you become so familiar with your language/database/system that there is no need to test a new feature/configuration/query/etc. by contained/simulated testing before ...
- 253
4
votes
2
answers
5k
views
How long to learn PostgreSQL? [closed]
I want to learn PostgreSQL and How to make the learning process efficient, but really don't know how long it would take even after googling my question.
I used MySQL before and knew relational ...
- 141
2
votes
1
answer
226
views
How do you generate large OLTP and reporting workloads? [closed]
My current skillset lies towards plain vanilla data warehousing, with < 20k users, our setups are rather simple..
I am looking for ways to enhance my technical skills, however, as much theory as I ...
- 553
0
votes
2
answers
591
views
Is there a free/web-based game that requires knowledge of SQL to win? [closed]
Looking for an alternative way of teaching SQL, and wondering if there is a free/web-based game that requires knowledge of SQL to win. If possible, the game should not only be fun, but also track how ...
- 334
0
votes
1
answer
1k
views
Where can I get best resources to learn sql? [duplicate]
I am very new to the databases just have basic knowledge about it.
I want to learn sql language and dont know where to start. Please help me to start with it.
And what is the difference between sql ...
- 101
0
votes
1
answer
1k
views
Create Table with Int-attribute which can only use values between 6 and 36
Hello I'm learning for my databases examination and in one exercise they asking for creating a table with a attribute which can only use values between 6 and 36. How do I solve it?
We used in the ...
- 131
8
votes
2
answers
1k
views
Do agile software development approaches apply to SQL?
I would like to learn if agile software development methods/principles/patterns are valid to SQL programming as well. If yes, where would be a good place to start learning about that? Are there any ...
- 165
4
votes
2
answers
760
views
Getting to know SQL via the "short questions/simple answers style of learning"
Looking for a incremental SQL course that would likely be similar to the this Ruby Koan course; which is in fact inspired by the book, "The Little Lisper", which uses a short questions/simple answers ...
- 334
2
votes
2
answers
3k
views
Good book on databases for beginners [duplicate]
Possible Duplicate:
Must-read Books for DBA
I'm already reading a book on Introduction to SQL (RDMS). But that only teaches SQL and commands and I feel like my knowledge lacks in database ...
- 21
5
votes
2
answers
581
views
Teradata learning resources
I'm moving from SQL Server to Teradata, therefore could someone recommend any good (preferably online) resources about Teradata? I'm not looking for information about basics, but rather about new ...
- 153
92
votes
15
answers
74k
views
Why is Database Administration so hard?
I know a lot of Database Administrators and they are all over 28-29 years old.
Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years?
Or is ...
- 1,045
3
votes
5
answers
720
views
Where can I find good literature for beginners? [closed]
I am trying to find some database tutorials,books and similar, since I have started this course in college, and received some material, but it is really hard to manage through all the info on the net. ...
- 39
11
votes
3
answers
3k
views
SQL Profiler tutorials for newbie
The MSDN documentation tough to understand.
Are there any online tutorials available to learn SQL Profiler? If possible, videos or simple blog posts would be preferred.
- 675
35
votes
5
answers
9k
views
How far should you go with normalization?
I have a decent amount of data in a database. I have well formed tables and good relationships between them with some redundancy in my data. But how far should I go with normalization? Are there ...
- 453
12
votes
2
answers
811
views
What are some good resources for learning about document oriented databases? [closed]
I'm interested in learning about NoSQL databases and I decided to start with document oriented databases. What are some good resources to learn the concepts and good design of this type of database?
- 1,111
7
votes
5
answers
516
views
What learning resources are there for part-time DBAs?
Luckily, this isn't a current issue for me, as in my current workplace we're pretty well supplied with DBA knowledge in the team. However, in small development teams, it's not uncommon in my ...
18
votes
8
answers
23k
views
Must-read Books for DBA [closed]
This question is almost mandatory in any SE site for basic reference.
Please post only books with permanently value for DBAs in general.
The post should be a must read book, the classical ones, the ...
5
votes
0
answers
281
views
books for aspiring DBA [duplicate]
Possible Duplicate:
Must-read Books for DBA
What books do you recommend for the aspiring DBA?
Update: I'm particularly looking for sql-server and PostgreSQL books (though books geared towards ...
106
votes
9
answers
43k
views
Where are some useful SQL puzzles to teach SQL in a workplace?
I'm looking for beginner and intermediate level SQL puzzles, that I can point trainees at for practice.
I'm aware of http://sqlzoo.net/ which is a great resource - is there anything else out there ...