Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [learning]

How to best attain knowledge or skill.

100
votes
8answers
36k 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 ...
92
votes
15answers
63k 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 ...
29
votes
5answers
7k 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 ...
18
votes
8answers
19k 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 ...
12
votes
2answers
272 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 ...
12
votes
2answers
749 views

What are some good resources for learning about document oriented databases?

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?
11
votes
3answers
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.
8
votes
2answers
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 ...
7
votes
5answers
415 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 ...
7
votes
2answers
4k 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 ...
5
votes
2answers
543 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 ...
5
votes
1answer
856 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), ...
5
votes
0answers
267 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 ...
4
votes
2answers
3k views

How long to learn PostgreSQL?

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 ...
4
votes
2answers
734 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 ...
3
votes
2answers
1k 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 ...
3
votes
5answers
560 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. ...
3
votes
1answer
127 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 ...
3
votes
1answer
23 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
2answers
307 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 ...
2
votes
1answer
175 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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
60 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 ...
1
vote
1answer
100 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 ...
0
votes
2answers
583 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 ...
0
votes
1answer
480 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 ...
0
votes
1answer
871 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 ...
0
votes
1answer
312 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 ...